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

You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a fact table named Table1.
You need to identify the extent of the data skew in Table1.
What should you do in Synapse Studio?

You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure
Data Lake Storage Gen2 account named Account 1.
You plan to access the files in Accoun1l by using an external table.
You need to create a data source in Pool1 that you can reference when you create the
external table.
How should you complete the Transact-SQL statement? To answer, select the appropriate
options in the answer area.
NOTE Each coned selection is worth one point.

You need to output files from Azure Data Factory.
Which file format should you use for each type of output? To answer, select the appropriate
options in the answer area.
NOTE: Each correct selection is worth one point.

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.

You have an Azure subscription that contains the following resources:
* An Azure Active Directory (Azure AD) tenant that contains a security group named
Group1.
* An Azure Synapse Analytics SQL pool named Pool1.
You need to control the access of Group1 to specific columns and rows in a table in Pool1
Which Transact-SQL commands should you use? To answer, select the appropriate
options in the answer area.
NOTE: Each appropriate options in the answer area.

You are designing an Azure Databricks table. The table will ingest an average of 20 million
streaming events per day.
You need to persist the events in the table for use in incremental load pipeline jobs in
Azure Databricks. The solution must minimize storage costs and incremental load times.
What should you include in the solution?

You need to design a data retention solution for the Twitter teed data records. The solution must meet the customer sentiment analytics requirements.
Which Azure Storage functionality should you include in the solution?