Foundational certification covering core data concepts and relational, non-relational, and analytics workloads on Azure.
Free sample questions
No account needed. Every question has a worked explanation, just like the full bank.
lock_openFree sampleDescribe Core Data Conceptsmedium
Storing customer profiles as JSON documents whose fields vary between records is an example of semi-structured data. Is this statement correct?
- AYescheck_circle Correct
- BNo
JSON documents with fields that differ between records are semi-structured, not unstructured. JSON is named in the grounding as a common semi-structured format precisely because its documents can vary in their specific fields between instances.
Why A is correct: Correct. JSON is named in the grounding as a common semi-structured format precisely because its documents can vary in their specific fields between instances.
Why B is wrong: Answering No is wrong because semi-structured data is defined as having some structure while allowing variation between instances, and JSON with varying fields is the common example the grounding gives.
lock_openFree sampleIdentify Considerations for Relational Data on Azureeasy
In a relational database, how is a single instance of a real-world entity such as one customer represented?
- AAs one row within the table that models that entitycheck_circle Correct
- BAs one column within the table that models that entity
- CAs a separate table created for that individual instance
- DAs a datatype definition applied to the whole table
A row is one instance of an entity; the table is the whole collection of those instances. A relational table contains rows where each row represents a single instance of an entity, so one customer occupies one row in the customer table.
Why A is correct: Correct. A relational table contains rows where each row represents a single instance of an entity, so one customer occupies one row in the customer table.
Why B is wrong: A column stores one attribute (such as Email) across many entity instances, not a single instance.
Why C is wrong: A table models a whole collection of entities; one instance is a row inside it, not its own table.
Why D is wrong: A datatype constrains the values a column may hold; it does not represent an entity instance.
lock_openFree sampleDescribe Core Data Conceptsmedium
In which type of database is structured data held in tables, with each entity instance assigned a primary key that other tables reference to eliminate duplicate values?
- AGraph database
- BRelational databasecheck_circle Correct
- CKey-value database
- DDocument database
Relational databases use tables and primary keys to reference entities and normalise data, storing each value only once. Relational databases store structured data in tables representing entities, assign each instance a primary key, and reference those keys from other tables, which enables normalisation so details such as an individual customer are stored only once.
Why A is wrong: A graph database stores entities as nodes with links defining relationships, rather than normalised tables that reference each other through primary keys.
Why B is correct: Correct. Relational databases store structured data in tables representing entities, assign each instance a primary key, and reference those keys from other tables, which enables normalisation so details such as an individual customer are stored only once.
Why C is wrong: A key-value database pairs a unique key with a value in any format, so it does not model entities as related tables joined by primary keys.
Why D is wrong: A document database stores each value as a JSON document optimised for parsing, not as normalised tables linked by primary keys to remove duplication.
More free DP-900 practice questions with worked answersFrequently asked questions
- How many questions are on the DP-900 exam?
- The Microsoft Azure Data Fundamentals (DP-900) exam has Typically 40 to 60 questions questions and runs for 45 minutes. The format is multiple choice and multiple response, at a pearson vue testing center or online proctored.
- What score do I need to pass DP-900?
- The pass mark is 700 / 1000. Examworthy gives you a per-domain readiness score so you can see which domains are holding you back before you book.
- How much does the DP-900 exam cost?
- The exam costs 99 USD to sit. Practising on Examworthy is free to start, with a worked explanation on every question.
- Is there a DP-900 practice exam?
- Yes. Examworthy's exam mode runs a timed DP-900 practice exam (mock) paced to match the real exam, scored per domain so you can see exactly where you stand against the blueprint. Timed mocks are free with an account.
- How does Examworthy help me prepare for DP-900?
- Every practice question carries a worked explanation and a per-distractor rationale, mapped to the official blueprint domains. You learn why each answer is right or wrong, not just the letter.
- Is Examworthy affiliated with Microsoft?
- No. Examworthy is not affiliated with or endorsed by Microsoft. Our questions are original, blueprint-aligned practice material; we never reproduce live exam items.
Examworthy is not affiliated with or endorsed by Microsoft. All questions are original, blueprint-aligned practice material. We never reproduce live exam items. DP-900 and related marks belong to their respective owners.
