DP-203 Exam Questions
311 real DP-203 exam questions with expert-verified answers and explanations. Page 6 of 7.
- Question #342Secure, monitor, and optimize data storage and data processing
You have an Azure Synapse Analytics dedicated SQL pool that contains a table named dbo.Users. You need to prevent a group of users from reading user email addresses from dbo.Users....
column-level securitydynamic data maskingdedicated SQL poolaccess control - Question #344Design and implement data storage
You have an Azure subscription that contains a storage account named storage1 and an Azure Synapse Analytics dedicated SQL pool. The storage1 account contains a CSV file that requi...
database scoped credentialexternal tableexternal data sourceADLS Gen2 - Question #346Secure, monitor, and optimize data storage and data processing
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...
integration runtimeself-hosted IRCopy activity performanceAzure IR scaling - Question #347Secure, monitor, and optimize data storage and data processing
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-partitio...
Delta LakeZ-Orderingdynamic file pruningAzure Databricks optimization - Question #348Design and implement data storage
You have an Azure Data Lake Storage Gen2 account named account1 that contains a container named container1. You plan to create lifecycle management policy rules for container1. You...
lifecycle managementaccess time trackingblob storage tiersADLS Gen2 - Question #350Secure, monitor, and optimize data storage and processing
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 i...
Azure Synapse AnalyticsPerformance MonitoringCacheQuery Optimization - Question #351Design and implement data storage
You have an Azure subscription that contains an Azure Synapse Analytics workspace named ws1 and an Azure Cosmos DB database account named Cosmos1. Cosmos1 contains a container name...
Azure Synapse LinkCosmos DB AnalyticsSynapse SQL PoolLinked Services - Question #353Implement and Manage Data Storage Security - Configure access control for Azure Data Lake Storage Gen2 using POSIX-style ACLs
Drag and Drop Question You have an Azure subscription that contains an Azure Data Lake Storage Gen2 account named account1 and a user named User1. In account1, you create a contain...
Azure Data Lake Storage Gen2ACL PermissionsLeast PrivilegeData Security - Question #354Develop data processing
You have an Azure Data Factory pipeline named pipeline1. You need to execute pipeline1 at 2 AM every day. The solution must ensure that if the trigger for pipeline1 stops, the next...
Azure Data FactoryADF TriggersSchedule TriggerPipeline Orchestration - Question #356Secure, monitor, and optimize data storage and processing
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 i...
Azure Synapse AnalyticsPerformance MonitoringQuery OptimizationCaching - Question #358Develop data processing
You have an Azure data factory named ADF1 that contains a pipeline named Pipeline1. Pipeline1 must execute every 30 minutes with a 15-minute offset. You need to create a trigger fo...
Azure Data FactoryTumbling Window TriggerPipeline OrchestrationBackfilling - Question #360Develop data processing
You have an Azure Synapse Analytics workspace that contains an Apache Spark pool named SparkPool1. SparkPool1 contains a Delta Lake table named SparkTable1. You need to recommend a...
serverless SQL poolDelta Lakepartition eliminationpartitioned view - Question #361Design and implement data storage
You have an Azure Synapse Analytics workspace. You plan to deploy a lake database by using a database template in Azure Synapse. Which two elements are included in the template? Ea...
lake databasedatabase templatetable definitionsrelationships - Question #363Design and implement data storage
You have an Azure subscription that contains an Azure Synapse Analytics serverless SQL pool. You execute the following query. Where will the rows returned by the query be stored?
serverless SQL poolCETASdata lake storagequery output - Question #364Design and implement data storage
You are deploying a lake database by using an Azure Synapse database template. You need to add additional tables to the database. The solution must use the same grouping method as...
lake databasebusiness area groupingdatabase templateAzure Synapse Analytics - Question #365Develop data processing
You have an Azure data factory connected to a Git repository that contains the following branches: - main: Collaboration branch - abc: Feature branch - xyz: Feature branch You save...
Azure Data FactoryGit IntegrationBranching StrategyDeployment Workflow - Question #366Develop data processing
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...
Azure Data FactoryPipeline developmentGit integrationValidation - Question #367Develop data processing
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...
Azure Data Factorypipeline debuggingADF Studioerror handling - Question #368Develop data processing
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...
Azure Data Factorypipeline debuggingADF Studioerror handling - Question #370Design and Implement Data Storage - Managing Azure Cosmos DB containers and analytical store configuration (e.g., AZ-204, DP-420, or DP-900 certification domains)
Drag and Drop Question You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1. The account1 account contains a container named Container1...
Azure Cosmos DBAnalytical StoreNoSQL Container ManagementAzure Data Migration - Question #371Design and Implement Data Storage - specifically managing and optimizing distributed tables in Azure Synapse Analytics dedicated SQL pools, including zero-downtime schema changes using CTAS and rename patterns.
Drag and Drop Question You have an Azure Synapse Analytics dedicated SQL pool named SQL1 that contains a hash- distributed fact table named Table1. You need to recreate Table1 and...
Azure Synapse AnalyticsDedicated SQL PoolCTASHash DistributionTable Migration - Question #372Develop data processing
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...
Azure Data Factorypipeline debuggingADF Studioerror handling - Question #373Develop data processing
You have an Azure Data Lake Storage Gen2 account named account1 and an Azure event hub named Hub1. Data is written to account1 by using Event Hubs Capture. You plan to query accoun...
ParquetEvent Hubs Capturedata formatsSpark ingestion - Question #374Develop data processing
You have an Azure Blob Storage account named blob1 and an Azure Data Factory pipeline named pipeline1. You need to ensure that pipeline1 runs when a file is deleted from a containe...
storage event triggerAzure Blob Storageevent-driven pipelineAzure Data Factory - Question #376Implement and manage data integration pipelines in Azure Data Factory, including configuring copy activities, control flow constructs, and file system behaviors for data movement scenarios.
Drag and Drop Question You have an Azure subscription that contains an Azure data factory. You are editing an Azure Data Factory activity JSON. The script needs to copy a file from...
Azure Data FactoryCopy ActivityControl FlowPipeline Authoring - Question #377Develop data processing
You are building a data flow in Azure Data Factory that upserts data into a table in an Azure Synapse Analytics dedicated SQL pool. You need to add a transformation to the data flo...
alter row transformationdata flowupsert logicAzure Data Factory - Question #378Develop data processing
You have an on-premises database named db1 and a set-hosted integration runtime. You have an Azure subscription that contains an Azure Data Lake Storage account named dl1. You need...
Power Queryself-hosted integration runtimeAzure Data FactoryGit integration - Question #379Develop data processing
You have the Azure Synapse Analytics pipeline shown in the following exhibit. You need to add a set variable activity to the pipeline to ensure that after the pipeline's completion...
pipeline dependency conditionsset variable activityerror handlingAzure Synapse Analytics - Question #380Develop data processing
You have an on-premises Linux server that contains a database named DB1. You have an Azure subscription that contains an Azure data factory named ADF1 and an Azure Data Lake Storag...
integration runtimeself-hosted runtimeADF pipelineon-premises connectivity - Question #381Design and Implement Data Storage / Query and Transform Data using Azure Synapse Analytics
Drag and Drop Question You have an Azure Data Lake Storage account named account1. You use an Azure Synapse Analytics serverless SQL pool to access sales data stored in account1. Y...
Azure Synapse AnalyticsServerless SQL PoolSynapse StudioData Visualization - Question #382Design and Implement Data Storage / Manage and Monitor Data Storage in Azure (DP-203 or AZ-305 - Synapse Analytics backup, restore, and cost management)
Drag and Drop Question You have an Azure Synapse Analytics dedicated SQL pool. You need to create a copy of the data warehouse and make the copy available for 28 days. The solution...
Azure Synapse AnalyticsDedicated SQL PoolRestore PointsCost Optimization - Question #386Develop data processing
You have an Azure Data Factory pipeline named P1. You need to schedule P1 to run at 10:15 AM, 12:15 PM, 2:15 PM, and 4:15 PM every day. Which frequency and interval should you conf...
ADF schedule triggerpipeline schedulingtrigger frequencyinterval configuration - Question #387Secure, monitor, and optimize data storage and data processing
You have a tenant in Microsoft Azure Active Directory (Azure AD), part of Microsoft Entra. The tenant contains a group named Group1. You have an Azure subscription that contains th...
OPENROWSETdatabase scoped credentialleast privilegeSynapse serverless SQL - Question #388Develop data processing
You have an Azure subscription that contains an Azure Data Lake Storage account named dl1 and an Azure Analytics Synapse workspace named workspace1. You need to query the data in d...
Spark poolADLS linked serviceSynapse Analyticsdata access configuration - Question #390Secure, monitor, and optimize data storage and data processing
You have an Azure subscription that contains an Azure Synapse Analytics workspace and a user named User1. You need to ensure that User1 can review the Azure Synapse Analytics datab...
Synapse RBACSynapse User roleleast privilegedatabase templates gallery - Question #391Secure, monitor, and optimize data storage and data processing
You have a Log Analytics workspace named la1 and an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 sends logs to la1. You need to identify whether a recently execute...
result set cachededicated SQL poolDMV monitoringSynapse Studio Monitor hub - Question #393Secure, monitor, and optimize data storage and data processing
You have an Azure data factory named DF1. DF1 contains a single pipeline that is executed by using a schedule trigger. From Diagnostics settings, you configure pipeline runs to be...
ADF diagnosticsLog AnalyticsKQLresource-specific table - Question #395Secure, monitor, and optimize data storage and data processing
You have an Azure subscription that contains an Azure Synapse workspace named WS1 and an Azure Monitor action group named Group1. WS1 has a dedicated SQL pool. You plan to archive...
Azure Monitordiagnostic settingsLog Analytics workspacecustom alerts - Question #396Secure, monitor, and optimize data storage and data processing
You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named Pool1. You have the queries shown in the following table. You are evaluating whethe...
result set cachingdedicated SQL poolcache eligibilityquery evaluation - Question #397Secure, monitor, and optimize data storage and data processing
You have an Azure subscription that contains an Azure Synapse Analytics workspace name workspace1, workspace1 contains an Azure Synapse Analytics dedicated SQL pool named Pool1. Yo...
mapping data flowsink processing timeperformance metricspipeline execution - Question #398Design and implement data storage
You have an Azure subscription that contains the resources shown in the following table. You need to implement Azure Synapse Link for Azure SQL Database. Which two actions should y...
Synapse LinkAzure SQL Databasemanaged identityfirewall configuration - Question #399Design and implement data storage
You have an Azure subscription that contains an Azure Cosmos DB database. Azure Synapse Link is implemented on the database. You configure a full fidelity schema for the analytical...
Cosmos DB analytical storefull fidelity schemacolumn representationmixed data types - Question #401Develop data processing
You are creating an Azure Data Factory pipeline. You need to add an activity to the pipeline. The activity must execute a Transact-SQL stored procedure that has the following chara...
ADF Lookup activitystored procedurepipeline activity typesreturn values - Question #403Reading and writing data in Azure Databricks using Spark structured APIs
Drag and Drop Question You have an Azure Databricks deployment and a local file named /tmp/file1 that contains the following code. You need to read /tmp/file1 into a data frame by...
Azure DatabricksSpark DataFrameReaderJSON ingestionScala - Question #404Secure, monitor, and optimize data storage and data processing
You have an Azure subscription that contains a Microsoft Purview account. You need to search the Microsoft Purview Data Catalog to identify assets that have an assetType property o...
Microsoft PurviewData Catalogsearch query syntaxasset discovery - Question #405Secure, monitor, and optimize data storage and data processing
You have an Azure Synapse Analytics dedicated SQL pool named SQL1 and a user named User1. You need to ensure that User1 can view requests associated with SQL1 by querying the sys.d...
DMV permissionsVIEW DATABASE STATEdedicated SQL poolleast privilege - Question #406Secure, monitor, and optimize data storage and data processing
You have a Microsoft Entra tenant. The tenant contains an Azure Data Lake Storage Gen2 account named storage1 that has two containers named fs1 and fs2. You have a Microsoft Entra...
ADLS Gen2 RBACStorage Blob Data Contributorcontainer-level accessleast privilege - Question #407Secure, monitor, and optimize data storage and data processing
You have an Azure data factory named DF1. DF1 contains a pipeline that has five activities. You need to monitor queue times across the activities by using Log Analytics. What shoul...
ADF monitoringLog Analyticsactivity runs diagnosticsqueue time - Question #408Secure, monitor, and optimize data storage and data processing
You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named Pool1. You need to monitor Pool1. The solution must ensure that you capture the sta...
Synapse SQL pool monitoringdiagnostic settingsExec Requestsquery timing - Question #409Secure, monitor, and optimize data storage and data processing
You have an Azure Stream Analytics job named Job1. The metrics of Job1 from the last hour are shown in the following table. The late arrival tolerance for Job1 is set to five secon...
Stream Analytics optimizationstreaming unitsquery parallelizationperformance tuning