DP-203T00: Data Engineering on Microsoft Azure Quiz Questions and Answers

Answer :
  • Azure SQL Database Hyperscale

Explanation :

A Hyperscale database is an Azure SQL database in the Hyperscale service tier that is backed by the Hyperscale scale-out storage technology. A Hyperscale database supports up to 100 TB of data and provides high throughput and performance, as well as rapid
Answer :
  • An architecture that splits incoming data into two paths - a batch path and a streaming path. This architecture helps address the need to provide real-time processing in addition to slower batch computations.

Explanation :

An architecture that splits incoming data into two paths - a batch path and a streaming path. This architecture helps address the need to provide real-time processing in addition to slower batch computations
Answer :
  • Azure Data Lake Storage Gen2

Explanation :

Azure provides several solutions for working with CSV and JSON files, depending on your needs. The primary landing place for these files is either Azure Storage or Azure Data Lake Store
Answer :
  • Files

Explanation :

Azure Files enables you to set up highly available network file shares that can be accessed by using the standard Server Message Block (SMB) protocol.
Answer :
  • All dimensions in a star schema join directly to the fact table (denormalized) while some dimension tables in a snowflake schema are normalized

Explanation :

All dimensions in a star schema join directly to the fact table (denormalized) while some dimension tables in a snowflake schema are normalized
Answer :
  • Gremlin

Explanation :

The Azure Cosmos DB Gremlin API can be used to store massive graphs with billions of vertices and edges.