Microsoft fabric

Which of the following is a key benefit of using Microsoft Fabric in data projects?

• It allows data professionals to work on data projects independently, without the need for collaboration.

• It requires duplication of data across different systems and teams to ensure data availability.

• It provides a single, integrated environment for data professionals and the business to collaborate on data projects.

What is the default storage format for Fabric's OneLake?

• Delta

• Json

• CSV

Which of the following Fabric workloads is used to move and transform data?

• Data Science

• Data Warehousing

• Data Factory

• Data Pipeline

What is a Microsoft Fabric Lakehouse?

• A relational database based on the Microsoft SQL Server database engine.

• A hierarchy of folders and files in Azure Data Lake Store Gen2.

• An analytical store that combines the file storage flexibility of a data lake with the SQL-based query capabilities of a data warehouse.

You want to include data in an external Azure Data Lake Store Gen2 location in your lakehouse, without the requirement to copy the data. What should you do?

• Create a Data pipeline that uses a Copy Data activity to load the external data into a file.

• Create a shortcut.

• Create a Dataflow (Gen2) that extracts the data and loads it into a table.

You want to use Apache Spark to interactively explore data in a file in the lakehouse. What should you do?

• Create a notebook.

• Switch to the SQL analytics endpoint mode.

• Create a Dataflow (Gen2).