Fabric Analytics Engineer Associate Practice Test

These questions are part of the practice quiz. Start practicing

• Which feature helps accelerate data exploration and cleansing in Fabric?
• What is the correct sequence to identify the slowest DAX query and compare DAX engine vs storage engine timings?
• For ResearchReviewersGroup1, which workspace role should you assign?
• In Delta Lake, what is the purpose of the VACUUM command?
• You want to merge two Azure SQL tables so the combined table contains all rows from Product and the matching rows from ProductCategory. Which join configuration should you use?
• Which statement best describes Direct Lake mode?
• Which statement best describes a notebook in Fabric?
• In a Python visual within a Microsoft Power BI report, if you want all rows to appear, which change should you apply?
• What is the purpose of a security predicate function in Row-Level Security (RLS)?
• What is the benefit of storing different layers of your lakehouse in separate workspaces?
• Which Power Query transformation generally prevents query folding and should be avoided if you want to preserve folding?
• To enable a Fabric Shortcut to access a firewall-protected Data Lake, which step is essential?
• Which function should be used to rank results without gaps when there are ties in SQL?
• What mode must the Research division semantic models use?
• Which Tabular Editor tool should you use to audit a model for performance or design issues?
• In Microsoft Fabric, item permissions in a workspace are used to grant access to what?
• For a Fabric workspace with a large lakehouse containing historical data and frequent updates, which semantic model storage mode yields best performance for near real-time reporting?
• RANKX( ALL( 'Product'[Product Name] ), [Sales],, DESC, Skip ) describes which ranking behavior?
• When persisting a Spark DataFrame to storage for Delta Lake use, which format should you write in?
• You have a Parquet file named Customers.parquet uploaded to a Fabric lakehouse and you want to load it into a pandas DataFrame using PySpark in a notebook. Which code should you run?
• You want a security role SalesRegionManager to not see the Address column in SalesAddress. Which sequence of steps is correct in Tabular Editor?
• You want to monitor capacity unit consumption in your Fabric data warehouse. What tools should you use?
• For ResearchReviewersGroup2, which workspace role should you assign?
• Which requirement describes how Research division workspaces should be organized to support OneLake data hub filtering based on department name?
• In DAX Studio, which feature should you enable to capture the queries executed by a report?
• Why is indexing important in a data warehouse?
• Which license type is typically sufficient to grant read access to reports without requiring Pro or PPU?
• Which action ensures the destination table matches the external data schema when copying data with a changing schema?
• To group workspaces for certain company divisions that should support OneLake data hub filtering, which pairing of grouping method and tool is correct?
• To create a virtual relationship for filtering across an unrelated table, which DAX function should be used?
• You want to include data in an external Azure Data Lake Store Gen2 location in your lakehouse, without the requirement to copy the data. What should you do?
• What is the primary advantage of using a custom theme in Power BI report development?
• For an RLS-enforced model where reports need fastest performance, where should RLS rules be applied?
• To apply logic-based DAX formatting to a single measure with minimal administrative effort and without modifying other measures, which approach should you use?
• In a Direct Lake semantic model with 500 million rows, which mode will DAX queries use?
• Which architecture best supports creating a relational data store on OneLake with SQL CREATE statements?
• Which engine processes the added custom step in a dataflow?
• Which command would you use to review the history of a Delta Parquet table named FactSales?
• In a star schema, what is the primary purpose of a surrogate key in a dimension table?
• To allow a Power BI bar chart to change its y-axis category using a slicer, which feature should be added?
• Which ranking behavior is associated with the RANK() function when there are ties?
• In numeric data summaries, which option correctly states an additional function included beyond COUNT, MEAN, and STD?
• Which tool can create partitions in the Power BI service without processing them?
• In Tabular Editor 2, to load data to a table without rebuilding hierarchies and relationships and without recalculating calculated columns and measures, which process mode should you use?
• What is the primary language used for querying a data warehouse?
• For optimizing a complex semantic model and reducing the number of joins, which tables should be denormalized?
• Which Power Query function should you use to identify the maximum values for numeric columns when loading a new dataset from OneLake into the warehouse?
• Which tool is specifically designed to verify that data models adhere to established best practices across the organization?
• What is the purpose of item permissions in a Fabric workspace?
• Which tool should you use to determine if query throttling is occurring in a Fabric warehouse?
• Why consider basic data cleansing when loading data into Fabric lakehouse?
• Which measure is most likely to perform best when filtering by a specific calendar year?
• In Dataflows Query Editor connected to an Azure SQL customer table, which option helps identify which column contains non-duplicate values per customer?
• Which function allows you to activate an inactive relationship between Date and ShipDateKey for a calculation?
• In a Copy Data activity, which Destination setting ensures the destination table is replaced with the source data?
• Which solution is most suitable for creating a data store that supports dataflows and ensures delta tables are V-order optimized automatically?
• Which statement best describes Dataflow Gen2 capabilities in Fabric?
• For a Dataflow Gen2 creating a new dimension table that must immediately relate to the central fact table, which schema option should you select in the data destination?
• Which tool should be used to implement calculation groups for the Research division semantic models?
• In the Fabric data pipeline UI, which type of activity supports parameterization (allowing you to pass runtime values)?
• For a survey, how many rows are added to the Response table per question in the survey?
• Which of the following is NOT a stated reason for basic data cleansing when loading into Fabric lakehouse?
• Which option would you use to load data into a Fabric data warehouse via SQL?
• Which of the following DAX expressions correctly activates an inactive Date to ShipDateKey relationship for the Shipped measure?
• Within a Fabric lakehouse environment, where should a data analyst create a shortcut to access data stored in an external Amazon S3 bucket via the SQL endpoint?
• Which DAX function should you use to create a virtual relationship between two tables without a physical relationship?
• What happens when a user is granted a permission and then denied the same permission in a warehouse?
• In Fabric, which statement best describes the relationship between a Data Factory workload and Dataflow Gen2?
• For a report that requires current-year data and table-level security, which authentication method and mode should you choose?
• Which storage options and file formats are supported for COPY when using Transact-SQL in Warehouse?
• What determines the data model size limits on a dataset when large dataset storage format is enabled?
• Which of the following is a valid step to hide a column from a security role in Tabular Editor?
• Which Dataflows Editor option shows distinct values for a column and helps identify non-duplicate entries across customers?
• For determining whether queries are mapped to aggregated data via user-defined aggregations, which single tool is most suitable for profiling queries in a semantic model?
• What is a data pipeline?
• In a calculation group, to switch context to month-to-date (MTD), which DAX expression is correct for the calculation item?
• To limit data in a lakehouse shortcut to CustomerID 100, which step should be taken when creating the shortcut?
• To integrate tables created in Dataverse into Fabric Lakehouse on OneLake and have them show up as valid Shortcut options, what must you do first?
• In the query, which functions should you use for ChargedQuantity and OrderPrice?
• In OneLake security, which permission should you assign to User2 to meet the requirement 'Read all SQL endpoint data'?
• Which general requirement should be followed to minimize privilege exposure?
• Which statement best defines a semantic model in a data warehouse context?
• In the data view for a Power Query dataflow, which option shows the distribution of column values?
• What is the recommended minimum file size when working with external data on files in Microsoft Fabric?
• What tool should Mary-Jo use to ensure all data models adhere to data modeling best practices?
• Which operation should you schedule to combine small Delta Lake files into larger ones?
• Which KQL keyword is used to limit the results of a query to a specified number of rows?
• Which storage mode should the detailed fact table use to enable real-time queries against the source?
• Which statement accurately describes how a Data Factory workflow interacts with a Dataflow Gen2 when loading data into a lakehouse?
• In the described dataflow with two lakehouses, non-folded steps are executed by which engine?
• In a data warehouse, what is the primary purpose of a dimension table?
• What is a Microsoft Fabric Lakehouse?
• Which objective is emphasized when refreshing the Orders table to minimize impact?
• Which statement about Delta tables and optimization is true?
• Which statement best describes the concept of capacity in Fabric?
• If a data source is only available in narrow time windows, which dataflow design best ensures the source is copied as-is and usable for later transformations?
• Given a report where a visual's DAX query takes 27 ms, visuals total 39 ms, and other 1047 ms, what change yields the greatest rendering improvement?
• Which combination of actions should you enable to enable external tools to create Fabric items and access XMLA while following least privilege?
• What is the default storage format for Fabric's OneLake?
• What is the purpose of V-Order and Optimize Write in Delta tables?
• In OneLake security, which permission should you assign to User1 to meet the requirement 'Read all spark data'?
• In a semantic model deployed to Development, Test, and Production, to reduce the size of query requests during full semantic model refreshes in Development or Test, what should you do in the deployment pipeline?
• Which tool can update a measure definition in a large model without refreshing in the Power BI service?
• What feature should be used to connect Dataverse data to Fabric for integration into Lakehouse shortcuts?
• To identify surrogate key columns in a model whose Summarize By is not None, which tool should you use?
• Where in the lakehouse UI should you create a shortcut to access data stored in Amazon S3?
• In a scenario with a very large dataset, which action best reduces rendering time for a report containing many visuals?
• Which function should be used to set PeriodDate to the first day of the month from OrderDate?
• Which tool can help identify memory-heavy columns loaded into memory in a Direct Lake model?
• Which view should you use to identify commonly run commands in your data warehouse?
• What determines the maximum allowed dataset size when large dataset storage format is enabled?
• To perform a one-time ingest of a small local CSV into a Fabric lakehouse with minimal administrative effort, which method is recommended?
• Which DAX pattern optimizes a measure by using a variable and SWITCH for the result?
• To enable T-SQL-based data cleanup in a Fabric Warehouse, which object type is best suited?
• In Power Query, which transformation is known to break query folding when splitting a column either by position or delimiter?
• Which action would you take to reference external Gen2 data in the lakehouse without copying it?
• To allow deployment to Development and Test workspaces only, which access should be granted to those workspaces?
• Which command sequence would correctly delete unreferenced files older than the retention policy for a Delta table?
• In Delta Lake, what does the OPTIMIZE command do?
• What is the recommended approach for bootstrapping the initial load of a large dataset published to the service?
• In the described dataflow scenario, which step generates the two columns OrderDateTime.1 and OrderDateTime.2?
• Which KQL keyword is used to group and aggregate data?
• What is the most efficient approach for data transformation when designing data models for scalability?
• For near-real-time reporting with minimal development effort on a lakehouse with heavy historical data and frequent incremental updates, which storage mode is most suitable?
• In a dataflow, how many transformation steps will fold?
• In a Power BI semantic model using Direct Lake mode, which option describes querying data directly from the lake without importing it?
• What is one of Data Activator's strengths in interoperability with other Fabric experiences?
• To enable a Fabric Shortcut to access an Azure Data Lake Storage Gen2 account behind a firewall, which initial step is required?
• A data pipeline is scheduled to run every four hours on Mondays and Fridays. Which Repeat setting should be chosen?
• You need to connect to and transform data to be loaded into a Fabric lakehouse using Dataflows Gen2. How would you complete this task?
• In DirectQuery mode, which change reduces the number of queries when using filters and slicers?
• Your Fabric Model1 refresh fails due to resource exhaustion. Which statement explains the likely cause?
• To transform data into attribute–value pairs by turning columns into rows, which operation should you apply in a data flow when the VendorID column is selected?
• To restrict access to a column (SSN) so that payroll employees can see it and others cannot, which feature should be used?
• Which language should you use in Dataflow Gen2 to transform data when ingesting from Azure SQL Database into a Lakehouse?
• A data model includes a products table and a sales table. A relationship is created between them. Which cardinality should be set to achieve an optimal model?
• Which tool is commonly used to inspect DAX queries outside the report to diagnose performance issues?
• What is the role of a KQL database in Real-Time Intelligence?
• For a semantic model that must enforce security and reflect current-year data, which authentication method and mode should be used?
• Which activity should you add to Pipeline1 to copy CSV data into Lakehouse1 and support Power Query M expressions?
• In Spark, which statement accurately describes the difference between df.explain() and df.describe() or df.summary()?
• What is a key benefit of using Microsoft Fabric in data projects?
• Which feature should you use to review MLflow's tracking results through a UI?
• What is the main limitation of using XMLA endpoints for the Microsoft Power BI deployment process?
• Which tool should you use to programmatically modify every column whose name ends with "Key" in a semantic model?
• If you need to increase Fabric capacity unit size to resolve a compute issue, which portal should you use?
• Which command would you use to view the query plan for how a Delta table query will be executed?
• What is the primary advantage of Dynamic Data Masking (DDM)?
• To permit a user to truncate tables only within schemaA, which X and Y tokens should be used in the GRANT statement?
• When using a Dataflow Gen2 to transform and append 1000 records daily into a Fabric Lakehouse, which staging setting should you choose?
• In the pricing logic, which ListPrice threshold maps to the 'low' pricing group?
• When optimizing a dataflow that filters a DateTime column to the current year, what sequence improves performance?
• In a Power BI model with no physical relationship between two tables, which DAX function maps values from one table into another to create a virtual relationship?
• If you drop a managed Delta table whose data resides in a folder, what happens to the table and data?
• Which dynamic management view helps identify long-running report requests in a Fabric warehouse?
• In Power BI, what approach minimizes administrative effort when applying the same time intelligence calculations to many measures?
• Which Fabric data store should be used to store data on OneLake and support CREATE TABLE statements?
• Which syntax should you use to read data from a Lakehouse shortcut named ResearchProduct in Lakehouse1?
• In a Type 1 slowly changing dimension, what happens when a non-key attribute changes?
• Which Fabric workload experience lets you create a Dataflow Gen2?
• Which set of permissions correctly assigns access to data engineers, data analysts, and data scientists to satisfy the security requirements?
• When a slicer causes visuals to render slowly, which tool should you use first to troubleshoot?
• If a survey has 5 questions, how many total rows are created across the Survey and Response tables when the survey is submitted?
• What is a primary benefit of denormalizing dimension tables in a semantic model?
• What is the purpose of a fact table in a data warehouse?
• If you want a Power BI semantic model to be reusable by multiple reports without an enterprise data warehouse, which component should you create?
• To minimize data shuffling when joining a large transactions DataFrame with a small customers DataFrame on the customer_id column, which join approach is best?
• What is the fastest refresh interval you can configure for Dataflow Gen2 native refresh scheduler?
• When choosing between filtering on a dimension table versus a fact table, which yields faster performance?
• Which Fabric capacity SKU is appropriate for a dedicated, on-demand capacity with per-minute billing for specialized analytics work?
• To enable incremental refresh, which two parameters should you add to Power Query?
• Partitioning a lakehouse table by CustomerID primarily enables which performance benefit?
• What does the NOT ENFORCED attribute imply when adding a PRIMARY KEY constraint in a database?
• Which statement correctly describes using a Data Factory workload to create a Dataflow Gen2 for transformation before loading into a lakehouse?
• What does setting Available in MDX to False do for a column?
• What is the primary effect of broadcasting a small DataFrame when joining with a large DataFrame in Spark?
• What is the primary benefit of using a calculation group in a data model?
• The date dimension must always contain dates from 2010 through the end of the current year. Which option satisfies this requirement?
• For scenario 1 (create a new version of the row), which Slowly Changing Dimension type is appropriate?
• Which statement best describes a main benefit of Real-Time Intelligence in Fabric?
• What is Dataflow Gen2?
• Which change reduces memory usage by adjusting how DateTime data is stored?
• In a Power BI semantic model, which storage mode should aggregated tables use?
• If you want to forecast monthly expenses, which modeling approach would you use?
• Where should you create a table shortcut when querying lakehouse data stored in S3 via the SQL endpoint?
• What database object type is used to hold the computed results for the pricing group in the example 'ProductsWithPricingGroup'?
• Which of the following statements is true about the ListPrice thresholds mapping to 'low', 'medium', and 'high' PricingGroup?
• In a star schema, which type of table stores measurable events or facts such as totals or counts?
• To display the value breakdown between starting balance and ending balance across customer segments, which visual should you use?
• What are the supported data sources and file formats for the COPY (Transact-SQL) statement in Warehouse?
• What is the recommended approach to ingest data into the bronze layer of the Lakehouse Medallion Architecture to minimize implementation effort?
• If row-level security must filter data based on the viewer's identity using dynamic rules, what should you implement?
• To interactively explore data in a file in the lakehouse using Spark, which option should you use?
• What is the simplest way to analyze data stored as CSV using Spark in Fabric?
• If you only need metadata copied from schema1.city to schema2.city, which statement would you run?
• Which statement best describes the effect of TOP 10 in a SQL query after an ORDER BY clause?
• In a Fabric Spark job reading a CSV with header and selecting specific columns, which statement is true?
• You want to use a pipeline to copy data to a folder with a different name for each run. Which approach should you take?
• Which dynamic management view provides details about SQL commands running in the data warehouse?
• What file format should you use to save a semantic model using the Tabular Model Definition Language extension for Visual Studio Code?
• You have a Fabric workspace and an Azure Data Lake Storage Gen2 account. You want to create a shortcut to storage1 in Lakehouse1. Which connection type and endpoint should you specify?
• Which role should be granted to an administrator who needs to monitor the health of a Fabric capacity, following the principle of least privilege?
• You save a DataFrame to Parquet with partitionBy year, month, and day. Which statement about the resulting files is true?
• Which dynamic management view provides details about SQL commands running in the data warehouse?
• Which tool is best suited for data transformation in Fabric when dealing with large-scale data that will continue to grow?
• In SQL Server, which datepart should be used with DATENAME to return the name of the day of the week?
• Which file format is recommended for data files stored in S3 to enable efficient querying via a SQL endpoint?
• Which statement is true about the COPY statement in Warehouse in terms of supported data sources and file formats?
• A matrix visual renders slowly; after using Performance Analyzer and DAX Studio, the DAX query runs fast in DAX Studio. What should you do next?
• Which statement best describes a typical use of VACUUM in Delta Lake?
• When using Row-Level Security, what is the primary purpose of the security predicate?
• Which Fabric capacity SKU is appropriate for Research division, given requirements for dedicated on-demand capacity and per-minute billing?
• To meet the requirement of a date dimension spanning 2010 through the end of the current year, which method can be used to populate the date dimension table?
• Which Spark DataFrame writer option controls how data is distributed into folders when saving?
• What is the purpose of the ROW_NUMBER() function when used with ORDER BY in a query?
• How can you customize the appearance of a Power BI report?
• In DAX, to specify a fixed date boundary such as 2023-12-01 in a query, which function is used?
• Which statement about the VACUUM operation is accurate?
• What does a custom theme file for Power BI specify to standardize visuals across reports?
• Which statement best describes active vs inactive relationships in a data model?
• Delta Lake stores tables based on which file format?
• You plan to use Data Wrangler to view basic summary statistics for the Customers.parquet data before loading it to a Delta table. Which tool should you use?
• In Power Query Editor, which option shows the percentage of valid records in a column?
• To monitor capacity unit consumption in Fabric data warehouses, which tool should you use?
• Which combination lists the four data ingestion methods for loading data into a Fabric data warehouse?
• Which practice preserves query folding and improves performance in data transformation workflows?
• To ignore spaces when joining data from a database and a lakehouse with minimal development, which approach should you take?
• Which statement best describes projection pushdown when reading a CSV into Spark?
• For scenario 2 (overwrite the existing value in the latest row), which Slowly Changing Dimension type is appropriate?
• Which column statistics should you update to improve query performance when table statistics are out of date?
• To help department teams find data relevant to them, which option supports OneLake filtering by grouping workspaces?
• Where in the Fabric Admin portal can you enable Fabric environments when migrating from Azure Synapse Analytics due to permission issues?
• Which gateway type is suitable when multiple users need to connect to multiple on‑premises data sources?
• For a small daily load of 1000 records via Dataflow Gen2, what is the recommended staging setting?
• Replacing the FILTER function with KEEPFILTERS reduces execution time in which scenario?
• Which expression is used to define the PricingGroup based on ListPrice thresholds?
• A model includes a products table and a table with monthly category targets; each product can belong to multiple categories and each category can have multiple products. Which cardinality should be set?
• In Spark, which function is used to extract the year from a date column?
• Which dynamic management view can help identify memory-heavy columns loaded into memory in a Direct Lake model?
• Which DirectQuery-related best practice is specifically about ensuring data integrity in relationships?
• Which action should you perform to ensure embedded reports require authentication and only read-only (live) connections to cloud semantic models?
• In the Medallion Architecture, which layer contains curated, aggregated data for business reporting?
• What data storage solution located in a Fabric workspace supports access via T-SQL or Python and can store unstructured or semi-structured data?
• Which of the following best practices for Power BI data modeling is relevant only to DirectQuery models?
• In the ingestion and history review, what is the retention policy applied to the lakehouse table mentioned?
• To reduce the size and number of files in a Delta Parquet table with a long version history and a six-month retention policy, which maintenance operation should be run?
• With 1 TB legacy accounting data in Azure Data Lake Gen2 and annual ad-hoc reporting needs, which Fabric architecture and integration approach minimizes admin costs while enabling reporting and analysis?
• In the Medallion Architecture, which layer would you expect to contain raw data?
• To ensure that queries against a Direct Lake semantic model always use Direct Lake mode, where do you configure this setting?
• Which statement about the effect of a DESCRIBE HISTORY query on a Delta table’s maintenance history is correct?
• Why can performing a split by position on a column cause a dataflow to load more data than expected?
• What is true about promotion and certification in Fabric?
• What is Data Activator's capability in real-time data analysis?
• To minimize costs while providing access for 20 report creators and 350 report customers in Fabric, which licensing option would you recommend?
• To ensure that foldable Power Query transformation steps are processed by the Microsoft SQL Server engine during ingestion from Azure SQL, which configuration should you apply?
• You have a historical dataset of monthly expenses and want to forecast next month's values. Which modeling approach is appropriate?
• Which storage mode should dimension tables use to maximize caching and performance for filtering?
• In a star schema for a customer dimension using SCD Type 2, which column is typically added to support versioning of records?
• In Microsoft Fabric, which component is used for integrated data storage and processing?
• Where can you check and enable high concurrency mode for notebooks when working in a Fabric environment?
• When querying a Delta table, which statement about metadata queries indicates maintenance events were recorded?
• What is the benefit of using Fabric notebooks over manual uploads for data ingestion?
• Fabric Domains are primarily used to support which capability?
• A Fabric notebook ingestion process must run daily at 7:00 AM and retry up to two times if source missing; minimal development effort. Which approach meets this?
• In a left join, which statement describes the result of the join?
• Which external tool can show the size of each table and column in a model?
• To ensure each customer's sales data is written to its own Parquet file, which data pipeline configuration should you implement?
• Delta Lake is best described as what in relation to Spark?
• In a DAX query intended for an XMLA endpoint, which sequence of keywords correctly starts the query?
• If you also want to copy the data, which statement would you run?
• Which approach is best for a one-time copy of a small local file into the lakehouse when convenience is prioritized?
• In the SQL example, what are the Ranking values for the first two records?
• To add a primary key constraint to a table as NONCLUSTERED and NOT ENFORCED, which T-SQL statement is correct?
• Which method should be used for a one-time copy of a small local file into the lakehouse when you want to minimize setup?
• What is the purpose of creating a Reflex in Data Activator?
• What is the purpose of Reflex in Data Activator?
• To enable read-write access to a dataset named DS1 via the XMLA endpoint, which setting must be modified first?
• Which statement best describes the effect of Dynamic Data Masking on data storage?
• In Real-Time Intelligence, which statement best describes the KQL database?
• In a left anti join, which describes the result set?
• In a Fabric notebook, which approach profiles the DataFrame with minimal administrative effort?
• You have previously run a pipeline containing multiple activities. What's the best way to check how long each individual activity took to complete?
• To merge Sales with ExceptionRecords in Dataflow Gen2 such that Sales excludes any records found in ExceptionRecords while preserving query folding, which applied steps should you use?
• Incremental refresh for a Fabric OneLake data model fails due to resource constraints. Which statement is correct?
• Which set of layers is typically associated with the Medallion Architecture for data management?
• When diagnosing slow DAX performance, which two elements can you view in Power BI to understand how time is spent?
• To build a Fabric analytical data store that supports a relational schema for SQL queries and stores data on OneLake, which option fits?
• When you create a clone using CREATE TABLE test.FactSales AS CLONE OF Dbo.FactSales, which statement is true?
• In a data model where a single product can appear in many sales records, which cardinality describes the relationship between the product and sales tables?
• In a Fabric survey data model, the third question in each survey response represents what?
• In a Dataflows Query Editor, which option would you select to view the frequency of values and identify duplicates by count per value?
• Which tool accelerates data exploration and cleansing in Fabric?
• Which Fabric UI component would you use to examine MLflow experiments?
• Which operation should you schedule to remove Delta Lake data files that are no longer used?
• What is the purpose of incremental refresh in a large fact-table model?
• To enforce RLS with a dynamic rule that restricts access to sales regions per user, what should you create?
• For consolidating supplier attributes used in claims, which type of table is appropriate?
• Which Fabric workload is used to move and transform data?
• In Microsoft Fabric, what type of capacity do you need to be able to pause and resume, and to scale up and down based on organizational needs?
• In Fabric with Apache Spark, which artifact should you create to explore data interactively?