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
Q2) Which statement is an example of Data Manipulation Language (DML)?
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?
B) Scalar Function
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?
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?
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?
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?
B. time series
Q21) At which two levels can you set the throughput for an Azure Cosmos DB account? Each right answer presents a complete solution.
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?
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
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?
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
C. MPP – massively parallel processing
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
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.
Q37) Drag and drop the appropriate Azure services to the suitable locations in the architecture.Show Answer
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 rightShow Answer
1) Microsoft SQL Server Management Studio (SSMS)
2) Microsoft Visual Studio Code
3) Azure Data Studio
4) Microsoft SQL Server Data Tools (SSDT)
Q40) Complete the sentence by selecting the appropriate option.Show Answer
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