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

Q1. You are importing a dataset into Power BI and need to determine how many values in a column are distinct versus unique. Which Power Query profiling feature should you use?

1. Column quality
2. Query Diagnostics
3. Column distribution
4. Query Dependencies

Correct Answer: 3. Column distribution

Explanation: Column distribution is a Power Query profiling feature that shows information about distinct and unique values in a column. This can help identify high-cardinality columns, duplicates, and unexpected data patterns before the data is loaded into the semantic model. Column quality focuses on valid, error, and empty values rather than distinctness. Query Diagnostics investigates query execution performance, while Query Dependencies shows how queries reference one another. Understanding column distribution is useful when assessing data quality and model efficiency, especially for columns that may serve as keys or categorical fields.

Q2. You need a DAX measure that returns a custom fallback value when another measure evaluates to BLANK(). Which function is most appropriate?

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

Correct Answer: 1. COALESCE

Explanation: COALESCE returns the first expression that does not evaluate to BLANK(). For example, COALESCE([Profit], 0) returns the Profit measure when it has a value and returns zero otherwise. This makes it useful for improving report readability when blank values should be replaced with a business-friendly fallback. TOPN returns ranked rows, UNION combines compatible table expressions, and PATH works with parent-child hierarchies. COALESCE is concise and often easier to read than an equivalent IF and ISBLANK expression for straightforward blank-replacement scenarios.

Q3. Your model contains a DirectQuery fact table and imported dimension tables. You want to optimize the way dimensions interact with both Import and DirectQuery data. Which storage mode may be appropriate for the shared dimensions?

1. Import only
2. DirectQuery only
3. DirectLake only
4. Dual

Correct Answer: 4. Dual

Explanation: Dual storage mode can allow a table to behave as either Import or DirectQuery depending on the context of a query. In composite models, shared dimension tables can sometimes benefit from Dual mode because they may serve imported and DirectQuery fact tables efficiently. This can reduce unnecessary source queries while maintaining compatibility with the DirectQuery portion of the model. Import mode stores data in memory, while DirectQuery always queries the source. DirectLake is a different storage approach associated with supported Fabric scenarios. Choosing storage mode should be based on model design and performance requirements.

Q4. A report contains a long list of regions. Users need to view each region as a separate repeated version of the same chart without creating individual visuals manually. Which Power BI feature should you use?

1. Page navigator
2. Small multiples
3. Bookmark navigator
4. Drillthrough

Correct Answer: 2. Small multiples

Explanation: Small multiples allow a visual to be repeated for each value of a selected category while keeping the same axes and visual structure. For example, one line chart can be repeated for each region, making comparisons easier without manually creating a separate chart for every region. Page and bookmark navigators control navigation, while drillthrough sends users to a detail page. Small multiples are useful when users need consistent side-by-side comparisons across categories such as regions, departments, products, or customer segments.

Q5. You need to add a column during Power Query transformation by writing your own M expression rather than using a predefined transformation. Which feature should you use?

1. Custom Column
2. Data alert
3. Display folder
4. Drill mode

Correct Answer: 1. Custom Column

Explanation: A Custom Column in Power Query allows you to define a new column using an M expression. This is useful when built-in transformations do not fully meet the required business rule or when several source fields must be combined in custom logic. Data alerts are used for notifications, display folders organize model fields, and drill mode supports hierarchy navigation in visuals. A Custom Column is evaluated during data preparation and becomes part of the transformed dataset before it is loaded into the semantic model.

Q6. You are reviewing a semantic model and discover that Auto date/time has created hidden date tables for many date columns. You already have a dedicated Date dimension. What should you consider?

1. Add more hidden date tables.
2. Disable Auto date/time for the model where appropriate.
3. Convert every date column to text.
4. Delete the dedicated Date table.

Correct Answer: 2. Disable Auto date/time for the model where appropriate.

Explanation: When a model already contains a well-designed Date dimension, Auto date/time may create unnecessary hidden date tables for individual date columns. These additional tables can increase model size and create inconsistent date-analysis experiences. Disabling Auto date/time can help ensure that report authors use the dedicated Date dimension consistently. Converting dates to text would reduce time-intelligence functionality, while deleting the proper Date table would remove a valuable modeling structure. Centralizing date analysis around one well-designed Date dimension often improves consistency and maintainability.

Q7. You need a measure that evaluates an expression only over rows that meet a complex multi-column condition. Which DAX table function is commonly used inside CALCULATE for this purpose?

1. CALENDAR
2. DISTINCT
3. PATHITEM
4. FILTER

Correct Answer: 4. FILTER

Explanation: FILTER returns a table containing only rows that satisfy a specified logical expression. It is frequently used inside CALCULATE when the filtering requirement is more complex than a simple Boolean condition. For example, you can filter transactions based on combinations of quantity, margin, and product status before evaluating a measure. CALENDAR generates dates, DISTINCT returns unique values, and PATHITEM works with parent-child hierarchy paths. FILTER is powerful because it can evaluate expressions row by row and create a virtual table that influences the calculation context.

Q8. A report visual contains many categories, and users want the labels arranged in a compact tabular form with expandable hierarchy levels. Which visual should you use?

1. Gauge
2. Scatter chart
3. Matrix
4. KPI

Correct Answer: 3. Matrix

Explanation: The Matrix visual supports hierarchical rows and columns, drill-down, expand/collapse behavior, subtotals, and grand totals. It is particularly useful for structured reporting where users need detailed category breakdowns while preserving a compact tabular presentation. A Gauge focuses on a single value relative to a target, a Scatter chart analyzes relationships between numeric variables, and a KPI visual emphasizes a key metric. When users need hierarchy-aware tabular analysis, Matrix is generally more suitable than a simple table.

Q9. Your organization wants a semantic model to be recognized as formally reviewed and trusted. Which endorsement should be used after the required governance process has been completed?

1. Certification
2. Promotion only
3. Personal bookmark
4. Sensitivity label only

Correct Answer: 1. Certification

Explanation: Certification is the Power BI endorsement intended to identify content that has passed an organization’s formal review and governance process. Certified semantic models can help report authors find trusted, authoritative data sources for enterprise reporting. Promotion is a lighter endorsement that can indicate recommended content without the same formal approval. Personal bookmarks store individual report states, and sensitivity labels classify information according to protection policies. Certification supports data governance by distinguishing formally approved content from less controlled analytical assets.

Q10. You need to create a measure that calculates the average of an expression evaluated separately for each customer. Which DAX function is most appropriate?

1. COUNTROWS
2. AVERAGEX
3. MAX
4. FORMAT

Correct Answer: 2. AVERAGEX

Explanation: AVERAGEX is an iterator that evaluates an expression for each row of a supplied table and then returns the average of the calculated results. For customer-level analysis, you can iterate over a customer table and calculate a measure or expression for each customer before averaging those customer results. COUNTROWS counts rows, MAX returns the highest value, and FORMAT converts values to text. AVERAGEX is useful whenever the required average is based on a derived row-by-row calculation rather than directly averaging one existing numeric column.

Q11. You are working with a large SQL source and want filtering steps in Power Query to execute on the SQL server rather than locally whenever possible. Which concept is most relevant?

1. Query folding
2. Conditional formatting
3. Drillthrough
4. Bookmark state

Correct Answer: 1. Query folding

Explanation: Query folding occurs when Power Query translates transformation steps into source-native operations that the underlying system can execute. For large SQL sources, this can improve refresh performance because filtering and other supported transformations occur on the database server, reducing data transfer to Power BI. Conditional formatting affects visuals, drillthrough handles report navigation, and bookmarks preserve report states. Maintaining query folding where practical is an important optimization technique when working with relational data sources capable of efficiently processing queries.

Q12. A report contains several trend charts, and you want to overlay a line that represents the average value for the visible data. What should you add?

1. A sensitivity label
2. A page navigator
3. A bridge table
4. An average reference line

Correct Answer: 4. An average reference line

Explanation: An average reference line can provide a visual benchmark that represents the mean value of the displayed data. It helps users quickly identify which data points are above or below the average without requiring a separate chart or calculation display. Sensitivity labels classify content, page navigators support report navigation, and bridge tables resolve modeling relationships. Reference lines are an analytical enhancement that can improve chart interpretation by adding thresholds, averages, medians, or other comparison values directly to supported visuals.

Q13. A column contains strings such as “INV-2026-00045”. You need only the final five characters in a new Power Query column. Which transformation should you use?

1. Group By
2. Extract Last Characters
3. Pivot Column
4. Fill Down

Correct Answer: 2. Extract Last Characters

Explanation: Power Query provides text extraction functions that can return characters from the beginning, end, or a specific range of a text value. Extract Last Characters is appropriate when you need the final five characters from a structured identifier such as “INV-2026-00045”. Group By aggregates data, Pivot changes row values into columns, and Fill Down propagates previous nonblank values. Text extraction transformations are useful when structured codes contain meaningful segments that need to be analyzed or used independently.

Q14. A user needs to compare actual revenue with target revenue, and the target should appear as a clear benchmark within the same visual. Which visual feature is most appropriate?

1. Report tooltip
2. Drill mode
3. Reference or target line
4. Row-level security

Correct Answer: 3. Reference or target line

Explanation: A reference or target line provides a clear benchmark against which actual values can be visually compared. It can help users immediately determine whether performance is above or below a goal without adding a separate visual. Tooltips provide additional information on hover, drill mode navigates through hierarchy levels, and row-level security restricts data access. Benchmark lines are especially useful in trend or category charts where a common target or threshold applies to many data points.

Q15. You have multiple Power BI reports that should all use the same definitions for Revenue, Margin, and Customer Count. What is the best governance approach?

1. Create one governed shared semantic model and build reports from it.
2. Recreate all measures independently in every report.
3. Export all data to CSV for each report.
4. Create disconnected tables in every report.

Correct Answer: 1. Create one governed shared semantic model and build reports from it.

Explanation: A governed shared semantic model centralizes business definitions, relationships, measures, and security so multiple reports can reuse the same analytical foundation. This reduces duplicated development and lowers the risk that different reports calculate key metrics differently. Recreating measures independently can lead to inconsistent business logic, while exporting to CSV removes much of the value of the semantic model. Disconnected tables do not solve governance. Shared semantic models support consistency, maintainability, and self-service reporting within controlled organizational standards.

Q16. You need to see the rows that contribute to a particular summarized value in a visual without designing a separate detail page. Which capability is most relevant?

1. Conditional formatting
2. Data details or show data
3. Deployment pipeline
4. Mobile layout

Correct Answer: 2. Data details or show data

Explanation: Data detail capabilities allow users to inspect the underlying or summarized data associated with a visual without requiring the report designer to create a dedicated drillthrough page. This can help users verify how totals were produced or inspect contributing categories. Conditional formatting changes visual appearance, deployment pipelines manage lifecycle stages, and mobile layout controls phone presentation. Data detail views are useful when users need quick access to the records or summarized values behind a report visual.

Q17. You need to calculate a ratio where both numerator and denominator are measures, and you want the calculation to safely handle a zero denominator. Which function should you use?

1. DIVIDE
2. SUMX
3. SELECTEDVALUE
4. UNION

Correct Answer: 1. DIVIDE

Explanation: DIVIDE safely calculates a quotient and handles zero or blank denominators without producing an undesirable error. You can also specify an alternate result if the denominator is zero. This makes DIVIDE preferable for ratios such as conversion rate, margin percentage, and utilization. SUMX performs iterative summation, SELECTEDVALUE returns a single selected value, and UNION combines tables. Ratio calculations are common in Power BI, and DIVIDE improves robustness when data may contain periods or filter contexts where the denominator is unavailable.

Q18. A report page has many slicers, and users need one button that resets all selections to a predefined default state. Which feature should you use?

1. Query parameter
2. Data alert
3. Sensitivity label
4. Bookmark linked to a button

Correct Answer: 4. Bookmark linked to a button

Explanation: A bookmark can capture a predefined combination of slicer selections, filters, and visual states. Linking that bookmark to a button provides users with an easy way to reset the report to the saved default configuration. Query parameters affect data preparation, data alerts provide notifications, and sensitivity labels classify content. Bookmarks are widely used for reset buttons, guided navigation, and alternate report states because they can preserve specific filter and display configurations.

Q19. A semantic model contains a Product table with 100 unique products and a Sales fact table with millions of rows. Which cross-filter direction is generally preferred in a standard star schema?

1. Bidirectional from every table
2. Single direction from Product to Sales
3. Single direction from Sales to Product
4. No filtering relationship

Correct Answer: 2. Single direction from Product to Sales

Explanation: In a standard star schema, filters generally propagate from a dimension table on the one side of a relationship to a fact table on the many side. Product selections can therefore filter Sales rows predictably. Bidirectional filtering should only be enabled when a specific requirement justifies it because it may introduce ambiguity or complexity. Filtering from the fact table back to the dimension is not the normal default pattern, and leaving the tables disconnected would prevent Product attributes from filtering Sales. Single-direction relationships support clear, maintainable model behavior.

Q20. You are analyzing a time series and need to highlight unusual spikes or drops that differ significantly from expected behavior. Which Power BI capability should you use?

1. Column distribution
2. Bookmark navigator
3. Anomaly detection
4. Query dependencies

Correct Answer: 3. Anomaly detection

Explanation: Anomaly detection helps identify points in time-series data that differ significantly from expected patterns. It can draw attention to unusual increases or decreases and assist users in investigating unexpected business events. Column distribution profiles data in Power Query, bookmark navigators provide report navigation, and Query Dependencies displays query relationships. Anomaly detection is designed for analytical exploration of time-based data and can help users focus on exceptions that may deserve further investigation.