All Coursera Quiz Answers

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

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

Enrol Link:ย  Data Warehousing with Microsoft Azure Synapse Analytics

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


 

Test prep Quiz Answer

Question 1)
Apache Spark pools for Azure Synapse Analytics uses an Autoscale feature that automatically scales the number of nodes in a cluster instance up and down. Autoscale continuously monitors the Spark instance and collects metrics. Which of the following conditions will trigger Autoscale to scale up? Select all options that apply.

  • Total pending memory is less than total free memory for more than 2 minutes.
  • Total pending memory is greater than total free memory for more than 1 minute.
  • Total pending CPU is greater than total free CPU for more than 1 minute.
  • Total pending CPU is less than total free CPU for more than 2 minutes.

Question 2)
Azure Advisor provides you with personalized messages that provide information on best practices to optimize the setup of your Azure services. Azure Advisor recommendations are free, and the recommendations are based on telemetry data that is generated by Azure Synapse Analytics. Azure Advisor recommendations are checked every how many hours?

  • 1 Hour
  • 4 Hours
  • 24 Hours
  • 12 Hours

Question 3)
Which Dynamic Management View enables you to view the active connections against a dedicated SQL pool?

  • sys.dm_pdw_dms_workers
  • sys.dm_pdw_exec_requests
  • DBCC PDW_SHOWEXECUTIONPLAN

Question 4)
Examine the following statement and select from the listed options to complete the sentence.

A columnstore index scans a table by scanning column segments of individual rowgroups. Maximizing the number of rows in each rowgroup enhances query performance. For best query performance, the goal is to maximize the number of rows per rowgroup in a columnstore index.
Columnstore indexes achieve good performance when rowgroups have at least ____________ rows.

  • 1,000,000 rows
  • 10,000 rows
  • 100,000 rows
  • 1,048,576 rows

Question 5)
SQL pool in Azure Synapse supports standard and materialized views. Which of the following are features of Materialized views? Select all options that apply.

  • Speed to retrieve view data from complex queries is Slow,
  • Speed to retrieve view data from complex queries is Fast,
  • View content is generated each time the view is used,
  • View content is pre-processed and stored in SQL pool during view creation. The view is updated as data is added to the underlying tables.

Question 6)
What would be the best approach to investigate if the data at hand is unevenly allocated across all distributions?

  • Grouping the data based on partitions and counting rows with a T-SQL query.
  • Using DBCC PDW_SHOWSPACEUSED to see the number of table rows that are stored in each of the 60 distributions.
  • Monitor query speeds by testing the same query for each partition.

Question 7)
Which of the following statements is a benefit of materialized views?

  • Increased resiliency benefits
  • Reducing the execution time for complex queries with JOINs and aggregate functions.
  • Increased high availability

Question 8)
What features are provided when using a managed workspace virtual network? Select all options that apply.

  • Management of the virtual network is offloaded to Azure Synapse.
  • Your workspace is network isolated from other workspaces.
  • You will need to create a subnet for your Spark clusters based on peak load.
  • You don’t have to configure inbound NSG rules on your own Virtual Networks to allow Azure Synapse management traffic to enter your Virtual Network.

Question 9)
Azure Synapse Analytics enables you to connect to its various components through endpoints. You can set up managed private endpoints to access these components in a secure manner known as private links. Which of the following statements are true in respect of Private Endpoints? Select all options that apply.

  • You must have an Azure Synapse workspace with a Managed workspace Virtual Network.
  • You can manage the private endpoints in the Azure Synapse Studio manage hub.
  • When you use a private link, traffic between your Virtual Network and workspace traverses entirely over the Microsoft backbone network.
  • When you use a private link, traffic between your Virtual Network and workspace traverses over the public Internet network.

Question 10)
Conditional access is a feature that enables you to define the conditions under which a user can connect to your Azure subscription and access services. Conditional access policies use signals as a basis to determine if conditional access should first be applied. Which of the following are common signals used as a basis to determine if conditional access should first be applied? Select all options that apply.

  • User or group membership names
  • Multi Factor Authentication
  • IP address information
  • Microsoft Cloud App Security (MCAS)
  • Device platforms or type

Question 11)
You want to configure a private endpoint. You open up Azure Synapse Studio, go to the manage hub, and see that the private endpoint is greyed out. Why is the option not available?

  • A conditional access policy has to be defined first.
  • A managed virtual network has not been created.
  • Azure Synapse Studio does not support the creation of private endpoints.

Question 12)
Transparent data encryption (TDE) is an encryption mechanism to help you protect Azure Synapse Analytics. The way TDE will do so, is by encrypting data at rest.

If you export a TDE-protected database, the exported content will be in a specific state. Which of the following represents the state of the exported content?

  • Will be encrypted using a new TDE Key
  • Remains in its original encrypted state
  • Will be in an unencrypted state