DP-203 V5

You have a data warehouse in Azure Synapse Analytics. You need to ensure that the data in the data warehouse is encrypted at rest. What should you enable?A . Advanced Data Security for this database B. Transparent Data Encryption (TDE) C. Secure transfer required D. Dynamic Data MaskingView AnswerAnswer: B...

You have an Azure data factory. You need to examine the pipeline failures from the last 180 flays. What should you use?A . the Activity tog blade for the Data Factory resource B. Azure Data Factory activity runs in Azure Monitor C. Pipeline runs in the Azure Data Factory user...

HOTSPOT 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...

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:

HOTSPOT You have an Azure Storage account that generates 200,000 new files daily. The file names have a format of {YYYY}/{MM}/{DD}/{HH}/{CustomerID}.csv. You need to design an Azure Data Factory solution that will load new data from the storage account to an Azure Data Lake once hourly. The solution must minimize...

You are designing a streaming data solution that will ingest variable volumes of data. You need to ensure that you can change the partition count after creation. Which service should you use to ingest the data?A . Azure Event Hubs Dedicated B. Azure Stream Analytics C. Azure Data Factory D....

HOTSPOT You need to design a data storage structure 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:...

HOTSPOT You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool. You plan to deploy a solution that will analyze sales data and include the following: • A table named Country that will contain 195 rows • A table named Sales that will contain 100 million...

You need to integrate the on-premises data sources and Azure Synapse Analytics. The solution must meet the data integration requirements. Which type of integration runtime should you use?A . Azure-SSIS integration runtime B. self-hosted integration runtime C. Azure integration runtimeView AnswerAnswer: C

You have an Azure Data Lake Storage account that contains a staging zone. You need to design a dairy process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics....