Q.1 ________ are used to represent data stores and compute resources that contains the connection strings.
A. Datastore
B. Pipeline
C. Dataset
D. Linked services
Ans : Linked services
Q.2 ADF enables to create pipelines that ingest data from disparate data stores.
A. True
B. False
Ans : True
Q.3 A pipeline is considered inactive if it is not associated with _______ and hasn’t been run over a week.
A. Pipeline runs
B. Trigger
C. Pipeline
D. Linked service
Ans : Pipeline runs
Q.4 _________ is a cloud integration service that is build for extract-load-transform (ETL), extract-transform-load (ELT), and data integration projects?
A. Azure Data factory
B. Azure SQL database
C. Azure virtual machines
D. Azure Batch service
Ans : Azure Data factory
Q.5 On-premises data stores connect to Azure resources by provisioning ________ instance in Azure.
A. SQL connection string
B. Datafactory
C. Data gateway
D. Pipeline
Ans : Data gateway
Q.6 Custom activity runs your customized code logic on a _______ pool of virtual machines.
A. Azure VM
B. Azure Data factory
C. Azure Batch
D. Azure SQL database
Ans : Azure Batch
Q.7 Which compute environment in Azure does Hive data transformation activities use?
A. HDInsight Hadoop
B. Azure data lake analytics
C. Azure VM
D. Azure SQL
Ans : HDInsight Hadoop
Q.8 ______ is a concept of moving your workloads to Azure cloud, deploy, and run the SSIS packages.
A. Self-hosted
B. Lift and shift SSIS
C. Data movement
D. Azure
Ans : Lift and shift SSIS
Q.9 What are the benefits of performing Lift and Shift SSIS?
A. Reduce operational costs
B. Increase high availability
C. Increase scalability
D. All of the options
Ans : All of the options
Q.10 Azure Data factory is available in which section of the market place in Azure portal?
A. Integration
B. Networking
C. Compute
D. Analytics
Ans : Integration
Q.11 Azure SSIS IR type is used to lift and shift SSIS only on a public network.
A. True
B. False
Ans : False
Q.12 What IR type should you install while copying data from on-premise to Azure?
A. Azure
B. Azure SSIS
C. Self hosted
D. None of the options
Ans : Azure SSIS
Q.13 What are the different ADF management tools available to manage key components?
A. Resource manager template
B. Azure portal
C. PowerShell
D. REST API
E. .NET SDK
F. All the options
Ans : All the options
Q.14 _________ component of ADF identifies data within different data stores, such as tables, files, folders, and documents.
A. Data store
B. Dataset
C. Linked service
D. Pipeline
Ans : Dataset
Q.15 What is the second step in performing copy activity between data stores?
A. Selecting destination datastore and specifying its details
B. Selecting source datastore and specifying its details
C. Providing performance details
Ans : Selecting destination datastore and specifying its details
Q.16 To specify a schedule to a dataset, in which section of its JSON file, is the frequency and interval defined?
A. scheduler
B. type
C. availability
D. typeProperties
Ans : availability
Q.17 __________ activity allows monitoring the scheduled activities for success and failure rates.
A. Transform and enrich
B. Monitor
C. Connect and collect
D. Publish
Ans : Monitor
Q.18 How to define a pipeline to not run between its start and end time?
A. isPaused: false
B. is paused: true
C. is paused: false
D. isPaused: true
Ans : isPaused: false
Q.19 In which section of the azure blob dataset JSON file, the file name is defined?
A. typeProperties
B. Properties
C. fileType
D. linkedServiceName
Ans : typeProperties
Q.20 On which format in Azure, the key components are defined?
A. .bacpac
B. table
C. JSON
D. xml
Ans : xml
Q.21 What is the third step in performing copy activity between data stores?
A. Selecting source datastore and specifying its details
B. Setting up properties
C. Selecting destination datastore and specifying its details
D. Providing performance details
Ans : Selecting destination datastore and specifying its details
Q.22 What IR type should you install while copying data from Azure to Azure?
A. Azure
B. Self hosted
C. Azure SSIS
D. None of the options
Ans : Azure
Q.23 Which field is not required to provide while creating a data factory instance in the Azure portal?
A. Resource group
B. Location
C. Name
D. Subscription
Ans : Resource group
Q.24 What are different types of integration runtime in ADF?
A. Azure-SSIS
B. Azure
C. Self hosted
D. All the options
Ans : All the options
Q.25 Integration runtime provides a bridge between activity and linked service.
A. True
B. False
Ans : True
Q.26 Without a data factory, it is possible to build custom component
A. True
B. False
Ans : True
Q.27 Azure IR type is capable of running copy activity between data stores in public and private network.
A. True
B. False
Ans : True
Q.28 In which phase of the pipeline the refined data is loaded into Azure data warehouse and other stores?
A. Transform and enrich
B. Monitor
C. Connect and collect
D. Publish
Ans : Publish
Q.29 What is the first step in the pipeline workflow?
A. Connect and collect
B. Monitor
C. Publish
D. Transform and enrich
Ans : Connect and collect
Q.30 Which option should you select from the ADF resource page to copy data from data stores?
A. Metrics and operation
B. Author and deploy
C. Copy data
D. Manage and monitor
Ans : Metrics and operation