Quizz DP 900 12

What should you use to create and run data ingestion pipelines?

• 
  Azure Cosmos DB

• Azure Data Factory

• 
  Azure Databricks

• 
  Azure HDInsight

Which service is built on Apache Spark and is compatible with other cloud providers?

• Azure Data Factory

• 
  Azure Databricks

• 
  Azure HDInsight

• 
  Azure Synapse Analytics

What should you create first for an integration process that copies data from Microsoft Excel files to Parquet files by using Azure Data Factory?

• a dataset

• 
  a linked service

• 
  a pipeline

• 
  an activity

What is a characteristic of batch processing?

• 
  Batch processing handles small datasets based on a time window.

• 
  Batch processing is used to perform complex analysis.

• 
  Batch processing processes individual events.

• 
  Latency is measured in seconds or milliseconds.

Which two services can be used as a source for stream processing? Each correct answer presents a complete solution.

• 
  Azure Databricks

• 
  Azure Event Hubs

• 
  Azure IoT Hub

• 
  Azure SQL Database

In a stream processing architecture, what can you use to persist the processed results as files?

• Azure Data Lake Storage Gen2

• Azure Databricks

• Azure Event Hubs

• 
  Azure Synapse Analytics

Which service allows you to perform on-demand analysis of large volumes of data from text logs, websites and IoT devices by using a common querying language for all the data sources?

• 
  Azure Cosmos DB

• 
  Azure Data Explorer

• Azure Data Lake Storage Gen2

• Azure Stream Analytics

Which type of data structure should you use to optimize create, read, update, and delete (CRUD) operations for data saved in a multi-column tabular format?

• 
  document database

• 
  graph database

• 
  key/value store

• 
  relational database

You have data stored in two tables in a database.

You create a relationship between the tables.

Which type of data do you have?

• 
  semi-structured

• 
  structured

• 
  unstructured

Which is the best type of database to use for an organizational chart?

• Azure Table storage

• 
  Azure SQL Database

• 
  columnar

• 
  graph