DP-900 Exam Questions & Dumps with Answers Free PDF

In this article, we will check the Most Repeated Questions asked in the DP-900 Microsoft Azure Data Fundamentals Exam. In the end, we have attached a pdf of DP-900 Exam Questions/Dumps with Answers Free[PDF].

We strongly recommend checking our guide to Microsoft Azure Data Fundamentals Certification. This is a step-by-step guide for preparing yourself for the exam.

We will review the type of questions for four Measured Skills in the DP-900 exam:

• Describe core data concepts (25–30%)
• Identify considerations for relational data on Azure (20–25%)
• Describe considerations for working with non-relational data on Azure (15–20%)
• Describe an analytics workload on Azure (25–30%)

DP-900 Most Important Questions

Q1) You created an azure storage account and data in the account must automatically replicate outside the azure region.
Which two types of replication can you use?
A) zone-redundant storage (ZRS)
B) locally-redundant storage (LRS)
C) read-access geo-redundant storage (RA-GRS)
D) geo-redundant storage (GRS)


Q2) Which statement is an example of Data Manipulation Language (DML)?

Q3) You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to persist the SQL query so that other users can use the query.
What should you create?
A) Index
B) Scalar Function
C) View
D) Table

Q4) Choose three objects that can be added to a Microsoft Power BI dashboard.

A. a report page
B. a Microsoft PowerPoint slide
C. a visualization from a report
D. a text box
E. a dataflow

Q5) What are the two characteristics of real-time data processing? A correct option is worth two points
A) Low latency is expected
B) Data is processed periodically
C) Data is processed as it is created
D) High latency is acceptable

Q6) You need to assure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database. Which type of authentication should you use?

A) SQL authentication
B) Certificate authentication
C) Azure Active Directory (Azure AD) authentication
D) Service principal authentication

Q7) What is the benefit of hosting an Azure SQL-managed instance compared to an Azure SQL database?
A) native support for cross-database queries and transactions
B) system-initiated automatic backups
C) support for encryption at rest
D) built-in high availability

Q8) You need to develop and model a database by using a graphical tool that supports project-oriented offline database development. What should you use?
A. Azure Data Studio
B. Microsoft SQL Server Management Studio (SSMS)
C. Azure Databricks
D. Microsoft SQL Server Data Tools (SSDT)

Q9) You are troubleshooting an Azure SQL database by writing a set of SQL queries as an administrator. 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 Power Shell
C. Azure CLI
D. Azure Data Studio

Q10) You have an e-commerce application that reads and writes data to an Azure SQL database.
Which type of processing does the application use?
A. Stream processing
B. Online Transaction Processing (OLTP)
C. Online Analytical Processing (OLAP)
D. Batch Processing

Q11) In Which scenario do you use an Azure Resource Manager template?
A. to provision Azure subscriptions
B. to apply Azure policies for multi-tenant deployments
C. to automate the creation of an interdependent group of Azure resources in a repeatable way
D. to control which services and feature administrators and developers can deploy from the Azure portal

Q12) Which command-line tool can you use to query Azure SQL databases?
A. bcp
B. sqlcmd
C. azdata
D. Azure CLI

Q13) Which statement is an example of DDL -Data Definition Language?

Q14) You are deploying a SaaS application that requires a relational database for Online Transaction Processing(OLTP). Which Azure service should you use?
A. Azure Cosmos DB
B. Azure SQL Database
C. Azure HDInsight
D. Azure Synapse Analytics

Q15) What are two benefits of platform as a service relational database offerings in Azure, such as Azure SQL Database? Mark two correct answers.
A. complete control over backup and restore processes
B. access to the latest features
C. in-database machine learning services
D. reduced administrative effort for managing the server infrastructure

Q16) When you create an Azure SQL database, which account can always connect to the database?
A. the sa account
B. the server admin login account of the logical server
C. the Azure Active Directory (Azure AD) administrator account
D. the Azure Active Directory (Azure AD) account that created the database

Q17) Your company is designing a database that will contain session data for a website. The data will include
notifications, personalization attributes, and products that are added to a shopping cart.
Which type of data store will provide the lowest latency to retrieve the data?
A. key/value
B. columnar
C. graph
D. document

Q18) You have an application that runs on Windows and requires access to a mapped drive.
Which Azure service should you use?
A. Azure Blob storage
B. Azure Files
C. Azure Cosmos DB
D. Azure Table storage

Q19) You need to suggest a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file. Which type of data store should you advise?
A. key/value
B. columnar
C. document
D. object

Q20) Your company is developing a data store for internet-connected temperature sensors.
The collected data will be used to analyze temperature trends. Which type of data store should you use?
A. relational
B. time series
C. columnar
D. graph

Q21) At which two levels can you set the throughput for an Azure Cosmos DB account? Each right answer presents a complete solution.
A. database
B. partition
C. container
D. item

Q22) Which storage Design supports role-based access control (RBAC) at the file and folder level?
A. Azure Data Lake Storage
B. Azure Disk Storage
C. Azure Blob storage
D. Azure Queue storage

Q23) Which type of nonrelational data store supports a flexible schema, stores data as JSON files, documents, and stores all the data for an entity in the same document?
A. graph
B. columnar
C. document
D. time series

Q24) If You provisioning a Cosmos DB account, which features provides redundancy within an Azure region?
A. automatic failover
B. Availability Zones
C. the strong consistency level
D. multi-master replication

Q25) What should you use to query the files using Transact-SQL in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse?
A. Azure Functions
C. PolyBase

Q26) Which type of data store should you use to develop a database that shows how changes in network traffic in one area of a network affect network traffic in other areas of the network?
A. columnar
B. key/value
C. document
D. graph

Q27) What tool is used to build a Microsoft Power BI paginated report?

B. Power BI Desktop
C. the Power BI service
D. Power BI Report Builder

Q28) Which scenario is an example of a streaming workload?

A. sending cloud infrastructure metadata every 30 minutes
B. sending transactions daily from point of sale (POS) devices
C. sending telemetry data from edge devices
D. sending transactions that are older than a month to an archive

Q29) Which type of workload describes this scenario to gather real-time telemetry data from a mobile application?

A. OLTP-Online Transaction Processing
B. batch
C. MPP – massively parallel processing
D. streaming

Q30) What should you use to query the files using Transact-SQL in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse?

A. Azure Functions
C. PolyBase

Q31) you need to minimize the cost of the SQL pool in Azure Synapse Analytics during idle times. What should you do on the SQL pool?

A. Delete the Pool
B. Pause the pool.
C. Create a user-defined restore point.
D. Scale down the data warehouse units (DWUs).

Q32) Which ADF component initiates the execution of a pipeline?

A. an activity
B. a trigger
C. a parameter
D. a control flow

Q33) Choose three characteristics of an Online Transaction Processing (OLTP) workload.

A. Schema on read
B. heavy writes and moderate reads
C. light writes and heavy reads
D. schema on write
E. denormalized data
F. normalized data

Q34) What should you use in Microsoft Power BI to develop a solution to provide data to executives? The solution must deliver an interactive graphical interface, depict various key performance indicators, and support data exploration by using drill down.

A. a dashboard
B. a dataflow
C. a report
D. Microsoft Power Apps

Q35) Choose two Azure services that can be used to provision Apache Spark clusters. Each correct answer presents a complete solution.

A. Azure Log Analytics
B. Azure HDInsight
C. Azure Databricks
D. Azure Time Series Insights

Q36) Match the types of analytics that can be used to answer the business questions.
To answer, drag the right analytics type from the column on the left to its question. Each
analytics type may be used once, more than once, or not at all.
NOTE: Each valid match is worth one point.

DP900 Question analytics type

1) Diagnostic
2) Prescriptive
3) Descriptive

Q37) Drag and drop the appropriate Azure services to the suitable locations in the architecture.

DP900 Question Azure Analytics

Ingest – ADF
Service – Azure Synapse Analytics

Q38) Drag and drop the appropriate tool from the column on the left to its suitable description on the right

DP900 Question Azure Data Studio

1) Microsoft SQL Server Management Studio (SSMS)
2) Microsoft Visual Studio Code
3) Azure Data Studio
4) Microsoft SQL Server Data Tools (SSDT)

Q39) Select Yes if the statement is true and No if false.

DP900 Question Relational Database


Q40) Complete the sentence by selecting the appropriate option.

DP900 Question Key Value

Simple Lookups

DP-900 Exam Questions Dumps Free PDF

We have prepared a PDF that contains the most repeated questions of the Microsoft Power BI Data Analyst exam DP900.

Link to download DP-900 exam Dump – Link