Foundational certification covering core data concepts and relational, non-relational, and analytics workloads on Azure, with a worked explanation on every practice question.
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 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.
lock_openFree sampleDescribe Core Data Conceptsmedium
Which term do data professionals use for files that store unstructured data, such as images, video and audio, as raw binary that an application must interpret and render?
- ABinary Large Object (BLOB)check_circle Correct
- BTab-separated values (TSV)
- CAvro row-based file
- DExtensible Markup Language (XML)
Raw binary files for unstructured content like images, video and audio are called BLOBs, short for Binary Large Objects. Some formats store unstructured data as raw binary that applications must interpret and render, and data professionals refer to these files as BLOBs, short for Binary Large Objects, with common examples including images, video and audio.
Why A is correct: Correct. Some formats store unstructured data as raw binary that applications must interpret and render, and data professionals refer to these files as BLOBs, short for Binary Large Objects, with common examples including images, video and audio.
Why B is wrong: TSV is a delimited text format whose bytes map to printable characters, so it represents readable structured data rather than raw binary media.
Why C is wrong: Avro does store data as binary blocks, but it is an optimized format for structured records with a JSON header, not the general term for unstructured image or video files.
Why D is wrong: XML is a human-readable text format whose bytes map to printable characters, so it is not used to describe raw binary media that must be rendered.
Frequently asked questions
- How many questions are on the DP-900 exam?
- The Microsoft Azure Data Fundamentals (DP-900) (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.
- 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.
