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

Q1. You are preparing a Power BI model and discover that a dimension table contains several duplicate CustomerID values. You need to use CustomerID on the one side of a relationship. What should you do first?

1. Create a many-to-many relationship.
2. Remove or resolve duplicate CustomerID values.
3. Hide the CustomerID column.
4. Convert CustomerID to text.

Correct Answer: 2. Remove or resolve duplicate CustomerID values.

Explanation: A column used on the one side of a one-to-many relationship should contain unique values. If CustomerID contains duplicates, the dimension table does not meet the expected structure for that relationship. The duplicates should be investigated and resolved in Power Query or at the data source before creating the relationship. Changing the data type or hiding the field does not make the values unique. Creating a many-to-many relationship simply to accommodate bad dimension data can introduce unnecessary complexity and ambiguous filtering. A clean dimension with one row per customer supports predictable relationships and a well-designed star schema.

Q2. You need a measure that returns total sales but ignores any filters applied to the Product Category column. Which DAX approach should you use?

1. CALCULATE with REMOVEFILTERS on Product Category.
2. COUNTROWS with Product Category.
3. CONCATENATE with Product Category.
4. RELATED with Product Category.

Correct Answer: 1. CALCULATE with REMOVEFILTERS on Product Category.

Explanation: CALCULATE modifies the filter context used to evaluate an expression. When combined with REMOVEFILTERS on Product Category, it can recalculate Total Sales while ignoring filters specifically applied to that category field. Other filters, such as date or region, can remain active. This pattern is commonly used for percentages of total, benchmarks, and comparisons. COUNTROWS counts table rows, CONCATENATE joins text, and RELATED retrieves a value from a related table. Because the requirement is to change filter context rather than perform a different type of aggregation, CALCULATE with REMOVEFILTERS is the appropriate solution.

Q3. A report must show the percentage of total sales contributed by each region. Which modeling concept is most important when creating this measure?

1. Query folding
2. Filter context
3. Data category
4. Privacy level

Correct Answer: 2. Filter context

Explanation: Percentage-of-total calculations depend heavily on filter context. The numerator typically evaluates sales within the current region, while the denominator removes the region filter and calculates total sales across all regions. DAX functions such as CALCULATE and REMOVEFILTERS are commonly used for this purpose. Query folding concerns pushing Power Query transformations to the source system, while data categories describe field semantics such as geographic data. Privacy levels help govern how data sources can be combined. Understanding filter context is essential for creating ratios, comparisons, and many other advanced DAX measures in Power BI.

Q4. You have sales data stored in separate monthly CSV files inside the same folder. New files will be added every month. Which Power Query approach is most appropriate?

1. Import each file manually every month.
2. Use a Folder connector and combine files.
3. Create a calculated table for each file.
4. Use bookmarks to switch between files.

Correct Answer: 2. Use a Folder connector and combine files.

Explanation: The Folder connector allows Power Query to retrieve files from a folder and apply a common transformation pattern across them. This is ideal for recurring files such as monthly CSV exports that share the same structure. When new files are added to the folder, they can be included automatically during refresh, assuming they follow the expected schema. Importing each file manually would require repeated maintenance. Calculated tables operate after data is loaded into the model, and bookmarks have nothing to do with data ingestion. The Folder connector provides a scalable way to consolidate recurring flat-file data.

Q5. You need to display a single high-level value showing total profit for the currently selected filters. Which visual should you use?

1. Matrix
2. Scatter chart
3. Card
4. Ribbon chart

Correct Answer: 3. Card

Explanation: A Card visual is designed to prominently display a single summarized value such as Total Profit, Total Sales, Number of Customers, or Average Margin. It responds to the current report filter context and is ideal for high-level KPIs. A Matrix is better suited to detailed tabular and hierarchical analysis. A Scatter chart shows relationships between numeric variables, and a Ribbon chart shows changes in rank across categories and time. When the goal is to emphasize one important metric and make it immediately visible to users, a Card is usually the most appropriate visual.

Q6. A Power Query column contains blank values that should inherit the most recent nonblank value from the row above. Which transformation should you use?

1. Fill Down
2. Unpivot Columns
3. Replace Errors
4. Split Column

Correct Answer: 1. Fill Down

Explanation: Fill Down copies the last nonblank value into subsequent blank rows until another nonblank value is encountered. This is useful for data imported from spreadsheets where labels or categories appear only on the first row of a group. Unpivot Columns restructures data from columns into rows, Replace Errors handles error values, and Split Column divides one field into multiple fields. Fill Down helps normalize semi-structured source data before it is loaded into the Power BI model. It should be applied only when the business logic confirms that blank rows are intended to inherit the value above.

Q7. You need to rank products by total sales within the current report context. Which DAX function is most appropriate?

1. RANKX
2. COUNT
3. LOOKUPVALUE
4. FORMAT

Correct Answer: 1. RANKX

Explanation: RANKX evaluates an expression across a table and returns the ranking of each item based on that expression. It is commonly used to rank products, customers, regions, or sales representatives by measures such as Total Sales or Profit. The ranking can respond dynamically to filters applied in the report. COUNT simply counts nonblank values, LOOKUPVALUE retrieves a value based on matching criteria, and FORMAT converts a value to text with a chosen display format. RANKX is specifically designed for ranking scenarios and is a valuable function for Top N and comparative analysis.

Q8. Your semantic model contains a Date table. You need to calculate sales for the same period in the previous year. Which DAX function is designed for this purpose?

1. DISTINCT
2. SAMEPERIODLASTYEAR
3. SUMX
4. FIND

Correct Answer: 2. SAMEPERIODLASTYEAR

Explanation: SAMEPERIODLASTYEAR returns a set of dates corresponding to the same period one year earlier than the current date context. It is commonly used with CALCULATE to build previous-year sales measures for year-over-year analysis. A proper Date table with a continuous sequence of dates and an appropriate relationship to the fact table is generally required for reliable time-intelligence calculations. DISTINCT returns unique values, SUMX iterates through rows to sum an expression, and FIND searches for text within another text string. SAMEPERIODLASTYEAR directly addresses prior-year period comparison requirements.

Q9. A report contains several charts, and you want a selection in one visual to highlight rather than filter another visual. Which feature should you configure?

1. Edit interactions
2. Row-level security
3. Data alerts
4. Sensitivity labels

Correct Answer: 1. Edit interactions

Explanation: Edit interactions lets the report designer control how visuals affect one another when users select data points. Depending on the target visual, you can configure the interaction to filter, highlight, or have no effect. This provides fine-grained control over report behavior. Row-level security is used for restricting data access by user, data alerts monitor certain values, and sensitivity labels classify information according to governance policies. Since the requirement is specifically about changing how one visual responds to another, Edit interactions is the appropriate report-design feature.

Q10. You need to create a reusable measure that sums Quantity multiplied by UnitPrice for each row in the Sales table. Which DAX function should you use?

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

Correct Answer: 3. SUMX

Explanation: SUMX is an iterator that evaluates an expression for each row of a table and then sums the resulting values. In this case, SUMX can iterate over the Sales table, calculate Quantity multiplied by UnitPrice for each row, and then add those row-level amounts together. SUM can aggregate a single numeric column but cannot directly evaluate a row-by-row multiplication expression unless that result is already stored in a column. COUNTROWS counts rows, while DISTINCTCOUNT counts unique values. Iterator functions such as SUMX are useful when aggregation depends on a calculation performed for each row.

Q11. You want to reduce the size of an imported Power BI model. Which action is most likely to help?

1. Add more calculated columns.
2. Increase the number of bidirectional relationships.
3. Remove unnecessary columns and rows before loading.
4. Duplicate every dimension table.

Correct Answer: 3. Remove unnecessary columns and rows before loading.

Explanation: Reducing the amount of data loaded into the model is one of the most effective ways to decrease model size. Unused columns, especially high-cardinality text fields, can consume significant memory. Unneeded rows should also be filtered out when appropriate. Adding calculated columns increases storage requirements, and unnecessary bidirectional relationships can make the model more complex. Duplicating dimensions increases redundancy. Efficient Power BI models typically load only the data required for reporting, relationships, calculations, and security. Data reduction should ideally be performed as early as possible in Power Query or at the source.

Q12. A user needs to move from a summary chart to another page that shows all transactions for the selected product. Which feature should you use?

1. Conditional formatting
2. Drillthrough
3. Tooltip
4. Sync slicers

Correct Answer: 2. Drillthrough

Explanation: Drillthrough allows users to navigate from a summarized visual to a dedicated detail page while passing the selected value as a filter. For example, a user can select a product and open a page showing detailed transactions for that product. Tooltips provide additional information without leaving the current page, while Sync slicers maintains slicer selections across pages. Conditional formatting changes visual appearance. Drillthrough is specifically intended for moving from summary-level analysis to detailed contextual information, making it appropriate for transaction-level follow-up pages.

Q13. You have a very large table with many years of historical data. Only the most recent month changes regularly. Which feature should you configure to improve scheduled refresh efficiency?

1. Automatic page refresh
2. Incremental refresh
3. Bookmarks
4. Q&A

Correct Answer: 2. Incremental refresh

Explanation: Incremental refresh partitions a large table and refreshes only the recent data that is expected to change, while older historical partitions remain untouched. This can substantially reduce refresh duration and resource consumption for large datasets. Automatic page refresh controls how often a report page queries updated data while open, which is a different scenario. Bookmarks save report states, and Q&A enables natural-language exploration. When only a small portion of a large historical table changes regularly, incremental refresh is the appropriate data-management feature to consider.

Q14. You need to identify data points that are significantly different from expected values in a time-series visual. Which Power BI analytical capability can assist?

1. Anomaly detection
2. Row-level security
3. Data source privacy levels
4. Merge Queries

Correct Answer: 1. Anomaly detection

Explanation: Anomaly detection can help identify unusual data points in a time series that differ significantly from expected patterns. It can support exploratory analysis by drawing attention to spikes, drops, or other deviations that may require investigation. Row-level security controls data access, privacy levels govern how data from different sources can be combined, and Merge Queries combines tables based on matching keys. Anomaly detection is specifically an analytical feature designed to help users identify unexpected patterns in time-based data and can be valuable for monitoring operational or business metrics.

Q15. You are publishing a report that connects to an on-premises SQL Server source and requires scheduled refresh. What is typically required?

1. A sensitivity label
2. A bookmark navigator
3. An on-premises data gateway
4. A dashboard subscription

Correct Answer: 3. An on-premises data gateway

Explanation: An on-premises data gateway provides secure connectivity between the Power BI service and supported data sources located within an organization’s network. It is commonly required when a semantic model published to Power BI needs scheduled refresh from an on-premises SQL Server database. The gateway is installed and configured in the local environment and uses credentials to connect to the source. Sensitivity labels classify content, bookmarks support navigation and report state management, and subscriptions distribute report updates. The gateway serves the data-connectivity requirement between cloud Power BI services and on-premises systems.

Q16. You need to classify a report as confidential according to your organization’s information-protection policy. Which feature should you use?

1. Sensitivity label
2. Conditional formatting
3. Visual-level filter
4. Drill mode

Correct Answer: 1. Sensitivity label

Explanation: Sensitivity labels classify Power BI content according to organizational information-protection policies. Labels can identify reports, semantic models, and other content as Public, Internal, Confidential, or according to other classifications configured by the organization. This helps users understand how the information should be handled and can integrate with broader Microsoft information-protection capabilities. Conditional formatting affects visual appearance, visual-level filters control which data appears in one visual, and drill mode supports navigation through hierarchy levels. For governance and classification of sensitive content, a sensitivity label is the appropriate feature.

Q17. A visual must show only the five customers with the highest total revenue. Which filter type should you use?

1. Relative date filter
2. Top N filter
3. Basic filter only
4. Drillthrough filter

Correct Answer: 2. Top N filter

Explanation: A Top N filter allows you to display the highest or lowest number of categories based on a selected numeric measure. You can configure Customer to show the top five values and use Total Revenue as the ranking measure. A relative date filter limits data according to a time period. A basic filter selects individual values but does not automatically rank them, while a drillthrough filter is used on destination pages for contextual navigation. Top N filtering is designed specifically for highlighting leading or trailing categories according to a measure.

Q18. You need to let users explore a metric by breaking it down interactively across Region, Product, and Sales Channel. Which visual should you use?

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

Correct Answer: 2. Decomposition tree

Explanation: The decomposition tree allows users to analyze a measure by successively breaking it down across multiple dimensions. For example, Total Sales can first be analyzed by Region, then by Product, and then by Sales Channel. This makes it useful for exploratory and root-cause analysis. A Gauge compares a measure with a target, a Card displays a single value, and a Donut chart shows proportions across categories. The decomposition tree is specifically designed for interactive multi-level analysis where users want to understand what factors contribute to a metric.

Q19. A text column contains values such as “North|Retail|Premium”. You need three separate columns. Which Power Query transformation should you use?

1. Group By
2. Pivot Column
3. Split Column by Delimiter
4. Replace Errors

Correct Answer: 3. Split Column by Delimiter

Explanation: Split Column by Delimiter separates a text field into multiple columns based on a specified separator. In this case, the pipe character can be used to divide the original value into Region, Channel, and Segment columns. Group By summarizes rows, Pivot Column transforms row values into columns, and Replace Errors substitutes error values. Splitting combined attributes into separate fields improves the structure of the data and makes each attribute independently available for filters, relationships, grouping, and analysis in the Power BI model.

Q20. You want report users to see the same Region slicer selection on multiple pages, while the slicer itself is hidden on some of those pages. What should you configure?

1. Sync slicers
2. Data alerts
3. Row-level security
4. Performance Analyzer

Correct Answer: 1. Sync slicers

Explanation: Sync slicers allows one slicer selection to apply across multiple report pages. The designer can control both synchronization and visibility separately, which means the Region slicer can filter multiple pages while being hidden on selected pages. This is useful for maintaining consistent context as users navigate through a report without repeating the same slicer everywhere. Data alerts monitor values, row-level security restricts data access, and Performance Analyzer helps investigate visual performance. Sync slicers is the feature designed specifically for maintaining filter selections across report pages.