Data granularity determines the level of details in a dimensional model. Which one of the following is not the result of finer grains in a dimensional model? 1. The fact table grows larger with many rows compared to the fact table prepared at coarse grain. 2. Offers more flexibility for data aggregation, reporting, and visualization. 3. To provide a detailed level of information, fact tables have multiple fact measures prepared at various levels of details and aggregation. 4. Requires larger storage space to store data.

The minimum level of data that can be stored in a fact table is known as ________a.Granularityb.Normalizationc.Grainsd.Data transformation

Which of the following is an example of high-granularity data? 1 pointSales data aggregated by product category.Sales data aggregated by month.Sales data aggregated by region.

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

The level of detail contained in the fact table is called the Blank 1 Question 8

The relational model feature is that there are tables with many dimensions is much more data independence than some other database models. is no need for primary key data. are explicit relationships among records.