Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 1 question 30 discussion

Actual exam question from Microsoft's DP-201

Question #: 30
Topic #: 1

You plan to store 100 GB of data used by a line-of-business (LOB) app.
You need to recommend a data storage solution for the data. The solution must meet the following requirements:
✑ Minimize storage costs.
✑ Natively support relational queries.
✑ Provide a recovery time objective (RTO) of less than one minute.
What should you include in the recommendation?

A. Azure Cosmos DB
B. Azure SQL Database
C. Azure Synapse Analytics
D. Azure Blob storage

Show Suggested Answer

Suggested Answer: D 🗳️
Incorrect Answers:
A: Azure Cosmos DB would require an SQL API.

by z8zhong at March 15, 2020, 2:39 a.m.

Comments

Submit Cancel

Nehuuu

Highly Voted 5 years, 2 months ago

Should it not be SQL Database? relational queries are supported in SQL DB and SQL DWH, however if cost becomes a factor, it should be SQL DB.

upvoted 90 times

chaoxes

4 years, 5 months ago

Yes, answer is B. Azure SQL Database. Cosmos DB - expensive SQL DW - expensive Blob Storage - cheap, but doesn't support SQL relational queries

upvoted 23 times

...

EricN

Highly Voted 5 years, 2 months ago

The answer should be B. Azure SQL Database manual database failover can be achieved in 30s. https://docs.microsoft.com/en-us/azure/sql-database/sql-database-business-continuity

upvoted 36 times

Niteen

5 years, 1 month ago

Yes, and it can be stored Point in time recovery with fastest. So Ans should be SQL DB

upvoted 2 times

...

Bro_its_guru

Most Recent 2 years, 11 months ago

Option D. Azure Blob Storage is correct answer 1000 percent sure. Not B.

upvoted 1 times

...

Sasha_in_San_Francisco

3 years, 9 months ago

I also believe it is B - Azure SQL Database. FYI: SkillCertPro has the wrong answer! Very confusing. :-(

upvoted 1 times

...

savin

3 years, 11 months ago

should be Azure SQL DB

upvoted 2 times

...

ismaelrihawi

4 years ago

Relational queries support is only provided by a Azure SQL Database

upvoted 1 times

...

cadio30

4 years ago

Definitely B is the answer

upvoted 1 times

...

davita8

4 years, 1 month ago

B. Azure SQL Database

upvoted 2 times

...

chirag1234

4 years, 2 months ago

Blob storage is correct. -- minimum cost -- support SQL Relational queries by creating an external table -- hot tier to recover fast

upvoted 2 times

chakanirban

4 years ago

Natively support relational queries. hence Azure SQL DB

upvoted 3 times

...

Nik71

4 years, 2 months ago

The Query Blob Contents API applies a simple Structured Query Language (SQL) statement on a blob's contents and returns only the queried subset of the data. so BLOB is correct

upvoted 1 times

...

syu31svc

4 years, 6 months ago

https://azure.microsoft.com/en-us/updates/azure-sql-db-published-first-in-industry-business-continuity-sla-for-a-relational-database-service/: "100% SLA for a 30 second recovery time objective (RTO)"

upvoted 2 times

...

sandGrain

4 years, 7 months ago

Azure SQL DB .... 100%

upvoted 5 times

...

BCYT

4 years, 7 months ago

Mark it for myself, SQL DB

upvoted 4 times

...

Bob123456

4 years, 9 months ago

It should be sql database instead of blob

upvoted 3 times

...

Yaswant

4 years, 10 months ago

Azure SQL Database DataStorage : Around 1TB (Max). Relational queries : Native support. RTO (Manual failover) : 30seconds.

upvoted 10 times

...

passnow

4 years, 10 months ago

B does not require sql api support

upvoted 1 times

...

proca

4 years, 10 months ago

The answer should be B. Azure SQL Database Business Critical tier configured with geo-replication has a guarantee of Recovery time objective (RTO) of 30 sec for 100% of deployed hours. https://azure.microsoft.com/en-us/support/legal/sla/sql-database/v1_4/#:~:text=of%20deployed%20hours.-,Azure%20SQL%20Database%20Business%20Critical%20tier%20configured%20with%20geo%2Dreplication,for%20100%25%20of%20deployed%20hours.

upvoted 2 times

...

Load full discussion...