DP-200

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...

A company has a SaaS solution that uses Azure SQL Database with elastic pools. The solution contains a dedicated database for each customer organization. Customer organizations have peak usage at different periods during the year. You need to implement the Azure SQL Database elastic pool to minimize cost. Which option...

DRAG DROP Your company has on-premises Microsoft SQL Server instance. The data engineering team plans to implement a process that copies data from the SQL Server instance to Azure Blob storage. The process must orchestrate and manage the data lifecycle. You need to configure Azure Data Factory to connect to...

You develop data engineering solutions for a company. You must integrate the company’s on-premises Microsoft SQL Server data with Microsoft Azure SQL Database. Data must be transformed incrementally. You need to implement the data integration solution. Which tool should you use to configure a pipeline to copy data?A . Use...

You develop data engineering solutions for a company. You need to ingest and visualize real-time Twitter data by using Microsoft Azure. Which three technologies should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.A . Event Grid topicB . Azure Stream...

HOTSPOT You are building the data store solution for Mechanical Workflow. How should you configure Table1? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Table Type: Hash distributed. Hash-distributed tables improve query performance on large fact tables....

HOTSPOT Which masking functions should you implement for each column to meet the data masking requirements? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Default Default uses a zero value for numeric data types (bigint,...

Load the data using the INSERT…SELECT statement. Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: There is no need to convert the parquet files to CSV files. 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-lakestore

DRAG DROP You have a table named SalesFact in an Azure SQL data warehouse. SalesFact contains sales data from the past 36 months and has the following characteristics: - Is partitioned by month - Contains one billion rows - Has clustered columnstore indexes All the beginning of each month, you...

HOTSPOT Which masking functions should you implement for each column to meet the data masking requirements? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Default Default uses a zero value for numeric data types (bigint,...