- All Exams Instant Download
Which two configurations should you include in the design?
You are designing a solution that will copy Parquet files stored in an Azure Blob storage account to an Azure Data Lake Storage Gen2 account. The data will be loaded daily to the data lake and will use a folder structure of {Year}/{Month}/{Day}/. You need to design a daily Azure...
You have an Azure Data Factory pipeline that has the activity shown in the following exhibit
HOTSPOT You have an Azure Data Factory pipeline that has the activity shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. View AnswerAnswer:
Which column should you add to the table?
You have a table in an Azure Synapse Analytics dedicated SQL pool. The table was created by using the following Transact-SQL statement. You need to alter the table to meet the following requirements: ✑ Ensure that users can identify the current manager of employees. ✑ Support creating an employee reporting...
What should you recommend using to secure sensitive customer contact information?
What should you recommend using to secure sensitive customer contact information?A . data labels B. column-level security C. row-level security D. Transparent Data Encryption (TDE)View AnswerAnswer: B Explanation: Scenario: All cloud data must be encrypted at rest and in transit. Always Encrypted is a feature designed to protect sensitive data...
How is the data for the lineage populated?
You have a Microsoft Purview account. The Lineage view of a CSV file is shown in the following exhibit. How is the data for the lineage populated?A . manually B. by scanning data stores C. by executing a Data Factory pipelineView AnswerAnswer: B Explanation: According to Microsoft Purview Data Catalog...
In which order should you perform the actions?
DRAG DROP You have an Azure Data Lake Storage Gen2 account that contains a JSON file for customers. The file contains two attributes named FirstName and LastName. You need to copy the data from the JSON file to an Azure Synapse Analytics table by using Azure Databricks. A new column...
Which three actions should you perform from Visual Studio on sequence?
DRAG DROP You have an Azure Stream Analytics job that is a Stream Analytics project solution in Microsoft Visual Studio. The job accepts data generated by IoT devices in the JSON format. You need to modify the job to accept data generated by the IoT devices in the Protobuf format....
How should you complete the code?
HOTSPOT You have an Azure subscription that contains an Azure Synapse Analytics workspace named workspace1. Workspace1 contains a dedicated SQL pool named SQL Pool and an Apache Spark pool named sparkpool. Sparkpool1 contains a DataFrame named pyspark.df. You need to write the contents of pyspark_df to a tabte in SQLPooM...
What should you include in the solution?
HOTSPOT You need to design the partitions for the product sales transactions. 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: Explanation: Box...
Which folder structure should you recommend to support fast queries and simplified folder security?
You are designing the folder structure for an Azure Data Lake Storage Gen2 container. Users will query data by using a variety of services including Azure Databricks and Azure Synapse Analytics serverless SQL pools. The data will be secured by subject area. Most queries will include data from the current...
