The latest Microsoft DP-900 Azure Data Fundamentals certification actual real practice exam question and answer (Q&A) dumps are available free, which are helpful for you to pass the Microsoft DP-900 Azure Data Fundamentals exam and earn Microsoft DP-900 Azure Data Fundamentals certification.
Table of Contents
- DP-900 Question 101
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 102
- Exam Question
- Correct Answer
- Explanation
- DP-900 Question 103
- Exam Question
- Correct Answer
- Reference
- DP-900 Question 104
- Exam Question
- Correct Answer
- DP-900 Question 105
- Exam Question
- Correct Answer
- Reference
- DP-900 Question 106
- Exam Question
- Correct Answer
- Reference
- DP-900 Question 107
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 108
- Exam Question
- Correct Answer
- DP-900 Question 109
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 110
- Exam Question
- Correct Answer
- Reference
DP-900 Question 101
Exam Question
When can you use an Azure Resource Manager template?
A. to automate the creation of an interdependent group of Azure resources in a repeatable way
B. to apply Azure policies for multi-tenant deployments
C. to provision Azure subscriptions
D. to control which services and feature administrators and developers can deploy from the Azure portal
Correct Answer
A. to automate the creation of an interdependent group of Azure resources in a repeatable way
Explanation
You can automate deployments and use the practice of infrastructure as code. In code, you define the infrastructure that needs to be deployed.
To implement infrastructure as code for your Azure solutions, use Azure Resource Manager templates (ARM templates). The template is a JavaScript Object Notation (JSON) file that defines the infrastructure and configuration for your project. The template uses declarative syntax, which lets you state what you intend to deploy without having to write the sequence of programming commands to create it. In the template, you specify the resources to deploy and the properties for those resources.
Reference
Microsoft Learn > Azure > Resource Manager > Templates > What are ARM templates?
DP-900 Question 102
Exam Question
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. batch processing
C. Online Analytical Processing (OLAP)
D. Online Transaction Processing (OLTP)
Correct Answer
D. Online Transaction Processing (OLTP)
Explanation
OLTP is designed to serve as a persistent data store for business or front-end applications. OLTP administers day to day transaction of an organization.
DP-900 Question 103
Exam Question
Match the terms to the appropriate descriptions. Each term may be used once, more than once, or not at all.
Terms:
- Index
- View
- Table
Descriptions:
- A database object that holds data
- A database object whose content is defined by a query
- A database object that helps improve the speed of data retrieval
Correct Answer
Table: A database object that holds data
View: A database object whose content is defined by a query
Index: A database object that helps improve the speed of data retrieval
Reference
DP-900 Question 104
Exam Question
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
Correct Answer
B. Azure Data Studio
DP-900 Question 105
Exam Question
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.
Which Azure service should you use?
A. Azure HDInsight
B. Azure SQL Database
C. Azure Cosmos DB
D. SQL Server on Azure virtual machines
Correct Answer
B. Azure SQL Database
Reference
DP-900 Question 106
Exam Question
You have an inventory management database that contains the following table.
| ProductName | Quality |
|---|---|
| Product1 | 100 |
| Product2 | 129 |
| Product3 | 176 |
Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?
A. INSERT
B. MERGE
C. UPDATE
D. CREATE
Correct Answer
C. UPDATE
Reference
Microsoft Learn > SQL > SQL Server > UPDATE (Transact-SQL)
DP-900 Question 107
Exam Question
To complete the sentence, select the appropriate option in the answer area.
An extract, load, and transform (ELT) process requires __________.
Answer Area:
A. a data pipeline that includes a transformation engine.
B. a separate transformation engine.
C. a target data store powerful enough to transform data.
D. data that is fully processed before being loaded to the target data store.
Correct Answer
C. a target data store powerful enough to transform data.
Explanation
In the ELT pipeline, the transformation occurs in the target data store. Instead of using a separate transformation engine, the processing capabilities of the target data store are used to transform data.
Reference
Microsoft Learn > Azure > Architecture > Data Architecture Guide > Extract, transform, and load (ETL)
DP-900 Question 108
Exam Question
To complete the sentence, select the appropriate option in the answer area.
__________ presents content defined by a query.
Answer Area:
A. A heap
B. A stored procedure
C. A view
D. An index
Correct Answer
C. A view
DP-900 Question 109
Exam Question
Match the types of analytics that can be used to answer the business questions. Each analytics type may be used once, more than once, or not at all.
Analytics Types:
- Cognitive
- Diagnostic
- Descriptive
- Predictive
- Prescriptive
Business Questions:
- Why did sales increase last month?
- Provide specific guidance on how to allocate current budget to buy different inventory items
- Detect images of the company’s logo included in PDF documents
Correct Answer
Diagnostic: Why did sales increase last month?
Prescriptive: Provide specific guidance on how to allocate current budget to buy different inventory items
Cognitive: Detect images of the company’s logo included in PDF documents
Explanation
Diagnostic: Why did sales increase last month?
Diagnostic Analytics: At this stage you can begin to answer some of those why questions. Historical data can begin to be measured against other data to answer the question of why something happened in the past. This is the process of gathering and interpreting different data sets to identify anomalies, detect patters, and determine relationships.
Prescriptive: Provide specific guidance on how to allocate current budget to buy different inventory items
Prescriptive analytics is a combination of data, mathematical models, and various business rules to infer actions to influence future desired outcomes.
Incorrect Answer:
Predictive analytics, broadly speaking, is a category of business intelligence that uses descriptive and predictive variables from the past to analyze and identify the likelihood of an unknown future outcome
Cognitive: Detect images of the company’s logo included in PDF documents
Reference
Describe, diagnose, and predict with IoT Analytics
DP-900 Question 110
Exam Question
To complete the sentence, select the appropriate option in the answer area.
A block of code that runs in a database is called __________.
Answer Area:
A. a stored procedure.
B. a table.
C. a view.
D. an index.
Correct Answer
A. a stored procedure.
Reference
Microsoft Learn > SQL > SQL Server > Stored Procedures (Database Engine)