Microsoft DP-900 Practice Exams
Last updated on Oct 22,2026- Exam Code: DP-900
- Exam Name: Microsoft Azure Data Fundamentals
- Certification Provider: Microsoft
- Latest update: Oct 22,2026
Which setting can only be configured during the creation of an Azure Cosmos DB account?
- A . geo-redundancy
- B . multi-region writes
- C . production or non-reduction account type
- D . API
D
Explanation:
You must create a separate account for each API.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-manage-database-account
HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Explanation:
Box 1: No
You can duplicate a dashboard. The duplicate ends up in the same Power BI workspace.
There is no current functionality that allows you to move reports from one workspace to another.
Box 2: No
Box 3: Yes
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-across-workspaces
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboardshttps://powerbi.microsoft.com/en-us/excel-and-power-bi/
What is a characteristic of non-relational data?
- A . a well-defined schema
- B . no indexes
- C . self-describing entities
- D . no unique key values
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://www.bmc.com/blogs/what-is-batch-processing-batch-processing-explained/
What is a difference between structured data and semi-structured data?
- A . Structured data has a fixed schema and semi-structured data has a flexible schema.
- B . Only Structured data supports entities.
- C . Structured data has a flexible schema and semi-structured data has a fixed schema.
- D . Only Structured data supports attributes.
Which command-line tool can you use to query Azure SQL databases?
- A . sqlcmd
- B . bcp
- C . azdata
- D . Azure CLI
A
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/az-cli-script-samples-content-guide?tabs=singledatabase
Which Azure Data Factory component initiates the execution of a pipeline?
- A . a control flow
- B . a trigger
- C . a parameter
- D . an activity
B
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers#trigger-execution
HOTSPOT
Select the answer that correctly completes the sentence.
Explanation:
CSV (Comma-separated values): This is a text file format that uses commas (,) as column delimiters and carriage returns (rn) as row delimiters. CSV files are widely used for exchanging data between different applications and platforms123.
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/create-graph-gremlin-console