Building Pipelines
Trigger type that executes a pipeline at specific times
What is the Schedule trigger?
Integration runtime used to execute activities against Azure SQL Database
What is the Azure Integration Runtime?
Interactive and collaborative environment that allows you to analyze data, write code, and create visualizations
What are Notebooks?
Primary language for querying and analyzing data
What is SQL (Structured Query Language)?
Service in Azure that provides identity and access management for Azure resources and applications
What is Azure Active Directory?
Allows you to run pipelines in a secure and isolated environment within your on-premises network
What is the Self-hosted Integration Runtime?
How to schedule the execution of an Azure Synapse Dataflow
What is by using triggers such as the Schedule trigger or event-based triggers?
Centralized environment where you can manage and work with data, pipelines, notebooks, and more
What is the Synapse Workspace?
Command for creating statistics on tables
What is the CREATE STATISTICS command?
Provides serverless compute service in Azure that allows you to run code in response to events or triggers?
What are Azure Functions?
Visually design and orchestrate complex data workflows using a drag-and-drop interface
What is the Pipeline Designer?
"Destination" in Azure Synapse Dataflows
What is a Sink?
Component that allows you to query data on-demand without requiring provisioned resources
What are Serverless SQL Pools?
How to scale Azure Synapse Dedicated SQL Pools
What is by modifying the scale settings and changing the DWUs?
Azure service that allows you to aggregate and analyze metrics and logs
What is Azure Monitor?
Uses a wizard in Azure Synapse Pipelines for moving and transforming data
What is the Data Copy activity?
Allows you to step through and troubleshoot data transformations during development
What is Debug mode?
Solution in Azure that is commonly used as a data lake in Azure Synapse Analytics
What is Azure Data Lake Storage?
Allows you to define the distribution of data across compute nodes for parallel processing based on the data
What is data distribution based on a hash?
Globally distributed, multi-model database service in Azure that offers high scalability and low latency
What is Azure Cosmos DB?
Activity that allows full control over transforming and processing data
What is the Data Flow activity?
Transformation used to remove duplicates from a dataset based on specified columns
What is the Remove Duplicates transformation?
Component that provides a provisioned resource for running high-performance, optimized SQL queries
What are Dedicated SQL Pools?
Allows you to allocate and prioritize resources for different workloads based on importance
What is workload management?
Set of development tools and services in Azure that enables you to plan, develop, test, and deploy applications
What is Azure DevOps?