exam questions

Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 20 question 2 discussion

Actual exam question from Microsoft's DP-201
Question #: 2
Topic #: 20
[All DP-201 Questions]

HOTSPOT -
Which Azure data storage solution should you recommend for each application? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Health Review: Azure SQL Database
Scenario: ADatum identifies the following requirements for the Health Review application:
Ensure that sensitive health data is encrypted at rest and in transit.

✑ Tag all the sensitive health data in Health Review. The data will be used for auditing.
Health Interface: Azure Cosmos DB
ADatum identifies the following requirements for the Health Interface application:
✑ Upgrade to a data storage solution that will provide flexible schemas and increased throughput for writing data. Data must be regionally located close to each hospital, and reads must display be the most recent committed version of an item.
✑ Reduce the amount of time it takes to add data from new hospitals to Health Interface.
✑ Support a more scalable batch processing solution in Azure.
✑ Reduce the amount of development effort to rewrite existing SQL queries.
Health Insights: Azure Synapse Analytics
Azure Synapse Analytics is a cloud-based enterprise data warehouse that leverages massively parallel processing (MPP) to quickly run complex queries across petabytes of data. Use SQL Data Warehouse as a key component of a big data solution.
You can access Azure Synapse Analytics (SQL DW) from Databricks using the SQL Data Warehouse connector (referred to as the SQL DW connector), a data source implementation for Apache Spark that uses Azure Blob Storage, and PolyBase in SQL DW to transfer large volumes of data efficiently between a
Databricks cluster and a SQL DW instance.
Scenario: ADatum identifies the following requirements for the Health Insights application:
✑ The new Health Insights application must be built on a massively parallel processing (MPP) architecture that will support the high performance of joins on large fact tables
Reference:
https://docs.databricks.com/data/data-sources/azure/sql-data-warehouse.html

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
dbdev
Highly Voted 4 years ago
Do not read other comments(save time), the answer is correct.
upvoted 12 times
...
akram786
Most Recent 4 years, 2 months ago
It should be cosmosdb for health review as well because of encyption at rest and transit
upvoted 4 times
H_S
4 years, 2 months ago
oltp synaps .?
upvoted 1 times
...
maciejt
4 years, 1 month ago
Nah, always encrypted will do the trick
upvoted 1 times
...
Devendra00023
4 years, 1 month ago
No, refer - https://docs.microsoft.com/en-us/azure/security/fundamentals/encryption-atrest#:~:text=Azure%20SQL%20Database%20currently%20supports,feature%20called%20Transparent%20Data%20Encryption.
upvoted 3 times
...
Mily94
4 years ago
you can enable always encrypted on SQL DB.
upvoted 2 times
Ous01
4 years ago
Well, Azure SQL is also encrypted in transit without using Always Encrypted.
upvoted 1 times
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...