View Full ServiceNow CIS-ITSM Exam Dumps and Practice Test Dumps.

Q1. A Power BI measure occasionally returns BLANK() when no sales exist for the selected period. The business wants the measure to display 0 instead. Which DAX function is most appropriate?

1. PATH
2. TOPN
3. USERELATIONSHIP
4. COALESCE

Correct Answer: 4. COALESCE

Explanation: COALESCE returns the first expression that does not evaluate to BLANK(). For example, COALESCE([Total Sales], 0) returns the Total Sales value when one exists and returns zero when the measure evaluates to BLANK(). This makes it useful for controlling how missing results appear in reports without changing the underlying data. PATH is used for parent-child hierarchies, TOPN returns ranked rows, and USERELATIONSHIP activates an inactive relationship during a calculation. COALESCE provides a concise way to substitute a fallback value for blank results in DAX measures.

Q2. A worksheet contains five introductory rows containing report titles and notes before the actual column headers begin. What should you do in Power Query before promoting the headers?

1. Remove the top five rows.
2. Pivot the first five rows.
3. Create five calculated columns.
4. Apply conditional formatting.

Correct Answer: 1. Remove the top five rows.

Explanation: If non-data rows appear before the actual headers, they should be removed before promoting the correct row to column headers. Power Query provides Remove Top Rows specifically for this type of cleanup. After removing the five introductory rows, the first remaining row can be promoted to headers. Pivoting would restructure data rather than eliminate unwanted metadata, calculated columns are created after loading and do not solve the source structure, and conditional formatting is a report presentation feature. Cleaning unnecessary title and note rows early helps create a properly structured tabular dataset.

Q3. A report includes a text field containing values such as “NY”, “CA”, and “TX”. You want Power BI to interpret these values as U.S. states when they are used in maps. What should you configure?

1. Default summarization as Sum.
2. A numeric bin.
3. The State or Province data category.
4. A parent-child hierarchy.

Correct Answer: 3. The State or Province data category.

Explanation: Data categories help Power BI understand the semantic meaning of fields. Assigning the State or Province category tells Power BI that abbreviations such as NY, CA, and TX represent geographic regions rather than arbitrary text. This can improve geocoding behavior in supported map visuals. Summing state abbreviations is meaningless, numeric bins apply to quantitative fields, and parent-child hierarchies address organizational or similar structures. Geographic fields should also include additional context such as country when ambiguity is possible to further improve mapping accuracy.

Q4. You have a table containing daily exchange rates. Each date should return only one applicable rate. Which model characteristic is most important for the Date column if the table is placed on the one side of a relationship?

1. The Date values should be formatted as text.
2. The Date values should be unique.
3. Every Date should appear at least twice.
4. The table should have bidirectional filtering enabled.

Correct Answer: 2. The Date values should be unique.

Explanation: A column on the one side of a one-to-many relationship must contain unique key values. If the exchange-rate table is intended to have one applicable record per date, the Date column must not contain duplicate dates unless another key is introduced to distinguish records. Formatting dates as text does not enforce uniqueness. Repeating each date would prevent the column from acting as a unique relationship key, while bidirectional filtering is unrelated to key uniqueness. Good relationship design depends on correctly identifying the grain and keys of each table.

Q5. You want users to display values in thousands, millions, or full units based on a slicer selection without changing the underlying data. Which approach is most appropriate?

1. Delete the original measure and create three separate reports.
2. Convert the numeric data into text in Power Query.
3. Add a separate fact table for every display unit.
4. Use a parameter-driven DAX measure or calculation logic.

Correct Answer: 4. Use a parameter-driven DAX measure or calculation logic.

Explanation: A disconnected parameter table can let users select a display scale such as Units, Thousands, or Millions. DAX can retrieve the selected value and divide the underlying measure appropriately while preserving the original data. This approach is flexible and keeps the semantic model centralized. Converting numbers to text would reduce analytical functionality, creating additional fact tables would introduce unnecessary duplication, and maintaining separate reports for each unit would increase maintenance. Parameter-driven measures are well suited to user-controlled display and scenario behavior in Power BI reports.

Q6. You need to remove rows in Power Query where the CustomerName field is null before loading the data. Which action is most appropriate?

1. Create a report-level filter after publishing.
2. Filter the CustomerName column to exclude null values.
3. Hide CustomerName from the model.
4. Create a bookmark with null values hidden.

Correct Answer: 2. Filter the CustomerName column to exclude null values.

Explanation: If rows with null CustomerName values are not valid for the analytical model, filtering them out in Power Query prevents those rows from being loaded at all. This improves data quality and may reduce model size. A report-level filter only changes what is displayed and does not remove the rows from the semantic model. Hiding the column affects report authoring but not the underlying records. Bookmarks save report states and are not a data-cleaning mechanism. Invalid records should generally be handled during data preparation whenever the business rule is clear.

Q7. You need a DAX measure that counts how many products have sales greater than 100,000 within the current report context. Which approach is most suitable?

1. Use COUNTROWS over a FILTER expression that evaluates product sales.
2. Use FORMAT on the sales measure.
3. Use CONCATENATE on ProductID.
4. Use DATEADD on the Product table.

Correct Answer: 1. Use COUNTROWS over a FILTER expression that evaluates product sales.

Explanation: FILTER can create a virtual table containing only products whose sales meet the specified threshold, while COUNTROWS can count the rows remaining in that filtered table. This combination is useful for measures that need to count entities based on an aggregated condition. FORMAT changes display representation, CONCATENATE joins text, and DATEADD modifies date context. Using FILTER together with COUNTROWS allows the calculation to respond dynamically to existing slicers and report filters while applying the additional sales threshold condition.

Q8. A report page contains 20 visuals and is slow to render. Performance Analyzer shows that several visuals execute nearly identical expensive DAX queries. What should you consider first?

1. Add more visuals to distribute the calculations.
2. Increase the number of high-cardinality columns.
3. Simplify the report and optimize the measures used by the slow visuals.
4. Convert all dimensions to bidirectional relationships.

Correct Answer: 3. Simplify the report and optimize the measures used by the slow visuals.

Explanation: A page containing many visuals can trigger many queries whenever filters change or the page loads. If Performance Analyzer identifies expensive DAX queries, the report author should evaluate whether all visuals are necessary and optimize the underlying measures and model. Adding more visuals increases workload, while high-cardinality columns can make the model larger. Enabling bidirectional relationships indiscriminately can introduce complexity and performance problems. Report performance is usually improved through a combination of efficient DAX, a well-designed model, sensible visual counts, and reduced unnecessary interactions.

Q9. A fact table contains OrderDate, ShipDate, and ReturnDate. You want separate slicers for all three date roles that can be used independently at the same time. Which modeling approach is often clearest?

1. Use one active relationship and no other date fields.
2. Create separate role-playing date dimensions for the three date roles.
3. Convert each date into text.
4. Combine all three dates into one column.

Correct Answer: 2. Create separate role-playing date dimensions for the three date roles.

Explanation: Separate role-playing date dimensions can provide independent filtering for Order Date, Ship Date, and Return Date. Each dimension can have an active relationship with the corresponding fact-table date column, allowing users to use separate slicers simultaneously without relying on inactive relationships in every calculation. Another valid design in some cases is one Date table with inactive relationships and USERELATIONSHIP measures, but that approach does not provide independent active slicer roles as directly. Role-playing dimensions make each business meaning explicit and can improve report authoring clarity.

Q10. A table contains customer satisfaction scores from 1 to 10. You need to show how many responses were received for each score. Which visual is generally suitable?

1. Gauge
2. KPI
3. Map
4. Column chart

Correct Answer: 4. Column chart

Explanation: A column chart is effective for comparing counts across discrete categories such as satisfaction scores from 1 through 10. Each score can appear on the horizontal axis, while the number of responses appears as the column height. This makes the distribution easy to interpret. A Gauge focuses on progress toward a target, a KPI emphasizes performance against a goal or trend, and a Map requires geographic information. Column charts are well suited to frequency comparisons across a manageable set of ordered or categorical values.

Q11. You need to create a table containing unique combinations of CustomerID and ProductID from a transaction table. Which Power Query approach is straightforward?

1. Keep only CustomerID and ProductID, then remove duplicate rows.
2. Convert both columns to measures.
3. Create a report tooltip.
4. Apply conditional formatting to both fields.

Correct Answer: 1. Keep only CustomerID and ProductID, then remove duplicate rows.

Explanation: Keeping only the two required columns and removing duplicates produces one row for each unique CustomerID-ProductID combination. This is useful when building an association or bridge-style table from transactional data. Measures cannot serve as row-level relationship keys, tooltips only affect report interaction, and conditional formatting changes appearance rather than table structure. Creating distinct key combinations during data preparation is often clearer and more efficient than loading unnecessary transaction attributes into a relationship table.

Q12. A report must show the number of days between an order date and a delivery date for each transaction. Which Power Query operation could calculate this before loading?

1. Append Queries.
2. Subtract the two date columns and return a duration or day count.
3. Pivot both date columns.
4. Enable row-level security.

Correct Answer: 2. Subtract the two date columns and return a duration or day count.

Explanation: Power Query can calculate the difference between two date or date/time values, producing a duration from which the number of days can be extracted. If delivery duration is a stable row-level attribute required throughout the model, calculating it during data preparation can be appropriate. Appending combines rows from tables, Pivot restructures data, and row-level security controls access after modeling. Whether to perform the calculation in Power Query or DAX depends on the requirement, but a fixed transaction-level duration can often be efficiently prepared before loading.

Q13. You want a visual to show the proportion of total sales contributed by four business divisions while also displaying the exact sales amount for each division. Which visual can support a straightforward part-to-whole comparison?

1. Scatter chart.
2. Gauge.
3. Pie or donut chart.
4. Waterfall chart.

Correct Answer: 3. Pie or donut chart.

Explanation: Pie and donut charts are designed for part-to-whole comparisons when the number of categories is small. With four business divisions, the slices can communicate relative contribution while data labels can show exact values or percentages. A Scatter chart examines relationships between numeric variables, a Gauge compares a single metric against a target, and a Waterfall chart explains sequential increases and decreases. Pie and donut visuals should generally be avoided when there are too many categories because differences become difficult to compare, but four divisions is a manageable use case.

Q14. An analyst needs to create a percentage measure that remains unaffected by filters on Customer but still responds to Date and Product filters. Which DAX capability is central to the solution?

1. FORMAT.
2. CALCULATE with targeted filter removal.
3. PATHITEM.
4. CONCATENATEX.

Correct Answer: 2. CALCULATE with targeted filter removal.

Explanation: CALCULATE allows an expression to be evaluated under a modified filter context. By using REMOVEFILTERS or a similar filter-modification function specifically on the Customer table, the measure can ignore customer selections while preserving filters coming from Date, Product, or other dimensions. FORMAT affects display text, PATHITEM works with parent-child paths, and CONCATENATEX concatenates row values. Fine-grained filter-context control is fundamental to many advanced DAX patterns, including percentages, benchmarks, comparisons, and calculations that intentionally ignore particular dimensions.

Q15. Your organization wants to monitor whether report refreshes are succeeding and investigate failures in the Power BI service. What should you review?

1. Refresh history for the semantic model.
2. The visual’s tab order.
3. The report theme.
4. Field parameter settings.

Correct Answer: 1. Refresh history for the semantic model.

Explanation: Refresh history provides information about previous refresh attempts, including whether they succeeded or failed and, when available, details about errors. It is an important place to start when troubleshooting scheduled-refresh problems in the Power BI service. Tab order relates to accessibility, report themes control visual styling, and field parameters enable dynamic field selection. Refresh issues may ultimately require checking credentials, gateway availability, query errors, or source permissions, but reviewing refresh history provides a clear starting point for understanding when and how the failure occurred.

Q16. A report page contains multiple bookmarks used to switch between a chart view and a table view. You want to provide users with automatically generated controls for those bookmarks. Which feature should you use?

1. Sync slicers.
2. Data alert.
3. Bookmark navigator.
4. Query Diagnostics.

Correct Answer: 3. Bookmark navigator

Explanation: A Bookmark navigator automatically creates buttons tied to bookmarks in the report. This provides users with a clean interface for switching between saved report states such as chart view, table view, or alternate layouts. Because the navigator is connected to the bookmark collection, it is generally easier to maintain than manually configuring individual buttons. Sync slicers maintains selections across pages, data alerts notify users about supported metric thresholds, and Query Diagnostics investigates Power Query execution. Bookmark navigators are specifically intended to expose bookmark-based navigation in a user-friendly way.

Q17. You have a text column containing values such as “A-100”, “A-200”, and “B-100”. You need a new column containing only the first character. Which Power Query operation is appropriate?

1. Group By.
2. Pivot Column.
3. Fill Up.
4. Extract First Characters.

Correct Answer: 4. Extract First Characters

Explanation: Power Query provides text extraction transformations that can return a specified number of characters from the beginning of a text value. Extracting the first character from values such as A-100 or B-100 produces A or B, which can then be used as a category or code prefix. Group By aggregates rows, Pivot restructures data, and Fill Up propagates values from later rows into earlier blank rows. Text extraction operations are useful when source systems store multiple pieces of information inside structured codes.

Q18. A report contains several measures that users commonly compare. You want to organize these measures so report authors can find them more easily in the Fields pane. What should you use?

1. Display folders.
2. Data alerts.
3. Geographic data categories.
4. Incremental refresh.

Correct Answer: 1. Display folders

Explanation: Display folders organize measures, columns, and hierarchies into logical groups within the model’s field list. For example, measures can be grouped into folders such as Revenue, Profitability, Customer Metrics, and Time Intelligence. This improves the authoring experience without altering calculations or data. Data alerts notify users when supported thresholds are reached, geographic categories describe location fields, and incremental refresh optimizes refresh processing. Display folders are particularly valuable in models containing many measures because they make semantic content easier to discover and maintain.

Q19. You need to compare two numeric measures that have very different units but should appear on the same chart over time. Which visual feature can help keep both series readable?

1. A second fact table.
2. A secondary axis in a combo chart.
3. Row-level security.
4. Query parameters.

Correct Answer: 2. A secondary axis in a combo chart.

Explanation: A combo chart can display one measure using columns and another using a line, while a secondary axis allows measures with different units or scales to remain readable. For example, Revenue can be shown in millions on one axis and Conversion Rate as a percentage on another. Adding a fact table does not solve the visual scaling problem, while row-level security and query parameters serve different purposes. Secondary axes should be labeled clearly because using two scales can confuse users if the visual design does not make the distinction obvious.

Q20. You need to create a calculated value that evaluates an expression for each row of a table and returns the smallest result. Which DAX iterator should you use?

1. SUMX
2. COUNTX
3. MINX
4. CONCATENATEX

Correct Answer: 3. MINX

Explanation: MINX iterates over a table, evaluates an expression for each row, and returns the smallest resulting value. It is useful when the minimum must be determined from a derived expression rather than directly from an existing column. SUMX sums row-level results, COUNTX counts evaluated nonblank results, and CONCATENATEX combines text values from rows. Iterator functions are particularly helpful when calculations require row-by-row evaluation before aggregation. MINX provides the correct behavior when the requirement is to identify the lowest value produced by a row-level expression.