Microsoft (DP-900) Exam Questions And Answers page 18
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
NOTE: Each correct selection is worth one point.
Introduction to Data Concepts
Core Data Concepts
To complete the sentence, select the appropriate option in the answer area.
Introduction to Data Concepts
Core Data Concepts
Which Azure Data Factory component provides the compute environment for activities?
an integration runtime
a control flow
a pipeline
Describe core data concepts in Azure
Working with Data on Azure
You have the following JSON document.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.
NOTE: Each correct selection is worth one point.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.
NOTE: Each correct selection is worth one point.
Introduction to Data Concepts
Core Data Concepts
Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. (Choose two.)
NOTE: Each correct selection is worth one point.
NOTE: Each correct selection is worth one point.
Azure Time Series Insights
Azure HDInsight
Azure Databricks
Azure Log Analytics
Describe how to work with non-relational data on Azure
Describe an analytics workload on Azure
You have an inventory management database that contains the following table.
Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?
Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?
INSERT
MERGE
UPDATE
CREATE
Describe how to work with relational data on Azure
Core Data Concepts
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Core Data Concepts
Working with Data on Azure
Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.
Introduction to Data Concepts
Working with Data on Azure
Match the security components to the appropriate scenarios.
To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Security, Privacy, Compliance, and Trust
Azure Data Services and Analytics Solutions
What is an example of Data Definition Language (DDL)?
Single Choice
Which statement is an example of Data Definition Language (DDL)?
SELECT
INSERT
DELETE
DROP
Core Data Concepts
Working with Data on Azure
Comments