Free PL-300 practice test: 30 questions with answers

Products is the one side and Sales is the many side, so filters should flow from Products to Sales. Many-to-many and one-to-one do not match this grain, and bidirectional filtering is not needed in a standard star schema.

REMOVEFILTERS clears the filters on the named table only. VALUES and KEEPFILTERS keep the Region filter in place, and SUMX iterates rows without removing the existing context.

Single direction filters from the one side to the many side. Both propagates filters in reverse, which can create ambiguity, and making the relationship inactive removes it from calculations entirely.

Calculated columns are evaluated per row and stored in the model, so they can be used on slicers and axes. Measures are computed at query time and cannot be slicer fields, and what-if parameters create a disconnected scenario table.

Only one relationship between two tables is active at a time, so USERELATIONSHIP activates the inactive ShipDate relationship for that measure. Changing direction does not switch the key, a duplicate table causes ambiguity, and RELATED does not change the filter path.

RLS roles are DAX filters on model tables, and View as role in Desktop tests them locally. Viewers are filtered by RLS, and RLS is enforced on the model rather than on individual report pages.

DirectQuery sends queries to the source at report time without importing the data. Import loads data into the model, Dual caches tables for composite models, and a live connection points to an external model rather than tables in this file.

TOTALYTD is the time-intelligence function that applies a year-to-date filter to a measure. PARALLELPERIOD and SAMEPERIODLASTYEAR return shifted date sets, and DATESBETWEEN returns a table rather than a total.

The Forecast option in the Analytics pane extends a line chart's series into future periods. A scatter trend line is a fitted line, a decomposition tree breaks down a measure, and key influencers ranks factors rather than forecasting.

Performance Analyzer shows which visuals are slow, and fewer visuals and fields mean fewer queries. Auto date/time adds hidden tables, while cross-highlighting and extra slicers add interaction queries.

Alt text gives a text description of a visual for screen readers. Tooltips appear on hover, bookmarks store view states, and header titles are not the description read by assistive technology.

The Between style lets users choose a start and end date. A relative date slicer filters to periods such as last 30 days, while list and hierarchy slicers select discrete values rather than a date range.

A scatter chart plots each item by its two values, which makes correlation visible. Area charts show accumulation, funnels show sequential stages, and treemaps show part-to-whole sizes, not the relationship between two measures.

Drillthrough pages open from a right-click and carry the selected customer as a filter. Tooltip pages appear on hover, bookmarks store view states, and sync slicers keep one selection aligned across pages.

Conditional formatting can take its colour from a measure, so cells update as the data changes. A theme sets static styling, a visual filter removes rows, and data alerts apply to dashboard tiles rather than table cells.

Find anomalies is an Analytics pane option for line charts that marks unusual points. A median line is a plain reference line, key influencers ranks contributing factors, and smart narrative writes a text summary.

Viewing Pro content requires a per-user license and access to the content through sharing or a workspace role. Exporting to PDF, DirectQuery storage mode and publish to web do not grant or define that access.

Contributors can create and edit content but cannot publish an app, which Members and Admins can do. Viewers have read-only access, and Admins have more management rights than the request needs.

The Production stage is the one published to end users. Development and Test hold content for building and checking changes before promotion, and quality assurance is not a deployment pipeline stage.

The on-premises data gateway lets the cloud service reach on-premises sources for scheduled refresh. Desktop files are not refreshed by the service, dataflows still need a gateway for on-premises data, and Analysis Services is a separate model server.

An app packages reports and dashboards for consumers with read-only access. An emailed file needs Desktop, a dataset alone has no visuals, and an image export loses interactivity.

Deployment pipelines promote content through development, test and production stages and show differences between them. PDF export creates static files, publish to web creates a public embed, and dataflows prepare data rather than manage releases.

Scheduled refresh uses stored data source credentials, and incremental refresh policies limit how much data is reloaded. The service does not edit table definitions in a PBIX, workspace roles are managed separately, and it does not export whole datasets as CSV.

Change Type with Locale tells Power Query how to parse day-first text. Date/Time/Timezone adds a time component and zone, and Number.From returns a number, so neither fixes the parsing.

Left Anti returns rows from the first query that have no match in the second. Left Outer keeps matched products too, Inner keeps only matches, and Full Outer keeps everything from both sides.

Folding pushes work to the database, and steps that break folding belong after the foldable ones. Table.Buffer forces full in-memory loading, calculated tables duplicate data, and turning off report refresh stops the query from updating.

Unpivot other columns keeps the product column and turns the month columns into attribute and value rows. Pivot does the opposite, Transpose swaps rows and columns, and splitting by delimiter does not reshape the table.

Removing the separator or setting the right locale lets Power Query convert the text to a number. Pivoting reshapes rows, a date type cannot hold an amount, and removing the column loses the data.

A folder source with Combine Files builds a sample-file function that applies the same steps to every file. Append stacks queries that already exist, merge joins columns across tables, and a blank query starts empty.

Text.Split returns a list of strings using a delimiter. Text.Combine joins a list into one string, Text.Length returns a count of characters, and Text.Upper changes case.