DP 900 - pt 13

Relational databases are commonly used to store & query ​ (a)  

• structure data
• unstructure data
• blob
• semi structure data

Which Azure SQL offering provides near-100 percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates. backups, and maintenance tasks?

• Azure SQL Managed Instance

• SQL Server on Azure Virtual Machines

• Azure SQL Database

• Azure SQL Edge

Relational data uses ​ (a)   to enforce relationship between tables

• keys
• collection
• rows
• partition

An extract, load and transform (ELT) process requires ​ (a)  

• target data store powerful to transform data
• separate transformation engine
• data pipeline includes transformation engine
• data is processed before loaded to target data sto

In an analytical model designed as star schema, the entities by which you aggregate or slice measure are called ​ (a)  

• dimensions
• cubes
• facts
• schema

Match the data storage options to the appropriate types of data.

a

b

c

Azure Cosmos DB for NoSQL

Azure SQL Database

Azure Blob Storage

• yes

• no

• yes

• no

• yes

• no

The Azure Cosmos DB ​ 0 SQL ​​ (a)   API enables the USE of SELECT statements to retrieve documents from Azure Cosmos DB

• for NoSQL
• for Apache Gremlin
• for MongoDB
• for Table