Azure Fabric

Question 1

What are diff set of Roles

Answer 1

Workspace
1Lake data access

Question 2

What are the 2 top level items u find when u open Lakehouse?

Answer 2

Tables
Files

Question 3

Where can u create shortcuts within a lakehouse ?

Answer 3

Under Tables - only in the top level
Under Files, anywhere in the folder structure

Question 4

What locations can be your target for a shortcut ?

Answer 4

AWS S3
ADLS Gen 2
GCP
On-premises

Question 5

Can you write to shortcut target location ?

Answer 5

In ADLS v2 Yes, if u have permission at target.
In AWS No, even if u don’t have permission

Question 6

How permissions are resolved in shortcuts ?

Answer 6

An IAM/Azure role is associated with the shortcut during creation and that role is used to resolve permission.

Question 7

What auth methods are used in shortcut connection setup of ADLS v2?

Answer 7

specify the full dfs url including the container name.
acct_key, sas_token or service principal are used

Question 8

How many 1Lake per Org ?

Answer 8

Only 1. 1Lake is a logical entity, that represents all the data elements within the org, without duplicating the data.

Question 9

How to have dept level segregation in 1Lake

Answer 9

1Lake is per Tenant. Within 1Lake workspaces can be created.

Question 10

What are data items in 1Lake?

Answer 10

Lakehouses, Warehouses, Files are the data items of 1Lake.
Each data item belongs to a different experience Fabric offers.
e.g. Lake house gives the spark experience to the developer.

Question 11

What is the data format of azure sql datawarehouse in a 1Lake ?
Will it be a propreitory sql db ?

Answer 11

All data items including lakehouse and sql warehouses are stored in Delta format. 1Lake is built on top of ADLS v2.

Question 12

What is Analysis services in Fabric

Answer 12

Analysis services supports PowerBI

Question 13

There is a new mode called Direct Lake in Analysis Services. What are the old modes ?

Answer 13

Fabric adds the new mode called DirectLake where PowerBI can read 1Lake directly. The existing modes are Import and DirectQuery. DirectLake is the best of both import and Direct query.

Question 14

What is Fast Copy?

Answer 14

New feature in Data flow Gen2 - Copy activity that cuts down processing time & cost.

Question 15

In what resource level you call the 1Lake Data access APIs?

Answer 15

At the Lakehouse level.
list/get/put - workspace_id/lakehouse_item_id/

Question 16

Azure Private endpoint

Answer 16

An interfact in your vnet, connecting to azure services(sql/cosmos) thru microsoft backbone network.

Question 17

Does Private endpoint and link protect all traffic ?

Answer 17

No, it protects only inbound access to fabric services, Like uploading a file to lakehouse. For outbound data access, like api access, you shoud setup firewall rules.

Question 18

Vnet Data Gateway

Answer 18

To connect to on-premise data sources

Question 19

What is Trusted Workspace Access to Storage acct ?

Answer 19

Storage Accts are given secured access to Workspaces (synapse/dbriks) . A form of security thru limited network access.

Question 20

What are Data WorkFlow ?

Answer 20

Manage Apache Airflow to orchestrate the pipelines.
DataWorkflow is offered under the umbrella of Data Factory. What was Data Factory back then, is now Data Flow Gen2 and Data Pipelines.

Question 21

Fabric.Provider for Airflow

Answer 21

Fabric will package the operators, hooks, sensors relevant to Fabric as Provider and make it available to code data workflow jobs