Section 3: Data Migration and Transformation Flashcards
What is Azure Data Factory primarily used for?
Azure Data Factory is primarily used for data integration and transformation.
True or False: Azure Migrate helps in assessing and migrating on-premises workloads to Azure.
True
Fill in the blank: ETL stands for ________.
Extract, Transform, Load
What is the purpose of the integration processes in Azure Synapse?
The integration processes in Azure Synapse facilitate data movement and transformation across various data sources.
Which Azure service allows you to create data pipelines?
Azure Data Factory
Multiple Choice: Which of the following is NOT a feature of Azure Data Factory? A) Data movement B) Data orchestration C) Data visualization D) Data transformation
C) Data visualization
What type of workloads does Azure Migrate assess?
Azure Migrate assesses on-premises workloads for migration to Azure.
True or False: Azure Data Factory can only work with Microsoft data sources.
False
What are the two main components of Azure Data Factory?
The two main components are the Data Pipeline and the Data Integration Runtime.
Fill in the blank: In ETL processes, the ‘Transform’ step is responsible for ________.
modifying the data to fit operational needs
What is the role of the Integration Runtime in Azure Data Factory?
The Integration Runtime provides the data integration capabilities across different network environments.
Multiple Choice: Which of the following can be a source for Azure Data Factory? A) SQL Database B) Excel files C) Blob storage D) All of the above
D) All of the above
What does Azure Synapse Analytics combine?
Azure Synapse Analytics combines big data and data warehousing.
True or False: Azure Migrate supports only Windows-based servers.
False
What is a key benefit of using Azure Data Factory for ETL processes?
A key benefit is its ability to orchestrate data workflows across different services.
What is the primary function of Azure Synapse Pipelines?
Azure Synapse Pipelines orchestrate the movement and transformation of data.
Fill in the blank: Azure Data Factory supports ________ data integration.
hybrid
Multiple Choice: Which of the following is a common use case for Azure Migrate? A) Web app hosting B) Database migration C) Machine learning model training D) Video streaming
B) Database migration
What does the term ‘data orchestration’ refer to in Azure Data Factory?
Data orchestration refers to managing and scheduling data workflows.
True or False: Azure Data Factory allows for real-time data processing.
False
What integration capabilities does Azure Data Factory provide?
Azure Data Factory provides data movement, data transformation, and data monitoring capabilities.
Fill in the blank: The primary output of an ETL process is ________.
a transformed dataset ready for analysis
What is a ‘data flow’ in Azure Data Factory?
A data flow is a visual way to design data transformation logic.
Multiple Choice: What is the first step in an ETL process? A) Load B) Transform C) Extract D) Analyze
C) Extract
What is the Azure service that allows users to analyze large volumes of data?
Azure Synapse Analytics
