RECALL, THEN CHECK

DP-900 Flashcards & Study Review

Recall first, then reveal the answer. Browse 12 sample cards below, or use spaced review to save your personal review schedule.

Compare data models and processing decisions. Selected foundations; check coverage for the full scope.

42 cards due or new · Ready when you are

Version 2026-11-03-readiness-r05 · Original foundation materials · No sign-up

Browse sample cards

Try recalling the idea before revealing it. Browsing these examples does not change your saved review schedule.

CARD 01 · Core data concepts

Does an allowed NULL value remove a relational table’s declared schema?

Reveal answer & explanation

No. The declared columns still exist; an unknown or absent value is different from a different set of columns.

Learn: Data representations
CARD 02 · Relational data on Azure

Why may a foreign-key value legitimately occur in several child rows?

Reveal answer & explanation

Different child rows may refer to the same parent. The parent reference need not uniquely identify each child row.

Learn: Relational tables, keys, SQL and objects
CARD 03 · Non-relational data on Azure

Does generic REST support make a Files endpoint interchangeable with Blob REST requests?

Reveal answer & explanation

No. Verify the actual service operations and client API contract.

Learn: Object,file and key/attribute storage
CARD 04 · Analytics on Azure

What is the order difference between ETL and ELT?

Reveal answer & explanation

ETL transforms before target loading; ELT loads first and transforms afterward.

Learn: Ingestion and analytical data stores
CARD 05 · Relational and non-relational decisions

In the stated Cosmos DB design, what identifies one logical partition?

Reveal answer & explanation

The configured partition-key value shared by its items. A container name or equal item-id text is not that boundary.

Learn: Service contracts and transaction boundaries
CARD 06 · Analytics workloads

Both candidate platforms support Spark notebooks. Does that feature alone select one?

Reveal answer & explanation

No. It is a shared capability. Compare the remaining actual integration, governance and workload requirements; overlap also does not prove complete platform equivalence.

Learn: Analytical grain, timing and platform evidence
CARD 07 · Core data concepts

In a CSV with one header line,what counts as a record?

Reveal answer & explanation

A data row represents a record under the declared contract; the header names fields rather than adding another entity.

Learn: Files,databases,and storage fit
CARD 08 · Relational data on Azure

Which Azure SQL operating model provides guest OS control when that control is explicitly required?

Reveal answer & explanation

SQL Server on Azure VMs, with additional VM-management duties.

Learn: Relational Azure service boundaries
CARD 09 · Non-relational data on Azure

Does a flexible document schema remove the need to plan access patterns?

Reveal answer & explanation

No. Representation flexibility and how the application reads or changes data are separate questions.

Learn: Cosmos DB API and partition boundaries
CARD 10 · Analytics on Azure

Why is event buffering not itself a running aggregate?

Reveal answer & explanation

Buffering captures/retains input; processing must read events and apply the aggregate logic.

Learn: Batch and streaming reasoning
CARD 11 · Core data concepts

What does atomicity require for one stated transaction?

Reveal answer & explanation

The whole unit succeeds or fails together; rather than committing only its successful first operation.

Learn: Transactional and analytical work
CARD 12 · Relational data on Azure

A left join retains a team with no matching visit. What appears in the visit fields?

Reveal answer & explanation

NULL placeholders for the missing right-side values. Retaining the team does not invent a real visit.

Learn: Normalize the fact, then check the SQL result

Use the cards as a recall routine

  1. Read the prompt and explain your answer before looking below it.
  2. Compare your reasoning with the saved answer, then revisit the linked lesson if a distinction is unclear.
  3. Use the spaced-review tool to schedule another attempt; its personal state stays in your browser.
Coverage, sources & review status

What this collection covers

Selected foundations; all 30 retained official leaves remain partial. Additional evidence is not a full-outline or calibrated simulation claim..

The cards preview selected ideas; they do not measure readiness for the whole examination. Your personal review schedule is available in the review tool.

Author-reviewed learning materials. Independent educator review is pending; question difficulty has not been calibrated with learner results. Check coverage and gaps before planning your preparation.

Sources and preparation route

These prompts and explanations are the site's original learning materials. The reference links below support the selected skills; they are not endorsements or official examination questions.