- All Exams Instant Download
What should you include in the solution?
You are designing an Azure Synapse Analytics dedicated SQL pool. You need to ensure that you can audit access to Personally Identifiable information (PII). What should you include in the solution?A . dynamic data maskingB . row-level security (RLS)C . sensitivity classificationsD . column-level securityView AnswerAnswer: C Explanation: Data Discovery...
Which two actions should you perform?
You are creating an Azure Data Factory data flow that will ingest data from a CSV file, cast columns to specified types of data, and insert the data into a table in an Azure Synapse Analytic dedicated SQL pool. The CSV file contains three columns named username, comment, and date....
What should you include in the solution?
HOTSPOT You need to design an analytical storage solution for the transactional data. The solution must meet the sales transaction dataset requirements. What should you include in the solution? To answer, select the appropriate options in the answer area . NOTE: Each correct selection is worth one point. View AnswerAnswer:...
What should you do?
You have an Azure Synapse Analytics dedicated SQL Pool 1. Pool1 contains a partitioned fact table named dbo.Sales and a staging table named stg.Sales that has the matching table and partition definitions. You need to overwrite the content of the first partition in dbo.Sales with the content of the same...
On which column should you partition the table?
You are designing an inventory updates table in an Azure Synapse Analytics dedicated SQL pool. The table will have a clustered columnstore index and will include the following columns: You identify the following usage patterns: ✑ Analysts will most commonly analyze transactions for a warehouse. ✑ Queries will summarize by...
What should you recommend?
You plan to ingest streaming social media data by using Azure Stream Analytics. The data will be stored in files in Azure Data Lake Storage, and then consumed by using Azure Datiabricks and PolyBase in Azure Synapse Analytics. You need to recommend a Stream Analytics data output format to ensure...
Does this meet the goal?
You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table 1. You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container 1. You plan to insert data from the files into Table1 and azure Data Lake Storage...
What should you create?
You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements. What should you create?A . a table that has an IDENTITY propertyB . a system-versioned temporal tableC . a user-defined SEQUENCE objectD . a table that has a FOREIGN...
What should you include in the solution?
HOTSPOT You are designing a monitoring solution for a fleet of 500 vehicles. Each vehicle has a GPS tracking device that sends data to an Azure event hub once per minute. You have a CSV file in an Azure Data Lake Storage Gen2 container. The file maintains the expected geographical...
Which two actions should you perform?
You are creating an Azure Data Factory data flow that will ingest data from a CSV file, cast columns to specified types of data, and insert the data into a table in an Azure Synapse Analytic dedicated SQL pool. The CSV file contains three columns named username, comment, and date....
