You are developing an application that uses Azure Data Lake Storage Gen 2.
You need to recommend a solution to grant permissions to a specific application for a limited time period.
What should you include in the recommendation?

• A.Azure Active Directory (Azure AD) identities
• B.shared access signatures (SAS)
• C.account keys
• D.role assignments

Comment: *

Name: *

Email: *

Verification: *

A company purchases IoT devices to monitor manufacturing machinery. The company uses an IoT appliance to communicate with the IoT devices.
The company must be able to monitor the devices in real-time.
You need to design the solution.
What should you recommend?

• A.Azure Stream Analytics cloud job using Azure PowerShell
• B.Azure Analysis Services using Azure Portal
• C.Azure Data Factory instance using Azure Portal
• D.Azure Analysis Services using Azure PowerShell

Comment: *

Name: *

Email: *

Verification: *

You implement an enterprise data warehouse in Azure Synapse Analytics.
You have a large fact table that is 10 terabytes (TB) in size.
Incoming queries use the primary key SaleKey column to retrieve data as displayed in the following table:

You need to distribute the large fact table across multiple nodes to optimize performance of the table.
Which technology should you use?

• A.hash distributed table with clustered index
• B.hash distributed table with clustered Columnstore index
• C.round robin distributed table with clustered index
• D.round robin distributed table with clustered Columnstore index
• E.heap table with distribution replicate

Comment: *

Name: *

Email: *

Verification: *

You are designing an Azure Synapse Analytics dedicated SQL pool.
Groups will have access to sensitive data in the pool as shown in the following table.

You have policies for the sensitive data. The policies vary be region as shown in the following table.

You have a table of patients for each region. The tables contain the following potentially sensitive columns.

You are designing dynamic data masking to maintain compliance.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation
Text Description automatically generated

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview

Comment: *

Name: *

Email: *

Verification: *

You have an enterprise data warehouse in Azure Synapse Analytics.
You need to monitor the data warehouse to identify whether you must scale up to a higher service level to accommodate the current workloads Which is the best metric to monitor?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.Data 10 percentage
• B.CPU percentage
• C.DWU used
• D.DWU percentage

Comment: *

Name: *

Email: *

Verification: *