Free Exam DP-900: Microsoft Azure Data Fundamentals Practice Questions

Sample Practice Questions

Try these 10 sample questions from the Exam DP-900: Microsoft Azure Data Fundamentals practice bank. Each includes the answer and explanation. Continue with the interactive practice above to review the full question set.

1. 1Which defining characteristic distinguishes structured data from other data representations?

   1. A. Every entity instance follows the same defined fields.
   2. B. Each entity instance must use a different set of fields.
   3. C. The content must consist of images, audio, or video.
   4. D. The content has no schema governing its organization.

   Answer: A

   Explanation: Microsoft states, "Structured data is data that adheres to a fixed schema, so all of the data has the same fields or properties." A fixed schema distinguishes structured data from variable or unspecified structures.

   Reference: Identify data formats — Structured data, first paragraph

2. 2What is the primary purpose of database normalization?

   1. A. Minimizing duplication while enforcing data integrity
   2. B. Preaggregating transactions into reporting summaries
   3. C. Copying entity details into each referencing record
   4. D. Combining distinct attributes into one composite text field

   Answer: A

   Explanation: Microsoft defines normalization as "a schema design process that minimizes data duplication and enforces data integrity." It separates entities and discrete attributes; summary aggregation, repeated entity details, and combined attribute fields are different design choices.

   Reference: Understand normalization — Opening definition

3. 3Within an Azure storage account, what groups related blobs together?

   1. A. A table partition
   2. B. A container
   3. C. A database schema
   4. D. A file share

   Answer: B

   Explanation: Microsoft states, "In an Azure storage account, you store blobs in containers." Containers group blobs; table partitions, database schemas, and file shares belong to different storage organizations.

   Reference: Explore Azure blob storage — Containers paragraph

4. 4How does the order of transformation differ between ETL and ELT?

   1. A. ELT loads data before transforming it; ETL transforms it before loading.
   2. B. ELT transforms data before loading it; ETL loads it before transforming.
   3. C. ELT requires unstructured sources; ETL requires structured sources.
   4. D. ELT processes only streams; ETL processes only static files.

   Answer: A

   Explanation: Microsoft states, "In ETL processes, the data is transformed before being loaded into an analytical store, while in an ELT process the data is copied to the store and then transformed." The distinction concerns transformation order, not exclusive source types.

   Reference: Describe data warehousing architecture — Data ingestion and processing

5. 5In a tabular representation of customers, what does a row represent?

   1. A. A characteristic shared by customer records
   2. B. A relationship joining two customer tables
   3. C. An individual instance of a customer entity
   4. D. The schema applied to the customer database

   Answer: C

   Explanation: The module describes "rows to represent each instance of a data entity". A customer row therefore represents one customer, rather than an attribute, relationship, or database schema.

   Reference: Identify data formats — Structured data, first paragraph

6. 6What is the purpose of a primary key in a relational table?

   1. A. Sorting every query result into alphabetical order
   2. B. Storing the default value used by every column
   3. C. Uniquely identifying each instance of the entity
   4. D. Copying all attributes from another related table

   Answer: C

   Explanation: Microsoft states, "Instances of each entity are uniquely identified by an ID or other key value, known as a primary key". A primary key identifies rows; it does not define query order or copy attributes.

   Reference: Understand normalization — Primary and foreign keys paragraph

7. 7In Blob Storage with the default flat namespace, what does a slash in a blob name do?

   1. A. Creates a directory with independent access controls
   2. B. Converts the blob into a network file share
   3. C. Creates a separate storage account for that prefix
   4. D. Provides a naming convention for virtual folders

   Answer: D

   Explanation: Microsoft states, "these folders are simply a way of using a "/" character in a blob name to organize the blobs into namespaces." Under the specified default namespace, they are virtual rather than independently managed directories.

   Reference: Explore Azure blob storage — Virtual folders paragraph

8. 8How do distributed processing systems commonly handle large volumes of analytical data?

   1. A. By routing all processing through one processor while other nodes wait
   2. B. By having every node independently repeat the entire computation
   3. C. By processing data in parallel across a multi-node cluster
   4. D. By requiring each node to finish before the next node begins

   Answer: C

   Explanation: Microsoft describes "distributed systems that can process high volumes of data in parallel using multi-node clusters." Work is performed concurrently, rather than through one processor, duplicated in full on each node, or serialized node by node.

   Reference: Describe data warehousing architecture — Data ingestion and processing

9. 9A product table has columns named ProductName and UnitPrice. What do these columns represent?

   1. A. Separate instances of the product entity
   2. B. Attributes describing the product entity
   3. C. Separate databases containing product data
   4. D. Transactions performed against product data

   Answer: B

   Explanation: The module specifies "columns to represent attributes of the entity". ProductName and UnitPrice describe characteristics of each product; they are not product instances or transactions.

   Reference: Identify data formats — Structured data, first paragraph

10. 10An Order table stores the primary key of the customer who placed each order. What is this customer reference called in the Order table?

    1. A. An index pointer
    2. B. A foreign key
    3. C. A column default
    4. D. A table alias

    Answer: B

    Explanation: Microsoft states, "the primary key of the related entity is stored as a foreign key." The reference in Order links to the Customer entity; it is not an alias or default value.

    Reference: Understand normalization — Primary and foreign keys paragraph