End-to-End Analytics (Fabric)

Question 1

What is OneLake?

Answer 1

Fabric’s lake-centric architecture that provides a single, integrated environment for data professionals and the business to collaborate on data projects.

Question 2

What is OneCopy?

Answer 2

A key component of OneLake that allows you to read data from a single copy, without moving or duplicating data.

Question 3

How does OneLake facilitate collaboration?

Answer 3

By eliminating the need to move and copy data between different systems and teams.

Question 4

What is the analogy used to describe OneLake?

Answer 4

Think of it like OneDrive for data.

Question 5

What does OneLake combine?

Answer 5

Storage locations across different regions and clouds into a single logical lake.

Question 6

What features does Fabric’s data warehousing, data engineering, integration, intelligence, and Power BI use?

Answer 6

They all use OneLake as their native store without needing any extra configuration.

Question 7

On what is OneLake built?

Answer 7

Azure Data Lake Storage (ADLS).

Question 8

What formats can data be stored in OneLake?

Answer 8

Delta, Parquet, CSV, JSON, and more.

Question 9

What is the benefit of storing data in OneLake?

Answer 9

Data stored in OneLake is directly accessible by all compute engines without needing to be moved or copied.

Question 10

What format do analytical engines in Fabric write for tabular data?

Answer 10

Delta-parquet format.

Question 11

What is a key feature of OneLake regarding shortcuts?

Answer 11

Shortcuts are embedded references within OneLake that point to other files or storage locations.

Question 12

What does the Synapse Data Engineering experience focus on?

Answer 12

Data engineering with a Spark platform for data transformation at scale.

Question 13

What is the purpose of the Synapse Data Warehouse experience?

Answer 13

Data warehousing with industry-leading SQL performance and scale to support data use.

Question 14

What does the Synapse Data Science experience utilize?

Answer 14

Azure Machine Learning and Spark for model training and execution tracking in a scalable environment.

Question 15

What is the focus of Synapse Real-Time Intelligence?

Answer 15

Real-time intelligence to query and analyze large volumes of data in real-time.

Question 16

What does the Data Factory experience combine?

Answer 16

Power Query with the scale of Azure Data Factory to move and transform data.

Question 17

What is the role of Power BI in Fabric?

Answer 17

Business intelligence for translating data to decisions through interactive reports.

Question 18

What is the function of workspaces in Microsoft Fabric?

Answer 18

They serve as logical containers that help you organize and manage your data, reports, and other assets.

Question 19

How do workspaces support collaboration?

Answer 19

By providing a clear separation of resources, making it easier to control access and maintain security.

Question 20

What can be customized within workspaces?

Answer 20

How to separate and control access to the items.

Question 21

What features do workspaces support for managing compute resources?

Answer 21

Settings to manage compute resources and integrate with Git for version control.

Question 22

What does Git integration in workspaces allow?

Answer 22

To track changes, collaborate on code, and maintain a history of your work.

Question 23

What is the significance of data lineage and impact analysis in workspaces?

Answer 23

They provide a comprehensive view of data flow and dependencies, enhancing transparency and decision-making.

Question 24

How is security managed in OneLake?

Answer 24

Data is secured and governed in one place, allowing users to easily find and access the data they need.

Question 25

What can be managed in the Fabric admin center?

Answer 25

Groups and permissions, configure data sources and gateways, and monitor usage and performance.

Question 26

What can you access in the Fabric admin center for automation?

Answer 26

Fabric admin APIs and SDKs.

Question 27

What does Microsoft Fabric transform in the analytics development process?

Answer 27

Unifies tools into a SaaS platform

Question 28

What flexibility does Microsoft Fabric provide for different roles?

Answer 28

Allows performing necessary skills without duplicating efforts

Question 29

What can data engineers do with large amounts of data in OneLake?

Answer 29

Ingest, transform, and load data

Question 30

How are data loading patterns simplified in Microsoft Fabric?

Answer 30

Using pipelines and easily configurable architectures

Question 31

What architecture is mentioned that can be configured using workspaces?

Answer 31

Medallion architecture

Question 32

What advantage do data analysts gain with Microsoft Fabric?

Answer 32

Greater context and streamlined processes

Question 33

What is the purpose of Data Factory in Microsoft Fabric?

Answer 33

Transform data upstream

Question 34

What mode allows data analysts to connect with data more directly?

Answer 34

DirectLake mode

Question 35

How do data scientists use Microsoft Fabric?

Answer 35

Integrate native data science techniques and use Power BI for insights

Question 36

What role do analytics engineers play in Microsoft Fabric?

Answer 36

Bridge gap between data engineering and data analysis

Question 37

What responsibilities do analytics engineers have?

Answer 37

Curate data store assets, ensure data quality, enable self-service analytics

Question 38

Who can discover curated data through the OneLake hub?

Answer 38

Low-to-no-code users and citizen developers

Question 39

What can low-to-no-code users do with curated data?

Answer 39

Further process and analyze it without dependency on data engineers

Question 40

True or False: Microsoft Fabric allows data engineers to duplicate data efforts.

Answer 40

False

Question 41

What must be done before exploring Microsoft Fabric capabilities?

Answer 41

Microsoft Fabric must be enabled for your organization.

Question 42

Who might you need to work with to enable Microsoft Fabric?

Answer 42

You might need to work with your IT department.

Question 43

What are the permissions required to enable Microsoft Fabric?

Answer 43

Admin privileges are required to enable Fabric.

Question 44

How can an admin enable Microsoft Fabric?

Answer 44

Admins can access the Admin center from the Settings menu in Power BI and enable Fabric in the Tenant settings.

Question 45

Can admins make Fabric available to specific groups?

Answer 45

Yes, admins can make Fabric available to the entire organization or specific groups of users.

Question 46

What is a workspace in Microsoft Fabric?

Answer 46

Workspaces are collaborative environments for creating and managing items like lakehouses, warehouses, and reports.

Question 47

Where is all data stored in Microsoft Fabric?

Answer 47

All data is stored in OneLake.

Question 48

What can you configure in the Workspace settings?

Answer 48

You can configure the license type, OneDrive access, Azure Data Lake Gen2 Storage connection, Git integration, and Spark workload settings.

Question 49

What roles are available for granting access to a workspace?

Answer 49

There are four available roles that have access to all items in a workspace.

Question 50

What is the OneLake data hub?

Answer 50

The OneLake data Hub helps users find and access various data sources within their organization.

Question 51

What can users do with the OneLake data hub?

Answer 51

Users can explore and connect to data sources, ensuring they have the right data for their needs.

Question 52

What should users consider when using OneLake Hub?

Answer 52

Users can narrow results by domains, filter by workspaces, explore default groups, and filter by keyword or item type.

Question 53

How do you create items in Fabric?

Answer 53

You can create items using the Create menu in the upper left corner of the Power BI service.

Question 54

What are Fabric workloads?

Answer 54

Fabric workloads refer to the different capabilities included in Fabric.

Question 55

How can you switch between Fabric workloads?

Answer 55

You can switch between workloads using the workload switcher in the bottom left corner of the navigation pane.

Question 56

What makes Fabric unique compared to other Microsoft data offerings?

Answer 56

Fabric brings together capabilities from various services in a single, SaaS integrated experience without needing access to Azure resources.