Microsoft (DP-900) Exam Questions And Answers page 16
To complete the sentence, select the appropriate option in the answer area.
Introduction to Data Concepts
Core Data Concepts
You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.
What should you use?
What should you use?
a Synapse SQL pool
Synapse Link
Synapse Studio
Describe core data concepts in Azure
Describe how to work with non-relational data on Azure
Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Describe core data concepts in Azure
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 Are the Key Features of Real-Time Data Processing?
Multiple Choice
What are two characteristics of real-time data processing? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
NOTE: Each correct selection is worth one point.
Data is processed periodically
Low latency is expected
High latency is acceptable
Data is processed as it is created
Describe an analytics workload on Azure
Core Data Concepts
When you create an Azure SQL database, which account can always connect to the database?
the Azure Active Directory (Azure AD) account that created the database
the server admin login account of the logical server
the Azure Active Directory (Azure AD) administrator account
the sa account
Describe core data concepts in Azure
Describe how to work with relational data on Azure
Your company is designing an application that will write a high volume of JSON data and will have an application-defined schema.
Which type of data store should you use?
Which type of data store should you use?
columnar
key/value
document
graph
Describe how to work with non-relational data on Azure
Working with Data on Azure
Which statement is an example of Data Definition Language (DDL)?
SELECT
JOIN
UPDATE
CREATE
Core Data Concepts
Working with Data on Azure
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.
Core Data Concepts
Working with Data on Azure
Comments