Practice Exam Questions For Microsoft DP-201 Exam

By | February 6, 2020

The DP-201 exam is required for the Microsoft Azure Data Engineer Associate Certification and DumpsSchool provides preparation content in its DP-201 exam dumps. Practice questions which you get from DumpsSchool DP-201 exam dumps help you gain maximum knowledge of Designing an Azure Data Solution topics.

Try it Latest DumpsSchool DP-201 Exam dumps. Buy Full File here: https://www.dumpsschool.com/dp-201-exam-dumps.html (146 As Dumps)

Download the DumpsSchool DP-201 braindumps from Google Drive: https://drive.google.com/file/d/1Gt2BHgFOCqqndtVkfMCVavaa9Rn1kBRI/view (FREE VERSION!!!)

Question No. 1

You are designing security for administrative access to Azure SQL Data Warehouse.

You need to recommend a solution to ensure that administrators use two-factor authentication when

accessing the data warehouse from Microsoft SQL Server Management Studio (SSMS).

What should you include in the recommendation?

Answer: A

Question No. 2

A company stores data in multiple types of cloud-based databases.

You need to design a solution to consolidate data into a single relational database. Ingestion of data will occur at set times each day.

What should you recommend?

Answer: C

Question No. 3

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 question sets might have more than one correct solution, while others might 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, these

questions will not appear in the review screen.

You are designing an HDInsight/Hadoop cluster solution that uses Azure Data Lake Gen1 Storage.

The solution requires POSIX permissions and enables diagnostics logging for auditing.

You need to recommend solutions that optimize storage.

Proposed Solution: Ensure that files stored are smaller than 250MB.

Does the solution meet the goal?

Answer: B

Ensure that files stored are larger, not smaller than 250MB.

You can have a separate compaction job that combines these files into larger ones.

Note: The file POSIX permissions and auditing in Data Lake Storage Gen1 comes with an overhead that

becomes apparent when working with numerous small files. As a best practice, you must batch your data into larger files versus writing thousands or millions of small files to Data Lake Storage Gen1. Avoiding small file sizes can have multiple benefits, such as:

Lowering the authentication checks across multiple files

Reduced open file connections

Faster copying/replication

Fewer files to process when updating Data Lake Storage Gen1 POSIX permissions

References:

https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-best-practices

Question No. 4

You are designing an Azure Databricks cluster that runs user-defined local processes.

You need to recommend a cluster configuration that meets the following requirements:

* Minimize query latency.

* Reduce overall costs.

* Maximize the number of users that can run queries on the cluster at the same time.

Which cluster type should you recommend?

Answer: C

High Concurrency clusters allow multiple users to run queries on the cluster at the same time, while minimizing query latency. Autoscaling clusters can reduce overall costs compared to a statically-sized cluster.

References:

https://docs.azuredatabricks.net/user-guide/clusters/create.html

https://docs.azuredatabricks.net/user-guide/clusters/high-concurrency.html#high-concurrency

https://docs.azuredatabricks.net/user-guide/clusters/terminate.html

https://docs.azuredatabricks.net/user-guide/clusters/sizing.html#enable-and-configure-autoscaling

Question No. 5

You are designing an application. You plan to use Azure SQL Database to support the application.

The application will extract data from the Azure SQL Database and create text documents. The text documents will be placed into a cloud-based storage solution. The text storage solution must be accessible from an SMB network share.

You need to recommend a data storage solution for the text documents.

Which Azure data storage type should you recommend?

Answer: B

Azure Files enables you to set up highly available network file shares that can be accessed by using the standard Server Message Block (SMB) protocol.

References:

https://docs.microsoft.com/en-us/azure/storage/common/storage-introduction

https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-overview

DP-201 Dumps Google Drive: (Limited Version!!!)
https://drive.google.com/file/d/1Gt2BHgFOCqqndtVkfMCVavaa9Rn1kBRI/view

Exam Vendor: Microsoft dumps

Leave a Reply

Your email address will not be published. Required fields are marked *