04 - Explore Modern Data Warehouse Analytics

Question 1

Modern data warehouse components

Answer 1

Azure Data Factory

Azure Data Lake

Azure Databricks

Azure HDInsight

Azure Synapse Analytics

Question 2

Azure Data Factory

Answer 2

Ingest the data

Question 3

Azure Synapse Analytics

Answer 3

Processes the data, or transform the data - VERIFY

Question 4

Azure Data Bricks

Answer 4

Transforms the data - VERIFY

Question 5

Azure Analysis Services - Online Analytical Processing

Answer 5

fill in

Question 6

Azure Data Factory

Answer 6

Data integration service.

Cloud replacement/evolution of SQL server integration service

Question 7

GDPR

Answer 7

EU revelation but has global reach

You cannot store PII or any personal data outside of EU territory unless you have specific permission from the user

Question 8

Azure Data Lake Storage

Answer 8

Repository of data for your modern data warehouse

Question 9

Azure Databricks

Answer 9

Apache Spark-based platform that provides big data processing and streaming

Question 10

Azure Analysis Services

Answer 10

Builds tabular models to support online analytical processing (OLAP)

Question 11

Azure HDInsight

Answer 11

Big data processing services which allows you to use open-source libraries on the one platform, in an Azure environment

Question 12

Data Ingestion

Answer 12

Azure Data Factory - ADF
Use batch or stream processing. Going to use SPARK

PolyBase - T-SQL environment

SSIS - SQL Server Integration Services or SQL Server Managed Instance

Question 13

Components of Azure Data Factory

Answer 13

Data Lake Store

Azure Databricks