← Back to exam page

DP-201 – Designing an Azure Data Solution

Loading demo links...

Showing 10–12 of 15 questions

Question 10 (Mixed Questions)

You need to design a solution to support the storage of datasets. The solution must meet the following requirements:

Send email alerts when new datasets are added.

Control access to collections of datasets by using Azure Active Directory groups.

Support the storage of Microsoft Excel, Comma Separated Values (CSV), and zip files.

What should you include in the solution?

Select an option, then click Submit answer.

  • ○

    Azure SQL Database
  • ○

    Azure Storage
  • ○

    Azure Cosmos DB
  • ○

    Azure HDInsight
Question 11 (Mixed Questions)

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 without compromising other requirements.

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

Which cluster type should you recommend?

Select an option, then click Submit answer.

  • ○

    Standard with Autoscaling
  • ○

    High Concurrency with Auto Termination
  • ○

    High Concurrency with Autoscaling
  • ○

    Standard with Auto Termination
Question 12 (Mixed Questions)

You are planning a streaming data solution that will use Azure Databricks. The solution will stream sales transaction data from an online store. The solution has the following specifications:

The output data will contain items purchased, quantity, line total sales amount, and line total tax amount.

Line total sales amount and line total tax amount will be aggregated in Databricks.

Sales transactions will never be updated. Instead, new rows will be added to adjust a sale.

You need to recommend an output mode for the dataset that will be processed by using Structured Streaming. The solution must minimize duplicate data.

What should you recommend?

Select an option, then click Submit answer.

  • ○

    Append
  • ○

    Complete
  • ○

    Update