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

Enrol Link:  Data Warehousing with Microsoft Azure Synapse Analytics

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

Test prep Quiz Answer

Question 1)
Which Workload Management capability manages minimum and maximum resource allocations during peak periods?

• Workload Importance
• Workload Isolation
• Workload Containment

Question 2)
Azure Synapse Analytics dedicated SQL pools can support a maximum of how many compute nodes?

• 60
• 20
• 80
• 40

Question 3)
Select from the options below to complete the missing text in the following statement.
A data warehouse that is built on a Massively Parallel Processing (MPP) system are built for processing and analyzing large datasets. As such they perform well with ____________ that can be distributed across compute nodes and storage. Select from the options to complete the missing text.

• Fewer and larger batch sizes
• Multiple small batch sizes

Question 4)
In Synapse Analytics resource classes are pre-determined resource limits in Synapse SQL pools that govern compute resources and concurrency for query execution. Dynamic Resource Classes allocate a variable amount of memory depending on the service level.

Which of the following are valid Dynamic Resource Classes?

• xxlargerc
• xlargerc
• mediumrc
• largerc
• tinyrc
• smallrc

Question 5)
Resource classes are pre-determined resource limits in Synapse SQL pool that govern compute resources and concurrency for query execution. Resource classes can help you configure resources for your queries by setting limits on the number of queries that run concurrently and, on the compute-resources assigned to each query.
Which of the following statements are correct? Select all options that apply.

• Larger resource classes increase concurrency, but reduce the maximum memory per query,
• Smaller resource classes reduce the concurrency, but increase maximum memory per query.
• Larger resource classes increase the maximum memory per query, but reduce concurrency.
• Smaller resource classes reduce the maximum memory per query, but increase concurrency.

Question 6)
In Azure Synapse Analytics configured with a dedicated SQL pool, classifiers assign incoming requests to a workload group. Classifiers are evaluated with every request submitted. If a request is not matched to a classifier, it is assigned to the default workload group. The default workload group in is the ___________ resource class.

• largerc
• mediumrc
• smallrc
• xlargerc

Question 7)
SQL Pools have the concept of concurrency slots, which manage the allocation of memory to connected users. Which of the following should you consider to optimize the load execution operations? Select all options that apply.

• Reducing or minimizing the number of simultaneous load jobs that are running.
• Increase the number of simultaneous load jobs that are running.
• Assigning lower resource classes that reduce the number of active running tasks.
• Assigning higher resource classes that reduce the number of active running tasks.

Question 8)
Dedicated SQL pool workload management in Azure Synapse consists of three high-level concepts which give you more control over how your workload utilizes system resources

Which of the following are valid concepts?

• Workload Classification
• Workload Importance
• Workload partitioning
• Workload Isolation

Question 9)
Which of the following hubs would you use to create a workload classifier in Azure Synapse Studio?

• Data
• Manage
• Integrate
• Develop

Question 10)
Which T-SQL Statement loads data directly from Azure Storage?

• LOAD DATA
• COPY
• INSERT FROM FILE