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

Q1. You are importing a large fact table into Power BI. Several text columns contain descriptive information that is never used in reports, relationships, or calculations. What should you do to improve model efficiency?

1. Hide the unused columns in Report view.
2. Remove the unused columns in Power Query.
3. Convert the columns to calculated columns.
4. Add the columns to a hierarchy.

Correct Answer: 2. Remove the unused columns in Power Query.

Explanation: Removing unused columns in Power Query prevents those fields from being loaded into the semantic model at all. This reduces memory consumption, model size, and potentially refresh time. Hiding columns only removes them from the field list for report authors; the data still exists in the model and consumes storage. Calculated columns would increase the amount of data stored, while adding the fields to a hierarchy does not improve performance. As a general modeling practice, only load data that is required for reporting, relationships, filtering, or calculations so that the model remains as lean and efficient as possible.

Q2. A measure named [Total Sales] already exists. You need to calculate sales only for the current year. Which DAX function is most important for modifying the filter context of the measure?

1. DISTINCT
2. CONCATENATE
3. CALCULATE
4. ROUND

Correct Answer: 3. CALCULATE

Explanation: CALCULATE is used to evaluate an expression under a modified filter context. For example, it can evaluate [Total Sales] while applying a condition that limits the calculation to the current year. This makes CALCULATE one of the most important DAX functions for filtered totals, ratios, time intelligence, and comparison measures. DISTINCT returns unique values, CONCATENATE joins text values, and ROUND changes the decimal precision of numeric values. Because the requirement involves changing the conditions under which an existing measure is evaluated, CALCULATE is the correct foundation for the solution.

Q3. You need to combine two tables that contain the same columns but store transactions from different regions. Which Power Query operation should you use?

1. Append Queries
2. Merge Queries
3. Pivot Column
4. Group By

Correct Answer: 1. Append Queries

Explanation: Append Queries combines tables vertically by adding rows from one table below the rows of another. This is appropriate when multiple tables share a similar schema, such as sales transactions from different regions, months, or years. Merge Queries combines tables horizontally by matching rows based on key columns, which is similar to a relational join. Pivot Column changes row values into columns, while Group By summarizes data based on selected fields. When the requirement is to create one larger transaction table from multiple similarly structured sources, Append Queries is the appropriate transformation.

Q4. You have a Sales table with millions of rows and a Product table with one row per product. Which relationship cardinality is most appropriate?

1. One-to-one
2. Many-to-many
3. One-to-many from Sales to Product
4. Many-to-one from Sales to Product

Correct Answer: 4. Many-to-one from Sales to Product

Explanation: The Sales fact table usually contains many rows for each product, while the Product dimension contains a single unique row for each ProductID. Therefore, the relationship is many-to-one from Sales to Product, or equivalently one-to-many from Product to Sales. This is a common star-schema relationship. A one-to-one relationship would require both tables to contain unique ProductID values. A many-to-many relationship is unnecessary when the dimension key is unique and can create additional model complexity. Correct cardinality helps Power BI propagate filters predictably and improves the clarity of the model.

Q5. A report user wants to quickly restrict all visuals on a page to a specific product category. Which visual should you add?

1. Slicer
2. Gauge
3. Card
4. Decomposition tree

Correct Answer: 1. Slicer

Explanation: A slicer is designed to provide interactive filtering directly on a report page. Users can select one or more product categories, and compatible visuals on the page can update automatically based on that selection. A Gauge is used to show progress toward a target, while a Card displays a summarized value. A decomposition tree supports exploratory breakdown of a measure across different dimensions. Since the requirement is to let users choose a category and filter the report interactively, a slicer is the most appropriate visual.

Q6. You need to calculate the number of unique orders in a Sales table. Each order may contain several line items with the same OrderID. Which DAX function should you use?

1. COUNT
2. DISTINCTCOUNT
3. COUNTROWS
4. SUM

Correct Answer: 2. DISTINCTCOUNT

Explanation: DISTINCTCOUNT returns the number of unique values in a specified column. Because an OrderID can appear on multiple line-item rows, COUNT or COUNTROWS could overstate the number of actual orders. DISTINCTCOUNT(Sales[OrderID]) counts each order only once within the current filter context. SUM is intended for adding numeric values rather than counting identifiers. DISTINCTCOUNT is commonly used for metrics such as unique customers, unique orders, unique products sold, and other business entities that may occur multiple times in a fact table.

Q7. You need to display how sales rankings for several product categories change from month to month. Which visual is best suited to this requirement?

1. Treemap
2. Card
3. Ribbon chart
4. Gauge

Correct Answer: 3. Ribbon chart

Explanation: A Ribbon chart is specifically designed to show how the relative ranking of categories changes across an ordered axis such as time. Each ribbon represents a category, and changes in its vertical position indicate how its ranking changes from one period to another. A Treemap focuses on proportional size, a Card displays one value, and a Gauge shows progress toward a target. When the business question focuses on category rank movement over multiple months, the Ribbon chart provides a clear visualization of those changes.

Q8. You have created an inactive relationship between Date[Date] and Sales[ShipDate]. Which DAX function can activate that relationship inside a measure?

1. RELATED
2. USERELATIONSHIP
3. VALUES
4. LOOKUPVALUE

Correct Answer: 2. USERELATIONSHIP

Explanation: USERELATIONSHIP is used within CALCULATE or CALCULATETABLE to temporarily activate an existing inactive relationship for the duration of a calculation. This is useful when a fact table contains multiple date fields such as OrderDate, ShipDate, and DeliveryDate. One relationship can remain active by default while others remain inactive. A measure that needs ShipDate-based analysis can invoke USERELATIONSHIP to use the ShipDate connection. RELATED retrieves values across relationships, VALUES returns distinct values, and LOOKUPVALUE retrieves a value based on matching conditions. USERELATIONSHIP directly addresses the inactive relationship requirement.

Q9. A source column contains values such as “123”, “456”, and “789”, but Power BI identifies the column as text. The values will be summed in reports. What should you do?

1. Keep the column as text.
2. Convert the column to Whole Number or another suitable numeric type.
3. Hide the column.
4. Convert the column to Boolean.

Correct Answer: 2. Convert the column to Whole Number or another suitable numeric type.

Explanation: Numeric values that need to be aggregated should use an appropriate numeric data type. If a column remains text, Power BI cannot treat it correctly for numerical aggregation and may provide inappropriate summarization options. Converting the column to Whole Number, Decimal Number, or another suitable numeric type enables mathematical operations and improves semantic accuracy. Hiding the column does not correct its data type, while Boolean is intended for true/false values. Data types should be validated during data preparation because incorrect types can cause calculation, sorting, and visualization problems.

Q10. You need to display the relationship between advertising spend and sales revenue for hundreds of campaigns. Which visual should you use?

1. Scatter chart
2. Pie chart
3. Table only
4. KPI visual

Correct Answer: 1. Scatter chart

Explanation: A Scatter chart is designed to show relationships between two numerical variables. Advertising spend can be placed on one axis and sales revenue on the other, allowing users to identify patterns, correlations, clusters, and outliers across campaigns. A Pie chart is mainly used to show category proportions, while a KPI visual emphasizes progress toward a target. A table can show exact values but makes it harder to identify relationships visually across hundreds of observations. Scatter charts are particularly useful when users need to investigate whether increases in one numeric variable are associated with changes in another.

Q11. You want to create a new query based on an existing Power Query query so that future changes to the original query flow into the new one. Which option should you choose?

1. Duplicate
2. Reference
3. Append
4. Transpose

Correct Answer: 2. Reference

Explanation: A referenced query uses the result of another query as its starting point. Therefore, changes made to the original query are reflected in the referenced query because the reference depends on that source. A duplicate creates an independent copy of the query steps at the time of duplication, so future modifications to the original are not automatically inherited. Append combines rows from tables, while Transpose exchanges rows and columns. References are useful when creating reusable staging queries and multiple downstream tables from a common set of preparation steps.

Q12. A report should show total sales for the current month compared with the previous month. Which type of DAX functionality is most relevant?

1. Text functions
2. Statistical functions only
3. Time-intelligence functions
4. Parent-child functions

Correct Answer: 3. Time-intelligence functions

Explanation: Time-intelligence functions are designed to perform calculations across dates and periods, including previous month, previous year, year-to-date, month-to-date, and period comparisons. A model should generally have a proper date table and appropriate relationships for reliable time-based calculations. Text functions handle character values, while parent-child functions support hierarchical relationships such as organizational structures. Statistical functions may perform averages or distributions but do not specifically manage shifting date contexts. For month-over-month comparison measures, DAX time-intelligence functionality is the appropriate approach.

Q13. Your report has one page for executives and another for detailed analysis. You want the same Year slicer selection to apply on both pages. Which feature should you use?

1. Sync slicers
2. Conditional formatting
3. Row-level security
4. Performance Analyzer

Correct Answer: 1. Sync slicers

Explanation: Sync slicers enables a slicer selection to remain consistent across multiple report pages. You can determine which pages are synchronized and whether the slicer is visible on each page. This allows a user who selects a specific year on the executive page to retain the same filter when navigating to the detailed analysis page. Conditional formatting affects visual appearance, row-level security restricts access to data, and Performance Analyzer measures report visual performance. Sync slicers is specifically intended for maintaining consistent filtering across pages.

Q14. You need to show users the exact underlying rows that contribute to a summarized value without creating a separate report page. Which Power BI capability is most appropriate?

1. Drillthrough only
2. See data or show data details
3. Bookmarks
4. Row-level security

Correct Answer: 2. See data or show data details

Explanation: Power BI provides options such as See data or data detail views that allow users to inspect values underlying a visual without requiring a dedicated drillthrough page. This can be useful when users want to understand the records contributing to an aggregated result. Drillthrough is appropriate when navigation to a separate detailed report page is required. Bookmarks save report states, while row-level security controls access to rows based on user identity. When the goal is simply to inspect data associated with a visual, data detail capabilities are more direct.

Q15. A large fact table is refreshed every night, but historical records rarely change. Which Power BI feature can reduce the amount of data processed during each refresh?

1. Incremental refresh
2. Bookmark navigator
3. Drill mode
4. Report tooltip

Correct Answer: 1. Incremental refresh

Explanation: Incremental refresh allows Power BI to partition a large table based on a date or date/time column and refresh only the required recent partitions. Older historical partitions can remain unchanged, reducing refresh duration and resource consumption. This is particularly valuable for large transactional tables where recent data is frequently updated but older data remains stable. Bookmark navigators, drill mode, and report tooltips are report interaction features and do not affect data-refresh processing. Incremental refresh is a data-management optimization designed specifically for large and growing datasets.

Q16. You need to display sales for the top 10 customers based on the [Total Sales] measure. What should you configure on the visual?

1. A relative date filter
2. A Top N filter
3. Row-level security
4. A sensitivity label

Correct Answer: 2. A Top N filter

Explanation: A Top N filter limits categories displayed in a visual to the highest or lowest specified number based on a selected measure. You can apply a Top N filter to Customer and specify 10, using [Total Sales] as the value that determines ranking. A relative date filter limits results based on time, row-level security restricts data according to user permissions, and a sensitivity label classifies content for information governance. Top N filtering is the appropriate solution when users need to focus on the highest-performing or lowest-performing categories.

Q17. Your model contains Sales, Product, Customer, and Date tables. Which design approach is generally recommended for analytical reporting?

1. A star schema
2. Multiple disconnected fact tables with no dimensions
3. A circular relationship model
4. A single text column containing all attributes

Correct Answer: 1. A star schema

Explanation: A star schema separates measurable business events into fact tables and descriptive business attributes into dimension tables. In this scenario, Sales would typically be the central fact table, while Product, Customer, and Date act as dimensions. This design creates clear one-to-many relationships and supports predictable filter propagation. It also improves usability because report authors can easily understand which fields describe entities and which fields contain metrics. Disconnected tables and circular relationships can make filtering difficult or ambiguous. Star-schema modeling is a widely recommended approach for Power BI semantic models.

Q18. Your organization wants different regional managers to see only rows that belong to their own region. Which Power BI feature should you configure?

1. Conditional formatting
2. Row-level security
3. Visual headers
4. Report themes

Correct Answer: 2. Row-level security

Explanation: Row-level security, or RLS, restricts access to rows in a semantic model based on roles and filter rules. A role can filter a Region table so that users assigned to that role see only the data for their permitted region. Dynamic RLS can also use user identity to apply different filters for different users through a mapping table. Conditional formatting affects visual appearance, while visual headers and themes change report presentation. None of those features enforce data access. RLS is specifically intended to secure model data at the row level for different users or groups.

Q19. You need to analyze the reason a metric changes by successively breaking it down across dimensions such as Region, Product, and Channel. Which visual should you use?

1. Card
2. Decomposition tree
3. Gauge
4. Donut chart

Correct Answer: 2. Decomposition tree

Explanation: The decomposition tree allows users to analyze a measure by breaking it down across multiple dimensions in an interactive sequence. Users can choose branches such as Region, Product, or Channel to understand how each dimension contributes to the overall value. It can also support AI-assisted exploration depending on the configuration. A Card shows a single summarized value, while a Gauge focuses on progress toward a target. A Donut chart compares category proportions but does not provide the same step-by-step explanatory breakdown. The decomposition tree is designed for root-cause and exploratory analysis.

Q20. You publish a Power BI semantic model that connects to an on-premises SQL Server database. Scheduled refresh must occur in the Power BI service. What is typically required?

1. A Power BI bookmark
2. A report tooltip page
3. An on-premises data gateway
4. A mobile layout

Correct Answer: 3. An on-premises data gateway

Explanation: An on-premises data gateway enables secure communication between the Power BI service and supported data sources located inside an organization’s local network. It is commonly required when a published semantic model needs scheduled refresh from an on-premises SQL Server database. The gateway is installed and configured within the organization’s environment and uses stored credentials to access the source. Bookmarks and tooltip pages are report-design features, while mobile layout controls how a report appears on smaller screens. The gateway provides the connectivity required for Power BI cloud services to access supported on-premises sources.