In this article i am gone to share Coursera Course: Data Integration with Microsoft Azure Data Factory Week 3 | Test prep Quiz Answers with you..

Enrol Link: Week 2 | Test prep Quiz Answers

Data Integration with Microsoft Azure Data Factory
Week 3 | Test prep Quiz Answers

Test prep Quiz Answers

Question 1)
Azure Data Factory can also call on compute resources to transform data. Which Compute environment can be used with Notebook, Jar and Python Activities?

• Azure Machine Learning Studio Machine
• Azure Databricks
• Azure SQL, Azure SQL Data Warehouse, SQL Server
• Azure Data Lake Analytics

Question 2)
Star schema design theory refers to common SCD types. In this design approach, the Dimension Table always reflects the latest values, and when changes in source data are detected, the dimension table data is overwritten. What SCD Type is being referred to in this scenario?

• Type 2 SCD
• Type 1 SCD
• Type 3 SCD
• Type 6 SCD

Question 3)
When building data flows, you can enable debug mode allowing for interactive preview of the output of your transformation logic. Enabling Debug Mode turns on which of the following?

• Spark Cluster
• SQL Cluster

Question 4)
You are currently working on a Mapping Data Flow transformation for a Movie Database. You are interested in how a movie ranks within its year for its specific genre. Which of the following transformations should you use to generate the required transformation?

• Window Transformation
• A Derive Transformation
• Alter Row Transformation
• Aggregate Transformation

Question 5)
You want to load a dimension table in Azure Synapse from source data in your Azure Synapse database using mapping data flows. Which of the following options would you choose in Synapse Studio Hub to create a Type 1 SCD in a Mapping Data Flow pipeline activity?

• Data
• Develop
• Integrate
• Manage

Question 6)
When creating transformations in Azure Data factory which of the following uses a grid type interface for basic data preparation similar to Excel, known as an Online Mashup Editor, while also allowing complex data preparation using formulas?

• Mapping Data Flow
• Azure-SSIS Integration Runtime
• Wrangling Data Flow

Question 7)
Which transformation is used to load data into a data store or compute resource?

• Sink
• Window
• Surrogate key
• Source

Question 8)
Which SCD type would you use to keep history of changes in dimension members by adding a new row to the table for each change?

• Type 1 SCD
• Type 2 SCD
• Type 3 SCD
• Type 6 SCD

Question 9)
Which of the following transformations are directly available in the Mapping Data Flows activity?
Select all options that apply.

• Insert
• Conditional Split
• Aggregate
• Exists