| Exam Code | DP-201 |
| Exam Name | Data Engineering on Microsoft Azure |
| Questions | 273 Questions Answers With Explanation |
| Update Date | March 05,2024 |
| Price |
Was : |
Are you ready to take your career to the next level with Data Engineering on Microsoft Azure? At Prep4Certs, we're dedicated to helping you achieve your goals by providing high-quality DP-201 Dumps and resources for a wide range of certification exams.
At Prep4Certs, we're committed to your success in the Microsoft DP-201 exam. Our comprehensive study materials and resources are designed to equip you with the knowledge and skills needed to ace the exam with confidence:
Start Your Certification Journey Today
Whether you're looking to advance your career, expand your skill set, or pursue new opportunities, Prep4Certs is here to support you on your certification journey. Explore our comprehensive study materials, take your exam preparation to the next level, and unlock new possibilities for professional growth and success.
Ready to achieve your certification goals? Begin your journey with Prep4Certs today!
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 statedgoals. Some question sets might have more than one correct solution, while othersmight not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As aresult, thesequestions will not appear in the review screen.You are designing an Azure SQL Database that will use elastic pools. You plan to storedata about customers in a table. Each record uses a value for CustomerID.You need to recommend a strategy to partition data based on values in CustomerID.Proposed Solution: Separate data into shards by using horizontal partitioning.Does the solution meet the goal?
A. Yes
B. No
You plan to ingest streaming social media data by using Azure Stream Analytics. The datawill be stored in files in Azure Data Lake Storage, and then consumed by using AzureDatabricks and PolyBase in Azure SQL Data Warehouse.You need to recommend a Stream Analytics data output format to ensure that the queriesfrom Databricks and PolyBase against the files encounter the fewest possible errors. Thesolution must ensure that the files can be queried quickly and that the data type information is retained.What should you recommend?
A. Avro
B. CSV
C. Parquet
D. JSON
You have a Windows-based solution that analyzes scientific data. You are designing acloud-based solution that performs real-time analysis of the data.You need to design the logical flow for the solution.Which two actions should you recommend? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
A. Send data from the application to an Azure Stream Analytics job.
B. Use an Azure Stream Analytics job on an edge device. Ingress data from an Azure DataFactory instance and build queries that output to Power BI.
C. Use an Azure Stream Analytics job in the cloud. Ingress data from the Azure Event Hubinstance and build queries that output to Power BI.
D. Use an Azure Stream Analytics job in the cloud. Ingress data from an Azure Event Hubinstance and build queries that output to Azure Data Lake Storage.
E. Send data from the application to Azure Data Lake Storage.
F. Send data from the application to an Azure Event Hub instance.
You are designing an Azure Databricks interactive cluster. The cluster will be usedinfrequently and will be configured for auto-termination.You need to ensure that the cluster configuration is retained indefinitely after the cluster isterminated. The solution must minimize costs.What should you do?
A. Clone the cluster after it is terminated.
B. Terminate the cluster manually when processing completes.
C. Create an Azure runbook that starts the cluster every 90 days.
D. Pin the cluster.
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 statedgoals. Some question sets might have more than one correct solution, while othersmight not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As aresult, thesequestions will not appear in the review screen.A company is developing a solution to manage inventory data for a group of automotiverepair shops. Thesolution will use Azure SQL Data Warehouse as the data store.Shops will upload data every 10 days.Data corruption checks must run each time data is uploaded. If corruption is detected, thecorrupted data must be removed.You need to ensure that upload processes and data corruption checks do not impactreporting and analytics processes that use the data warehouse.Proposed solution: Create a user-defined restore point before data is uploaded. Delete therestore point after data corruption checks complete.Does the solution meet the goal?
A. Yes
B. No
You have a MongoDB database that you plan to migrate to an Azure Cosmos DB account that uses theMongoDB API.During testing, you discover that the migration takes longer than expected.You need to recommend a solution that will reduce the amount of time it takes to migrate the data.What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
A. Increase the Request Units (RUs).
B. Turn off indexing.
C. Add a write region.
D. Create unique indexes.
E. Create compound indexes.
You are designing an Azure Cosmos DB database that will support vertices and edges.Which Cosmos DB API should you include in the design?
A. SQL
B. Cassandra
C. Gremlin
D. Table
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 statedgoals. Some question sets might have more than one correct solution, while othersmight not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As aresult, these questions will not appear in the review screen.You have an Azure SQL database that has columns. The columns contain sensitivePersonally Identifiable Information (PII) data.You need to design a solution that tracks and stores all the queries executed against thePII data. You must be able to review the data in Azure Monitor, and the data must beavailable for at least 45 days.Solution: You add classifications to the columns that contain sensitive data. You turn onAuditing and set the audit log destination to use Azure Log Analytics.Does this meet the goal?
A. Yes
B. No
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 statedgoals. Some question sets might have more than one correct solution, while othersmight not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, thesequestions will not appear in the review screen.You are designing an Azure SQL Database that will use elastic pools. You plan to storedata about customers in a table. Each record uses a value for CustomerID.You need to recommend a strategy to partition data based on values in CustomerID.Proposed Solution: Separate data into customer regions by using horizontal partitioning.Does the solution meet the goal?
A. Yes
B. No
A company is developing a mission-critical line of business app that uses Azure SQL Database ManagedInstance. You must design a disaster recovery strategy for the solution.You need to ensure that the database automatically recovers when full or partial loss of the Azure SQLDatabase service occurs in the primary region.What should you recommend?
A. Failover-group
B. Azure SQL Data Sync
C. SQL Replication
D. Active geo-replication
