All Coursera Quiz Answers

Data Integration with Microsoft Azure Data Factory Week 8 | Course practice exam Quiz Answers

by Niyander

In this article i am gone to share Coursera Course: Data Integration with Microsoft Azure Data Factory Week 8 | Course practice exam Quiz Answers with you..

Enrol Link: Week 1 | Test prep Quiz Answers

Data Integration with Microsoft Azure Data Factory
Week 8 | Course practice exam Quiz Answers

 

Course practice exam

Question 1)
Much of the functionality of Azure Data Factory appears in Azure Synapse Analytics as a feature called pipelines. You can use it to integrate data pipelines between which of the following?

  • SQL Pools
  • SQL Serverless
  • Spark Pools
  • Apache Hive

Question 2)
Microsoft Azure provides a variety of data platform services that enables you to perform different types of analytics. Predictive analytics can be implemented through which of the following features? Select all options that apply.

  • HDInsight
  • Azure Databricks
  • Azure Data Lake Storage Gen2
  • Machine Learning Services

Question 3)
When setting up Azure Data factory through the Azure Portal. Which of the following pieces of Information are required? Select all options that apply.

  • Resource Group name
  • Management Group Name
  • Subscription
  • Instance Name
  • Region

Question 4)
Which of the following is true in respect of Azure data factory datasets?

  • A dataset is a table that holds a copy of the data for the destination.
  • A dataset does not exist in Azure Data factory
  • A dataset is a named view that points or references the data.
  • A dataset is a table that holds a copy of the data from the source.

Question 5)
Data Factory offers three types of Integration Runtime.

  1. Azure
  2. Self-hosted
  3. Azure-SSIS

Which of these provides support for both Public Networks and Private Networks? Select all options that apply.

  • Azure only
  • Azure-SSIS only
  • Azure and Self Hosted
  • Self Hosted and Azure-SSIS
  • Self Hosted only
  • Azure and Azure-SSIS

Question 6)
Which Azure Data Factory component contains the transformation logic or the analysis commands of the Azure Data Factory’s work?

  • Activities
  • Linked Services
  • Datasets
  • Pipelines

Question 7)
What are the benefits of Azure-SSIS Integration Runtime? Select all options that apply.

  • Natively execute existing SSIS packages
  • Create On-demand HDInsight clusters
  • Process Azure Databricks Activities
  • Deploy and manage existing SSIS packages

Question 8)
You want to ingest data from a SQL Server database hosted on an on-premises Windows Server. What integration runtime is required for Azure Data Factory to ingest data from the on-premises server?

  • Self-Hosted Integration Runtime
  • Azure Integration Runtime
  • Azure-SSIS Integration Runtime

Question 9)
You need to deploy and manage existing SSIS packages using Azure Data Factory. Which of the following tools would you use? Select all options that apply.

  • Azure Data Factory Pipelines
  • Azure Copy Activity
  • SQL Server Data Tools (SSDT)
  • SQL Server Management Studio (SSMS)

Question 10)
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?

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

Question 11)
Mapping Data Flows support Debug so that you can interactively watch how the data transformations are executing. When enabling Debug, you are be prompted to select the Integration runtime to use. If you select AutoResolveIntegrationRuntime a cluster will be made available automatically. How many Cores will be made available in the cluster and what will the time to live be in minutes?

  • 4 Cores and 30 Minutes
  • 4 Cores and 60 Minutes
  • 8 Cores and 30 Minutes
  • 8 cores and 60 minutes

Question 12)
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 3 SCD
  • Type 2 SCD
  • Type 1 SCD
  • Type 6 SCD

Question 13)
Control flow is the orchestration of pipeline activities. The If-condition activity, which is similar to an if-statement, provided in programming languages is an example of which type of control flow activity?

  • Trigger based flows
  • Branching Activity
  • Chaining Activity
  • Looping Containers

Question 14)
In Azure Data factory you need to connect to several different databases that are on the same SQL server. Which of the following will require the least administrative effort?

  • Create a linked service for each database
  • Use Parameters

Question 15)
To lift and shift an existing SSIS workload, you can create an Azure-SSIS IR to natively execute SSIS packages. The location for your Azure-SSIS IR is important to achieve high performance in your extract-transform-load (ETL) workflows. Select which of the following statements are true.

  • The location of your Azure-SSIS IR does not need to be the same as the location of your data factory.
  • The location of your Azure-SSIS IR must be the same as the location of your data factory.

Question 16)
When you migrate your database workloads from SQL Server on premises to Azure SQL database services, you may have to migrate SSIS packages as well. The first step required is to perform an assessment of your current SSIS packages to make sure that they are compatible in Azure. Which of the following tools would be most appropriate to check for compatibility issues?

  • SQL Server Management Studio (SSMS)
  • Data Migration Assistant (DMA)
  • SQL Server Data Tools (SSDT)

Question 17)
An SSIS Project is the unit of deployment for SSIS solutions. In which version of SQL Server was SSIS Projects introduced?

  • SQL Server 2016
  • SQL Server 2008.
  • SQL Server 2012

Question 18)
Azure Data Factory allows you to configure a Git repository with either Azure Repos or GitHub. Which of the following are advantages of using GIT Integration?
Select all options that apply.

  • PowerShell or an SDK changes are published directly to GIT.
  • Better CI/CD
  • Partial saves
  • Source control

Question 19)
Each Azure Git repository that’s associated with a data factory has a collaboration branch with a default name of main. Users can also create feature branches. Which of the following statements are true?

  • You can publish to the Data Factory service from your Feature branch only.
  • You can publish to the Data Factory service from both Collaboration and Feature Branches.
  • You can publish to the Data Factory service from your collaboration branch only.

Question 20)
In Azure Data factory what is a supported connector for built-in parameterization?

  • Azure Data Lake Storage Gen2.
  • Azure Synapse Analytics
  • Azure Key Vault

 

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

  • Window
  • Source
  • Sink

Question 22)
Azure Data Factory can call on compute resources to process data by a specific data platform service that may be better suited to the job. Which compute resource can carry out the following activities, Spark, MapReduce and Hadoop Streaming activities?

  • Azure Machine Learning
  • Azure Batch
  • Azure Databricks
  • On-demand HDInsight cluster

Question 23)
Azure Data Factory provides a range of methods to perform transformations. You need to perform transformations without writing code. Which transformations would you use in this scenario?

  • HDInsight Pig activity
  • Mapping Data Flows
  • Stored procedure activity
  • Azure Machine Learning Studio

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

  • Source
  • Sink.
  • Surrogate key
  • Window

Question 25)
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?

  • Manage
  • Integrate
  • Develop
  • Data

Question 26)
By default, the Azure Data Factory user interface experience (UX) authors directly against the data factory service. Which of the following are true in respect of the Azure Data Factory user interface experience?

  • The Data Factory service is not optimized for collaboration and version control.
  • Includes a repository for storing the JSON entities for changes.
  • Does not include a repository for storing the JSON entities for changes.
  • The Data Factory service is optimized for collaboration and version control.

Question 27)
Which feature commits the changes of Azure Data Factory work in a custom branch created with the main branch in a Git repository?

  • Pull request
  • Commit
  • Repo

Question 28)
Pipelines in Azure Data Factory typically perform four distinct steps. Identify these steps?
Select all options that apply.

  • Connect and Collect
  • Monitor
  • Transform and Enrich
  • Data Analysis
  • Publish