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
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)
Answer
C&D
Q2) Which statement is an example of Data Manipulation Language (DML)?
A) REVOKE
B) DISABLE
C) GRANT
D) INSERT
Answer
D, DML Statements – DELETE, INSERT, UPDATE
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
Answer
C
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
Answer
A,C&D
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
Answer
A&C
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
Answer
C
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
Answer
A
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)
Answer
D
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
Answer
D
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
Answer
B
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
Answer
C
Q12) Which command-line tool can you use to query Azure SQL databases?
A. bcp
B. sqlcmd
C. azdata
D. Azure CLI
Answer
B
Q13) Which statement is an example of DDL -Data Definition Language?
A. SELECT
B. JOIN
C. MERGE
D. CREATE
Answer
D
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
Answer
B
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
Answer
B&D
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
Answer
B
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
Answer
B
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
Answer
B
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
Answer
D
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
Answer
B
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
Answer
A&C
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
Answer
A
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
Answer
C
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
Answer
B
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
B. SSIS
C. PolyBase
D. ADF
Answer
C
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
Answer
D
Q27) What tool is used to build a Microsoft Power BI paginated report?
A. SSIS
B. Power BI Desktop
C. the Power BI service
D. Power BI Report Builder
Answer
D
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
Answer
C
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
Answer
D
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
B. SSIS
C. PolyBase
D. ADF
Answer
C
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).
Answer
B
Q32) Which ADF component initiates the execution of a pipeline?
A. an activity
B. a trigger
C. a parameter
D. a control flow
Answer
B
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
Answer
B,D&F
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
Answer
C
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
Answer
B&C
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.
Q37) Drag and drop the appropriate Azure services to the suitable locations in the architecture.
Q38) Drag and drop the appropriate tool from the column on the left to its suitable description on the right
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