Free Microsoft Azure DP-900 Actual Exam Questions

This seems more about managing who can get into the data, so it points to B (security controls). D feels off since it’s not about privacy laws or policies, just keeping unauthorized users out.

I’d rule out D because while privacy is important, this sentence looks focused on preventing unauthorized access, not data privacy rules. So B makes more sense as it’s about security controls.

I think option B fits best because it talks about data analytics roles, which matches the sentence's focus on using data for insights rather than just storage.

Can’t see the sentence fully, anyone got a clearer pic?

I’m thinking it’s A too since it just shows what has happened so far. Doesn’t really explain why or predict what’s next, right? Could B ever fit here?

A imo

D works better if you consider the main concept, not just sentence flow.

I’d pick B because it completes the sentence logically and keeps the technical meaning intact. The other options either break the flow or don’t fit the context of data processing accurately.

A and D—both are known for Spark clusters, unlike B or C.

It’s definitely A and D because Log Analytics and Time Series Insights aren’t for big data processing.

Option C seems off since it talks about hashing, which isn’t encryption here. The image clearly shows the same key on both ends, so symmetric encryption in B still feels right.

I’d rule out A and D since they mention asymmetric keys, which don’t fit the example. B looks like the best pick because it matches the symmetric key scenario shown in the picture.

Data warehouses prioritize reads over updates to ensure fast query performance.

I’d go with the option that says data is mostly read and rarely updated too. Since data warehouses are designed for complex queries and reporting, heavy writes or frequent updates just don’t make sense. It’s all about fast querying and analysis, not transaction processing.

I can’t see the image either, but generally, Azure SQL Database is great for managed relational DBs, Azure SQL Managed Instance fits for migrations with compatibility, and SQL Server on VMs is usually for full control scenarios. Hope that helps!

Looks like a straightforward matching but the image isn’t loading for me.

Task 1 looks like a data steward role, so B still fits best to me.

Task 1 seems to fit B well since it’s about maintaining data accuracy, which is usually part of that role. Task 3 looks more like A’s responsibility because it deals with infrastructure setup or management.

I think the key is remembering that “Filesystem” in ADLS Gen2 is basically the container level, so matching “Blob container” under Filesystem makes sense. The rest follows naturally from Account down to File.

I remember this one! The hierarchy starts with Account, then Filesystem, followed by Directory, and finally File at the lowest level. It’s about matching terms to these layers.

Not sure if the question image loaded properly for everyone? Can't see the sentence fully here, so guessing is tough right now. Anyone else having trouble with it?

Probably B here. Azure Data Lake Storage Gen2 explicitly supports POSIX ACLs, which none of the others offer natively. That feature is key for Hadoop and similar workloads.

D imo, since Azure Files supports SMB which is more Windows-oriented, it doesn’t offer native POSIX ACL support like Azure Data Lake Storage does. So that rules it out for POSIX compliance.

I’d rule out A and B because they don’t really match the cardinality shown in the diagram. D seems off since the relationship isn’t one-to-one. C fits the pattern of many-to-many with a linking table, which the image hints at. The question is about relational databases, so that helps confirm C as the best match here.

C

Since the sentence mentions the role of professionals working with data, option B fits best because it covers both analyzing and managing data, not just storing or transforming it.

I’m thinking C could also work here because it talks about transforming data, which is a crucial part of what data professionals do before analysis. Just storing data (like in A or D) doesn’t capture the full picture. So, I’m not convinced it’s just about analyzing but also preparing and managing data properly. B is good too, but C might be a better fit if the sentence is emphasizing the full workflow, not just analysis.

Sounds like D, but could the question be mixing up OLTP and OLAP terms?

D, because e-commerce requires handling multiple quick transactions simultaneously.