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?
A. columnar
B. key/value
C. document
D. graph
Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?
A. an Azure SQL Database elastic pool
B. Azure SQL Managed Instance
C. Azure Database for MySQL
D. Azure SQL Database
You have an on-premises Microsoft SQL Server database.
You need to migrate the database to the cloud. The solution must meet the following requirements:
*
Minimize maintenance effort.
*
Support the Database Mail and Service Broker features. What should you include in the solution?
A.
Azure SQL Database single database
B.
an Azure SQL Database elastic pool
C.
Azure SQL Managed instance
D.
SQL Server on Azure virtual machines
HOTSPOT
You have the following SQL query.
What are dbo.Products and ProductName? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Hot Area: