Exam DP-900: Microsoft Azure Data Fundamentals
| Exam Number: DP-900 | Length of test: 120 mins |
| Exam Name: Microsoft Azure Data Fundamentals | Number of questions in the actual exam: 40-60 |
| Format: PDF, VPLUS | Passing Score: 700/1000 |
|
Total Questions: 285 $30 Premium PDF file 2 months updates Last updated: November-2024 |
Total Questions: 285 FREE Premium VPLUS file Last updated: November-2024 |
Download practice test questions – Exam Topics
| Title | Size | Hits | Download |
|---|---|---|---|
| Microsoft.DP-900.vOct-2024.by.Lino.110q | 5.89 MB | 40 | Download |
| Microsoft.DP-900.vOct-2024.by.Lino.110q | 10.34 MB | 30 | Download |
| Microsoft.DP-900.vMar-2024.by.Isac.111q | 7.13 MB | 144 | Download |
Study guide for Exam DP-900: Microsoft Azure Data Fundamentals
Audience profile
This exam is an opportunity to demonstrate your knowledge of core data concepts and related Microsoft Azure data services. As a candidate for this exam, you should have familiarity with Exam DP-900’s self-paced or instructor-led learning material.
This exam is intended for you, if you’re a candidate beginning to work with data in the cloud.
You should be familiar with:
- The concepts of relational and non-relational data.
- Different types of data workloads such as transactional or analytical.
You can use Azure Data Fundamentals to prepare for other Azure role-based certifications like Azure Database Administrator Associate or Azure Data Engineer Associate, but it is not a prerequisite for any of them.
Skills at a glance
Describe core data concepts (25–30%)
- Describe ways to represent data
- Identify options for data storage
- Describe common data workloads
- Identify roles and responsibilities for data workloads
Identify considerations for relational data on Azure (20–25%)
- Describe relational concepts
- Describe relational Azure data services
Describe considerations for working with non-relational data on Azure (15–20%)
- Describe capabilities of Azure storage
- Describe capabilities and features of Azure Cosmos DB
Describe an analytics workload on Azure (25–30%)
- Describe common elements of large-scale analytics
- Describe consideration for real-time data analytics
- Describe data visualization in Microsoft Power BI
Some new questions:
Q
Which three services support Apache Spark? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.
A. Azure Data Explorer
B. Azure Synapse Analytics
C. Azure Databricks
D. Azure Stream Analytics
E. Azure HDInsight
Q
Blob rehydration occurs in Azure Blob storage when a blob moves between which access tiers?
A. Archive to Cool
B. Hot to Cool
C. Cool to Archive
D. Hot to Archive
Q
What is the responsibility of a database administrator?
A. applying data cleaning routines
B. creating data visualizations
C. managing data integration processes
D. storing backup copies of data
……….
Some new questions:
Q
You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to create a database object that would allow other users to rerun the same SQL query.
What should you create?
A. a scalar function
B. a table
C. an index
D. a view
Q
SELECT, INSERT, and UPDATE are examples of which type of SQL statement?
A. Data Definition Language (DDL)
B. Data Control Language (DCL)
C. Data Manipulation Language (DML)
Q
You have a banking application that transfers money in to and out of accounts.
Of which type of solution is this is an example?
A. extract transform, and load (ETL)
B. a data warehouse
C. online analytical processing (OLAP)
D. online transaction processing (OLTP)
Q
Which Azure Storage service implements the key/value model?
A. Azure Files
B. Azure Table
C. Azure Blob
D. Azure Queue
……………..