Exam 70-487 topic 1 question 108 discussion

Actual exam question from Microsoft's 70-487

Question #: 108
Topic #: 1

You are developing a ASP.NET Core MVC web application that processes sensitive data.
Users in an Azure Active Directory (Azure AD) group named DataAdmins must be able to see all data in human readable form. Sensitive data must be masked from all other users that handle the data store.
You need to implement storage for the application.
What should you implement?

A. Azure SQL Database
B. Azure Cosmos DB
C. Azure Database for MySQL
D. Azure Database for PostgreSQL
E. Azure Storage Tables

Show Suggested Answer

Suggested Answer: E 🗳️
References:
https://docs.microsoft.com/en-us/aspnet/core/security/authentication/identity-custom-storage-providers?view=aspnetcore-2.2

by bobtables at Nov. 26, 2019, 5:31 p.m.

Comments

Submit Cancel

bobtables

Highly Voted 5 years, 6 months ago

I think this answer should be "A. Azure SQL Database".

upvoted 21 times

...

[Removed]

Highly Voted 5 years, 5 months ago

answer: A. https://azure.microsoft.com/nl-nl/blog/limit-the-exposure-of-sensitive-data-in-azure-sql-database-using-dynamic-data-masking/

upvoted 16 times

...

drugotomoeaz

Most Recent 4 years, 8 months ago

Azure Storage and Azure SQL Database encrypt data at rest by default so there is no reason to worry about the security. Also Azure AD will take care of the access to the sensitive data that should be hidden from inappropriate groups. The right answer is Azure Table Storage (NoSQL db) because the data should be in a human readable format.

upvoted 1 times

zimzimzimma

4 years, 8 months ago

Dynamic data masking doesn't apply to Azure Table Storage. 'Human readable format' is a broad term also, you can store data in an azure sql database so that it is in a human readable format very well. https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview

upvoted 6 times

...

nfgmaia

5 years, 6 months ago

Should be A: Static Data Masking feature of Azure SQL Database.

upvoted 13 times

...