Microsoft Azure Data Fundamentals DP-900

An online shop records each order and its payment atomically. Which workload category best describes this activity?

An analyst summarizes five years of sales by region and product. Which workload is most relevant?

A table must prevent two customers from sharing the same row identifier. Which relational constraint is most appropriate?

An Orders table stores CustomerId values that must refer to existing Customers rows. Which constraint expresses the relationship?

A query must return one row per department with the number of employees in that department. Which SQL operation is central to the solution?

A company stores customer profiles whose optional attributes differ substantially between records. Which model is a reasonable candidate?

A system stores relationships between people and needs to traverse friends-of-friends efficiently. Which data model naturally represents the problem?

A pipeline transforms records before loading them into the target warehouse. What is the usual name of this sequence?

A factory analyzes sensor events continuously as they arrive to detect anomalies quickly. Which processing approach best matches?

A warehouse separates sales amounts into a fact table and product details into a dimension table. What is the main role of the dimension?

A dashboard needs to show total revenue by month and let users filter by region. Which layer is primarily responsible for presenting that analysis to business users?

A team stores raw structured, semi-structured and unstructured files for later processing. Which architecture component best describes this repository?