Fabric Analytics Engineer Associate Practice Test

These questions are part of the practice quiz. Start practicing

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