Microsoft free flashcards
8 real DP-900 flashcards, sampled across every domain the exam tests. Each concept card is paired with the misconception card built from the tempting wrong answer - the trap most decks skip. No account, no card.
The full deck has 727 flashcards. For a domain-by-domain breakdown and a study plan, read the DP-900 study guide.
How is JSON whose fields vary between records classified?
JSON documents with fields that differ between records are semi-structured, not unstructured. JSON is a common semi-structured format precisely because each document can add or drop optional fields while still keeping some structure.
Customer profiles stored as JSON documents whose fields vary between records are unstructured data.
JSON with varying fields is the classic example of semi-structured data, which has some structure while allowing variation between instances. Unstructured data has no structure at all, so JSON documents with recognisable fields do not qualify.
In a star schema, what is the role of the central fact table relative to the dimension tables?
The central fact table holds the numeric values that can be aggregated, while the surrounding dimension tables represent the entities (such as customer, product, store and time) by which those numbers are aggregated.
In a star schema, the central fact table holds the descriptive entities such as customer, product, and store used to group and slice the data.
Those descriptive entities are held by the surrounding dimension tables. The central fact table holds the numeric values that can be aggregated by the related dimensions.
In a relational table, how is a single instance of an entity such as one customer represented?
As one row within the table that models that entity. A row holds the data for a single instance, while the table is the whole collection of those instances. A column, by contrast, stores one attribute across many instances.
In a relational database, a single customer is represented as one column in the customer table.
A column stores one attribute (such as Email) across many entity instances, not a single instance. A single customer is one row in the table that models that entity.
What is the purpose of Azure Blob storage?
Blob storage is Azure's object store for unstructured data. It holds massive amounts of binary large objects such as images, video, and backup archives, which applications read and write through the Blob storage API.
Azure Files is the right service for storing large numbers of images, video, and backup archives that applications read and write through a cloud storage API.
Azure Files provides cloud network file shares mounted over SMB or NFS, not an object store accessed through a Blob API. Azure Blob storage is the object store designed for unstructured data like images, video, and archives, read and written through the Blob storage API.
Drop your email and we will keep you posted as new DP-900 study material ships. No spam - we mail you only when it is worth your time.
Yes. Every card on this page is free to read with no sign-up. The full deck has 727 flashcards; drop your email below and we will keep you posted, or create a free account to study the rest.
A card built from a tempting wrong answer in our question bank, naming the trap and explaining why it fails. Most flashcard decks only drill the fact (a concept card); we pair each one with the misconception the exam actually tests you against.
No. These are original flashcards written from our own blueprint-aligned practice questions. We never reproduce live exam items or vendor material.
727 cards spread across all 4 domains. For the full domain-by-domain breakdown, read the study guide.
Examworthy is not affiliated with or endorsed by Microsoft. All flashcards are original, drawn from our own blueprint-aligned practice questions. We never reproduce live exam items. DP-900 and related marks belong to their respective owners.
