MICROSOFT-DP203

Microsoft's DP-203 You have a SQL pool in Azure Synapse.You discover that some queries fail or take a long time to complete.You need to monitor for transactions that have rolled back.Which dynamic management view should you query?

Microsoft's DP-203 You are monitoring an Azure Stream Analytics job.You discover that the Backlogged Input Events metric is increasing slowly and is consistently non-zero.You need to ensure that the job can handle all the events.What should you do?

Microsoft's DP-203 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 product category type, date, and/or inventory event type.You need to recommend a partition strategy for the table to minimize query times.On which column should you partition the table?

Microsoft's DP-203 You are designing a star schema for a dataset that contains records of online orders. Each record includes an order date, an order due date, and an order ship date.You need to ensure that the design provides the fastest query times of the records when querying for arbitrary date ranges and aggregating by fiscal calendar attributes.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. E. Use DateTime columns for the date fields.

Microsoft's DP-203 A company purchases IoT devices to monitor manufacturing machinery. The company uses an Azure IoT Hub to communicate with the IoT devices.The company must be able to monitor the devices in real-time.You need to design the solution.What should you recommend?

Microsoft's DP-203 You have a SQL pool in Azure Synapse.A user reports that queries against the pool take longer than expected to complete. You determine that the issue relates to queried columnstore segments.You need to add monitoring to the underlying storage to help diagnose the issue.Which two metrics should you monitor? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

Microsoft's DP-203 You manage an enterprise data warehouse in Azure Synapse Analytics.Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries.You need to monitor resource utilization to determine the source of the performance issues.Which metric should you monitor?

Microsoft's DP-203 You have an Azure Databricks resource.You need to log actions that relate to changes in compute for the Databricks resource.Which Databricks services should you log? E. jobs

Microsoft's DP-203 You are designing a highly available Azure Data Lake Storage solution that will include geo-zone-redundant storage (GZRS).You need to monitor for replication delays that can affect the recovery point objective (RPO).What should you include in the monitoring solution?

Microsoft's DP-203 You configure monitoring for an Azure Synapse Analytics implementation. The implementation uses PolyBase to load data from comma-separated value (CSV) files stored in Azure Data Lake Storage Gen2 using an external table.Files with an invalid schema cause errors to occur.You need to monitor for an invalid schema error.For which error should you monitor?

Microsoft's DP-203 You have an Azure Synapse Analytics dedicated SQL pool.You run PDW_SHOWSPACEUSED('dbo.FactInternetSales'); and get the results shown in the following table.Which statement accurately describes the dbo.FactInternetSales table?

Microsoft's DP-203 You have two fact tables named Flight and Weather. Queries targeting the tables will be based on the join between the following columns.You need to recommend a solution that maximizes query performance.What should you include in the recommendation?

Microsoft's DP-203 You have several Azure Data Factory pipelines that contain a mix of the following types of activities:✑ Wrangling data flow✑ Notebook✑ Copy✑ JarWhich two Azure services should you use to debug the activities? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point E. Azure Databricks

Microsoft's DP-203 You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a fact table named Table1.You need to identify the extent of the data skew in Table1.What should you do in Synapse Studio?

Microsoft's DP-203 You manage an enterprise data warehouse in Azure Synapse Analytics.Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries.You need to monitor resource utilization to determine the source of the performance issues.Which metric should you monitor?

Microsoft's DP-203 You have an Azure data factory.You need to examine the pipeline failures from the last 180 days.What should you use?

Microsoft's DP-203 A company purchases IoT devices to monitor manufacturing machinery. The company uses an Azure IoT Hub to communicate with the IoT devices.The company must be able to monitor the devices in real-time.You need to design the solution.What should you recommend?

Microsoft's DP-203 You have an Azure Synapse Analytics dedicated SQL pool named SA1 that contains a table named Table1.You need to identify tables that have a high percentage of deleted rows.What should you run?

Microsoft's DP-203 You have an enterprise data warehouse in Azure Synapse Analytics.You need to monitor the data warehouse to identify whether you must scale up to a higher service level to accommodate the current workloads.Which is the best metric to monitor?More than one answer choice may achieve the goal. Select the BEST answer.

Microsoft's DP-203 A company purchases IoT devices to monitor manufacturing machinery. The company uses an Azure IoT Hub to communicate with the IoT devices.The company must be able to monitor the devices in real-time.You need to design the solution.What should you recommend?

Microsoft's DP-203 You have a partitioned table in an Azure Synapse Analytics dedicated SQL pool.You need to design queries to maximize the benefits of partition elimination.What should you include in the Transact-SQL queries?

Microsoft's DP-203 You have an Azure Stream Analytics query. The query returns a result set that contains 10,000 distinct values for a column named clusterID.You monitor the Stream Analytics job and discover high latency.You need to reduce the latency.Which two actions should you perform? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point. E. Convert the query to a reference query.

Microsoft's DP-203 You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a fact table named Table1.You need to identify the extent of the data skew in Table1.What should you do in Synapse Studio?

Microsoft's DP-203 You have an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 contains a fact table named Table1.You need to identify the extent of the data skew in Table1.What should you do in Synapse Studio?

Microsoft's DP-203 You use Azure Data Lake Storage Gen2.You need to ensure that workloads can use filter predicates and column projections to filter data at the time the data is read from disk.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. E. Register the query acceleration feature.

Microsoft's DP-203 You have an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 contains a fact table named Table1.You need to identify the extent of the data skew in Table1.What should you do in Synapse Studio?

Microsoft's DP-203 You have an Azure Data Lake Storage Gen2 account that contains two folders named Folder1 and Folder2.You use Azure Data Factory to copy multiple files from Folder1 to Folder2.You receive the following error.Operation on target Copy_sks failed: Failure happened on 'Sink' side.ErrorCode=DelimitedTextMoreColumnsThanDefined,'Type=Microsoft.DataTransfer.Common.Snared.HybridDeliveryException,Message=Error found when processing 'Csv/Tsv Format Text' source'0_2020_11_09_11_43_32.avro' with row number 53: found more columns than expected column count 27., Source=Microsoft.DataTransfer.Comnon,'What should you do to resolve the error?

Microsoft's DP-203 A company plans to use Apache Spark analytics to analyze intrusion detection data.You need to recommend a solution to analyze network and system activity data for malicious activities and policy violations. The solution must minimize administrative efforts.What should you recommend?

Microsoft's DP-203 You have an Azure Data Factory pipeline named pipeline1 that includes a Copy activity named Copy1. Copy1 has the following configurations:• The source of Copy1 is a table in an on-premises Microsoft SQL Server instance that is accessed by using a linked service connected via a self-hosted integration runtime.• The sink of Copy1 uses a table in an Azure SQL database that is accessed by using a linked service connected via an Azure integration runtime.You need to maximize the amount of compute resources available to Copy1. The solution must minimize administrative effort.What should you do?

Microsoft's DP-203 You are designing a solution that will use tables in Delta Lake on Azure Databricks.You need to minimize how long it takes to perform the following:• Queries against non-partitioned tables• Joins on non-partitioned columnsWhich two options should you include in the solution? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.