DP-203 Exam Questions
311 real DP-203 exam questions with expert-verified answers and explanations. Page 1 of 7.
- Question #1
Case Study 1 - Contoso, Ltd Overview Contoso, Ltd. is a clothing retailer based in Seattle. The company has 2,000 retail stores across the United States and an emerging online pres...
- Question #2
Case Study 1 - Contoso, Ltd Overview Contoso, Ltd. is a clothing retailer based in Seattle. The company has 2,000 retail stores across the United States and an emerging online pres...
- Question #3
Case Study 1 - Contoso, Ltd Overview Contoso, Ltd. is a clothing retailer based in Seattle. The company has 2,000 retail stores across the United States and an emerging online pres...
- Question #4
Case Study 1 - Contoso, Ltd Overview Contoso, Ltd. is a clothing retailer based in Seattle. The company has 2,000 retail stores across the United States and an emerging online pres...
- Question #5Design and Implement Data Storage / Configure external data sources and PolyBase in Azure Synapse Analytics or SQL Server (DP-203 / DP-900 / 70-765)
Case Study 1 - Contoso, Ltd Overview Contoso, Ltd. is a clothing retailer based in Seattle. The company has 2,000 retail stores across the United States and an emerging online pres...
PolyBaseAzure Synapse AnalyticsExternal TablesT-SQL DDL - Question #8
You are designing a fact table named FactPurchase in an Azure Synapse Analytics dedicated SQL pool. The table contains purchases from suppliers for a retail store. FactPurchase wil...
- Question #9
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 foll...
- Question #10
You have an Azure Synapse workspace named MyWorkspace that contains an Apache Spark database named mytestdb. You run the following command in an Azure Synapse Analytics Spark pool...
- Question #11
You have files and folders in Azure Data Lake Storage Gen2 for an Azure Synapse workspace as shown in the following exhibit. You create an external table named ExtTable that has LO...
- Question #12
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 Syna...
- Question #13
You need to design an Azure Synapse Analytics dedicated SQL pool that meets the following requirements: - Can return an employee record from a given point in time. - Maintains the...
- Question #14
You have an enterprise-wide Azure Data Lake Storage Gen2 account. The data lake is accessible only through an Azure virtual network named VNET1. You are building a SQL pool in Azur...
- Question #15
You are creating an Azure Data Factory data flow that will ingest data from a CSV file, cast columns to specified types of data, and insert the data into a table in an Azure Synaps...
- Question #16
You have an Azure Storage account and a data warehouse in Azure Synapse Analytics in the UK South region. You need to copy blob data from the storage account to the data warehouse...
- Question #17
You have an Azure Stream Analytics job that receives clickstream data from an Azure event hub. You need to define a query in the Stream Analytics job. The query must meet the follo...
- Question #18
You need to schedule an Azure Data Factory pipeline to execute when a new file arrives in an Azure Data Lake Storage Gen2 container. Which type of trigger should you use?
- Question #19
You have two Azure Data Factory instances named ADFdev and ADFprod. ADFdev connects to an Azure DevOps Git repository. You publish changes from the main branch of the Git repositor...
- Question #20
You are developing a solution that will stream to Azure Stream Analytics. The solution will have both streaming data and reference data. Which input type should you use for the ref...
- Question #21
You are designing an Azure Stream Analytics job to process incoming events from sensors in retail environments. You need to process the events to produce a running average of shopp...
- Question #22
You are designing an Azure Databricks table. The table will ingest an average of 20 million streaming events per day. You need to persist the events in the table for use in increme...
- Question #23
You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. You need to configure workspace1 to support autoscaling all-purpose clusters. The solution mus...
- Question #24
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 q...
- Question #25
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 q...
- Question #26
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 q...
- Question #27
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 q...
- Question #28
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 q...
- Question #29
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 q...
- Question #30
You have an Azure Synapse Analytics dedicated SQL pool. You need to ensure that data in the pool is encrypted at rest. The solution must NOT require modifying applications that que...
- Question #31
You plan to create an Azure Synapse Analytics dedicated SQL pool. You need to minimize the time it takes to identify queries that return confidential information as defined by the...
- Question #32
You are designing an enterprise data warehouse in Azure Synapse Analytics that will contain a table named Customers. Customers will contain credit card information. You need to rec...
- Question #33
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...
- Question #34
You implement an enterprise data warehouse in Azure Synapse Analytics. You have a large fact table that is 10 terabytes (TB) in size. Incoming queries use the primary key SaleKey c...
- Question #35
You have an Azure Synapse Analytics dedicated SQL pool that contains a large fact table. The table contains 50 columns and 5 billion rows and is a heap. Most queries against the ta...
- Question #36
You create an Azure Databricks cluster and specify an additional library to install. When you attempt to load the library to a notebook, the library in not found. You need to ident...
- Question #37
You have an Azure data factory. You need to examine the pipeline failures from the last 60 days. What should you use?
- Question #38
You are monitoring an Azure Stream Analytics job. The Backlogged Input Events count has been 20 for the last hour. You need to reduce the Backlogged Input Events count. What should...
- Question #39
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...
- Question #40
You have an alert on a SQL pool in Azure Synapse that uses the signal logic shown in the exhibit. On the same day, failures occur at the following times: 08:01 08:03 08:04 08:06 08...
- Question #41
You plan to monitor the performance of Azure Blob storage by using Azure Monitor. You need to be notified when there is a change in the average time it takes for a storage service...
- Question #42
You create an Azure Databricks cluster and specify an additional library to install. When you attempt to load the library to a notebook, the library is not found. You need to ident...
- Question #44Design and Implement Data Storage - specifically optimizing data loading, archiving, and partition management strategies in Azure Synapse Analytics dedicated SQL pools (DP-203 / Azure Data Engineer Associate)
Drag and Drop Question You have a table named SalesFact in an enterprise data warehouse in Azure Synapse Analytics. SalesFact contains sales data from the past 36 months and has th...
Azure Synapse AnalyticsPartition SwitchingClustered Columnstore IndexData Warehouse Performance Optimization - Question #50Design and Implement Data Storage - Implement partitioned tables and data distribution strategies in Azure Synapse Analytics dedicated SQL pools
Drag and Drop Question You need to create a partitioned table in an Azure Synapse Analytics dedicated SQL pool. How should you complete the Transact-SQL statement? To answer, drag...
Azure Synapse AnalyticsDedicated SQL PoolTable PartitioningT-SQL DDL - Question #52Design and Implement Data Storage and Processing Pipelines in Azure (DP-203 / Azure Data Engineer Associate)
Drag and Drop Question You need to create an Azure Data Factory pipeline to process data for the following three departments at your company: Ecommerce, retail, and wholesale. The...
Azure Data FactoryData FlowConditional Split TransformationPipeline Scripting - Question #56Implement and manage data processing pipelines using Azure Stream Analytics, including configuring custom input serialization formats for IoT and streaming workloads (DP-203 / Azure Data Engineer Associate)
Drag and Drop Question 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...
Azure Stream AnalyticsCustom DeserializerProtobufVisual Studio Integration - Question #61Monitor and optimize Azure Data Factory pipelines / Implement monitoring and logging for Azure data solutions
Drag and Drop Question You have an Azure data factory. You need to ensure that pipeline-run data is retained for 120 days. The solution must ensure that you can query the data by u...
Azure Data FactoryLog AnalyticsDiagnostic SettingsKusto Query Language (KQL) - Question #62Design and Implement Data Security - Configure authentication, authorization, and access control for Azure Synapse Analytics dedicated SQL pools using Azure Active Directory and database-level roles.
Drag and Drop Question You have an Azure Active Directory (Azure AD) tenant that contains a security group named Group1. You have an Azure Synapse Analytics dedicated SQL pool name...
Azure Synapse AnalyticsSQL Pool SecurityAzure AD IntegrationLeast Privilege Access Control - Question #65Develop data processing
Case Study 1 - Contoso, Ltd Overview Contoso, Ltd. is a clothing retailer based in Seattle. The company has 2,000 retail stores across the United States and an emerging online pres...
Azure Data FactoryIntegration RuntimesData IntegrationAzure Synapse Analytics - Question #68
You have an Azure Data Lake Storage account that has a virtual network service endpoint configured. You plan to use Azure Data Factory to extract data from the Data Lake Storage ac...
- Question #69
You plan to create a dimension table in Azure Synapse Analytics that will be less than 1 GB. You need to create the table to meet the following requirements: - Provide the fastest...
- Question #71
You have an Azure Synapse Analystics dedicated SQL pool that contains a table named Contacts. Contacts contains a column named Phone. You need to ensure that users in a specific ro...