D900_6

Which Azure Data Factory component provides the compute environment?

• control flow

• a linked service

• ​a pipeline

• ​an integration runtime

Select True or False

• ​1.True

  2. True

  3. True

• ​1.True

  2. True

  3. False ​

• 1.True

  2. False

  3. True

Select True or False for each:

• ​1. True

  2. True

  3. True

• ​1. True

  2. True

  3. False ​

• 1. False

  2. True

  3. False

• ​1. True

  2. False

  3. True

Which of the following Azure databases would be considered as "Infrastructure as a service"?

• SQL Managed Instance

• ​Cosmos DB

• ​​SQL Server in a VM

• ​Azure SQL Database

You have an Azure Cosmos DB account that uses the Core (SQL) API. Which settings can you configure at the container level? Select two correct options.

• ​the partition key

• ​the read region

• ​the API

• ​​the throughput

What happens when you add a new property to a JSON document, that doesn't exist in any other document, when storing in Cosmos DB?

• ​​You cannot dynamically add a new property and the insert will fail

• You can dynamically insert a new property and the insert will succeed. Previous documents will not be updated

• ​You can dynamically insert a new property and the insert will succeed. Previous documents will be updated with the new property

Select the correct options for below

• ​a database object that holds data - Table

  a database object whose content is defined by a query - Index

  a database object that helps improve data retrieval time - View

• a database object that holds data - Table

  a database object whose content is defined by a query - View

  a database object that helps improve data retrieval time - Index

• a database object that holds data - Table

  a database object whose content is defined by a query - Normalization

  a database object that helps improve data retrieval time - Index

• a database object that holds data - View

  a database object whose content is defined by a query - Table

  a database object that helps improve data retrieval time - Index

Which of the following tools can be used in macOS to access data stored in Azure SQL Database?

• ​Azure Storage Explorer

• SQL Server Data Tools

• ​Azure Data Studio

• ​SQL Server Management Studio

During which step of ETL is a data column modified to match the expected format of the destination? For instance, changing the date field from "31 Dec, 2021" to "31/12/2021".

Select the correct option.

• ​Loading

• Transformation

• Extraction

Which of the following Azure services can be used to provision Apache Spark clusters?

Select two correct options.

• ​Azure HDInsight

• ​Azure Log Analytics

• ​Azure Time Series Insights

• ​Azure Databricks