NEW
Font size
WorksheetsMicrosoft Fabric Data Warehouse Quiz
Total questions: 23
Worksheet time: 15mins
What is the initial step in establishing a Microsoft Fabric data warehouse?
Set up event stream processing
Build dashboards
Create a warehouse in the workspace
Configure encryption settings
When it comes to loading data into Microsoft Fabric data warehouses, which of the following is NOT supported?
Copy Data tool
T-SQL bulk insert
Direct API upload
Dataflow Gen2
Which feature makes sure that a Fabric data warehouse is only accessible by authorized users?
Access Control Lists (ACLs)
Sensitivity labels
Row-level security
Static data masking
How can a Fabric data warehouse's activity and performance be tracked?
Through the Fabric's Monitoring Hub
With SQL Profiler
With Power Automate
Logic Apps on Azure
When keeping an eye on a Fabric data warehouse, which statistic is crucial to monitor?
Density of pixels
Duration of query
Version of file
Storage class
What kind of authentication is most frequently employed to protect a Fabric data warehouse?
Basic Auth
OAuth 2.0 with Azure AD
SSH Key
API Token
In fabric warehouses, what is the best way to secure sensitive data access?
Turn on soft delete
Give all users admin access
Employ role-based access control
Turn off encryption
Which Fabric feature allows data to be loaded into a data warehouse on a scheduled basis?
SQL stored procedures
Event stream jobs
Data pipelines
Refreshing Power BI
Which integrated system enables Fabric data warehouse reporting?
Microsoft Teams
Azure Logic Apps
BI with Power
Online Excel
What kind of encryption is used by Microsoft Fabric to protect warehouse data when it is at rest?
Encryption using public keys
Encryption using customer-managed keys (CMK)
Only symmetric keys are supported
Fabric is not encrypted
You want to set organization-wide data retention policies. Where can this be configured?
What is the main objective of Microsoft Fabric's pipelines for real-time intelligence?
To produce dashboards and reports
To coordinate the processes of data transformation and movement
To control access
To make predictive analytics available
What does the 'Gold' layer usually stand for in the Medallion architecture utilized in Microsoft Fabric Lakehouses?
Unprocessed, raw data
Data that has been cleaned and combined from several sources
Business-ready, aggregated data
Data streaming for events
What function does Microsoft Fabric's Eventhouse serve?
To use relational databases exclusively
To function as an engine for batch processing
To offer analytics for streaming data
To function as a dashboard user interface
Which Microsoft Fabric feature makes it possible to visually monitor real-time data updates?
Notepads
Endpoints for SQL Analytics
Dashboards in real-time
Power Inquiry
Which of the following is the correct sequence of layers in a Medallion architecture?
Bronze → Silver → Gold
Silver → Gold → Bronze
Raw → Cleaned → Enriched
Bronze → Gold → Silver
