Quizz 10 DP 900

What is a characteristic of non-relational data?

• A. a well-defined schema

• B. no indexes

• C. self-describing entities

• D. no unique key values

You have structured data in tabular format.

What represents an individual instance of a data entity?

• A. a column

• B. a cell

• C. a row

• D. a table

In Azure Table storage, each row in a table must be uniquely identified by which two components?

• A. a timestamp

• B. a range

• C. a row key

• D. a partition key

What is a difference between structured data and semi-structured data?

• A. Structured data has a fixed schema and semi-structured data has a flexible schema.

• B. Only Structured data supports entities.

• C. Structured data has a flexible schema and semi-structured data has a fixed schema.

• D. Only Structured data supports attributes.

The ..................... file format uses a hierarchical document schema to define data entities that have multiple attributes.

• JSON

• CSV

• ORC

• TSV

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

• A. Bash

• B. PowerShell

• C. KQL

• D. SQL

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

Database administrators apply data cleansing routines and turn data into useful information.

• Yes

• No

Data engineers manage databases, store backup copies of data, and restore data in the

event of a failure.

• Yes

• No

Data analysts create data visuals and enable companies to make data-driven decisions.

• Yes

• No