Explore topic-wise InterviewSolutions in .

What IR type should you install while copying data from Azure to Azure?
CHOOSE the correct option from below LIST
(1)Azure
(2)NONE of the options
(3)SELF hosted
(4)Azure SSIS

Answer:-(1)Azure

_________ is a cloud integration service that is build for extract load TRANSFORM (ETL), extract transform load (ELT), and DATA integration projects?
Choose the correct option from below LIST
(1)Azure virtual machines
(2)Azure SQL database
(3)Azure BATCH service
(4)Azure Data factory

Answer:-(4)Azure Data factory

What is the type defined for the Azure storage linked service?
CHOOSE the CORRECT option from below list
(1)Azurestorage
(2)AzureStorageLinkedService
(3)AzureStorage
(4)azure storage

Answer:-(3)AzureStorage

For scheduling activity, in which of its JSON file, the FREQUENCY and interval are defined?
Choose the correct option from below LIST
(1)typeProperties
(2)type
(3)Scheduler
(4)scheduler

Answer:-(4)scheduler

What are the benefits of performing Lift and Shift SSIS?
Choose the correct option from below list
(1)Increase scalability
(2)All of the options
(3)Increase HIGH AVAILABILITY
(4)REDUCE OPERATIONAL costs

Answer:-(2)All of the options

Azure SSIS IR type is used to LIFT and shift SSIS only on a public network.
Choose the correct option from below list
(1)TRUE
(2)False

Answer:-(2)False

A pipeline is considered INACTIVE if it is not ASSOCIATED with _______ and hasnt been run over a week.
Choose the correct OPTION from below list
(1)Trigger
(2)Pipeline runs
(3)Pipeline
(4)Linked service

Answer:-(1)Trigger

_________ component of ADF identifies data within DIFFERENT data stores, such as tables, files, folders, and documents.
Choose the correct option from below list
(1)Data store
(2)LINKED service
(3)Dataset
(4)Pipeline

Answer:-(3)Dataset

What IR type should you install while copying data from on premise to Azure?
Choose the correct OPTION from below list
(1)SELF hosted
(2)Azure
(3)Azure SSIS
(4)NONE of the options

Answer:-(1)Self hosted

What are the DIFFERENT ADF management tools available to manage KEY COMPONENTS?
Choose the correct option from below list
(1)Azure portal
(2)All the options
(3)PowerShell
(4)Resource manager template
(5)REST API
(6).NET SDK

Answer:-(2)All the options

On which format in AZURE, the key COMPONENTS are defined?
Choose the CORRECT option from below LIST
(1).bacpac
(2)xml
(3)table
(4)JSON

Answer:-(2)xml

Which kind of data activity is TRANSFORMED by AZURE data LAKE analytics compute ENVIRONMENT in Azure?
Choose the correct option from below list
(1)Stored procedure
(2)U-SQL data
(3)Spark
(4)Hive

Answer:-(2)U-SQL data

Which COMPUTE environment in Azure does Hive data transformation activities use?
CHOOSE the correct option from below LIST
(1)Azure SQL
(2)Azure VM
(3)HDInsight Hadoop
(4)Azure data lake analytics

Answer:-(3)HDInsight Hadoop

You can PARAMETERIZE the linked service by selecting the Code icon on the CONNECTIONS tab and USING the JSON editor.
Choose the correct option from below list
(1)TRUE
(2)False

Answer:-(1)True

________ are used to REPRESENT data stores and COMPUTE resources that contains the connection strings.
Choose the correct OPTION from below list
(1)LINKED services
(2)Pipeline
(3)Dataset
(4)Datastore

Answer:-(1)Linked services

How to define a PIPELINE to not run between its start and END time?
Choose the correct option from below list
(1)isPaused: FALSE
(2)isPaused: true
(3)is paused: true
(4)is paused: false

Answer:-(2)isPaused: true

In which phase of the pipeline the REFINED data is loaded into Azure data WAREHOUSE and other stores?
Choose the correct option from below list
(1)Transform and enrich
(2)PUBLISH
(3)MONITOR
(4)Connect and collect

Answer:-(2)Publish

What are different types of integration runtime in ADF?
Choose the correct OPTION from below list
(1)AZURE
(2)SELF hosted
(3)Azure-SSIS
(4)All the options

Answer:-(4)All the options

Data MOVEMENT in the data FACTORY is enabled only in the Azure Data Factory PROVISIONED region.
Choose the correct option from below LIST
(1)False
(2)True

Answer:-(2)True

In which section of the AZURE blob dataset JSON FILE, the file name is defined?
Choose the correct OPTION from below list
(1)PROPERTIES
(2)FILETYPE
(3)typeProperties
(4)linkedServiceName

Answer:-(3)typeProperties

What is the second STEP in performing copy activity between DATA stores?
CHOOSE the correct OPTION from below list
(1)Providing performance details
(2)Selecting source DATASTORE and specifying its details
(3)Selecting destination datastore and specifying its details

Answer:-(2)Selecting source datastore and specifying its details

Custom ACTIVITY RUNS your customized code logic on a _______ pool of virtual machines.
Choose the correct option from below LIST
(1)Azure VM
(2)Azure Batch
(3)Azure Data factory
(4)Azure SQL database

Answer:-(2)Azure Batch

Azure Data FACTORY is available in which section of the market place in Azure portal?
Choose the CORRECT option from below list
(1)Networking
(2)Integration
(3)Compute
(4)Analytics

Answer:-(2)Integration

To specify a schedule to a dataset, in which section of its JSON file, is the frequency and INTERVAL defined?
Choose the CORRECT OPTION from below list
(1)scheduler
(2)type
(3)AVAILABILITY
(4)typeProperties

Answer:-(3)availability

On premises data stores connect to Azure resources by provisioning ________ instance in Azure.
Choose the CORRECT OPTION from below LIST
(1)Data gateway
(2)Pipeline
(3)SQL connection string
(4)Datafactory

Answer:-(1)Data gateway

_______ is a LOGICAL grouping of activities that PERFORM a task.
Choose the correct OPTION from below list
(1)PIPELINE
(2)Linked service
(3)Dataset
(4)Datastore

Answer:-(1)Pipeline

______ is a CONCEPT of moving your workloads to Azure cloud, deploy, and RUN the SSIS packages.
Choose the CORRECT option from below list
(1)Self-hosted
(2)LIFT and shift SSIS--------
(3)Azure
(4)DATA movement

Answer:-(2)Lift and shift SSIS