DP-201 Free Questions – Designing an Azure Data Solution – PassQuestion Free Questions To Test Online

1. You need to design the vehicle images storage solution.

What should you recommend?

Azure Media Services

Azure Premium Storage account

Azure Redis Cache

Azure Cosmos DB

2. You need to design a sharding strategy for the Planning Assistance database.

What should you recommend?

a list mapping shard map on the binary representation of the License Plate column

a range mapping shard map on the binary representation of the speed column

a list mapping shard map on the location column

a range mapping shard map on the time column

3. You need to recommend an Azure SQL Database pricing tier for Planning Assistance.

Which pricing tier should you recommend?

Business critical Azure SQL Database single database

General purpose Azure SQL Database Managed Instance

Business critical Azure SQL Database Managed Instance

General purpose Azure SQL Database single database

4. You need to design the runtime environment for the Real Time Response system.

What should you recommend?

General Purpose nodes without the Enterprise Security package

Memory Optimized Nodes without the Enterprise Security package

Memory Optimized nodes with the Enterprise Security package

General Purpose nodes with the Enterprise Security package

5. You need to recommend a solution for storing the image tagging data.

What should you recommend?

Azure File Storage

Azure Cosmos DB

Azure Blob Storage

Azure SQL Database

Azure SQL Data Warehouse

6. You need to design the solution for analyzing customer data.

What should you recommend?

Azure Databricks

Azure Data Lake Storage

Azure SQL Data Warehouse

Azure Cognitive Services

Azure Batch

7. You need to design a backup solution for the processed customer data.

What should you include in the design?

AzCopy

AdlCopy

Geo-Redundancy

Geo-Replication

8. You need to design a solution to meet the SQL Server storage requirements for CONT_SQL3.

Which type of disk should you recommend?

Standard SSD Managed Disk

Premium SSD Managed Disk

Ultra SSD Managed Disk

9. You need to recommend an Azure SQL Database service tier.

What should you recommend?

Business Critical

General Purpose

Premium

Standard

Basic

10. You need to recommend the appropriate storage and processing solution?

What should you recommend?

Enable auto-shrink on the database.

Flush the blob cache using Windows PowerShell.

Enable Apache Spark RDD (RDD) caching.

Enable Databricks IO (DBIO) caching.

Configure the reading speed using Azure Data Studio.

DP-201 Free Questions – Designing an Azure Data Solution

DP-201 Free Questions – Designing an Azure Data Solution

Leave a Reply Cancel reply