You need to implement an Azure Synapse Analytics database object for storing the sales transactions dat a. The solution must meet the sales transaction dataset requirements.
What solution must meet the sales transaction dataset requirements.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have an Azure Databricks workspace named workspace1 in the Standard pricing tier.
You need to configure workspace1 to support autoscaling all-purpose clusters. The solution must meet the following requirements:
* Automatically scale down workers when the cluster is underutilized for three minutes.
* Minimize the time it takes to scale to the maximum number of workers.
* Minimize costs.
What should you do first?

• A.Enable container services for workspace1.
• B.Upgrade workspace1 to the Premium pricing tier.
• C.Set Cluster Mode to High Concurrency.
• D.Create a cluster policy in workspace1.

Comment: *

Name: *

Email: *

Verification: *

You have a data model that you plan to implement in a data warehouse in Azure Synapse Analytics as shown in the following exhibit.

All the dimension tables will be less than 2 GB after compression, and the fact table will be approximately 6 TB.
Which type of table should you use for each table? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

Which Azure Data Factory components should you recommend using together to import the daily inventory data from the SQL server to Azure Data Lake Storage? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You plan to create an Azure Synapse Analytics dedicated SQL pool.
You need to minimize the time it takes to identify queries that return confidential information as defined by the company's data privacy regulations and the users who executed the queues.
Which two components should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.sensitivity-classification labels applied to columns that contain confidential information
• B.resource tags for databases that contain confidential information
• C.audit logs sent to a Log Analytics workspace
• D.dynamic data masking for columns that contain confidential information

Correct Answer: A,C

Explanation
A: You can classify columns manually, as an alternative or in addition to the recommendation-based classification:

* Select Add classification in the top menu of the pane.
* In the context window that opens, select the schema, table, and column that you want to classify, and the information type and sensitivity label.
* Select Add classification at the bottom of the context window.
C: An important aspect of the information-protection paradigm is the ability to monitor access to sensitive data. Azure SQL Auditing has been enhanced to include a new field in the audit log called data_sensitivity_information. This field logs the sensitivity classifications (labels) of the data that was returned by a query. Here's an example:

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-overview

Comment: *

Name: *

Email: *

Verification: *