DP 900 - pt 6

​ (a)   is a platform as a service (PaaS) relational data service that uses massively parallel processing (MPP).

• Azure Synapse Analytics
• Azure SQL database
• Azure Database for MariaDB
• SQL server on Azure virtual machine

​ (a)   physically sorts the data in the table based on the values in a specified column.

• Clustered index
• view
• stored procedure
• nonclustered index

Dbo.Products ​ ​ (a)  

ProductName ​ (b)  

• table
• column
• database
• index

In a relational database, the ​ (a)   uniquely identifies each row in a table

• primary key
• foreign key
• WHERE clause
• nonclustered index

​ (a)   presents content defined by query

• view
• heap
• stored procedure
• index

Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

• . Azure SQL Database

• Azure Database for MySQL

• Azure SQL Managed Instance

• Azure SQL Database elastic pool

Which setting can only be configured during the creation of an Azure Cosmos DB account?

• geo-redundancy

• multi-region writes

• production or non-production account type

• API

Match the types of data stores to the appropriate scenarios. To answer, drag the appropriate data store type from the column on the left to its scenario on the right. Each data store type may be used once, more than once, or not at all.

c

b

a

Graph

Object

Key/Value

You have an Azure Cosmos DB account that uses the Core (SQL) API. Which two settings can you configure at the container level? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

• the throughput

• the read region

• the partition key

• the API

Your company is designing a data store that will contain student data. The data has the following format.

• graph

• key/value

• object

• columnar