Fabric Analytics Engineer Associate Practice Test

These questions are part of the practice quiz. Start practicing

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