DP-200

You need to process and query ingested Tier 9 data. Which two options should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.A . Azure Notification HubB . Transact-SQL statementsC . Azure Cache for RedisD . Apache Kafka statementsE . Azure...

Load the data using the CREATE TABLE AS SELECT statement. Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: You load the data using the CREATE TABLE AS SELECT statement. References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure­data-lake-store

DRAG DROP You need to ensure that phone-based polling data can be analyzed in the PollingData database. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer are and arrange them in the correct order. View AnswerAnswer: Explanation:...

A company manages several on-premises Microsoft SQL Server databases. You need to migrate the databases to Microsoft Azure by using the backup process of Microsoft SQL Server. Which data technology should you use?A . Azure SQL Database Managed InstanceB . Azure SQL Data WarehouseC . Azure Cosmos DBD . Azure...

Your company uses several Azure HDInsight clusters. The data engineering team reports several errors with some application using these clusters. You need to recommend a solution to review the health of the clusters. What should you include in you recommendation?A . Azure AutomationB . Log AnalyticsC . Application InsightsView AnswerAnswer:...

DRAG DROP You need to provision the polling data storage account. How should you configure the storage account? To answer, drag the appropriate Configuration Value to the correct Setting. Each Configuration Value may be used once, more than once, or not at all. You may need to drag the split...

HOTSPOT You need to mask tier 1 data. Which functions should you use? To answer, select the appropriate option in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: A: Default Full masking according to the data types of the designated fields. For string data...

Validate configuration results and deploy the solution Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: Use the Azure Key Vault, not the Windows Certificate Store, to store the master key. Note: The Master Key Configuration page is where you set up your CMK (Column Master...

You need to set up Azure Data Factory pipelines to meet data movement requirements. Which integration runtime should you use?A . self-hosted integration runtimeB . Azure-SSIS Integration RuntimeC . .NET Common Language Runtime (CLR)D . Azure integration runtimeView AnswerAnswer: A Explanation: The following table describes the capabilities and network support...

Validate configuration results and deploy the solution Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: Use the Azure Key Vault, not the Windows Certificate Store, to store the master key. Note: The Master Key Configuration page is where you set up your CMK (Column Master...