Free Microsoft Certified: Power BI Data Analyst Associate (PL-300) Sample Questions

Correct answer: D — Web API

• A. Anonymous authentication is used when the data source is public and does not require any credentials. It does not provide a field or mechanism to input an API key.
• B. Windows authentication uses domain-based credentials (NTLM or Kerberos) from an Active Directory environment. It is not intended for supplying API keys for web-based services.
• C. Basic authentication expects a username and password pair. While some services might allow an API key to be passed in a username or password field, it is not the standard or direct method provided in Power BI for API keys.
• D. The Web API authentication method is specifically designed for services requiring API keys. It provides a dedicated field to enter the key and allows the user to specify the key's application (header or query parameter), making it the correct choice for this scenario.

Correct answers: A, B, C — Create a parameter in Power Query.; Bind the parameter to a column in the Model View.; Change the storage mode to DirectQuery.

• A. Correct. Dynamic M Query Parameters begin with a query parameter created in Power Query (M). This parameter must be defined so it can be referenced within the M code of the source query to filter the data.
• B. Correct. Once the M parameter is created, you must bind it to a specific model column in the Model View (under the Advanced section of column properties). This binding allows slicer or filter selections on that column to pass values directly to the parameter.
• C. Correct. Dynamic M Query Parameters are exclusively supported for DirectQuery sources. Because the current report is in Import mode, you must change the storage mode to DirectQuery to allow Power BI to send filtered queries to the source at runtime.
• D. Incorrect. The 'Allow user to edit parameters' setting in the Power BI service is used for report-level parameters that users can modify in the dataset settings; it is not the mechanism that enables slicer-driven Dynamic M Query Parameters.
• E. Incorrect. What-if parameters are DAX-based and are used for scenario analysis within the report. They cannot be bound to M parameters to modify the source query at the engine level.

Correct answer: C — Right-click the column, select 'Change Type', then 'Using Locale', and select 'English (United Kingdom)'.

• A. Incorrect. Swapping delimiters (hyphens to slashes) does not change the interpretation of the day and month order. Power Query will still use the default locale settings to parse the result, which would lead to the same errors or incorrect dates.
• B. Incorrect. Simply changing the data type to 'Date' without specifying a locale uses the default regional settings (English US). Since the source data is 'DD-MM-YYYY' and the locale expects 'MM/DD/YYYY', values where the day is greater than 12 will result in errors, and others will have the month and day swapped.
• C. Correct. Using 'Change Type' -> 'Using Locale' allows you to specify a culture (such as English (United Kingdom)) that uses the 'DD-MM-YYYY' format. This instructs Power Query to parse the text correctly regardless of your global or system regional settings.
• D. Incorrect. The FORMAT function is a DAX function used for formatting values after they are loaded into the data model. In Power Query, you would use 'Date.FromText' with a culture parameter for manual parsing, but 'Using Locale' is the standard UI-based method.

Correct answer: B — Merge Queries

• A. Append Queries is used to combine multiple tables into a single table by stacking rows on top of each other vertically (similar to a UNION ALL in SQL). It requires identical or similar column structures and does not perform lookups or joins based on specific key columns.
• B. Merge Queries is the Power Query transformation used to join two tables based on a common column (the key), such as ProductID. After merging, you can expand the resulting column to include specific fields like 'Category' from the related table, functioning similarly to a SQL JOIN.
• C. Transpose is used within a single table to flip the orientation, turning rows into columns and columns into rows. It does not facilitate combining data from separate queries based on shared keys.
• D. Pivot Column takes unique values from a column and turns them into multiple new columns while performing an aggregation. This transformation is used for restructuring data within a table, not for performing a lookup or join between two distinct tables.

Correct answer: B — Fill > Down

• A. Replacing nulls with 0 is incorrect in this context as it would set the exchange rate to zero for missing dates. This would distort calculations and fail to meet the requirement of using the previous Friday's rate.
• B. Fill Down in Power Query propagates the last non-null value downward into subsequent null cells. This will effectively carry the previous Friday's exchange rate forward to fill the missing weekend dates, assuming the table is sorted by Date in ascending order.
• C. Fill Up would propagate the next known value (e.g., Monday's rate) backward into the prior null cells (the weekend). This fills the missing dates with future data rather than the previous Friday's rate as required.
• D. Removing empty rows (or rows with null values) would delete the dates for which we need to fill in rates. This would lose the date continuity established by the merge operation and defeat the purpose of generating a continuous list of dates.

Correct answer: A — Distinct and Unique

• A. In the Power Query 'Column Distribution' visual, 'Distinct' identifies the total number of different values in the column, while 'Unique' identifies the count of values that appear exactly once. If the Product_SKU column is truly unique for every row, the 'Distinct' count will equal the 'Unique' count, and both will equal the total number of rows.
• B. Min and Max statistics show the lowest and highest values in a range. While helpful for detecting outliers or range issues, they do not provide information regarding whether values are repeated within the column.
• C. Empty and Error statistics focus on data quality by identifying missing values or calculation failures. They are used for data cleaning but cannot be used to verify if the non-null values are unique.
• D. Count identifies the total number of records, and Average provides the arithmetic mean for numeric data. Neither of these metrics provides insights into the distribution of unique vs. duplicated values.

Correct answer: C — Column Profile

• A. Column Quality displays counts of valid, error, and empty values to assess data completeness and accuracy. It does not provide numerical summary statistics like min, max, average, or standard deviation.
• B. Column Distribution provides a visual histogram-like view showing the frequency of distinct and unique values. While helpful for identifying patterns, it lacks specific summary statistics such as mean or standard deviation.
• C. Column Profile provides a comprehensive, detailed summary for a selected column in Power Query. It includes essential statistical measures such as Minimum, Maximum, Average (Mean), Standard Deviation, and various counts, which are critical for identifying outliers.
• D. The Advanced Editor is used to view, write, or edit the Power Query M code for dataset transformations. It does not display data profiling statistics or column summary information.

Correct answer: B — Remove Top Rows (3), then Use First Row as Headers.

• A. Incorrect. Using the first row as headers initially would incorrectly promote the first metadata row (Report Title) to column headers. Removing top rows afterward would not restore the intended headers from row 4.
• B. Correct. This is the standard sequence in Power Query. Removing the top three metadata rows shifts the actual header row (originally row 4) to the first position in the grid. Applying 'Use First Row as Headers' then correctly promotes these values to column names.
• C. Incorrect. Removing bottom rows and transposing do not address the issue of metadata rows at the beginning of the file. Transposing would swap rows and columns, which is not appropriate for this cleaning task.
• D. Incorrect. While 'Keep Range of Rows' might isolate specific data, it is not the standard or most efficient method for removing leading metadata. The sequence of removing top rows and then promoting headers is the recommended Power BI workflow.

Correct answer: B — Dataset Settings > Parameters

• A. Incorrect. Gateway connection settings are used to manage credentials and data source mappings for an on-premises data gateway. While a parameter's value might be used by a gateway connection, the parameter itself is not configured here.
• B. Correct. According to Microsoft documentation, parameters defined in Power BI Desktop are carried over when the report is published. You can then modify these values in the Power BI service by navigating to the dataset's (now often called semantic model's) settings and expanding the `Parameters` section. This allows you to change data source details without needing to republish the `.pbix` file.
• C. Incorrect. Persistent filters are a report-level setting that saves the state of slicers and filters for users between sessions. This feature affects the report's display and user experience, not the underlying data source connection parameters.
• D. Incorrect. The `Workspace Access` pane is used to manage permissions and assign roles (such as Admin, Member, or Viewer) to users and groups. It controls who can access or edit content within the workspace, not the configuration of dataset parameters.

Correct answer: A — Create a One-to-Many relationship from Product to Sales and a One-to-Many relationship from Product to Returns.

• A. Correct. This approach follows the Star Schema best practice by placing the Product dimension at the center, connected to both the Sales and Returns fact tables via one-to-many relationships. This configuration ensures that filters applied to the Product table (such as Product Name) flow efficiently to both fact tables, allowing for side-by-side analysis of measures without ambiguity.
• B. Incorrect. Direct many-to-many relationships between fact tables on a shared key bypass the dimension table and typically lead to performance issues and incorrect aggregations. Using the Product dimension as a common filter source is the standard and most efficient method.
• C. Incorrect. Merging distinct fact tables into a single table can lead to a complex structure that is difficult to maintain and may lose the semantic distinction between different business processes (sales vs. returns). It can also result in unnecessary data duplication and more complex DAX measures.
• D. Incorrect. Bi-directional relationships are unnecessary in this scenario and can introduce filter ambiguity and performance overhead. Single-direction relationships from the dimension to the fact tables are the recommended approach for clear and efficient filter propagation in Power BI.

Correct answer: B — Add 'Revenue' as a Synonym for the 'Total Sales' measure.

• A. Renaming the measure to 'Revenue' would technically resolve the Q&A issue, but it is disruptive as it changes the data model and can break existing reports or DAX formulas that reference the original name. Using synonyms is the preferred non-breaking method.
• B. Adding 'Revenue' as a synonym for 'Total Sales' in the model properties allows the Power BI Q&A engine to map natural language queries containing the term 'Revenue' to the correct existing measure. This provides flexibility for users without requiring changes to the underlying model structure or names.
• C. A description is used for documentation and tooltips within the report authoring environment. It does not provide the natural language engine with the necessary metadata to map specific search terms to measures in Q&A.
• D. The format string defines how the data is displayed (e.g., as currency, percentages, or decimals). It has no impact on the keyword recognition or natural language processing capabilities of the Q&A feature.

Correct answer: A — Is Hidden

• A. Correct. Toggling the 'Is Hidden' property removes the column from the field list in the Report view, preventing report authors from seeing or using it in visuals. However, the column remains fully functional within the data model for defining relationships and as a reference in DAX calculations.
• B. Incorrect. The 'Is Key' property identifies a column as a unique identifier or part of a relationship key within the model to assist with identity and uniqueness, but it does not control the visibility of the field in client tools or the Report view.
• C. Incorrect. 'Is Nullable' is a data integrity property that determines whether a column can contain null values. It has no impact on whether the column is visible to users in the Report view.
• D. Incorrect. The 'Summarize By' property defines the default aggregation behavior (such as Sum, Count, or Do Not Summarize) for a column when it is used in visuals, but it does not affect its visibility in the field list.

Correct answer: B — Variables (VAR)

• A. Incorrect. CALCULATETABLE is used to modify filter context and return a table. It does not store intermediate results for reuse; repeated use within a measure would still trigger repeated computation and would not address the performance bottleneck described.
• B. Correct. Variables (VAR) in DAX allow you to store the result of an expression and reference it multiple times within a single measure. This improves performance by ensuring the complex calculation is evaluated only once before being passed to the SWITCH statement, rather than being re-evaluated for every branch of the logic.
• C. Incorrect. EARLIER is used to reference an earlier row context during nested iterations (typically in calculated columns). It is not designed to cache or reuse computed values in a measure and has largely been replaced by variables for readability and performance.
• D. Incorrect. USERELATIONSHIP is used to activate a specific inactive relationship for a calculation within CALCULATE. It does not provide a mechanism for storing or reusing intermediate results.

Correct answers: A, B, D — DAX query duration; Visual display duration; DirectQuery duration

• A. Correct. Performance Analyzer captures DAX query duration, which is the time it takes for the engine to execute the DAX queries generated by a visual. This helps identify slow measures or complex calculations that require optimization.
• B. Correct. Performance Analyzer records visual display duration (often grouped under 'Other'). This represents the time required to render the visual on the screen after the data has been retrieved from the source.
• C. Incorrect. Network latency to the Power BI Service is not a metric captured by the Performance Analyzer in Power BI Desktop. The tool focuses on local report execution components like queries, rendering, and processing.
• D. Correct. For reports using DirectQuery mode, the Performance Analyzer explicitly captures DirectQuery duration—the time spent sending requests to and receiving data from the external data source.
• E. Incorrect. Model refresh time (ETL/Power Query processing) is not measured by the Performance Analyzer. Performance Analyzer is designed to track interactive report performance and visual load times, while refresh performance is typically tracked via refresh history in the Power BI Service.

Correct answer: C — Round the column in Power Query to 1 decimal place to increase the repetition of values for better compression.

• A. Changing the format string only affects the visual presentation layer. The underlying data remains stored at full precision (high cardinality), which does not improve storage or performance.
• B. While rounding is correct, creating a calculated column in DAX adds to the model's storage and processing overhead. It is best practice to perform data transformations as far upstream as possible (in Power Query or the source).
• C. Rounding in Power Query reduces the number of unique values (cardinality) before the data is loaded into the model. This increases the repetition of values, allowing the VertiPaq engine to compress the data more efficiently, which reduces model size and improves performance.
• D. Converting numeric data to Text is generally inefficient for storage and prevents users from performing standard numeric aggregations (like Average or Sum) on the temperature data.

Correct answer: B — CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date]))

• A. Incorrect. PARALLELPERIOD('Date'[Date], -1, MONTH) shifts the date context by one month rather than one year. To achieve a prior year calculation with PARALLELPERIOD, the interval would need to be set to YEAR, and the number of periods to -1.
• B. Correct. The SAMEPERIODLASTYEAR function is a built-in DAX time intelligence function specifically designed to shift the filter context to the set of dates in the previous year that corresponds to the current selection. It is the standard and most concise pattern for year-over-year comparisons when a marked Date table is present.
• C. Incorrect. DATEADD('Date'[Date], 1, YEAR) shifts the filter context forward by one year, which would return the sales for the following year relative to the current context. To calculate the previous year's sales using DATEADD, the interval should be -1.
• D. Incorrect. TOTALYTD computes the cumulative year-to-date total for the current year context. It does not perform a temporal shift to compare data against the previous year.

Correct answer: B — CALENDARAUTO

• A. Incorrect. The CALENDAR function returns a table with a single column of dates, but it requires the user to explicitly provide the start and end dates as arguments. It does not automatically detect the range from the model's data.
• B. Correct. CALENDARAUTO scans all date columns in the model (excluding calculated columns and tables) to determine the minimum and maximum dates. It then returns a table with a contiguous range of dates covering those years. You can also provide an optional argument for the fiscal year-end month.
• C. Incorrect. The DATE function is a scalar function that returns a single date value based on year, month, and day integers. It cannot generate a table or automatically determine a range of dates from the model.
• D. Incorrect. GENERATESERIES creates a table of values based on a specified start, end, and increment. While it can be used for dates, it requires explicit boundary values and does not have the native capability to scan the model's data for the date range.

Correct answer: A — True

• A. The statement is true because the DATESYTD function is specifically designed to return a set of dates starting from the beginning of the year up to the last date in the current filter context. When used within CALCULATE to aggregate sales, it effectively calculates the cumulative year-to-date total; since there are typically no sales records beyond the current date, the calculation naturally stops at the last date with data.
• B. The statement is false because the combination of CALCULATE and DATESYTD correctly satisfies the requirement for a year-to-date calculation within the Power BI time intelligence framework, and although it relies on the filter context provided by the Date table, it is the standard method for reaching the cumulative sales goal.

Correct answer: B — KPI Visual

• A. A Card visual is ideal for displaying a single value clearly, but it does not inherently include built-in target comparison, variance calculation, or status indicators (Red/Yellow/Green) to show progress against a goal.
• B. The KPI visual is specifically designed to display a current value (Indicator) against a target (Goal). It displays the distance/variance to the goal and can be configured with visual indicators (color/icons) to represent status, such as Red/Yellow/Green, making it the most appropriate choice for this requirement.
• C. While a Gauge visual can show progress toward a goal and include colored ranges, it is less effective than a KPI visual at providing a concise numeric distance and explicit variance text in a single, compact display.
• D. A Donut chart is used to show parts of a whole or categorical composition. It is not suitable for displaying a single numeric value against a target goal or showing a clear Red/Yellow/Green progress status.

Correct answer: B — Paginated Report

• A. Incorrect. Power BI interactive reports are optimized for on-screen exploration and dynamic visuals. They do not provide the pixel-perfect control over page size, repeated headers/footers, or flow-over pagination required for a multi-page, print-ready document like a 50-page invoice.
• B. Correct. Paginated Reports are specifically designed for pixel-perfect, page-oriented output. They offer explicit control over page size, margins, and repeating headers/footers, making them ideal for multi-page documents. They are created using Power BI Report Builder (RDL) to ensure that tables flow correctly across pages with consistent formatting.
• C. Incorrect. Dashboards provide a single-page, consolidated view of key metrics and visuals for quick monitoring. They are not intended for generating long, paginated documents and lack the layout controls required to produce a 50-page A4 document with consistent headers/footers.
• D. Incorrect. Scorecards (part of Power BI Goals) are used to track progress against key performance indicators (KPIs) and objectives. They are not designed for producing formatted, printable documents or multi-page reports.

Correct answer: B — Line Chart

• A. Incorrect. Stacked Column charts are designed to compare data across categories and show parts of a whole. They do not expose the Forecast option in the Analytics pane; forecasting in Power BI generally requires a continuous time-based axis and a line/area style visual.
• B. Correct. The Line Chart is the standard visual that supports the Forecast feature in the Analytics pane. To use it, you must have a field on a continuous x-axis (such as a date/time field). This allows Power BI to apply built-in exponential smoothing models to predict future values based on historical trends.
• C. Incorrect. A Matrix is a tabular visual used for displaying multi-dimensional data in a grid format. It does not include an Analytics pane with graphical forecasting capabilities, which are reserved for specific trend-based charts.
• D. Incorrect. A Donut Chart (a variation of a pie chart) is used to show categorical proportions and percentages of a whole. It lacks a time-series axis and does not support the Forecast feature in the Analytics pane.

Correct answer: B — Edit Interactions

• A. Sync Slicers is primarily used to synchronize the selection state of slicers across different report pages or within the same report to ensure consistency. It does not provide the granular control needed to make specific visuals ignore a slicer's filtering on the same page.
• B. Edit Interactions allows report authors to control how visuals interact with one another. By selecting the 'Year' slicer and using 'Edit Interactions', you can set the 'Profit by Region' chart to 'None', which ensures it remains static while other visuals, like 'Sales by Region', continue to be filtered.
• C. Drill through is a navigation feature that allows users to move from a summary visual to a separate page that displays detailed information about a specific data point. It is not designed to control filtering interactions between visuals on a single page.
• D. Personalize Visuals is an end-user feature that allows viewers to change the fields, chart types, or formatting of a visual at runtime. It does not control the backend cross-filtering or interaction logic between a slicer and a visual.

Correct answer: B — Data

• A. Incorrect. The 'Display' setting in Power BI Bookmarks controls visual properties such as visibility (the 'eye' icon in the Selection pane), spotlight, and focus mode. Unchecking this would prevent the bookmark from toggling which visuals are visible, but it does not govern slicer or filter states.
• B. Correct. The 'Data' setting in Bookmarks captures the data state, which includes filters, slicers, and the sort order of visuals. By unchecking 'Data', the bookmark will no longer override the user's current filter context (like Year=2023), allowing the user to switch measures (via visibility changes) while keeping their filters intact.
• C. Incorrect. The 'Current Page' (or 'Page') setting determines whether the bookmark forces navigation to the specific page active when the bookmark was created. It does not control whether slicers or filters are reset.
• D. Incorrect. 'All Visuals' and 'Selected Visuals' are scope settings that define which elements on the report page are affected by the bookmark. While choosing 'Selected Visuals' is a best practice for measure swapping, the specific setting that prevents slicer states from being reset is 'Data'.

Correct answer: B — Bookmark Navigator

• A. Incorrect. The Page Navigator is used specifically to navigate between different report pages. It does not leverage bookmark groups to switch views on a single page.
• B. Correct. The Bookmark Navigator is designed specifically to create a navigation experience based on bookmark groups. It automatically generates a set of buttons or tabs that allow users to switch between bookmarks on the same page, significantly reducing the manual effort required for design and maintenance.
• C. Incorrect. A Drill through button is used to navigate to a different report page while passing specific data filters from the source visual. It is not intended for toggling views on the same page via bookmarks.
• D. Incorrect. While a Shape with an Action can be manually configured to trigger a bookmark, it requires manual setup for every individual button and does not automatically update or generate based on bookmark groups like the Bookmark Navigator does.

Correct answer: C — Decomposition Tree

• A. A Matrix visual displays data in a tabular rows-and-columns format and supports drill-down along a predefined hierarchy. However, it is a static hierarchical view and cannot automatically suggest the next dimension to investigate based on the highest or lowest value.
• B. The Key Influencers visual is designed to identify which factors statistically influence a specific metric. While it helps identify drivers, it does not provide the interactive, ad-hoc hierarchical drill-down structure required for this root-cause analysis scenario.
• C. The Decomposition Tree is the correct choice because it is specifically built for ad-hoc exploration and root cause analysis. It allows users to drill down into dimensions in any order and includes 'AI splits' (High Value/Low Value) that automatically suggest the next dimension to expand based on the highest value.
• D. A Treemap visualizes hierarchical proportions using nested rectangles. While it is effective for comparing category sizes relative to the whole, it does not offer the interactive, order-agnostic drill-down capability or the automated dimension suggestions found in a Decomposition Tree.

Correct answer: B — Smart Narrative

• A. While a Text Box with the 'Value' feature allows you to insert dynamic data points using natural language, it requires manual configuration of the surrounding text. It does not automatically generate a comprehensive narrative or descriptive summary of trends and insights across the dataset in the same way the Smart Narrative visual does.
• B. The Smart Narrative visual is specifically designed to provide automated, AI-driven textual summaries of data. It highlights key insights and trends and updates dynamically in real-time as users interact with or filter the report, making it the ideal choice for generating narrative descriptions on the page.
• C. The Q&A visual allows users to ask questions using natural language to produce specific charts or values. However, it is an interactive query tool intended for exploratory analysis rather than a persistent, automatically updating narrative summary of trends.
• D. A Multi-row Card is used to display multiple data fields or measures in a concise, structured format. While it updates based on filters, it only displays raw values or calculations and does not provide explanatory text or natural language insights.

Correct answer: B — Use the 'fx' (conditional formatting) button next to the Value field and select a measure.

• A. Typing a static number in the Value field creates a fixed reference line that does not respond to slicer or filter changes. It will remain at that specific value regardless of user interaction, making it unsuitable for dynamic requirements.
• B. Using the 'fx' (conditional formatting/expression-based formatting) button next to the Value field allows the reference line to be driven by a DAX measure. Since measures respond to the current filter context (such as slicer selections), the Constant Line will update dynamically to reflect the correct value for the selected Region.
• C. This is incorrect. A Trend Line is used to visualize general progression or regression over a continuous axis (like a timeline). Constant Lines are the correct tool for specific reference values, and Power BI specifically allows them to be dynamic through the 'fx' feature.
• D. Adding a measure to the Tooltips field well only displays the value when a user hovers over data points. It does not generate a visual reference line or any persistent marker across the chart's axis.

Correct answer: B — No, RLS is not applied to users with Edit permissions (Admin, Member, Contributor) on the workspace.

• A. Incorrect. RLS is not applied universally regardless of the workspace role. Users assigned to roles that allow for editing the workspace content (Admin, Member, and Contributor) can bypass Row-Level Security.
• B. Correct. In Power BI, users with Admin, Member, or Contributor roles in a workspace have edit permissions on the semantic model (dataset) by default. Power BI assumes that if you can edit the dataset, you should have access to all its data; therefore, RLS is not enforced for these roles. RLS is only applied to users with the 'Viewer' role or those accessing the report through an App.
• C. Incorrect. While adding a user to an RLS role is the standard way to restrict data for consumers, workspace-level edit permissions (like Contributor) override RLS role membership. Even if a Contributor is added to an RLS role, they will still see all the data.
• D. Incorrect. This is a fictitious setting. There is no 'Enforce RLS for internal users' toggle in Power BI; enforcement is strictly determined by the user's workspace role and dataset permissions.

Correct answer: A — [Region] = LOOKUPVALUE(Security[Region], Security[UserEmail], USERPRINCIPALNAME())

• A. Correct. When no physical relationship exists between tables, the LOOKUPVALUE function can be used to retrieve a value from a secondary table (Security) based on a criteria (USERPRINCIPALNAME()). Comparing Sales[Region] to this looked-up value effectively enforces Row-Level Security without a model relationship.
• B. Incorrect. The RELATED function requires an existing many-to-one relationship between the current table and the related table. Since the scenario specifies there is no physical relationship, this function will fail or return blank.
• C. Incorrect. USERELATIONSHIP is used inside CALCULATE to activate an existing inactive relationship for a specific measure. It is not a boolean filter predicate suitable for RLS definitions and still requires a defined relationship in the data model.
• D. Incorrect. This is a static filter that restricts the table to a literal value ('All'). It does not reference the Security table or the dynamic identity of the user, failing to meet the requirement for region-based security.

Correct answer: A — True

• A. The statement is true because the 'Contributor' role in Power BI allows users to create, edit, and delete content (such as reports and dashboards) and publish reports within a workspace, but it does not grant permissions to manage workspace membership or add other users, which is restricted to the Admin and Member roles.
• B. The statement is false because the 'Contributor' role correctly fulfills all the requirements of the scenario, providing the necessary content creation and editing permissions while maintaining the security constraint of preventing user management.

Correct answer: B — Card

• A. Matrix visuals display data in a grid format with rows and columns. They are multi-value visuals and are not supported for Power BI data alerts, which require tiles that show a single aggregated numeric value.
• B. Card visuals display a single data point or aggregated numeric value prominently. In Power BI, data alerts are specifically supported on Cards, KPIs, and Gauges, allowing you to trigger email or in-app notifications based on threshold conditions (such as revenue dropping below a specific value).
• C. Line charts are used to visualize trends over time and contain multiple data points. Because they are not single-value tiles, they do not support the data alert feature.
• D. Stacked bar charts are used for categorical comparisons and display multiple data points. Like other multi-value visuals, they are not compatible with Power BI data alerts.

Correct answer: B — Power BI Premium capacity workspace; Standard Gateway.

• A. Incorrect. Power BI Pro is limited to a maximum of 8 scheduled refreshes per day. A 30-minute refresh interval requires 48 refreshes per day, which exceeds the Pro limit.
• B. Correct. Power BI Premium capacity (and Premium Per User) supports up to 48 scheduled refreshes per day, which allows for the required 30-minute interval. The Standard (Enterprise) on-premises data gateway is the professional choice for connecting shared team workspaces to on-premises data sources like PostgreSQL.
• C. Incorrect. Power BI Pro does not support the necessary refresh frequency. Furthermore, the Personal Gateway is intended for individual use and is not suitable for supporting team-based reports or shared workspaces.
• D. Incorrect. While Premium capacity supports the 30-minute refresh frequency, the Personal Gateway is not recommended for production environments or team-based scenarios; the Standard Gateway is required for enterprise-grade connectivity.

Correct answer: B — A QR Code for the report page from the Power BI Service.

• A. Incorrect. A Barcode column in the dataset is used to tag data so that scanning a product's barcode filters a report. It is not used to generate a scannable code that navigates the user to a specific report page.
• B. Correct. Power BI Service can generate a QR code for a specific report or report page. When scanned by a mobile device using the Power BI app or a camera, it acts as a deep link that opens the specific report page immediately.
• C. Incorrect. While a shortened URL can link to a report, it requires manual entry or a third-party QR generator. Power BI's native QR code feature is the standard and most efficient way to provide scannable access in physical locations.
• D. Incorrect. Subscription emails are used for scheduled delivery of report snapshots to a user's inbox; they cannot be scanned from a physical location to open a report page.

Correct answer: B — False

• A. The statement is false because 'Publish to Web' generates a public URL that bypasses all Power BI authentication. Since Row-Level Security (RLS) relies on identifying the specific user to apply the appropriate data filters, it cannot be enforced when authentication is removed.
• B. The statement is true because 'Publish to Web' is designed for publicly accessible data and does not support Row-Level Security (RLS). To securely share a report with external users while maintaining RLS, you must use authenticated sharing methods such as Azure AD B2B guest access or Power BI Embedded.

Correct answer: A — True

• A. The statement is true because Row-Level Security (RLS) is only enforced for users with read-only access. By adding external users to the 'Viewer' role in a workspace or providing access via a Power BI App, you ensure they do not have edit permissions (which are granted to Admin, Member, or Contributor roles), thus triggering the enforcement of RLS. Provided the external users are also assigned to the RLS roles in the dataset security settings, this is the correct method for sharing.
• B. The statement is false because simply granting report access via the 'Viewer' role or an App audience is only one part of the process. To successfully apply RLS to external users, they must first be added to the organization's tenant as guest users (Azure AD B2B), and then they must be explicitly mapped to the security roles defined within the Power BI Service's dataset security settings.