BTE 210-Chapter 5 Adaptive Practice/Quiz Review/exam questions and answers/correct/verified A+

BTE 210-Chapter 5 Adaptive Practice/Quiz Review/exam questions and answers/correct/verified A+BTE 210-Chapter 5 Adaptive Practice/Quiz Review/exam questions and answers/correct/verified A+ __________________________ is an approach to managing information across an entire organization. A. Master data management B. Data governance C. Big Data D. Master data - correct answers-B Data ___________ means all applications are able to access the same data, which is ___________ by databases. A. independence; maximized B. isolation; minimized C. isolation; maximized D. independence; minimized - correct answers-A Which of the following is a good example of a primary key in a student table? A. Birthdate B. Address C. Social security number D. First and Last Name - correct answers-C Big Data primarily deals with ______________ data. A. Semi-structured B. Structured C. Unstructured D. All of the above - correct answers-D Big Data helps companies treat customers as individuals. This is called __________. A. microsegmentation B. experimentation C. data analyzation D. business model creation - correct answers-A ___________ support local control, whereas ____________ support central control. A. Data marts; data dictionaries B. Data warehouses; data marts C. Data marts; data warehouses D. Data warehouses; data dictionaries - correct answers-C Data warehouses and data marts are __________; this means users cannot change or update the data in data warehouses or data marts. A. integrated B. time variant C. nonvolatile D. organized by business dimension or subject - correct answers-C ___________ is one form of data integration. A. SQL B. ETL C. SAP D. EDI - correct answers-B ____________ is use to plan and control Business Intelligence activities. A. Governance B. ETL C. A data dictionary D. Metadata - correct answers-A A __________________________ defines the required format for entering the data into the database A. data dictionary B. primary key C. DBMS D. entity - correct answers-A If a university is using a database management system, which type of binary relationship would it assign to a PROFESSOR-CLASS relationship? A 1:N B 1:M C 1:1 D M:M - correct answers-B hat is the difference between a unary relationship and a ternary relationship? A A unary relationship means the degree of the relationship is three, while a ternary relationship means the degree of the relationship is one. B A unary relationship has reached the maximum number of times an instance can be related to another instance, while a ternary relationship has not yet reached the maximum number of times an instance can be related to another instance. C A unary relationship means the degree of the relationship is one, while a ternary relationship means the degree of the relationship is three. D A unary relationship has not yet reached the maximum number of times an instance can be related to another instance, while a ternary relationship has reached the maximum number of times an instance can be related to another instance. - correct answers-C Which of the following is a way to find information in databases by filling out a form describing the data desired? A NoSQL B QBE C ERM D SQL - correct answers-B Normalization of a relational database involves A streamlining. B modifying. C initializing. D renaming. - correct answers-A What is the MOST likely result for an organization that keeps its knowledge assets in emails, documents, and people's heads, rather than in a relational database? A