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

Q1. You are importing data from an Excel workbook that contains several named tables. You only need one table for your Power BI model. What is the best approach?

1. Import the entire workbook and delete the unused tables later.
2. Select only the required table in the Navigator before loading.
3. Convert all worksheet ranges to text.
4. Create a calculated table after loading all workbook data.

Correct Answer: 2. Select only the required table in the Navigator before loading.

Explanation: Selecting only the required table in the Navigator reduces unnecessary data ingestion and helps keep the Power BI model lean. Loading extra tables that are not used increases refresh time, model size, and maintenance effort. Although unused tables can be removed later, it is usually more efficient to avoid loading them in the first place. Converting ranges to text does not solve the issue, and calculated tables are created after data is already loaded into the model. A good data-preparation practice is to bring in only the source objects that are actually needed for reporting and analysis.

Q2. You need to calculate the percentage change between current sales and previous-period sales. Which DAX expression pattern is most appropriate?

1. DIVIDE([Current Sales] – [Previous Sales], [Previous Sales])
2. COUNTROWS(Sales)
3. DISTINCT(Product[Category])
4. CONCATENATE([Current Sales], [Previous Sales])

Correct Answer: 1. DIVIDE([Current Sales] – [Previous Sales], [Previous Sales])

Explanation: Percentage change is generally calculated as the difference between the current value and the previous value divided by the previous value. Using DIVIDE is preferred because it safely handles cases where the previous-period value is zero or blank. COUNTROWS counts rows and does not perform percentage calculations. DISTINCT returns unique values, while CONCATENATE combines text. This DAX pattern is frequently used for month-over-month, quarter-over-quarter, and year-over-year comparisons and responds dynamically to the current filter context when implemented as a measure.

Q3. A report author wants users to switch dynamically between viewing sales by Region, Product Category, and Salesperson in the same chart. Which feature should be used?

1. Drillthrough
2. Calculation groups
3. Field parameters
4. Row-level security

Correct Answer: 3. Field parameters

Explanation: Field parameters allow users to dynamically change which dimensions or measures appear in a visual. In this scenario, a field parameter can include Region, Product Category, and Salesperson so users can select which dimension they want to analyze without requiring separate charts. Drillthrough navigates to another report page, calculation groups apply reusable calculation logic to measures, and row-level security controls data access. Field parameters are designed specifically to make visuals more flexible and interactive while reducing report clutter and duplicated visuals.

Q4. You need to prevent users from changing a certified semantic model while still allowing them to consume reports built from it. Which principle should guide permission assignment?

1. Give all users workspace Admin access.
2. Apply least-privilege permissions.
3. Duplicate the model for each user.
4. Remove all report permissions.

Correct Answer: 2. Apply least-privilege permissions.

Explanation: The principle of least privilege means users should receive only the permissions required to perform their tasks. Consumers who only need to view reports should not receive editing or administrative rights over the semantic model. This reduces the risk of accidental changes and supports better governance. Granting Admin access would provide excessive permissions, while duplicating the model creates unnecessary maintenance and inconsistency. Removing report permissions would prevent legitimate access. Proper use of workspace roles, item permissions, and semantic model access helps keep governed Power BI content secure and manageable.

Q5. You are building a report that must show geographic sales data by state, but some state names are ambiguous internationally. What should you add to improve geocoding accuracy?

1. A Product Category field.
2. A CustomerID field.
3. Country information.
4. A calculated profit measure.

Correct Answer: 3. Country information.

Explanation: Geographic fields can be ambiguous because the same place name may exist in multiple countries or regions. Adding country information gives Power BI additional geographic context and helps mapping services resolve locations more accurately. This is especially useful for states, provinces, cities, and postal codes. Product Category, CustomerID, and profit measures do not help with geolocation. Data categories should also be configured appropriately. Providing enough location context improves map accuracy and reduces the risk that Power BI places a data point in the wrong geographic area.

Q6. You want to compare actual monthly sales against both a budget measure and a forecast measure in one time-based visual. Which visual is most appropriate?

1. Line chart
2. Card
3. Treemap
4. Funnel chart

Correct Answer: 1. Line chart

Explanation: A line chart is well suited to comparing multiple measures over time. Actual Sales, Budget, and Forecast can each be plotted as separate lines against a monthly date axis, making trends and differences easy to identify. A Card displays a single summary value, a Treemap shows proportions among categories, and a Funnel chart is typically used for stage-based processes. When the goal is to compare several time-series measures consistently across months, a line chart provides a clear and familiar analytical presentation.

Q7. You need a calculation that finds the average result of Quantity multiplied by UnitPrice for each row in the Sales table. Which DAX function should you use?

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

Correct Answer: 2. AVERAGEX

Explanation: AVERAGEX is an iterator that evaluates an expression for each row of a table and then returns the average of those results. In this scenario, it can calculate Quantity multiplied by UnitPrice for every row in Sales and then average the resulting row values. SUM can only add an existing numeric column directly, while COUNTROWS counts rows and MAX returns the largest value. Iterator functions ending in X are useful when a row-level expression must be evaluated before an aggregation is performed.

Q8. Your organization wants to move Power BI content from development to test and then to production in a controlled manner. Which feature should you use?

1. Bookmarks
2. Deployment pipelines
3. Drillthrough
4. Data alerts

Correct Answer: 2. Deployment pipelines

Explanation: Deployment pipelines support application lifecycle management by providing structured stages such as development, test, and production. They help teams promote Power BI content in a controlled way and reduce the risk of manually copying items between environments. Bookmarks save report states, drillthrough supports detail navigation, and data alerts notify users when supported values cross thresholds. Deployment pipelines are specifically designed to help manage Power BI content across environments and are useful for enterprise development and release processes.

Q9. A Power Query table contains a single column with full names such as “Sarah Ahmed”. You need separate FirstName and LastName columns. Which transformation is appropriate?

1. Split Column by Delimiter
2. Group By
3. Pivot Column
4. Fill Down

Correct Answer: 1. Split Column by Delimiter

Explanation: Split Column by Delimiter divides a text field based on a specified separator, such as a space. In this case, the full name can be split into FirstName and LastName. Group By aggregates rows, Pivot Column restructures row values into columns, and Fill Down copies values into blank rows. Splitting combined text fields during data preparation creates cleaner attributes that can be used independently in filtering, sorting, or reporting. The transformation should be reviewed carefully when names contain multiple spaces or more complex structures.

Q10. You need a report visual that highlights how values are distributed across categories using rectangular areas sized according to the measure value. Which visual should you use?

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

Correct Answer: 2. Treemap

Explanation: A Treemap uses rectangular areas to represent categories, with the size of each rectangle typically corresponding to a measure value. It is useful for showing proportional relationships among many categories in a compact space. A Gauge compares a value against a target, a Scatter chart shows relationships between numeric variables, and a KPI visual emphasizes performance against a goal. When users need to see category contribution by relative size, a Treemap can provide an effective visual summary.

Q11. You need a DAX measure to return a custom message when no value is selected in a slicer. Which function can help identify whether the selected value is blank?

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

Correct Answer: 1. ISBLANK

Explanation: ISBLANK tests whether an expression returns BLANK(). It can be used in conditional DAX logic to display a custom message or alternate result when a slicer selection is missing. TOPN returns a ranked subset of rows, CROSSJOIN creates combinations of rows from multiple tables, and RANKX ranks items according to an expression. ISBLANK is useful for user-friendly measures that need to distinguish between a meaningful zero value and the absence of a selected or calculated result.

Q12. You need to restrict a report so that each salesperson can view only their assigned customer records. Which feature should you configure?

1. Conditional formatting
2. Row-level security
3. Report tooltips
4. Sync slicers

Correct Answer: 2. Row-level security

Explanation: Row-level security restricts which records users can see based on defined roles and filters. In this scenario, each salesperson can be associated with assigned customers, and RLS can ensure that only those customer rows are visible after the report is published. Dynamic RLS can make the solution scalable by using the identity of the signed-in user. Conditional formatting changes visual appearance, tooltips display contextual information, and Sync slicers maintains filter selections across pages. RLS is the appropriate security mechanism for restricting access to data at the row level.

Q13. You need to create a DAX table containing only the five products with the highest Total Sales. Which function is most appropriate?

1. FILTER
2. TOPN
3. UNION
4. CALENDAR

Correct Answer: 2. TOPN

Explanation: TOPN returns a specified number of rows from a table according to an ordering expression. It can be used to return the five products with the highest Total Sales for further analysis or calculated-table logic. FILTER returns rows based on a condition but does not inherently rank and limit them, UNION combines compatible tables, and CALENDAR generates dates. TOPN is especially useful when a ranked subset of data is required inside DAX rather than simply applying a visual-level Top N filter.

Q14. A report needs to display a measure against a fixed benchmark value of 80. What should you add to the chart?

1. A calculated table.
2. A reference line.
3. A new relationship.
4. A query parameter.

Correct Answer: 2. A reference line.

Explanation: A reference line adds a visible benchmark or threshold to a supported chart. By placing a line at 80, users can quickly compare plotted values with the expected target. This is useful for goals, limits, service levels, or other standards. A calculated table is not necessary, a new relationship would not address the visual requirement, and a query parameter affects data retrieval or transformation. Reference lines improve chart interpretation by making target comparisons immediately visible.

Q15. You need to understand which tables and queries depend on a staging query before deleting it. Which Power Query feature should you review?

1. Column quality
2. Query Dependencies
3. Performance Analyzer
4. View as

Correct Answer: 2. Query Dependencies

Explanation: Query Dependencies provides a visual map of how Power Query queries reference and depend on one another. Before deleting a staging query, reviewing this view helps identify downstream queries that may break if the staging query is removed. Column quality profiles data values, Performance Analyzer evaluates report visual performance, and View as is used to test row-level security. Query Dependencies is specifically intended to help understand transformation flow and query relationships in more complex Power Query solutions.

Q16. A Power BI report contains a date slicer. Users want to automatically show only the last 30 days relative to the current date. Which slicer type should you configure?

1. Relative date slicer
2. Between slicer
3. List slicer
4. Dropdown slicer with manual dates

Correct Answer: 1. Relative date slicer

Explanation: A relative date slicer dynamically filters data based on the current date, such as the last 30 days, last 3 months, or current year. Unlike a Between slicer, it does not require users to manually update the start and end dates over time. List and dropdown slicers are useful for discrete values but are less suitable for automatically moving time windows. Relative date filtering is appropriate for operational reports that should continually show the most recent period as time progresses.

Q17. You need to create a new table containing all unique combinations of Region and Product Category from an existing dataset. Which DAX function is suitable for grouping by those columns?

1. SUMMARIZE
2. DIVIDE
3. DATEADD
4. RELATED

Correct Answer: 1. SUMMARIZE

Explanation: SUMMARIZE can create a table grouped by one or more specified columns. In this case, it can return unique combinations of Region and Product Category and optionally include calculated summary expressions. DIVIDE performs safe division, DATEADD shifts date context, and RELATED retrieves a value from a related table. SUMMARIZE is useful for calculated tables or intermediate table expressions when grouped combinations of dimension attributes are required.

Q18. You want users to inspect additional details about a data point by hovering over it without navigating away from the page. What should you configure?

1. Drillthrough
2. Report tooltip
3. Data alert
4. Deployment pipeline

Correct Answer: 2. Report tooltip

Explanation: A report tooltip displays additional contextual information when a user hovers over a data point. A custom tooltip page can include measures, charts, or descriptive information filtered automatically to the hovered value. Drillthrough navigates to another page, data alerts provide threshold-based notifications, and deployment pipelines manage content promotion. Tooltips are a useful way to provide more detail while keeping the main report page uncluttered and preserving the user’s current analytical context.

Q19. You have a table containing ProductID and ProductName. ProductID is numeric, but users should never see it automatically summed in visuals. What should you configure?

1. Set ProductID to Do not summarize.
2. Convert ProductID to a measure.
3. Create a many-to-many relationship.
4. Apply conditional formatting.

Correct Answer: 1. Set ProductID to Do not summarize.

Explanation: Numeric identifiers such as ProductID may be interpreted by Power BI as values that can be summed, averaged, or otherwise aggregated. Because an identifier has no meaningful arithmetic interpretation, setting its default summarization to Do not summarize prevents inappropriate aggregation when report authors add it to visuals. Converting it into a measure is unnecessary, changing relationship cardinality would not solve the issue, and conditional formatting only affects appearance. Correct semantic configuration improves the report-authoring experience and reduces misleading results.

Q20. A report must compare category values while also showing how each category contributes to the overall total. Which visual is generally most appropriate?

1. Donut chart
2. Card
3. Gauge
4. Table

Correct Answer: 1. Donut chart

Explanation: A Donut chart is designed to show how categories contribute proportionally to a total. It can be effective when the number of categories is relatively small and users need a quick view of percentage contribution. A Card shows one summarized value, a Gauge compares one value to a target, and a Table provides detailed values but does not emphasize part-to-whole relationships visually. For category contribution analysis, a Donut chart can provide a concise and intuitive representation when used with an appropriate number of categories.