Question 60 Four Zones members have [Total Consumption] values [69, 55, 80, 46] respectively. Using RANKX(ALL(Dim[Zones]), [Total Consumption], , DESC, DENSE), what is the rank of the member with value 69? 4 2 1 3 Explanation Correct Answer B:Descending totals are [80, 69, 55, 46], making 69 position 2. Incorrect Answers A:Rank 4 belongs to the amount 46, not 69. C:Rank 1 belongs to the amount 80, not 69. D:Rank 3 belongs to the amount 55, not 69.
Question 61 A wholesale distributor needs a stable band label ("Large" or "Small") for each deliveries row based on its own ShipmentWeight at dataset refresh, and wants to use the band as a category axis. Which modeling technique directly adds that per-row attribute? Create a calculated column or Power Query column using the row threshold Create only a DAX measure returning one total for the current visual Change a relationship to both-direction filtering Use a report page bookmark to recategorize records Explanation Correct Answer A:Row-level columns store the band derived from each ShipmentWeight value, so it can be used on axes or slicers. Incorrect Answers B:An aggregate measure has filter-context output but does not materialize a category for each transaction row. C:Relationship direction cannot derive the required per-row threshold band. D:Bookmarks preserve report state; they do not create row-level business fields.
Question 62 A subscription company measures how opening and closing SubscriptionValue totals reconcile through positive new sales, negative refunds, and adjustments. Which visual best displays each increase/decrease as a bridge? Waterfall chart with increase/decrease contributors Pie chart where negatives are separate shares Gauge showing only closing total Map with circles at transaction locations Explanation Correct Answer A:Waterfall bars show the stepwise contribution of increases and decreases to the closing SubscriptionValue total. Incorrect Answers B:A pie does not naturally represent signed movements that bridge a starting to an ending amount. C:A gauge shows a value against a target and cannot explain intermediate drivers. D:A map shows geography, not a numeric reconciliation from opening to closing.
Question 63 An energy utility created a well-reviewed semantic model, and its owner wants colleagues to see an endorsement indicating it is suitable for organizational reuse. The owner cannot grant tenant-level certification approval. What can an authorized content owner typically apply? Promoted endorsement Certified endorsement without an authorized certifier A new row-level security role as an endorsement Changing every field to hidden Explanation Correct Answer A:Promotion marks content as useful for reuse while certification has additional organization-admin authorization requirements. Incorrect Answers B:Certification is controlled by authorized users defined by the tenant and should not be self-assigned without permission. C:RLS limits rows and is unrelated to endorsing model quality. D:Hiding all fields makes a model harder to reuse, not endorsed.
Question 64 An education provider reports directly against its enrollment SQL database using DirectQuery. A page has 18 complex visuals; every student-segment slicer change sends many source queries and user response time is unacceptable. What architectural fact should guide remediation? DirectQuery sends interactions to the source, so simplify visuals/query paths or evaluate aggregations and Import where acceptable DirectQuery stores all rows in VertiPaq and never contacts SQL during interaction Changing to a darker report theme removes SQL round-trips Giving readers Workspace Admin automatically eliminates database load Explanation Correct Answer A:DirectQuery depends on source response and queries can fan out with interactions; query reduction, aggregates or an alternative storage strategy target the cause. Incorrect Answers B:Full dataset caching is characteristic of Import; DirectQuery can issue SQL with each interactive visual query. C:Theme changes do not affect remote source-query volume. D:Workspace roles do not change the query engine’s behavior for visual interactions.
Question 65 A sports league wants a manager to right-click the Arenas member in a summary and navigate to a details page already filtered to that member. Which interaction should be configured? Drillthrough page with the dimension as a drillthrough filter A general URL to an unrelated report home page A normal tooltip with no page navigation A source database credential prompt Explanation Correct Answer A:Drillthrough passes the selected Arenas context to a detail page, enabling focused investigation. Incorrect Answers B:An unrelated URL does not carry the selected Arenas filter context. C:Tooltips show context on hover and are not the requested navigation to a full detail page. D:Credential configuration is unrelated to context-preserving report navigation.
Question 66 A JSON feed for a government agency returns a list of service applications objects, each with an embedded record for Districts. The analyst needs a normal table of rows and expanded fields. What sequence is most appropriate? Create an unrelated date dimension before parsing Convert the list to a table and expand the record fields Pivot the list directly into dates Concatenate the entire JSON document into one text value Explanation Correct Answer B:List-to-table and expand operations expose the repeating service applications objects and nested Districts attributes as columns. Incorrect Answers A:A date dimension cannot decode nested JSON source records. C:Pivot needs a tabular category/value structure; the source is still nested JSON. D:Concatenating JSON loses structured fields needed for data modeling.
Question 67 A factory group records month-end inventory snapshots for three successive months: 131, 86, and 69 units. A quarter-end inventory balance measure returns the last available balance in the period. What is its quarter result? 131 86 69 286 Explanation Correct Answer C:A balance is semi-additive across time; the last snapshot at quarter end is 69, not a sum. Incorrect Answers A:131 is the first month-end balance, not the quarter end. B:86 is the middle snapshot and does not represent quarter-end inventory. D:286 adds three balances observed at different times and double-counts inventory across months.
Question 68 A government agency receives Amount in a text column with valid entries like "12.75" and "8.40". The report must sum the values, not concatenate them or sort them alphabetically. Which data-type change is required? Keep the field as Text and enable summarize Set the field to True/False Convert the field to a calendar Date Set the field to Decimal Number Explanation Correct Answer D:Decimal Number allows correct arithmetic over numeric values of Amount, including fractional values. Incorrect Answers A:Text is not the intended numeric type and cannot reliably provide arithmetic totals. B:Boolean values cannot express a monetary or quantitative decimal amount. C:Date values would reinterpret the source numbers instead of enabling sums.
Question 69 A financial cooperative needs one manager to view a published report but not enumerate, edit or manage all objects in the authors’ workspace. What access strategy minimizes exposure? Make the manager a workspace Admin Give Contributor access to every item Share the underlying source credentials Grant access to the specific shared report or appropriate app audience rather than workspace editing roles Explanation Correct Answer D:Item sharing or app audiences can grant the intended loan disbursements report consumption without broad workspace edit access. Incorrect Answers A:Admin exposes workspace-wide management rights unrelated to report consumption. B:Contributor grants content-edit capabilities beyond the scenario. C:Source credentials bypass the controlled reporting experience and overexpose data access.
Question 70 A food chain imported a single wide store purchases table with a repeated Locations name, address, and region on every event. The repeated text inflates model size. What model change is most appropriate? Create a calculated table for each distinct transaction amount Create a unique Locations dimension and keep store purchases fact columns at event grain Duplicate the full wide table for each visual Turn on every relationship’s Both direction Explanation Correct Answer B:A compact Locations dimension and numeric-grain fact reduce repeated descriptive attributes and support shared slicers. Incorrect Answers A:One calculated table per NetSpend value fragments the data and is not a star-schema fix. C:Duplicating the wide table multiplies redundant attributes and increases the memory burden. D:Filter-direction settings do not remove repeated text values from model storage.
