DP 900 - pt 14

Which language is used to define queries in Azure Synapse Data Explorer?

• Bash

• .PowerShell

• KQL

• SQL

The ​ (a)   service is optimized for IoT solutions

• Azure SQL Edge
• Azre SQL database
• Azure SQL Manages Instance
• SQL server on Azure Virtual Machine

• yes

• no

• yes

• no

• yes

• no

The ​ (a)   fromat is used to store delimited data, separate data fields by using commas and terminate rows by carriage return

• CSV
• JSON
• TSV
• XML

The ​ (a)   file format uses a hierarchal document schema to define data entities that have multiple attributes

• JSON
• CSV
• ORC
• TSV

Match the Azure Cosmos DB APIs to the appropriate data structures.

a

b

c

Azure Cosmos DB for Apache Gremlin API

Azure Cosmos DB for Table API

Azure Cosmos DB for NoSQL API

Which Azure Cosmos DB API should you use for a graph database?

• Azure Cosmos DB for Table

• Azure Cosmos DB for Apache Cassandra

• Azure Cosmos DB for NoSQL

• Azure Cosmos DB for Apache Gremlin

​ (a)   are responsible for the availability, performance and optimization of databases

• Database administrators
• data analysts
• data engineers
• data scientist