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

Q1. You import a CSV file into Power BI, and a column containing dates such as 31/12/2026 is interpreted incorrectly because the source uses a different regional format. What should you do in Power Query?

1. Convert the date column to Boolean.
2. Change the data type by using the appropriate locale.
3. Hide the date column.
4. Create a bookmark for each date format.

Correct Answer: 2. Change the data type by using the appropriate locale.

Explanation: Power Query allows you to change a column’s data type while specifying a locale. This is important when source data uses regional formats that differ from the environment in which Power BI is running. For example, 31/12/2026 follows a day/month/year pattern and may be interpreted incorrectly under a month/day/year locale. Using Change Type with Locale ensures the values are parsed according to the expected regional convention. Hiding the column does not fix incorrect dates, Boolean is an unsuitable type, and bookmarks have no role in data conversion. Correct date interpretation should be handled during data preparation.

Q2. You need to combine two customer tables whose customer names are similar but not always identical, such as “Contoso Ltd” and “Contoso Limited.” Which Power Query capability should you consider?

1. Fill Down
2. Transpose
3. Unpivot Columns
4. Fuzzy matching when merging queries

Correct Answer: 4. Fuzzy matching when merging queries

Explanation: Fuzzy matching can be used when merging Power Query tables where text values are similar but do not match exactly. It can identify likely matches based on textual similarity, making it useful for customer names, company names, addresses, and other inconsistent descriptive fields. Because fuzzy matching can produce incorrect matches, the results should be reviewed and configured with appropriate similarity thresholds and transformation tables when necessary. Fill Down propagates existing values, Transpose exchanges rows and columns, and Unpivot reshapes columns into rows. Fuzzy merging is specifically designed for approximate text matching between datasets.

Q3. You need to categorize each sales transaction as “Large” when Amount is at least 5,000 and “Regular” otherwise during data preparation. Which Power Query feature is appropriate?

1. Conditional Column
2. Column Distribution
3. Query Dependencies
4. Data Source Settings

Correct Answer: 1. Conditional Column

Explanation: A Conditional Column lets you create a new field in Power Query based on one or more logical rules. In this scenario, the rule can test whether Amount is greater than or equal to 5,000 and return “Large”; otherwise, it can return “Regular.” This transformation occurs before the data is loaded into the semantic model. Column Distribution profiles the values in a column, Query Dependencies shows relationships among queries, and Data Source Settings controls connections and credentials. A Conditional Column is appropriate when the classification represents a stable row-level data-preparation rule that should be stored with the imported data.

Q4. You are troubleshooting a slow Power Query refresh and need detailed information about the operations performed by the query engine during evaluation. Which capability should you use?

1. Report page tooltips
2. Manage Roles
3. Query Diagnostics
4. Personal bookmarks

Correct Answer: 3. Query Diagnostics

Explanation: Query Diagnostics helps investigate Power Query performance by capturing information about query evaluation, data-source operations, and transformation execution. It can be useful when identifying expensive steps or understanding why a query takes longer than expected. Report tooltips affect the reporting experience, Manage Roles configures row-level security, and personal bookmarks store report-consumption states. Query Diagnostics is specifically aimed at understanding data-preparation behavior. Combined with awareness of query folding and source-system performance, it can help analysts identify inefficient transformations and determine whether changes should be made to Power Query logic or the underlying source.

Q5. You need a report visual that shows the distribution of customers across numeric income ranges. You want Power BI to group the continuous income values automatically into intervals. What should you create?

1. A geographic hierarchy.
2. Numeric bins.
3. A drillthrough filter.
4. A sensitivity label.

Correct Answer: 2. Numeric bins.

Explanation: Binning groups continuous numeric values into ranges that can be used as categories in visuals. For example, customer income values can be grouped into ranges such as 0–25,000, 25,001–50,000, and so on. This makes it easier to understand distributions rather than displaying every individual income value. Geographic hierarchies are designed for location data, drillthrough filters support navigation to detail pages, and sensitivity labels classify information. Binning is particularly useful for histogram-style analysis involving age, income, transaction size, quantity, duration, and other continuously varying numeric fields.

Q6. You have an imported semantic model containing a very large table. A column stores timestamps down to the millisecond, but reports only need dates. What should you do to improve compression where appropriate?

1. Add another millisecond column.
2. Convert every timestamp into text.
3. Keep the full precision regardless of requirements.
4. Reduce the column’s granularity to the required date level.

Correct Answer: 4. Reduce the column’s granularity to the required date level.

Explanation: High-cardinality columns usually compress less efficiently than columns with fewer distinct values. A timestamp containing millisecond precision can generate an enormous number of unique values. If the business only needs date-level analysis, reducing the granularity to a date can significantly reduce cardinality and potentially improve model compression and performance. The transformation should be based on confirmed reporting requirements because removing time detail is irreversible in the loaded model. Converting timestamps to text does not solve the underlying cardinality problem, while retaining unnecessary precision wastes storage. Model design should preserve only the detail required for analysis.

Q7. You need to create a DAX measure that returns a value from one of several measures depending on a user-selected scenario called Actual, Plan, or Forecast. Which function is particularly suitable for the branching logic?

1. SWITCH
2. COUNTROWS
3. PATH
4. EARLIER

Correct Answer: 1. SWITCH

Explanation: SWITCH is useful when a DAX expression needs to return different results based on one of several possible selections or conditions. Combined with a slicer-driven selection, it can return measures such as [Actual], [Plan], or [Forecast] according to the user’s choice. SWITCH is usually more readable than deeply nested IF statements when several alternatives exist. COUNTROWS counts rows, PATH works with parent-child hierarchies, and EARLIER is associated with nested row-context calculations. Scenario-driven reporting is a common use case for SWITCH, especially when paired with SELECTEDVALUE to retrieve the current slicer selection.

Q8. Your semantic model includes two tables that should filter each other in both directions for a specific analytical requirement. Before enabling bidirectional filtering, what should you evaluate carefully?

1. Whether every column is formatted as text.
2. Whether the report contains a card visual.
3. Whether bidirectional filtering could create ambiguous filter paths.
4. Whether all measures use SUM.

Correct Answer: 3. Whether bidirectional filtering could create ambiguous filter paths.

Explanation: Bidirectional cross-filtering can be useful in certain scenarios, but it can introduce ambiguous filter paths when multiple relationship routes exist between tables. Ambiguity can produce confusing results and make the model more difficult to understand and maintain. Single-direction filtering from dimensions to facts is generally a safer default in star-schema models. Bidirectional relationships should therefore be enabled intentionally and only when the analytical requirement justifies them. Column formatting, visual type, and use of SUM do not determine whether bidirectional filtering is appropriate. Relationship design should prioritize predictable filter propagation and model clarity.

Q9. You are creating a map report and have a column containing five-digit US postal codes. Some codes begin with zero. How should the field generally be treated?

1. As a numeric field that is always summed.
2. As text with an appropriate geographic data category.
3. As a percentage.
4. As a date hierarchy.

Correct Answer: 2. As text with an appropriate geographic data category.

Explanation: Postal codes are identifiers rather than quantities, and treating them as numbers can remove leading zeros or cause inappropriate aggregation. Storing them as text preserves their exact representation. Applying the appropriate geographic data category also helps Power BI interpret the field correctly in mapping scenarios. A postal code such as 02108 must retain its leading zero, which may be lost if interpreted numerically. Percentages and date hierarchies are unrelated to geographic identifiers. Correctly configuring identifier fields improves both data quality and mapping accuracy.

Q10. You want to compare a measure with its value from exactly one quarter earlier. Which DAX time-intelligence function can shift the date context by a specified number of quarters?

1. DATEADD
2. CONCATENATEX
3. GENERATE
4. ISBLANK

Correct Answer: 1. DATEADD

Explanation: DATEADD shifts the current date context forward or backward by a specified number of intervals, including days, months, quarters, or years. To compare a measure with the previous quarter, DATEADD can shift the relevant date set by negative one quarter inside CALCULATE. The model should use a suitable Date table to support consistent time-intelligence calculations. CONCATENATEX combines text values from rows, GENERATE works with table expressions, and ISBLANK tests whether an expression returns blank. DATEADD is therefore well suited to flexible prior-period comparisons based on a defined time interval.

Q11. You publish a report that uses a cloud-based source supported directly by the Power BI service. Scheduled refresh fails because the authentication token has expired. What should you review first?

1. Visual interactions.
2. Data source credentials.
3. Mobile layout.
4. Report page size.

Correct Answer: 2. Data source credentials.

Explanation: When scheduled refresh fails because authentication has expired or become invalid, the data source credentials in the Power BI service should be reviewed. Credentials may need to be updated or reauthenticated depending on the source and authentication method. Visual interactions, mobile layouts, and page size affect report presentation rather than source authentication. While an on-premises gateway may be required for certain local sources, many supported cloud sources can be refreshed directly after valid credentials are configured. Refresh troubleshooting should therefore include checking authentication, permissions, connection settings, and any relevant gateway configuration.

Q12. A company wants a report page to show a customer list only when a user has selected exactly one region. Otherwise, the visual should display a message asking the user to make a selection. Which DAX technique can support this behavior?

1. Use SUM on Region.
2. Use RELATED only.
3. Use PATHLENGTH.
4. Use HASONEVALUE or SELECTEDVALUE in conditional logic.

Correct Answer: 4. Use HASONEVALUE or SELECTEDVALUE in conditional logic.

Explanation: HASONEVALUE can determine whether exactly one value exists for a specified column in the current filter context. SELECTEDVALUE can similarly retrieve the single selected value or return an alternate result when multiple or no values are selected. These functions can be incorporated into conditional measures that return data only after the user selects exactly one region. SUM is inappropriate for a categorical field, RELATED retrieves values through relationships in row context, and PATHLENGTH works with parent-child hierarchies. Selection-aware DAX is useful for controlling report behavior and providing users with clearer guidance.

Q13. You are designing a semantic model where an Account dimension is normalized into separate Account, Account Category, and Account Group tables. For simpler reporting, you want to reduce the number of dimension tables. What should you consider?

1. Denormalizing related dimension attributes into a single dimension where appropriate.
2. Creating additional snowflake levels.
3. Removing all dimension relationships.
4. Converting all dimensions to fact tables.

Correct Answer: 1. Denormalizing related dimension attributes into a single dimension where appropriate.

Explanation: Power BI models often benefit from star-schema designs with relatively denormalized dimensions. Combining related descriptive attributes such as Account, Category, and Group into one Account dimension can simplify relationships, improve usability, and reduce the complexity of filter propagation. Highly normalized dimension structures are often described as snowflake schemas and may be appropriate in some cases, but they can make self-service reporting harder to understand. Removing relationships or treating dimensions as facts would be incorrect. The modeling decision should balance source-system structure against the needs of an efficient, intuitive analytical model.

Q14. You need to show sales for each category alongside the category’s percentage of the report total, and users should be able to use the measure in many visuals. Where should you implement the calculation?

1. Only as manual text in a visual title.
2. As a reusable DAX measure in the semantic model.
3. As a report bookmark.
4. As a Power Query sorting operation.

Correct Answer: 2. As a reusable DAX measure in the semantic model.

Explanation: A percentage-of-total calculation that needs to be reused across visuals should generally be implemented as a DAX measure in the semantic model. Measures respond dynamically to filter context and can be used consistently across charts, matrices, cards, and other report elements. Manual text does not calculate values, bookmarks store report states, and Power Query sorting does not perform dynamic report calculations. A reusable measure also centralizes the business definition so that the same calculation logic is applied consistently wherever the metric appears.

Q15. Users need to identify the lowest-performing product within each selected category. Which DAX iterator can rank products based on a measure?

1. DISTINCTCOUNT
2. RELATED
3. RANKX
4. CALENDAR

Correct Answer: 3. RANKX

Explanation: RANKX evaluates a ranking expression across a table and returns the rank of each item. It can be used to rank products according to measures such as Sales, Profit, Margin, or Units Sold within the current filter context. The ranking direction can be configured so that the lowest-performing product receives the desired rank. DISTINCTCOUNT counts unique values, RELATED retrieves a value from a related table, and CALENDAR generates a date table. RANKX is the appropriate DAX function when users need dynamic ranking that responds to report selections.

Q16. You want report consumers to focus on a specific visual by temporarily expanding it to occupy more screen space without leaving the report page. Which user capability can help?

1. Query folding.
2. Spotlight or focus mode.
3. Data source privacy.
4. Deployment pipelines.

Correct Answer: 2. Spotlight or focus mode.

Explanation: Focus mode allows users to enlarge a visual so it can be examined in greater detail, while spotlighting can emphasize one visual relative to others on the report page. These capabilities help users concentrate on a particular chart without requiring the report author to create a separate page. Query folding concerns data transformations, privacy settings govern source combination, and deployment pipelines manage content lifecycle across environments. Report-consumption features such as focus mode can improve usability when a visual contains dense information that benefits from additional viewing space.

Q17. Your model contains a measure that must return BLANK() when there are no matching sales rows instead of displaying zero. Which DAX function can explicitly test for a blank result?

1. ISBLANK
2. UNION
3. TOPN
4. CROSSJOIN

Correct Answer: 1. ISBLANK

Explanation: ISBLANK checks whether an expression evaluates to BLANK(). It can be used inside IF or other conditional logic to control how measures behave when no value is available. This is useful because blank and zero can have different business meanings; zero may indicate an actual measured value, while blank may mean no applicable data exists. UNION combines tables, TOPN returns a specified number of rows based on ranking, and CROSSJOIN produces combinations of rows from tables. ISBLANK is specifically intended for testing whether a DAX expression has returned a blank value.

Q18. You need to identify the ten customers with the highest sales and then perform an additional calculation over only those customers in DAX. Which table function is designed to return a specified number of highest-ranked rows?

1. CALENDAR
2. TOPN
3. PATH
4. SUBSTITUTE

Correct Answer: 2. TOPN

Explanation: TOPN returns a specified number of rows from a table based on an ordering expression. For example, it can return the ten customers with the highest [Total Sales], after which another iterator or table calculation can operate over that result. This is useful for more advanced DAX calculations that require a ranked subset rather than simply applying a visual-level Top N filter. CALENDAR creates date tables, PATH works with parent-child hierarchies, and SUBSTITUTE replaces text. TOPN is therefore the appropriate function for producing a ranked table expression.

Q19. You need to create a standalone Date table that starts on January 1, 2024 and ends on December 31, 2027. Which DAX function can directly generate the date rows between those boundaries?

1. FORMAT
2. NETWORKDAYS
3. CALENDAR
4. COUNT

Correct Answer: 3. CALENDAR

Explanation: CALENDAR creates a single-column table containing a continuous sequence of dates between a specified start date and end date. The resulting table can be enhanced with calculated columns for year, quarter, month, weekday, and other useful date attributes. FORMAT changes how values are represented, COUNT counts nonblank values, and NETWORKDAYS is concerned with working-day calculations rather than generating a complete date dimension. A dedicated date table is an important modeling component for many time-intelligence scenarios and provides a consistent date structure across the semantic model.

Q20. A report uses a custom sort order for product size values: Small, Medium, Large, and Extra Large. Alphabetical sorting produces the wrong sequence. What should you do?

1. Use a visual tooltip.
2. Convert all sizes to measures.
3. Apply row-level security.
4. Create a numeric sort-order column and use Sort by Column.

Correct Answer: 4. Create a numeric sort-order column and use Sort by Column.

Explanation: Text categories are normally sorted alphabetically unless Power BI is given another sorting field. Creating a numeric sort-order column, such as Small = 1, Medium = 2, Large = 3, and Extra Large = 4, allows the Size column to be configured with Sort by Column. This produces the intended business ordering consistently across supported visuals. Tooltips do not affect sorting, measures are not necessary for category ordering, and row-level security controls access rather than display sequence. Custom sorting is useful whenever categories have a logical order that differs from alphabetical sorting.