Question bank
Microsoft Fabric Analytics Engineer
41 Microsoft Fabric Analytics Engineer questions with the correct answer and a written explanation, organised across 3 exam domains.
- 41 questions
- 3 domains
- Foundation level
certilumQuestion index
Jump straight to any question. Answers and explanations are inline.
Implement and manage semantic models
10 questions in this domain
- Question 1Single Choice
Which data connection mode reads data directly from OneLake without creating another copy of the data for the semantic model?
- AImport mode
- BDirect Lake modeCorrect answer
- CDirectQuery mode
- DLive connection mode
Why this is the answer
Direct Lake reads Delta Parquet files directly from OneLake, so semantic models do not need an imported copy of the data.
- Question 2Multiple Select
Which of the following are managed objects that can be included in the definition of a Microsoft Fabric semantic model? Select all that apply.
- AMeasuresCorrect answer
- BHierarchiesCorrect answer
- CRow-level security rolesCorrect answer
- DDataflow refresh schedules
Why this is the answer
Measures, hierarchies, and RLS roles are model objects. Dataflow refresh schedules belong to data preparation, not to the semantic model definition.
- Question 3Interactive
Review the DAX measure in the code block. Which filter context is applied before the Amount values are summed by the measure?
- ASales rows in the West regionCorrect answer
- BSales rows in the East region
- CSales rows in the current year
- DRows from the Product table
Why this is the answer
The CALCULATE function applies the filter Sales[Region] = 'West' before summing the Sales[Amount] column.
- Question 4Single Choice
In the context of a Fabric semantic model, what is the main purpose of row-level security roles?
- ARestrict which data rows users can seeCorrect answer
- BEncrypt all data in the model
- CImprove query performance through indexes
- DDefine relationships between tables
Why this is the answer
RLS applies DAX filters to roles, limiting the rows that a user or group can see in a semantic model.
- Question 5Multiple Select
Which of the following tasks are involved in the ongoing maintenance of a semantic model in Microsoft Fabric? Select all that apply.
- ASchedule data refreshesCorrect answer
- BMonitor query performanceCorrect answer
- CManage user permissionsCorrect answer
- DCreate a new Lakehouse
Why this is the answer
Maintaining a semantic model includes refreshing data, monitoring performance, and managing access. Creating a Lakehouse is a separate data engineering task.
- Question 6Interactive
The code block defines a DAX measure. What does the measure count when it is evaluated against the Sales table?
- ACount of unique products soldCorrect answer
- BTotal number of sales rows
- CTotal quantity of products sold
- DCount of report pages
Why this is the answer
DISTINCTCOUNT returns the number of unique values in Sales[ProductID], which represents the count of distinct products sold.
- Question 7Single Choice
In a star schema used by a semantic model, which type of table is located at the center of the schema?
- AFact tableCorrect answer
- BDimension table
- CCalculated table
- DStaging table
Why this is the answer
In a star schema, the fact table is in the center and contains measurable data; dimension tables surround it with descriptive data.
- Question 8Multiple Select
Which of the following methods can be used to control access to a semantic model in Microsoft Fabric? Select all that apply.
- AWorkspace rolesCorrect answer
- BItem permissionsCorrect answer
- CRow-level security rolesCorrect answer
- DCustom connector configuration
Why this is the answer
Workspace roles, item permissions, and RLS roles control access to semantic models. A custom connector is not an access control mechanism.
- Question 9Interactive
The code block contains a DAX measure. What calculation does the measure perform on the Sales table?
- ATotal revenue across all salesCorrect answer
- BAverage unit price of products
- CMaximum revenue from a product
- DTotal number of sales records
Why this is the answer
SUMX iterates over each row in Sales and sums the product of Quantity and UnitPrice, producing total revenue.
- Question 10Single Choice
Which endpoint allows external tools such as Tabular Editor to directly manage semantic models in Microsoft Fabric for deployment and scripting?
- AXMLA endpointCorrect answer
- BT-SQL endpoint
- CREST API endpoint
- DOData endpoint
Why this is the answer
The XMLA endpoint exposes semantic models to tools like Tabular Editor and SQL Server Management Studio for management and scripting.
Maintain a data analytics solution
11 questions in this domain
- Question 11Single Choice
What is the main reason to monitor query performance in a Microsoft Fabric analytics solution?
- ATo keep reports within performance targetsCorrect answer
- BTo replace all semantic models daily
- CTo delete inactive workspaces automatically
- DTo create new data sources on demand
Why this is the answer
Monitoring query performance keeps reports within expected speed limits and helps detect issues before users are affected. It is a core maintenance activity.
- Question 12Multiple Select
Which two tasks are considered routine maintenance of a data analytics solution in Microsoft Fabric?
- ARefresh semantic modelsCorrect answer
- BMonitor pipeline runsCorrect answer
- CDesign workspace logos
- DUpdate email signatures
Why this is the answer
Routine maintenance includes refreshing semantic models and monitoring pipeline runs so data stays current and operational problems are detected early.
- Question 13Interactive
Review the code block. What maintenance information does this query return from the Fabric lakehouse?
- ATables ordered by recent refresh timeCorrect answer
- BTables with no refresh history
- CTables with failed refresh jobs
- DTables requiring permission changes
Why this is the answer
The query orders tables by last_refresh, so the returned list shows which lakehouse tables were refreshed most recently during the maintenance window.
- Question 14Single Choice
In a Microsoft Fabric analytics solution, which component must be scheduled to keep a semantic model up to date?
- ASemantic model refreshCorrect answer
- BWorkspace snapshot
- CGateway restart
- DReport theme update
Why this is the answer
A semantic model refresh is the scheduled process that loads updated data from sources into the model for reports to use.
- Question 15Multiple Select
Which two checks should be completed before deploying a Fabric data analytics solution to production?
- AValidate in a test workspaceCorrect answer
- BCheck item dependenciesCorrect answer
- CDelete all audit logs
- DDisable workspace monitoring
Why this is the answer
Validating in a test workspace and checking item dependencies reduces the risk of production failures caused by incomplete or incompatible deployments.
- Question 16Interactive
Review the code block. Which Fabric data pipeline maintenance problem does this query specifically identify?
- APipelines with the highest number of failuresCorrect answer
- BPipelines that ran successfully
- CPipelines waiting for available data
- DPipelines with missing dependencies
Why this is the answer
The query counts failed pipeline runs and orders them by failure count, making it easy to identify the pipelines that need the most maintenance attention.
- Question 17Single Choice
What is the purpose of an on-premises data gateway in a Microsoft Fabric analytics solution?
- ASecures refresh from on-premises sourcesCorrect answer
- BCreates visualizations automatically
- CStores semantic model backups
- DReplaces the data warehouse
Why this is the answer
An on-premises data gateway securely transfers data between on-premises sources and cloud services so scheduled refreshes work correctly.
- Question 18Multiple Select
Which two items are reviewed during a typical scheduled maintenance check of a Fabric workspace?
- AConnection credentialsCorrect answer
- BRefresh schedulesCorrect answer
- CWorkspace theme colors
- DDashboard background image
Why this is the answer
Connection credentials and refresh schedules are common maintenance checks because expired credentials or broken schedules will stop data from being refreshed.
- Question 19Interactive
Review the code block. Which lakehouse maintenance task is being performed on the data tables?
- ARefreshes a table and checks its row countCorrect answer
- BDeletes a table from the lakehouse
- CCreates a new semantic model
- DChanges table permissions
Why this is the answer
The code refreshes the silver.sales table and then displays its row count, confirming the refresh completed and produced data.
- Question 20Single Choice
In a Microsoft Fabric environment, which feature should you use to promote items between development, test, and production?
- ADeployment pipelinesCorrect answer
- BPower Query Online
- CDataflow Gen2
- DMicrosoft Copilot
Why this is the answer
Deployment pipelines promote Fabric items between workspaces, allowing you to manage changes from development to test to production.
- Question 21Multiple Select
In a Microsoft Fabric analytics solution, which two outcomes can be expected after a successful semantic model refresh?
- AReport visuals show updated dataCorrect answer
- BThe model contains current source dataCorrect answer
- CAll workspace users are recreated
- DStorage accounts are removed
Why this is the answer
A successful semantic model refresh loads current source data into the model and allows report visuals to display updated values.
Prepare data
20 questions in this domain
- Question 22Single Choice
What is the primary purpose of OneLake in Microsoft Fabric?
- ACentral file storage for all Fabric dataCorrect answer
- BA visualization tool for reports
- CA compute engine for data transformations
- DA security service for external users
Why this is the answer
OneLake is the central storage layer in Microsoft Fabric, which stores all data items in one unified location.
- Question 23Multiple Select
Which tools in Microsoft Fabric can be used to transform data during preparation? Select all that apply.
- ADataflow Gen2Correct answer
- BNotebookCorrect answer
- CData pipelineCorrect answer
- DPower BI Report
Why this is the answer
Dataflows, notebooks, and pipelines support data transformation; reports are used for visualization, not transformation.
- Question 24Interactive
Review the code block. What is the purpose of this code?
- ARead a CSV file into a DataFrameCorrect answer
- BWrite a DataFrame to a database
- CDelete a file from OneLake
- DInstall a Python library
Why this is the answer
The code uses Spark to load a CSV file into a DataFrame, which is a common first step in data preparation.
- Question 25Single Choice
What is the main use of the Monitoring Hub in Microsoft Fabric?
- AMonitor and troubleshoot Fabric activityCorrect answer
- BDesign data models
- CManage workspace permissions
- DCreate Power BI reports
Why this is the answer
The Monitoring Hub provides a centralized view of activity, including pipeline runs and refreshes, for monitoring and troubleshooting.
- Question 26Multiple Select
Which checks are part of validating data during preparation? Select all that apply.
- ACompare row countsCorrect answer
- BValidate data typesCorrect answer
- CCheck for missing valuesCorrect answer
- DCreate color themes
Why this is the answer
Data validation includes verifying row counts, data types, and missing values, not visual design tasks.
- Question 27Interactive
Review the code block. What does this query return?
- AOne row per group with an aggregated totalCorrect answer
- BAll detail rows without aggregation
- COnly duplicate rows
- DAn error because SUM is invalid
Why this is the answer
The query groups records by category and returns the sum of amounts for each category.
- Question 28Single Choice
What is the typical environment sequence in a Fabric deployment pipeline?
- ADevelopment, Test, ProductionCorrect answer
- BProduction, Test, Development
- CTest, Production, Development
- DDevelopment, Production, Test
Why this is the answer
Fabric deployment pipelines usually move content from Development to Test to Production.
- Question 29Multiple Select
Which actions help maintain a prepared data solution in Fabric? Select all that apply.
- ASchedule data refreshCorrect answer
- BMonitor gateway connectionsCorrect answer
- CUse Git integration for source controlCorrect answer
- DRemove all existing tables
Why this is the answer
Scheduling, monitoring, and source controlling changes maintain the solution; deleting tables is not a maintenance best practice.
- Question 30Interactive
Review the code block. What effect does this command have on the DataFrame?
- ARemoves rows with missing valuesCorrect answer
- BFills missing values with zero
- CRenames the columns
- DSorts rows by index
Why this is the answer
dropna() removes rows that contain missing values, a common cleaning step.
- Question 31Single Choice
What is a OneLake shortcut in Microsoft Fabric?
- APointer to data stored in another locationCorrect answer
- BCopy of all data in every workspace
- CBackup of the Power BI service
- DFabric reporting view
Why this is the answer
A shortcut references external data without copying it, keeping the source in place.
- Question 32Multiple Select
What are benefits of using shared semantic models? Select all that apply.
- AConsistent data definitionsCorrect answer
- BReduced duplication of logicCorrect answer
- CSingle source of truthCorrect answer
- DIncreased storage cost
Why this is the answer
Shared semantic models unify definitions, reduce duplicate logic, and create a single source of truth.
- Question 33Interactive
Review the code block. What is this statement doing?
- AChanging data in an existing rowCorrect answer
- BCreating a new table
- CDeleting a column
- DInserting multiple rows
Why this is the answer
The UPDATE statement modifies data in existing rows; here it changes the status of product 5.
- Question 34Single Choice
Where should you check first after a Dataflow Gen2 refresh fails?
- AMonitoring HubCorrect answer
- BPower BI report view
- COneLake file explorer
- DFabric app designer
Why this is the answer
The Monitoring Hub shows refresh history and failure details for dataflows, pipelines, and other Fabric items.
- Question 35Multiple Select
Which components are commonly part of a Fabric data preparation pipeline? Select all that apply.
- ADataflow Gen2Correct answer
- BNotebooksCorrect answer
- CPipelinesCorrect answer
- DDashboards
Why this is the answer
Data preparation in Fabric uses dataflows, notebooks, and pipelines; dashboards do not prepare data.
- Question 36Interactive
Review the code block. What value does this query return?
- AThe number of rows in the tableCorrect answer
- BThe total sales amount
- CThe average order value
- DThe number of unique customers
Why this is the answer
COUNT(*) returns the number of rows in the sales table.
- Question 37Single Choice
In Microsoft Fabric, which item stores data files in Delta format?
- ALakehouseCorrect answer
- BDashboard
- CReport
- DDataflow
Why this is the answer
A Lakehouse stores files, including Delta tables, in OneLake for analytical workloads.
- Question 38Multiple Select
Which activities are included when maintaining an analytics solution? Select all that apply.
- AMonitoring refreshesCorrect answer
- BUpdating data source credentialsCorrect answer
- CValidating data qualityCorrect answer
- DDesigning the app logo
Why this is the answer
Refresh monitoring, credential updates, and data quality validation are maintenance activities; logo design is not.
- Question 39Interactive
Review the code block. Which statements correctly describe this command? Select all that apply.
- AIt refreshes cached table metadataCorrect answer
- BIt is useful after underlying data changesCorrect answer
- CIt permanently deletes the table
- DIt creates a new empty table
Why this is the answer
REFRESH TABLE updates cached metadata, so the table reflects new data; it does not delete or create tables.
- Question 40Single Choice
What is the main purpose of Git integration in Microsoft Fabric?
- AProvide version control and collaborationCorrect answer
- BStore large amounts of raw data
- CRun machine learning models
- DReplace the operating system
Why this is the answer
Git integration allows tracking changes, reviewing history, and collaborating on Fabric items.
- Question 41Multiple Select
What should you monitor to ensure prepared data remains reliable? Select all that apply.
- ARefresh historyCorrect answer
- BEnd-to-end lineageCorrect answer
- CGateway cluster statusCorrect answer
- DReport bookmark usage
Why this is the answer
Refresh history, lineage, and gateway health affect data readiness; bookmark usage does not.
Frequently asked questions
Everything about the Microsoft Fabric Analytics Engineer question bank and how to use it.