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

Enrol Link:  Data Warehousing with Microsoft Azure Synapse Analytics

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

Test prep Quiz Answers

Question 1)
When data is loaded into Synapse Analytics dedicated SQL pools, the datasets are broken up and dispersed among the compute nodes for processing, and then written to a decoupled and scalable storage layer. What term is used to describe this action?

• Sharding
• Separating
• Sharing
• Shredding

Question 2)
Which of the following table distributions available in Synapse Analytics SQL Pools creates a hash function to deterministically assign each row to a distribution and has a column designated as the distribution column?

• Replicated tables
• Hash distribution
• Round robin distribution

Question 3)
Which of the following indexing options are available in Dedicated SQL Pools? Select all options that apply.

• Clustered index
• Clustered columnstore index
• Table Index
• Non-clustered index

Question 4)
Select from the following options to complete the missing word in the sentence.

Dedicated SQL Pools create a _______________________ index when no index options are specified on a table

• Non-clustered
• Clustered columnstore
• Clustered

Question 5)
Which of the following index types can be defined on a table or view with a clustered index or on a heap?

• Clustered
• Non-clustered
• Clustered columnstore

Question 6)
Materialized views are prewritten queries with joins and filters whose definition is saved and the results persisted to pools. Which of the following pools are the results for Materialized views persisted to?

• Serverless SQL Pool
• Dedicated SQL Pool

Question 7)
You can use Materialized Views to improve the performance of either complex or slow queries. As the data in the underlying base tables change, the data in the materialized view will automatically update without user interaction. However, there are certain restrictions you must comply with when defining a materialized view. Which of the following are valid when defining materialized views?

• The Replicated tables distribution is supported in the definition.
• The hash table distribution is supported in the definition.
• The round_robin table distribution is supported in the definition.
• Clustered Columnstore index is supported by materialized views.
• Clustered index is supported by materialized views.

Question 8)
In Azure Synapse SQL, you should enable result-set caching when you expect results from queries to return the same values. This option stores a copy of the result set on the control node so that queries do not need to pull data from the storage subsystem or compute nodes.

By default, data within the result-set cache is expired and purged by the dedicated SQL pool after how many hours of not being accessed?

• 12 Hours
• 36 Hours
• 48 Hours
• 24 Hours

Question 9)
Which Index Type offers the highest compression?

• Rowstore
• Heap
• Columnstore

Question 10)
How do column statistics improve query performance?

• By caching column values for queries
• By keeping track of how much data exists between ranges in columns.
• By keeping track of the columns which are being queried.