Question 1Which of the following statements about Data models is correct?1 pointA Data model is and abstract, formal representation of entities.A Data model describes information at a conceptual level.A Data model defines the relationships between objects.A Data model is the blueprint of any database system.

A data model is a plan for a database design.Question 27Select one:TrueFalse

Which of the following statements best defines data?1 pointData is an assortment of questions.Data is a business process.Data is the use of calculations and statistics.Data is a collection of facts.2.Question 2Fill in the blank: In data analytics, the data eco

“Data Model” is nothing but a data structure where data is stored. True False

1.Question 1True or false: Data modeling is only used to develop entity relational databases.1 pointTrueFalse2.Question 2Fill in the blank: The dimensions in a dimensional data model define the ______ for your measures.1 pointcontextquantityunits3.Question 3Fill in the blank: A dimensional data model is created using four key steps; identifying the ______, choosing the grain, the facts, and the dimensions.1 pointtextual datadata sourcelevel of detailbusiness process4.Question 4Which data model is typically used for complicated database projects? 1 pointObject-Oriented modelEntity Relationship model Dimensional modelHierarchical model5.Question 5In normalization of relational database models, which normal form deals with removing unnecessary duplicated data?1 pointFourth normal formFirst normal formSecond normal formThird normal form6.Question 6In data warehouse architecture, which process or processes takes place in the data staging component?1 pointextract, transform, and loadtrain and extractextract and loadtransform and load7.Question 7Which of the following describes what MySQL Workbench is?1 pointA tool for developers to create data models and manage data.External hardware that plugs into a computer to help with efficiently creating and managing data models.A computer that can efficiently handle anything database related.8.Question 8True or false: MySQL Workbench facilitates data migration between different versions of MySQL, and between MySQL and other relational database systems. 1 pointTrueFalse9.Question 9Fill in the blank: ______ data analysis identifies patterns to better make informed decisions about the future.1 pointPredictiveExploratoryCausalInteresting10.Question 10True or false: With MySQL Workbench, you can use the reverse engineer method to create an ER diagram from an existing database. 1 pointTrueFalse11.Question 11Fill in the blank: A data _________ is a centralized data repository that aggregates, stores and processes large amounts of data from multiple sources for data analytics.1 pointwarehouseshopcentermodel12.Question 12In dimensional data modeling, after selecting the business process to focus on you must choose the grain. Which of the following is the grain concerned with? Select all that apply.1 pointThe size of the data set.The lowest level of detail required.The facts and dimensions.The detail required to address the problem.13.Question 13An Entity Relationship data model represents a database as a collection of relations. How are these relations presented?1 pointAs an entity with its own set of attributes.As an entity with primary and foreign keys.As an entity with no attributes.As a conceptual diagram.14.Question 14Fill in the blank: The hierarchical data model organizes data in a tree-like or a parent-child structure. Because of its structure it can only be used to record ______ relationships.1 pointone to manyone to onemany to many15.Question 15The ______ scale describes the ordering of data without defining the degree of variation between data points.1 pointordinalintervalnominalratio16.Question 16Which database system(s) is the data ware

Data Model is collection of conceptual tools for describinga.Consistency Constaintsb.Data Schemac.Datad.All of these