dp 203 case study questions Practice Exam: Test Your Knowledge 2025

You are designing a data lake solution for your organization. The solution needs to store petabytes of unstructured data with hierarchical namespace support for big data analytics workloads. Which Azure storage option should you implement?

Your company is migrating an on-premises SQL Server database to Azure. The database is 8 TB in size and requires support for cross-database queries and SQL Agent jobs. Which Azure service should you choose?

You need to implement a data partitioning strategy for a large fact table in Azure Synapse Analytics dedicated SQL pool to optimize query performance. The table contains 5 years of sales data and most queries filter by transaction date. What partitioning strategy should you use?

You are developing an Azure Data Factory pipeline to copy data from an on-premises SQL Server to Azure Data Lake Storage Gen2. The on-premises network has strict firewall rules. What component must you install to enable this data movement?

You have an Azure Databricks notebook that processes streaming data from Azure Event Hubs. The notebook needs to track the processing progress and handle failures by resuming from the last checkpoint. What feature should you implement?

You need to orchestrate a complex data workflow in Azure that includes data movement, Databricks notebook execution, and conditional logic based on previous activity outcomes. The solution must support scheduling, monitoring, and retry logic. Which service should you use?

Your organization processes IoT sensor data that arrives at high velocity. You need to ingest millions of events per second, ensure event ordering per device, and enable multiple consumers to read the stream independently. Which Azure service provides the best solution?

You are implementing a medallion architecture (bronze, silver, gold layers) in Azure Databricks using Delta Lake. What is the PRIMARY purpose of the bronze layer?

You have a data pipeline in Azure Synapse Analytics that loads data into a dedicated SQL pool. The pipeline runs nightly and occasionally fails due to transient errors. You need to implement a solution that automatically retries failed activities with exponential backoff. What should you configure?

You need to implement slowly changing dimension (SCD) Type 2 logic in Azure Databricks to track historical changes in customer data. Which Delta Lake feature provides the most efficient implementation?

Your Azure Data Factory pipeline processes sensitive customer data. You need to parameterize the connection string for Azure SQL Database without exposing credentials in the pipeline code. What is the recommended approach?

You are implementing column-level security in Azure Synapse Analytics dedicated SQL pool. Users in the Finance group should see all columns in the Employee table, while users in the HR group should not see the Salary column. What should you implement?

Your Azure Synapse Analytics workspace experiences slow query performance during business hours. You need to identify the longest-running queries and their resource consumption. Which DMV (Dynamic Management View) should you query?

You need to enable auditing for an Azure SQL Database to track all database events and store audit logs for compliance requirements. The audit logs must be retained for 5 years. Where should you configure the audit logs to be stored?

Your Azure Data Lake Storage Gen2 account contains sensitive data that must comply with GDPR requirements. You need to ensure that data is encrypted at rest using your own encryption keys that you can rotate on demand. What should you implement?

You have an Azure Synapse Analytics dedicated SQL pool with multiple fact and dimension tables. Queries joining large fact tables are performing poorly. You've verified that statistics are up to date. What additional optimization technique should you implement?

You need to implement a solution to automatically scale Azure Databricks clusters based on workload demands while minimizing costs. The clusters run scheduled data processing jobs with variable data volumes. What should you configure?

You are implementing change data capture (CDC) for an Azure SQL Database that needs to track all inserts, updates, and deletes. The downstream system consumes changes in near real-time. Which technology should you use?

Your company uses Azure Data Factory to orchestrate data pipelines. You need to implement CI/CD for deploying pipeline changes across development, staging, and production environments. What is the recommended approach?

You are designing a real-time analytics solution that ingests clickstream data, performs aggregations, and displays results on a dashboard with sub-second latency. The solution must handle 100,000 events per second. Which Azure services combination is most appropriate?