Question 150 A software vendor must preserve the ability to reuse a shared license invoices model while publishing a new report, not duplicate its data under a second imported semantic model. What is the appropriate publication approach? Build the report from the existing shared semantic model and publish the report item Export the model to separate CSV tables for each report Force all consumers to use raw SQL directly Duplicate the entire semantic model for each page Explanation Correct Answer A:Connecting to the shared license invoices model preserves central DAX definitions, relationships and governance across multiple reports. Incorrect Answers B:CSV exports create redundant copies and lose the central model lifecycle. C:Raw SQL access bypasses the curated semantic definitions and governance. D:Duplicating the model per page fragments refresh and measure consistency.
Question 151 An analyst has three report pages. A Region slicer should apply the same selection across all pages but be visible only on the landing page. How should Sync slicers be configured? Make the slicer visible on all pages but disable Sync Enable Sync for all three pages and Visible only for the landing page Create unrelated Region columns on each page with different mappings Place Region selection in a data-source password field Explanation Correct Answer B:Visibility and synchronization are independent controls; a hidden synchronized slicer still affects its page. Incorrect Answers A:Visibility without Sync permits the three pages to diverge. C:Unrelated fields cannot reliably propagate one shared selection. D:Credentials do not store report filter selections.
Question 152 A billing model needs a persistent Band label for every invoice based on its individual NetFee at refresh time. The label will be used as a slicer category. Which calculation should be created? A single aggregation measure returning one total NetFee for the current selection A report bookmark with a label but no fact-level category A calculated column or Power Query column assigning Band for each invoice row A filter on an unrelated lookup with no InvoiceID relationship Explanation Correct Answer C:A row-level calculated column yields values that can group invoices in a slicer. Incorrect Answers A:A total measure cannot create a stored label for each invoice record. B:Bookmarks store UI state, not per-row band assignments. D:An unrelated lookup cannot categorize invoices without correct keys.
Question 153 A dashboard Card shows TotalWorkHours as 15472.875. Executives want the same numeric measure formatted as 15.5K, without changing its stored value for other visuals. What should the author adjust? Round and overwrite all source work-hour rows Convert the underlying DAX measure into a text category with no numeric semantics Use display-units and decimal-place formatting for the Card Delete the source column and use a static image Explanation Correct Answer C:Display units abbreviate a numeric value in the Card without modifying model data. Incorrect Answers A:Changing source rows would discard precision needed in other reports. B:Converting the measure to text breaks numeric reuse. D:A static image would not respond to report filters.
Question 154 A wholesale order table reports a total of 450 currency units across 15 shipped pieces. The DAX measure is DIVIDE(SUM(Fact[Revenue]), SUM(Fact[Units])). What is its result? 465, the sum of revenue and units 30 currency units per shipped piece 450 currency units, without dividing by pieces 15, the count of pieces only Explanation Correct Answer B:DIVIDE(450,15) equals 30, the aggregate revenue per actual shipped unit. Incorrect Answers A:Adding measurements with incompatible units is not a rate calculation. C:450 is total revenue and overstates the per-unit metric. D:15 is the denominator, not the requested average selling value.
Question 155 An API response has one Order object containing an Items array with three records, each with Sku and Quantity. The analyst needs one row per ordered item while retaining OrderID. What Power Query operation order fits? Convert the entire array into one unstructured report caption Pivot OrderID into a separate column for every item Discard Items and retain only OrderID Expand the Items list to rows, then expand each item record into Sku and Quantity fields Explanation Correct Answer D:Expanding the list creates one record per item before expanding nested record fields into columns. Incorrect Answers A:A caption loses the item-level table structure. B:Pivoting the identifier does not enumerate array records. C:Dropping Items removes all SKU and quantity details.
Question 156 An analyst loads invoice totals with fractional cents from a calculation. Financial reconciliation requires decimal arithmetic rather than binary floating approximation. Which numeric type should be evaluated? True/False Date/Time inferred from the invoice amount Fixed Decimal Number (Currency), with explicit scaling/rounding rules Any text string representing a formatted currency symbol Explanation Correct Answer C:Fixed Decimal Number provides scaled decimal storage suited to currency-like values when precision is defined. Incorrect Answers A:A Boolean cannot encode invoice amounts. B:Calendar types represent timestamps, not financial magnitudes. D:Text cannot support reliable arithmetic aggregations without conversion.
Question 157 A telecom provider discovers that users with Viewer-only app access can see a column containing personal identifiers in a monthly charges table visual. Simply hiding the field in Desktop was proposed as a remedy. Which approach is appropriate? Change column text color to white Rename the report to Internal Enforce a proper data-access or transformation-level control so the sensitive column is not exposed Hide the column in the Fields pane only Explanation Correct Answer C:Field visibility is not data security; actual model/source controls or removal of the field are needed to prevent disclosure. Incorrect Answers A:White text is still present in export and can be revealed. B:A title conveys intention but is not a permission or data-protection mechanism. D:Hiding a field from authors does not secure accessible underlying data.
Question 158 A lender chooses DirectQuery because personally identifying loan rows must stay in a controlled SQL source. The team assumes that each report reader’s SQL permissions will automatically apply, but the connection uses one stored service account. What configuration risk should the analyst recognize? Without a supported SSO identity-passing design, source queries can run using the configured connection identity rather than each viewer’s account DirectQuery always creates an editable full local copy of every loan row before querying SQL An RLS role must be deleted because DirectQuery cannot filter model rows A report color theme determines SQL user identity for each query Explanation Correct Answer A:Stored credentials can be shared for queries unless the architecture is configured for appropriate supported SSO/impersonation; data authorization must be designed explicitly. Incorrect Answers B:DirectQuery does not by default store a full Import replica of the source table. C:Semantic-model RLS is available in supported DirectQuery scenarios and might be needed along with source security. D:Visual themes never influence authentication or identity propagation at the database.
Question 159 A monthly line of SubscriptionValue for a subscription company shows a clear seasonal pattern and leadership wants to estimate future periods with uncertainty bands. What Power BI analytic capability should the analyst try on an eligible time-series visual? An average reference line at the historic mean of SubscriptionValue Only a regression trend line without a configured future forecast horizon Merge-as-new on fact and dimension Forecasting with its appropriate confidence interval Explanation Correct Answer D:Forecasting estimates future SubscriptionValue values from the time series and can display confidence/uncertainty ranges. Incorrect Answers A:A fixed historical average can be an analytic baseline but is not a seasonal projection or forecast interval. B:A historical trend line summarizes fitted past direction but does not deliver requested future estimates with uncertainty bands. C:Merging data queries does not fit the requested analytic projection.
Question 160 A maintenance table has rows (TaskID,Status): (T31,Open), (T31,Closed), (T32,Closed), (T33,Open), (T34,Closed). A measure CALCULATE(DISTINCTCOUNT(Fact[TaskID]), Fact[Status] = "Closed") runs with no other filters. What result should it return? 5 because every row is counted regardless of repeated TaskID 4 because all IDs are included despite the Closed filter 3 distinct closed-task IDs: T31, T32 and T34 2 because the Open row for T31 excludes T31 from all other rows Explanation Correct Answer C:The filter keeps closed rows T31, T32 and T34; their distinct count is three even though T31 also has an Open row outside the selected subset. Incorrect Answers A:Five is row count without de-duplicating and without the filter. B:The unfiltered count of four IDs includes open-only T33. D:A task with at least one Closed row remains in the selected Closed rows.
