CramX Logo
RegisterLog in
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Document preview page 1

2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 1

Document preview content for 2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions)

2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions)

2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers lets you practice with real past exam questions to boost your confidence.

Olivia Parker
Contributor
4.8
65
over 1 year ago
Preview (29 of 94 Pages)
100%
Log in to unlock
Page 1 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 1 preview imageWGU C175/D426 DATA MANAGEMENT FOUNDATIONSOA EXAM 2023-2024 ACTUAL EXAM 2 LATESTVERSIONS 300 QUESTIONS AND CORRECT DETAILEDANSWERS WITH RATIONALES (100% CORRECT ANDVERIFIED ANSWERS)|ALREADY GRADED A+
Page 2 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 2 preview image
Page 3 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 3 preview imageWGU C175/D426 DATA MANAGEMENT FOUNDATIONS OAEXAM 2023-2024 ACTUAL EXAM 2 LATESTVERSIONS 300QUESTIONS AND CORRECT DETAILED ANSWERS WITHRATIONALES(100% CORRECT AND VERIFIEDANSWERS)|ALREADY GRADED A+VERSION AWhat does modality refer to? How does it appear on ER diagram?-ANSWER-Refers to the MINIMUM number of times an instance in one entity can beassociated with instance of another entity (minima)Appears as a 0 or 1 on the relationship line, next to cardinalityDefine: Referential Integrity-ANSWER-Requires that ALL foreign key valuesmust either be fully NULL or match some primary key value4 Ways Referential Integrity can be violated:-ANSWER-1. Primary key isupdated2. Foreign key is updated3. Row containing primary key is DELETED4. Row containing foreign key is INSERTED4 Actions to Correct Referential Integrity Violation:-ANSWER-1. RESTRICT-rejects an insert, update, or delete2. SET NULL-sets invalid foreign keys to null3. SET DEFAULT-sets invalid foreign keys to a default primary value4. CASCADE-propagates primary key changes to foreign keysWhat is an important aspect to referential integrity?-ANSWER-reference to datain one relation is based on values in another relation
Page 4 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 4 preview imageWhat is a broad definition of data?-ANSWER-Raw facts captured on printed ordigital mediaWhat are data?-ANSWER-Facts that are collected and stored in a databasesystemWhat is a determining characteristic of unstructured data?-ANSWER-It does notfollow a data modelWhat is true about flat files?-ANSWER--They contain no internal hierarchicalorganizationHow were data retrieved before database management systems?-ANSWER-Sequentially from simple filesWhat is an attribute or group of attributes that uniquely identify a tuple in arelation?-ANSWER-Primary KeyWhat is necessary for a primary key in one relation of a database to match with itscorresponding foreign key in another relation of the same database?-ANSWER-A domain of valuesWhat uniquely identifies each entity in a collection of entities but is not theprimary key?-ANSWER-Alternate KeyWhat is the term for a set of columns in a table that can uniquely identify anyrecord in that table without referring to other data?-ANSWER-Candidate KeyWhat happens to the original data in database indexing?-ANSWER-It is copiedto the indexWhy are indexes created in a physical database design?-ANSWER-To retrievedata DIRECTLY using a pointerWhy is an index created on a database column?-ANSWER-To optimize dataretrievalsDefine: Functional Dependency-ANSWER-Each value of a column relates to atMOST one value of another columnDependence of one column on another
Page 5 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 5 preview imageWhat term is used to describe: a value of one particular attribute associated with aspecific single value of another attribute?-ANSWER-Functional DependencyRules/Appearance of First Normal Form-ANSWER--All non-key columnsdepend on primary key-Each table cell contains one value-A table with no duplicate rowsRules/Appearance of Second Normal Form-ANSWER--When all non-keycolumns depend on the WHOLE primarykey-Must be in 1NF-Non-key column can not depend on just one part of a composite key-a singleprimary key is automatically in 2NFRules/Appearance of Third Normal Form-ANSWER--All non-key columnsdepend ONLY on the primary key-Tables are totally free of data redundancyWhat are the 4 ways that operational and analytical databases differ?-ANSWER--Volatility-Detail-Scope-HistoryDefine: Volatility; How it applies to Operational? Analytical?-ANSWER--Database updates in real time-Operational Data is Volatile-Analytical Data is NOT VolatileDefine: Detail; How it applies to operational and analytical DB?-ANSWER--Adatabase that keeps record of individual transactions; line items-Operational: Detailed-Analytical: DetailedDefine: Scope; How it applies to operational and analytical DB?-ANSWER--How far a database can reach-Operational: incompatible-Analytical: Enterprise-Wide/Summary
Page 6 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 6 preview imageDefine: History; How it applies to operational and analytical DB?-ANSWER--Whether DB is current or tracks all data-Operational: Current only-Analytical: Tracks trendsData warehouses are refreshed periodically with a 5-step process:-ANSWER-1.Extraction2. Cleanse3. Integrate4. Restructure5. LoadWhat happens during Extraction? (ETL)-ANSWER-Data extracted and put intostaging areaWhat happens during Cleanse? (ETL)-ANSWER-Errors are eliminated fromdata; standard abbreviations appliedWhat happens during Integrate? (ETL)-ANSWER-Data is put into a uniformstructure; Data converted to uniform structureWhat happens during Restructure? (ETL)-ANSWER-Data is structured in adesign that is optimal for analysisWhat happens during Load? (ETL)-ANSWER-Data is loaded to the datawarehouseWhat is an issue that is focused on the 'Load' component of ETL?-ANSWER-Monitor refreshing volume and frequencyDuring which step in the ETL Process, is raw data aggregated?-ANSWER-Transformation stepsWhat are the 6 different data mining activities?-ANSWER-1. Clustering &Segmentation2. Classification3. Estimation4. Prediction5. Affinity Grouping6. Description
Page 7 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 7 preview imageDefine: Clustering & Segmentation-when is it helpful?-ANSWER--Takinglarge entity and dividing into smaller groups of entities-Useful when unsure of what looking forDefine: Classification (Data Mining)-ANSWER--Organizing data intopredefined classesDefine: Estimation (Data Mining)-ANSWER--Assigning a numeric value to anobjectDefine: Prediction (Data Mining)-ANSWER--Classifying objects according toan expected future behaviorDefine: Affinity Grouping-ANSWER-Evaluating relationships between dataelements that demonstrate some kind of affinity between objectsWhere does affinity grouping occur in data mining?-ANSWER-Between objectsWhat is the uniquely identifiable element about which data can be categorized inan entity-relationshipdiagram?-ANSWER-Entity typesWhich 3 rules for referential integrity are provided by modern relational databasemanagement systems?-ANSWER-InsertUpdateDeleteWhat does the DISTINCT clause do?-ANSWER-Returns only unique or 'distinct'values; Filters Data ResultsWhat does the ORDER BY clause do?-ANSWER-Modifies presentation of dataresultsWhich SQL statement alphabetizes customer names within the same satellite-officecity?-ANSWER-ORDER BY SATCITY, CUSTNAMEWhat is a heap file?-ANSWER-A file where records can be placed anywhere inthe memory
Page 8 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 8 preview imageWhat is a hash file?-ANSWER-A file that uses Hash function computation onsome fields of the records, and the result of that computation determines where therecord is storedWhat are the different types of major Joins?-ANSWER--LEFT JOIN-RIGHT JOIN-INNER JOIN-FULL JOINWhat do joins do?-ANSWER-Joins *usually* compare the foreign key of onetable to the primary key of another table (but can join any columns)-joiningtogether data from two tables into one tableLEFT JOIN-ANSWER-selects all the rows from the left table, and only matchingrows from the right tableRIGHT JOIN-ANSWER-selects all the rows from the right table, and onlymatching rows from the left tableOUTER JOIN-ANSWER-Any join that selects unmatched rows; LEFT, RIGHT,or FULL JOINSINNER JOIN-ANSWER-Joins together only rows that match from both tables-contains no unmatched rowsFULL JOIN-ANSWER-Fully joins two tables together, even unmatched rows-places a NULL in any cell that does not match the other tableWhat is the difference between Signed and Unsigned data?-ANSWER--SIGNED: a number that may be negative-UNSIGNED: a number that can NOT be negativeCHAR vs. VARCHAR-ANSWER--CHAR: Fixed number of characters-VARCHAR: Variable length of charactersA record consists of a:-ANSWER-set of one or more fieldsWhat functions does the DBMS perform to guarantee integrity and consistency ofthe data in a database?-ANSWER--Data Integrity Management-Data storage mangagement
Page 9 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 9 preview image-Security managementIn what two ways does a DBMS environment increase effectiveness in workingwith data?-ANSWER--Enables Data Sharing-Storage of vast volumes of dataA company posts an internet-based newsletter about their products.Whatadvantage will this company gain from the relational database management systemthat will store customer information?-ANSWER-Improved query response timeWhat is the method of organizing attributes into tables?-ANSWER-DataNORMALIZATIONWhat should a company expect from implementing a business intelligence system?-ANSWER--Financial: Increased profitability-Productivity: Increased throughput, decreased workloads-Trust: greater satisfaction-Risk: improved visibilityWhat is a relational model?-ANSWER-A database model based on mathematicalprinciplesWhat are the 3 mathematical concepts of the relational model?-ANSWER--Domain-Tuple-RelationDefine: Domain-ANSWER-Set of values = 'Data Type'Define: Tuple-ANSWER-Finite sequence of values pulled from a fixed domain ='Row'Define: Relation-ANSWER-A named set of tuples, all from same domain ='Table'A tuple position is calleda:-ANSWER-AttributeHow is cardinality depicted in a diagram for many, one, and zero?-ANSWER--Many = Crow's Foot-One = a bar across the end of a relationship (--||--)
Page 10 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 10 preview image-Zero = CircleDifference between Unary and Binary:-ANSWER--Unary: One entity involvedin relationship (one box, one line)-Binary: Two entities (two boxes combined by one line)If an entity is mandatory, how is it depicted in an ER diagram?-ANSWER-Witha single vertical line through the relationship lineWhat does an 'M' mean when shown on an entity in an ER diagram?-ANSWER-MandatoryWhat does a 'PI' mean when shown on an entity in an ER diagram?-ANSWER-Primary Identifier-used for attribute(s) that uniquely identify the whole entityHow are maxima and minima depicted in an ER diagram?-ANSWER-Maxima isthe first letter/number shown (outside of the entity) and Minima is the letter next toit in parenthesesDefine: Singular Attribute-ANSWER-Each entity instance has at most ONEattribute instanceDefine: Plural Attribute-ANSWER-Each entity instance can have MANYattribute instancesDefine: Unique Attribute-ANSWER-Each attribute instance describes only ONEentity instanceHow do entity and attribute maxima appear in an ER diagram?-ANSWER-As Mor 1 following the attribute nameWhat combination of entity and attribute maxima/minima is considered unique?-ANSWER-If the first number is a 1What combination of entity and attribute maxima/minima is considered singular?-ANSWER-If the second number is 1What combination of entity and attribute maxima/minima is considered plural?-ANSWER-If the second number is M
Page 11 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 11 preview imageDefine: Select Operation-ANSWER-Selects table rows based in logicalexpression (σ)Define: Project Operation-ANSWER-Selects Table Columns (II)Define: Join Operation-ANSWER-Joins two tables (⋈)Define: Union operation-ANSWER-Combines ALL rows of two compatibletables into a single table (U)Define: Intersect Operation (and how it appears on an ER diagram)-ANSWER-Operates on two compatible tables and returns only rows that appear in BOThtables (∩)Appears as a line and square coming off of a relationship between two otherentitiesWhat does cardinality refer to? How does it appear on ER diagram?-ANSWER-Refers to the MAXIMUM number of times an instance in one entity can beassociated with instance of another entity (Maxima)Appears as a 1 or M on the relationship line, closest to entityA pet owner can have manypets; a specific pet is linked to one pet owner. What isthe binary relationship described?-ANSWER-One-To-ManyDatabase models were developed to _____?-ANSWER-model real-world eventsor conditionsThe entity integrity rule requires:-ANSWER-All primary keys must be uniqueA table is perceived as a ______.-ANSWER-Two-dimensional structureA table can be logically connected to another table by defining a _____.-ANSWER-common attributeWe can describe a link by observing that ____.-ANSWER-A primary key of onetable appears again as a foreign key in a related tableAn attribute (or group of attributes) that uniquely identifies each entity in a table iscalled:-ANSWER-A superkey
Page 12 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 12 preview imageA foreign key must:-ANSWER-Match a primary key in a related tableThe ERD is used to graphically represent the ____ database model.-ANSWER-ConceptualA derived attribute _____.-ANSWER-need not be physically stored within thedatabaseA _____ attribute is one that cannot be subdivided-ANSWER-AtomicIf an entity can exist apart from one or more related entities, it is said to be:-ANSWER-Existence-IndependentDependencies based on only a part of a composite key are called:-ANSWER-Partial-DependenciesA special operator used to check for similar character strings is:-ANSWER-LIKEUPDATE tablename*****WHERE conditionlistWhat command replaces the *****?-ANSWER-expression = columnnameWhat does a record consist of?-ANSWER-A set of one or more fieldsWhat function does A DBMS perform that guarantee the integrity and consistencyof the data in the database?-ANSWER-Data integrity, data storage, and securitymanagementWhat is data?-ANSWER-Raw FactsDatabase models were developed to what?-ANSWER-Model real-world eventsor conditionsThe entity integrity rule requires that-ANSWER-all primary key entries areunique
Page 13 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 13 preview imageWhat does the 'refer' in referential integrity mean-ANSWER-A foreign key in atable must refer to a valid primary key in another table.A table is perceived as-ANSWER-two-dimensional structureAnother term for "relation"-ANSWER-TableWhat does SQL command ORDER BY do?-ANSWER-modifies the presentationby changing the order of the result set.What does SQL command DISTINT do?-ANSWER-filters the results to removeduplicatesThis value must be unique in the entire database-ANSWER-Primary KeyA table can be logically connected to another table by defining a-ANSWER-common attributeA relational operator that allows for the combination of information from two ormore tables-ANSWER-JOINa primary key of one table appears again as a foreign key in a related table-ANSWER-LINKWhat should you focus on when creating a new database?-ANSWER-minimizedata redundancyAn attribute (or combination of attributes) that uniquely identifies each entity in atable-ANSWER-superkeyThis key must match the value of a primary key in a related table-ANSWER-Foreign keyWhat does the ERD (Entity Relationship Diagram) graphically represent?-ANSWER-Conceptual database modelThis type of attribute does not need not be physically stored within the database-ANSWER-Derived attributeThe association between separate entities-ANSWER-Relationship
Page 14 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 14 preview imagea key that consists of more than one attribute-ANSWER-composite keyan entity that can exist apart from one or more related entities-ANSWER-Existent-Independent entityThe set of possible values for an attribute-ANSWER-domainWhich attribute(s) make up the primary key in the table definition: CLASS(CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM,PROF_NUM)-ANSWER-CRS_CODE andCLASS_SECTIONA table that has all key attributes defined, has no repeating groups, and all itsattributes are dependent on the primary key-ANSWER-1NFA table that is in 2NF and contains no transitive dependencies-ANSWER-3NFWhat does data redundancy produce?-ANSWER-data integrity problemsNormalization works through a series of normal:-ANSWER-formsDependencies based on only a part of a composite primary key-ANSWER-partialdependenciesDescribe 1NF relationship-ANSWER--A table that has all key attributes defined-no repeating groups-all its attributes are dependent on the primary keyThe SQL command that lets you insert data into a table, one row at a time-ANSWER-INSERTThe SQLcommand that enables you to make changes in the data-ANSWER-UPDATETo list all the contents of the PRODUCT table, you would use what SQLcommand?-ANSWER-SELECT * FROM PRODUCT;Which SQL command would you use when making corrections to the PRODUCTtable?-ANSWER-UPDATE
Page 15 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 15 preview imageWhich SQL command would be used to delete the table row-ANSWER-DELETESQL allows the use of special operators in conjunction with the WHERE clause.What is a special operator used to check for similar character strings?-ANSWER-LIKEWhat SQL command can delete a table from the database?-ANSWER-DROPUPDATE tablename ***** [WHERE conditionlist]; What command replaces the***** in the above statement?-ANSWER-SET columnname = expressionreturns rows with matching values and includes all rows from both tables (T1 andT2) with unmatched values-ANSWER-full outer joinWhat is ETL in database management?-ANSWER-ExtractTransformLoadDuring which step in the extract, transform, load (ETL) process are raw data setsaggregated-ANSWER-TransformationDescribe data extraction from the ETL process-ANSWER-Extract or copy rawdata from multiple sources and store it in a staging areaDescribe data transformation from the ETL process-ANSWER-Transform andconsolidate the raw data in the staging area to prepare it for the target datawarehouseDescribe data loading from the ETL process-ANSWER-Moves the transformeddata from the staging area into the target data storage or warehouse. Focuses ontarget dependencies such as where and on how many machines the data lives. Alsofocuses on refresh volume and frequency, whether data is loaded incrementally oris a full load, etc.DescribeETL in a nutshell-ANSWER-ETL stands for Extract, Transform, Load.Extraction-Raw data is extracted from sources and stored in a temporary stagingarea.
Page 16 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 16 preview imageTransform-The data is then transformed and consolidated in the staging area.Basic transformations improve data quality by removing errors, emptying datafields, or simplifying data. Examples of these transformations follow.Load-move the transformed data from the staging area into the target datawarehouseDescribe "unnormalized" forms of tables as compared to 1NF, 2NF, or 3NF forms.-ANSWER--Has repeating groups-Contains multi valued fields or-Fields that contain multiple valuesWhere does affinity grouping occur in data mining?-ANSWER-Between entitygroup namesIn data mining, thisis the process of evaluating relationships between dataelements to demonstrate an affinity or link between objects.-ANSWER-AffinityGroupingIn data mining, this classifies objects according to an expected future behavior-ANSWER-PredictionA stepof the extract, transform, load (ETL) process in which raw data sets areaggregated-ANSWER-TransformMonitor refreshing volume and frequency is focused on the what component of theextract, transform, load (ETL) process?-ANSWER-LoadThis serves asthe primary source of information that feeds analytical processingfor an organization's data analysis.-ANSWER-Data warehouseThe set of results a company should expect from implementing a businessintelligence system. PowerBI is an example of software that implements businessintelligence systems.-ANSWER-Increased profitability and increased throughputPrimary source of information that feeds the analytical processing within anorganization-ANSWER-Data WarehouseA centralized repository of information-ANSWER-Data Warehouse
Page 17 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 17 preview imageThis is arranged around the relevant subject areas important to the business. It isalso nonvolatile, not used for transactions but for analysis, and integrates data frommultiple sources.-ANSWER-Data WarehouseSubject-oriented data repository smaller than a data warehouse and normally for asmaller or specific group within an organization-ANSWER-Data MartDifferences between OLAP and OLTP-ANSWER-OLAP is for analysis, andOLTP is for transaction processingWhat is ETL?-ANSWER-Extract, Transform, LoadThe infrastructure where raw data sets are aggregated-ANSWER-Staging AreaWhat twoprime questions are essential to understanding extraction?-ANSWER-What and how should data be extracted?What processes are involved in the Transformation step of the ETL process?-ANSWER--Data type conversion-Data Cleansing-Integration-Referential integrity checking-Derivations-Denormalization-Renormalization-Aggregation-Audits-Null conversionsThis step of the ETL is focused on moving transformed data into the datawarehouse-ANSWER-LoadWhat processes are involved in the Load step of the ETL process?-ANSWER--Target Dependencies-Refresh volume and frequencyData mining can be described in this way-ANSWER-The Virtuous Cycle
Page 18 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 18 preview imageIdentifying the business problems, and continual improvement of businessprocesses that drive discovery of actionable knowledge and taking action based onthat knowledge-ANSWER-The Virtuous cycleDescribe the brief steps of the Virtuous Cycle-ANSWER--Identify the businessproblem-Mine the data for actionable information-Take the action-Measure resultsThis is the type of knowledge where you already have identified the problem youwant to resolve (For example, a business is trying to figure out where they arelosing the most money)-ANSWER-Directed Knowledge DiscoveryThis is the type of knowledge where you find patterns within data sets as a way todiscover something interesting or an issue (for example,MMO-Champion data-mining).-ANSWER-Undirected Knowledge discoveryWhat are the six basic tasks of data mining?-ANSWER--Classification-Estimation-Prediction-Affinity Grouping-Clustering-DescriptionExamine the attributes of a particular objectand assign it a defined class-ANSWER-ClassificationThe process of assigning continuously valued numeric value to an object, such as acredit risk assessment.-ANSWER-EstimationClassify objects according to some expected future behavior-ANSWER-PredictionProcess of evaluating relationships or associations between data elements thatdemonstrate an affinity with one another-ANSWER-Affinity groupingTask of taking large collections of objects and dividing them into smaller groups-ANSWER-Clustering
Page 19 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 19 preview imageProcess of trying to characterize or explain what has been discovered-ANSWER-DescriptionWhen the primary key is in one column only, non-key columns always depend onthe whole primary key.-ANSWER-Second Normal FormTables with a simple primary key are always in what form?-ANSWER-SecondNormal FormWhen the primary key is a single column and not composite, meaning one or morecolumns, this is known as what? This will always be at least second normal form-ANSWER-Simple KeyWhen no dependencies exist between non-key columns-ANSWER-Third NormalFormWhen all non-key columns depend on the key, the whole key, and nothing but thekey.-ANSWER-Third Normal FormThisform is present when the primary key is the ONLY unique column-ANSWER-Third Normal FormIn databases, this is a pair of related values-ANSWER-FactThis is the same as third normal form except it applies to all key columns insteadof just non-key columns-ANSWER-Boyce-Codd FormOne disadvantage of the DBMS is that it increases the risk of data securitybreaches.FalseTrue-ANSWER-FalseAccurate, relevant, and timely information is the key to _______.knowledgegood decision making
Page 20 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 20 preview imagedata managementunderstanding-ANSWER-good decision making_____ relates to the activities that make the database execute transactions moreefficiently in terms of storage and access speed.Database designQuery accessDatabase managementPerformance tuning-ANSWER-Performance tuningThe response of the DBMS to a query is the ______.integrated view of the dataquery result setad hoc responsead hoc query-ANSWER-query result setField refers to a collection of related records.FalseTrue-ANSWER-FalseThe DBMS uses the ________ to look up the required data component structuresand relationships, thus relieving programmers from having to code such complexrelationships in each program.-ANSWER-data dictionaryA(n) ________ is a collection of programs that manages the database structure andcontrols access to the data stored in the database.-ANSWER-databasemanagement systemA _____ is a character or group of characters that has a specific meaning.
Page 21 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 21 preview imagefilerecordfielddatabase-ANSWER-fieldData warehouse contains historical data obtained from the_____.desktop databaseenterprise databasesworkgroup databasesoperational databases-ANSWER-operational databasesThe database structure in a DBMS is stored as a ______.single filecollection of filesset of key/value pairscollection of queries-ANSWER-collection of filesThe DBMS reveals much of the database's internal complexity to the applicationprograms and users.TrueFalse-ANSWER-False_____ exists when different versions of the same data appear in different places.Conceptual dependence
Page 22 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 22 preview imageData inconsistencyPoor data securityStructural dependence-ANSWER-Data inconsistencyA _____ contains at least all of the attribute names and characteristics for eachtable in the system.logical schemarelational schemadata dictionarydatabase-ANSWER-data dictionaryA(n) _____ might be written by a programmer or it might be created through aDBMS utility program.applicationdatabase management systemoperating systemquery-ANSWER-application_____ is the body of information and facts about a specific subject.KnowledgeA databaseValidationA format-ANSWER-KnowledgeAn XML database supports the storage and management of _____ XML data.
Page 23 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 23 preview imagesemistructuredfullystructuredmultistructuredstructured-ANSWER-semistructuredThe only way to access the data in a database is through the DBMS.FalseTrue-ANSWER-TrueMetadata describe the data characteristics and the set of relationships that links thedata found within the database.TrueFalse-ANSWER-TrueA data warehouse can store data derived from many sources.FalseTrue-ANSWER-TrueA workgroup database is a(n) _____ database.distributedsingle-usermultiuserdesktop-ANSWER-multiuserData is said to be verifiable if:the data always yields consistent results.
Page 24 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 24 preview imagethe data is stored in different placeswithin the database.the data is obtained from trusted sources.the data cannot be changed or manipulated.-ANSWER-the data always yieldsconsistent results.A desktop database is a _____ database.single-usermultiuserworkgroupdistributed-ANSWER-single-user_____ is defined as the condition in which all of the data in the database areconsistent with the real-world events and conditions.Data ubiquityData qualityData integrityData anomaly-ANSWER-Data integrityCorporations use only structured data.FalseTrue-ANSWER-False________ is a special language used to represent and manipulate data elements in atextual format.-ANSWER-Extensible Markup Language (XML)Data processing can be as simple as organizing data to reveal patterns.
Page 25 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 25 preview imageTrueFalse-ANSWER-TrueData is the result of processing raw facts to reveal its meaning.TrueFalse-ANSWER-False________ is data about data through which the end-user data are integrated andmanaged.-ANSWER-MetadataOne disadvantage of a database system over previous data management approachesis increased costs.FalseTrue-ANSWER-True________ relates to activities that make a database operate more efficiently interms of storage and access speed.-ANSWER-Performance tuning________ is the result of processing raw data to reveal its meaning.-ANSWER-InformationStructural dependence exists when itis possible to make changes in the filestructure without affecting the application program's ability to access the data.FalseTrue-ANSWER-FalseData constitute the building blocks of information.TrueFalse-ANSWER-TrueAn operational database is sometimes referred to as an enterprise database.
Page 26 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 26 preview imageFalseTrue-ANSWER-False________ exists when the same data are stored unnecessarily at different places.-ANSWER-Data redundancy_____ serve as the intermediary betweenthe user and the database.Programming languagesEnd-user dataMetadataDBMSs-ANSWER-DBMSsOne advantage of a database system over previous data management approaches isthat the database system is considerably less complex.FalseTrue-ANSWER-FalseThe organization of data within folders in a manual file system is determined by_____.its date of creationthe data processing specialistthe title of the documents in the folderits expected use-ANSWER-its expected use________ databases focus primarily on storing data used to generate informationrequired to make tactical or strategic decisions.-ANSWER-Analytical
Page 27 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 27 preview imageWhich of the following refers to the situation where the same data is storedunnecessarily at different places?Data queryData integrityData dictionaryData redundancy-ANSWER-Data redundancyInformation is produced by processing ________ .-ANSWER-dataA(n) ________ is a specific request issued tothe DBMS for data manipulation.-ANSWER-queryAn advantage of database systems is that you needn't perform frequent updates andapply latest patches.TrueFalse-ANSWER-FalseRaw data must be properly ________ for storage, processing and presentation.-ANSWER-formattedA _____ is a logically connected set of one or more fields that describes a person,place, or thing.columndatabasefilerecord-ANSWER-recordA(n) ________ develops when all required changes in the redundant data are notmade successfully.-ANSWER-data anomaly
Page 28 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 28 preview image_____ are the result of formatting disorganized data in order to facilitate storage,use and generation of information.UnstructureddataObsolete dataStructured dataRaw data-ANSWER-Structured data
Page 29 of 29
2023-2024 WGU C175/D426 Data Management Foundations OA Exam with Answers (531 Solved Questions) - Page 29 preview imageVERSION BThe same data might be simultaneously structured and unstructured depending onthe intended processing.FalseTrue-ANSWER-True_____ data exist in the format in which they were collected.HistoricalStructuredSemistructuredUnstructured-ANSWER-Unstructured_____ is the result of revealing the meaning of raw facts.Information
Preview Mode

This document has 94 pages. Sign in to access the full document!

Study Now!

X-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat

Document Details

Subject
Western Governors University

Related Documents

View all
Past Exams

2023 WGU D080 Practice Exam with Answers (161 Solved Questions)

4.4
00
Past Exams

2023-2024 WGU D236 Pathophysiology Practice Exam with Answers (170 Solved Questions)

4.6
00
Past Exams

WGU Education Practice Exam With Answers (243 Solved Questions)

4.0
00
Past Exams

2024 WGUC233 Law Practice Exam With Answers (179 Solved Questions)

4.1
00
Past Exams

WGU Management Practice Exam With Answers (130 Solved Questions)

4.7
00
Past Exams

WGU D174 Marketing Practice Exam With Answers (36 Solved Questions)

4.9
00
Past Exams

2023 WGUD094 Education Practice Exam With Answers (156 Solved Questions)

4.8
00
Past Exams

WGU C429 Health Care Assessment Practice Exam With Answers (115 Solved Questions)

4.7
00
Past Exams

2024 WGU D236 Pathophysiology Practice Exam With Answers (134 Solved Questions)

5.0
00
Past Exams

2022-2024 WGU C182 Computer Science Real Exam With Answers (70 Solved Questions)

4.0
00