In this article i am gone to share Data Warehousing with Microsoft Azure Synapse Analytics Week 2 | Test prep Quiz Answer with you..

Enrol Link:  Data Warehousing with Microsoft Azure Synapse Analytics

Data Warehousing with Microsoft Azure Synapse Analytics Week 2 | Test prep Quiz Answer

Test prep Quiz Answer

Question 1)
Examine the following statement and replace the missing words with your choice from the supplied options.
A fact table contains dimension key columns that relate to dimension tables. Dimension key columns determine the ________ of a fact table, while the dimension key values determine the _________ of a fact table.

• dimensionality, granularity
• granularity, dimensionality

Question 2)
What type of system is Azure Synapse Analytics?

• Symmetric Multiprocessing (SMP) system
• Massively Parallel Processing (MPP) system
• Online Transactional Processing (OLTP) Database

Question 3)
True or False
A Snowflake Schema is an extension of a Star Schema, and it adds additional dimensions. The dimension tables are normalized which splits data into additional tables.

• True
• False

Question 4)
To create a snowflake schema in Azure Synapse Studio you navigate to which of the following hubs?

• Manage
• Develop
• Integrate
• Data

Question 5)
What distribution option would you use for a product dimension table that will contain 1,000 records in Synapse Analytics?

• DISTRIBUTION = HASH([ProductId]).
• DISTRIBUTION = REPLICATE.
• DISTRIBUTION = ROUND_ROBIN.

Question 6)
What is the difference between a star schema and a snowflake schema?

• All dimensions in a star schema are normalized while all dimensions in a snowflake schema join directly to the fact table (denormalized).
• A star schema uses surrogate keys while a snowflake schema uses business keys.
• All dimensions in a star schema join directly to the fact table (denormalized) while some dimension tables in a snowflake schema are normalized.
• A star schema has one fact table while a snowflake schema has multiple fact tables.

Question 7)
Which of the following are true in respect of fact tables? Select all options that apply.

• A fact table contains numeric measure columns.
• A fact table contains dimension key columns that relate to dimension tables.
• Fact tables store observations or events.
• A fact table describes business entities.

Question 8)
Which of the following statements are true in respect of a Star schema? Select all options that apply.

• A Star schema will have a fact table surrounded by dimension tables which are in turn surrounded by dimension tables.
• Star schemas have a high level of Data redundancy.
• A Star schema contains a fact table surrounded by dimension tables.
• Star schema dimension tables are a denormalized data structure.
• In a Star schema Cube processing might be slow because of the complex join.

Question 9)
What distribution option would be best for a sales fact table that will contain billions of records?

• DISTRIBUTION = HASH([SalesOrderNumber])
• DISTRIBUTION = HEAP
• DISTRIBUTION = REPLICATE

Question 10)
A Star schema is a modeling approach widely adopted by relational data warehouses. It requires modelers to classify their model tables as either dimension or fact. Which of the following are features of dimension tables? Select all options that apply.

• A dimension table contains a key column (or columns)
• A dimension table describes business entities
• A dimension stores numeric measure columns