Microsoft (DP-900) Exam Questions And Answers page 15
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
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?
You need to persist the SQL query so that other users can use the query.
What should you create?
a view
a scalar function
a table
Describe core data concepts in Azure
Describe how to work with relational data on Azure
What is the primary purpose of a data warehouse?
to provide answers to complex queries that rely on data from multiple sources
to provide transformation services between source and target data stores
to provide read-only storage of relational and non-relational historical data
to provide storage for transactional line-of-business (LOB) applications
Core Data Concepts
Azure Data Services and Analytics Solutions
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Core Data Concepts
Security, Privacy, Compliance, and Trust
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
To complete the sentence, select the appropriate option in the answer area.
Introduction to Data Concepts
Working with Data on Azure
To complete the sentence, select the appropriate option in the answer area.
Introduction to Data Concepts
Core Data Concepts
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?
provides resiliency if an Azure region fails
supports partitioning
provides a higher storage capacity
supports a multi-master model
Describe how to work with non-relational data on Azure
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
Comments