The Microsoft DP-900 Exam is challenging and thorough preparation is essential for success. This exam study guide is designed to help you prepare for the Azure Data Fundamentals certification exam. It contains a detailed list of the topics covered on the Professional exam, as well as a detailed list of preparation resources. These study guides for the Microsoft Azure Data Fundamentals will help guide you through the study process for your certification.
DP-900 Microsoft Azure Data Fundamentals Exam Summary
● Exam Name: Microsoft Azure Data Fundamentals
● Exam Code: DP-900
● Exam Price: $99 (USD)
● Duration: 60 mins
● Number of Questions: 40-60
● Passing Score: 700 / 1000
● Books / Training: DP-900T00-A: Microsoft Azure Data Fundamentals
● Schedule Exam: Pearson VUE
● Sample Questions: Microsoft Azure Data Fundamentals Sample Questions
● Recommended Practice: Microsoft DP-900 Certification Practice Exam
Exam Syllabus: DP-900 Microsoft Certified - Azure Data Fundamentals
1. Describe core data concepts (15-20%)
● Describe types of core data workloads
- describe batch data
- describe streaming data
- describe the difference between batch and streaming data
- describe the characteristics of relational data
● Describe data analytics core concepts
- describe data visualization (e.g., visualization, reporting, business intelligence (BI))
- describe basic chart types such as bar charts and pie charts
- describe analytics techniques (e.g., descriptive, diagnostic, predictive, prescriptive, cognitive)
- describe ELT and ETL processing
- describe the concepts of data processing
2. Describe how to work with relational data on Azure (25-30%)
● Describe relational data workloads
- identify the right data offering for a relational workload
- describe relational data structures (e.g., tables, index, views)
● Describe relational Azure data services
- describe and compare PaaS, IaaS, and SaaS solutions
- describe Azure SQL database services including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machine
- describe Azure Synapse Analytics
- describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQL
● Identify basic management tasks for relational data
- describe provisioning and deployment of relational data services
- describe method for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI)
- identify data security components (e.g., firewall, authentication)
- identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)
- identify query tools (e.g., Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.)
● Describe query techniques for data using SQL language
- compare Data Definition Language (DDL) versus Data Manipulation Language (DML)
- query relational data in Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQL
3. Describe how to work with non-relational data on Azure (25-30%)
● Describe non-relational data workloads
- describe the characteristics of non-relational data
- describe the types of non-relational and NoSQL data
- recommend the correct data store
- determine when to use non-relational data
● Describe non-relational data offerings on Azure
- identify Azure data services for non-relational workloads
- describe Azure Cosmos DB APIs
- describe Azure Table storage
- describe Azure Blob storage
- describe Azure File storage
● Identify basic management tasks for non-relational data
- describe provisioning and deployment of non-relational data services
- describe method for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI)
- identify data security components (e.g., firewall, authentication, encryption)
- identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)
- identify management tools for non-relational data
4. Describe an analytics workload on Azure (25-30%)
● Describe analytics workloads
- describe transactional workloads
- describe the difference between a transactional and an analytics workload
- describe the difference between batch and real time
- describe data warehousing workloads
- determine when a data warehouse solution is needed
● Describe the components of a modern data warehouse
- describe Azure data services for modern data warehousing such as Azure Data Lake, Azure Synapse Analytics, Azure Databricks, and Azure HDInsight
- describe modern data warehousing architecture and workload
● Describe data ingestion and processing on Azure
- describe common practices for data loading
- describe the components of Azure Data Factory (e.g., pipeline, activities, etc.)
- describe data processing options (e.g., Azure HDInsight , Azure Databricks, Azure Synapse Analytics, Azure Data Factory)
● Describe data visualization in Microsoft Power BI
- describe the role of paginated reporting
- describe the role of interactive reports
- describe the role of dashboards
- describe the workflow in Power BI
Microsoft DP-900 Certification Sample Questions and Answers
To make you familiar with Microsoft Azure Data Fundamentals (DP-900) certification exam structure, we have prepared this sample question set. We suggest you to try our Sample Questions for Azure Data Fundamentals DP-900 Certification to test your understanding of Microsoft DP-900process with the real Microsoft certification exam environment.
DP-900 Microsoft Azure Data Fundamentals Sample Questions:-
01. You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database. You need to embed documents and query results into a SQL notebook. What should you use?
a) Microsoft SQL Server Management Studio (SSMS)
b) Azure Data Studio
c) Azure CLI
d) Azure PowerShell
02. A team of developers has computers Thai run Windows 10 and Ubuntu Desktop. The developers need to connect to and query an Azure SCX database from the computers. The developers require code assistance features such as intellSense.
What should the developers use?
a) Azure Data Explorer
b) sq1cmd
c) Azure Data Studio
d) Microsoft SQL Server Management Studio (SSMS)
03. Which Azure Data Factory component provides the compute environment for activities?
a) a linked service
b) an integration runtime
c) a control flow
d) a pipeline
04. You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?
a) Online Transaction Processing (OLTP)
b) batch processing
c) Online Analytical Processing (OLAP)
d) stream processing
05. When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?
a) multi-master replication
b) Availability Zones
c) automatic failover
d) the strong consistency level
06. Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?
a) Azure table storage
b) Azure Files
c) Azure Queue storage
d) Azure Data Lake Storage
07. What do you use to create Power BI paginated reports?
Choose the correct answer
a) Power BI Report Builder
b) Power BI Dashboard
c) Power BI Desktop
d) Power BI service
08. What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
a) built-in high availability
b) native support for cross-database queries and transactions
c) system-initiated automatic backups
d) support for encryption at rest
09. Which Azure Data Factory component initiates the execution of a pipeline?
a) a control flow
b) a trigger
c) a parameter
d) an activity
10. At which level in Azure Cosmos DB can you configure multiple write regions and read regions?
a) collection
b) partition
c) database
d) account
Answers:-
Answer 1:- b
Answer 2:- b
Answer 3:- a
Answer 4:- a
Answer 5:- b
Answer 6:- a
Answer 7:- a
Answer 8:- b
Answer 9:- b
Answer 10:- a