Ingestion

What is the primary purpose of data ingestion in Microsoft Fabric?

• To analyze the data

• To import and prepare data for further use

• To visualize data

• To store data for future reference

Which of the following is NOT a method of data ingestion in Microsoft

• Data Flow Gen 2

• Power Query

• Azure Data Lake

• Excel Plugin

Which data ingestion tool in Microsoft Fabric is primarily used for ETL (Extract, Transform, Load) processes?

• Power BI

• Data Flow Gen 2

• Synapse

• Excel Online

What format is commonly used for ingesting large, structured datasets in Microsoft Fabric?

• CSV

• XML

• JSON

• All of the above

In Microsoft Fabric, which feature allows for seamless integration with Azure Data Lake for data ingestion?

• Direct Query

• OneDrive Sync

• Lakehouse

• Power Automate

Which of the following is true about streaming data ingestion in Microsoft Fabric?

• It requires batch processing

• It is only available in Power BI

• It processes data in real-time

• It is limited to CSV files

Which connector would you typically use to ingest data from cloud sources into Microsoft Fabric?

• SQL Connector

• REST API

• OData Feed

• All of the above

What is the role of Power Query in the data ingestion process within Microsoft Fabric?

• To create visualizations

• To cleanse and transform data before ingestion

• To store data

• To apply machine learning models

Which of the following can be used to automate data ingestion in Microsoft Fabric?

• Power Automate

• Data Flow Gen 2

• Synapse Pipelines

• All of the above

Which of the following can be used to automate data ingestion in Microsoft Fabric?

• Power Automate

• Data Flow Gen 2

• Synapse Pipelines

• All of the above