DP-900 Exam Prep Quiz for Microsoft

In the context of relational data, which of the following statements best describes the process of data normalization? Select the correct option.

• The data has been marked as read-only

• Data is split into a large number of narrow, well-defined tables

• Data is stored in a format that more closely matches the original structure

• Data has been ingested and transformed ready for querying

Which of the roles listed below are most likely to use SQL to query a database? Select all that apply

• Data Analyst

• Data Engineer

• Database Administrator

• Cloud solution Architect

In relational database design, which of the following statements best describes the use of a Foreign Key? Select the correct option.

• They indicate the column (or combination of columns) that uniquely identify each row

• They reference, or link to, the primary key of another table, and are used to maintain the relationships between tables

• They are used to identify whether a user has write-access to a specific table

• They indicate the column where data has been ingested from a different table

Which of the following statements are true of a relational database? Select all that apply.

• A table can contain any number of rows

• A Primary Key is used to indicate the column (or combination of columns) that uniquely identify

  each row

• Rows in the same table can have different sets of fields

• The data is tabular

How is data in a relational table organized?

• Pages and Paragraphs

• Rows and Columns

• Header and Footer

Which of the following is an example of unstructured data?

• A comma-delimited text file with EmployeeID, EmployeeName, and EmployeeDesignation fields

• Audio and Video files

• A table within relational database

What is a data warehouse?

• A non-relational database optimized for read and write operations

• A storage location for unstructured data files

• A relational database optimized for read operations

Which one of the following tasks is the responsibility of a database administrator?

• Backing up and restoring databases

• Creating dashboards and reports 

• Creating pipelines to process data in a data lake

Which role is most likely to use Azure Data Factory to define a data pipeline for an ETL process? 

• Database Administrator

• Data Engineer

• Data Analyst 

Which one of the following statements is a characteristic of a relational database?

• All columns in a table must be of the same data type

• A row in a table represents a single instance of an entity

• Rows in the same table can contain different columns