Introduction to Microsoft Fabric

1. 1. As a data analyst working with only structured datasets, where would your data be stored?

• Data Lakehouse

• One lake

• Warehouse

• Database

2. You have a data stored in tables in snowflakes, which of the following cannot be used to bring the data into fabric.

• Use a data pipeline copy data activity

• Create a shortcut to the snowflake tables from lakehouse

• use a dataflow Gen2 with a snowflake connection

• use database mirroring to create a mirrored snowflake database in fabric

3. 3. You are running an F2 capacity, and you experience regular throtting, there are many long running spark jobs that take an average of 3 hours to complete, you need it to complete in 1 hour, you plan to increase the capacity of the SKU, where will you go?

• Go to workspace settings > spark settings

• Go to admin portal > capacity settings and check through to azure to update capacity

• Go to mirroring Hub and look at the run history

• use the capacity metric app

I have my data in JSON format, Mp3 format, CSV. where would i be able to store it?

• Data warehouse

• Data Lakehouse

• One lake

• Database

What is the full meaning of ETL?

• Edit - Transfer - Load

• Excel - TSQL - LLM

• Extract - Transfer - Load

• Extract - Transform - Load

Which of these data ingestion method uses a Low/No Code Environment?

• Pipeline

• Notebook

• Dataflow

I have my data stored in my on- prem SQL, how can i ingest it into Fabric?

• Database Mirroring

• Shortcuts

• Eventstream

• Dataflow

Which of these Facric storage features can be used for Real Time Reporting?

• Data Mirroring

• Dataflow

• Event Stream

• Data Pipeline

Arrange this Administrators in order of hierarchy.

• Capacity > Tenant > Workspace

• Workspace > Tenant > Capacity

• Tenant > Capacity > Workspace

• Workspace > Capacity > Tenant

Which of the following is not an Experience in Microsoft Fabric

• Data Science

• Data Engineering

• Data analytics

• Data activator