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

Q1. You are importing a large CSV file into Power BI Desktop. The file contains several columns that are not required for reporting. What should you do to improve model efficiency before loading the data?

1. Hide the unnecessary columns in Report view.
2. Remove the unnecessary columns in Power Query.
3. Disable interactions for the unnecessary columns.
4. Create calculated columns that return BLANK().

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

Explanation: Removing unnecessary columns in Power Query prevents those fields from being loaded into the Power BI semantic model. This reduces model size, memory consumption, and potentially refresh time. Simply hiding a column does not remove it from the model; the column continues consuming storage and can still affect performance. Calculated columns would increase the size of the model rather than reduce it. Disabling visual interactions is unrelated to data loading. A good data-preparation practice is to eliminate unused columns and rows as early as possible in the transformation process before data reaches the model.

Q2. You have a Sales table containing multiple transactions per day. You need a DAX measure that calculates total sales while respecting the filters applied to the report. Which expression should you use?

1. COUNT(Sales[SalesAmount])
2. DISTINCTCOUNT(Sales[SalesAmount])
3. AVERAGE(Sales[SalesAmount])
4. SUM(Sales[SalesAmount])

Correct Answer: 4. SUM(Sales[SalesAmount])

Explanation: SUM is the appropriate aggregation when you need to calculate the total value of a numeric column such as SalesAmount. A DAX measure created using SUM automatically responds to the current filter context, including filters applied by slicers, visual categories, and page-level or report-level filters. COUNT would return the number of nonblank values rather than their monetary total. DISTINCTCOUNT would count unique sales values, while AVERAGE would calculate their arithmetic mean. Measures are generally preferable to calculated columns for dynamic aggregations because they are calculated based on the current report context rather than stored for every row.

Q3. A Power BI model contains separate Sales and Product tables. Each sales transaction references exactly one product, while each product can appear in many sales transactions. Which relationship should you configure?

1. A many-to-one relationship from Sales to Product.
2. A one-to-one relationship between Sales and Product.
3. A many-to-many relationship between Sales and Product.
4. No relationship is required.

Correct Answer: 1. A many-to-one relationship from Sales to Product.

Explanation: The Sales table represents the many side because multiple transaction rows can reference the same product. The Product table represents the one side because each product should have a unique product identifier. This is a standard fact-and-dimension relationship in a star schema. The Product dimension filters the Sales fact table through the relationship. A one-to-one relationship would require every product to appear only once in Sales, which is not the case. Many-to-many relationships should generally be used only when both sides contain repeated values and the business scenario specifically requires that modeling pattern.

Q4. You need users to select a year from a slicer and have all report visuals update accordingly. Which Power BI feature should you use?

1. Drillthrough.
2. Conditional formatting.
3. A slicer visual.
4. A tooltip page.

Correct Answer: 3. A slicer visual.

Explanation: A slicer provides an interactive filtering mechanism that allows report users to select one or more values, such as a year, region, category, or customer. By default, the slicer affects other compatible visuals on the report page through visual interactions. Drillthrough is designed to navigate from a summarized value to a dedicated detail page. Conditional formatting changes the appearance of visual elements based on values, while tooltip pages provide additional contextual information when users hover over data points. Therefore, a slicer is the most appropriate choice for letting users dynamically filter report visuals by year.

Q5. Your Power Query transformation must replace null values in a Quantity column with zero before the data is loaded into the model. What should you use?

1. A report-level filter.
2. Replace Values in Power Query.
3. Conditional formatting.
4. A Power BI bookmark.

Correct Answer: 2. Replace Values in Power Query.

Explanation: Power Query provides transformation operations that allow you to clean data before loading it into the model. Using Replace Values, you can replace null values in the Quantity column with zero during the data preparation stage. This ensures that downstream calculations and visualizations receive standardized values. Report-level filters do not modify the underlying data and would only control which records appear in reports. Conditional formatting affects visual appearance, while bookmarks save a particular report state. Performing the transformation in Power Query is generally preferable when the change represents a data-cleaning requirement that should consistently apply throughout the semantic model.

Q6. You need to create a calculated table containing unique customer IDs from the Customers table. Which DAX function is most appropriate?

1. DISTINCT(Customers[CustomerID])
2. SUM(Customers[CustomerID])
3. COUNT(Customers[CustomerID])
4. CONCATENATE(Customers[CustomerID], Customers[CustomerID])

Correct Answer: 1. DISTINCT(Customers[CustomerID])

Explanation: DISTINCT returns a one-column table containing the unique values found in the specified column. Therefore, it is suitable when you need a calculated table that contains one row for each unique CustomerID. SUM aggregates numeric values and does not return a table of unique identifiers. COUNT calculates the number of nonblank entries rather than returning those entries. CONCATENATE combines text values and is unrelated to eliminating duplicates. Although data modeling usually favors a properly prepared dimension table, DISTINCT is useful when a unique list must be generated dynamically as a DAX calculated table inside the semantic model.

Q7. A manager should only be able to view sales records for the region assigned to the manager after a report is published to the Power BI service. What should you configure?

1. Conditional formatting.
2. A visual-level filter.
3. A report bookmark.
4. Row-level security.

Correct Answer: 4. Row-level security.

Explanation: Row-level security (RLS) restricts which rows of data users can access based on security roles and filter expressions. For example, a role can filter the Region table so that a manager sees only records associated with the appropriate region. After defining and testing roles in Power BI Desktop, access can be assigned and managed in the Power BI service. Visual-level and page-level filters are report-design features and are not intended to enforce data security because users with sufficient access may potentially access data outside those filters. Bookmarks and conditional formatting control presentation rather than authorization and therefore cannot replace RLS.

Q8. You have monthly revenue data and need to display the pattern of revenue over time. Which visual is generally the most appropriate?

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

Correct Answer: 3. Line chart.

Explanation: A line chart is well suited for showing trends across a continuous sequence such as dates, months, quarters, or years. Plotting monthly revenue along a time axis makes it easier to identify increases, decreases, seasonality, and other patterns. A card displays a single summary value and therefore does not communicate changes over time effectively. A gauge compares a value against a target, while a treemap is mainly useful for showing relative proportions across hierarchical categories. Choosing a visualization that matches the analytical purpose improves report readability and helps users recognize important trends without having to interpret individual numeric values manually.

Q9. You want to create a measure that calculates sales for the previous year based on the current date context. Which DAX function can be used as part of the calculation?

1. SAMEPERIODLASTYEAR.
2. LEFT.
3. SUBSTITUTE.
4. COUNTROWS.

Correct Answer: 1. SAMEPERIODLASTYEAR.

Explanation: SAMEPERIODLASTYEAR is a DAX time-intelligence function that returns a set of dates shifted one year backward from the dates in the current filter context. It is commonly combined with CALCULATE to produce measures such as prior-year sales. For reliable time-intelligence calculations, the model should contain an appropriate date table with a continuous sequence of dates and a relationship to the fact table. LEFT and SUBSTITUTE are text functions, while COUNTROWS counts rows in a table. Using dedicated time-intelligence functions simplifies year-over-year calculations and allows results to respond dynamically to filters applied by date, month, quarter, or year.

Q10. You need to prevent users from modifying a certified semantic model while still allowing them to build reports from it. Which general Power BI approach is appropriate?

1. Give every user workspace Admin permissions.
2. Export the semantic model to CSV.
3. Create a separate copy of every report.
4. Provide appropriate read/build permissions without edit-level workspace access.

Correct Answer: 4. Provide appropriate read/build permissions without edit-level workspace access.

Explanation: Power BI permissions should follow the principle of least privilege. Users who need to create reports from an existing semantic model can be given the permissions required to access and build from that model without receiving workspace roles that allow them to modify or delete managed content. Granting Admin permissions would provide excessive control. Exporting data to CSV would remove many semantic-model capabilities, including measures and relationships. Maintaining separate unnecessary copies would complicate governance. Proper workspace and item-level access enables centralized semantic models to be reused for self-service reporting while allowing administrators and content owners to retain control over governed assets.

Q11. A column imported into Power BI contains values such as “2026-01-15”, but Power BI treats the column as text. You need date-based calculations. What should you do?

1. Hide the column.
2. Change the column data type to Date.
3. Convert the values into measures.
4. Apply conditional formatting.

Correct Answer: 2. Change the column data type to Date.

Explanation: Setting the appropriate data type is an important part of preparing data for analysis. A text column containing date-like values cannot reliably support date hierarchies, chronological sorting, date arithmetic, and many time-intelligence operations. Changing the data type to Date allows Power BI to recognize each value as a date and enables date-oriented functionality. Hiding the column would not correct the data type. Measures are intended for calculations rather than replacing a source date field. Conditional formatting only changes the appearance of report visuals. Data types should generally be corrected during Power Query transformations or in the model before report development.

Q12. You have a measure named Total Sales. You need a new measure that returns Total Sales only for products in the “Accessories” category. Which DAX function is central to this requirement?

1. FORMAT.
2. RELATED.
3. CALCULATE.
4. LEN.

Correct Answer: 3. CALCULATE.

Explanation: CALCULATE evaluates an expression within a modified filter context. For example, a measure can evaluate [Total Sales] while applying a filter that restricts Product[Category] to “Accessories.” This makes CALCULATE one of the most important DAX functions because it enables context modification for filtered aggregations, time intelligence, ratios, and many other calculations. FORMAT converts values into formatted text, RELATED retrieves a value from a related table in row context, and LEN returns the number of characters in a text string. Understanding how CALCULATE modifies filter context is essential for creating effective analytical measures in Power BI semantic models.

Q13. You need to combine two tables that contain the same columns but represent sales transactions from two different years. You want the rows from the second table added below the rows from the first. Which Power Query operation should you use?

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

Correct Answer: 4. Append Queries.

Explanation: Append Queries combines tables vertically by adding the rows of one table to another. It is appropriate when multiple sources contain records with a similar structure, such as sales transactions from different years, months, branches, or files. Merge Queries combines tables horizontally by matching rows based on one or more key columns, which is conceptually similar to a database join. Group By aggregates records according to selected columns, while Pivot Column converts distinct row values into columns. When appending, column names and compatible data types should be reviewed to ensure that the resulting table is structured correctly and does not create unexpected null values.

Q14. Your model contains Sales, Product, Customer, and Date tables. Sales contains transaction-level values, while the other tables describe business entities. Which modeling design is generally recommended?

1. A star schema.
2. A single table containing every available column.
3. A model with unrelated tables.
4. A circular relationship design.

Correct Answer: 1. A star schema.

Explanation: A star schema is a recommended analytical modeling pattern in which a central fact table, such as Sales, connects to dimension tables such as Product, Customer, and Date. The fact table contains measurable business events, while dimensions contain descriptive attributes used for filtering and grouping. This structure generally makes relationships easier to understand and improves the usability and maintainability of the semantic model. A single highly denormalized table may introduce unnecessary repetition, while unrelated tables cannot effectively filter each other. Circular or ambiguous relationship paths can produce confusing results. Clear fact-to-dimension relationships help produce predictable DAX filter behavior.

Q15. You need users to navigate from a sales summary visual to another report page that displays detailed information about the selected customer. Which feature should you configure?

1. Data alerts.
2. Conditional formatting.
3. Drillthrough.
4. Automatic page refresh.

Correct Answer: 3. Drillthrough.

Explanation: Drillthrough allows users to right-click or otherwise navigate from a selected data point to a dedicated report page that is filtered according to the selected value. For example, a drillthrough page configured with Customer can display detailed transactions, customer attributes, and performance metrics for the customer selected on the summary page. Conditional formatting only changes visual appearance. Data alerts are associated with monitoring certain values in supported Power BI experiences, while automatic page refresh periodically updates report data for appropriate connection scenarios. Drillthrough is specifically designed to support contextual navigation from summarized information to detailed analysis.

Q16. A report contains several visuals, and selecting a value in one chart currently filters another chart. You want the selection to have no effect on the second chart. What should you configure?

1. Row-level security.
2. Edit interactions.
3. Incremental refresh.
4. Query folding.

Correct Answer: 2. Edit interactions.

Explanation: Edit interactions controls how one visual responds when a user selects data in another visual. For each target visual, the report designer can typically specify whether the source visual should filter it, highlight it, or have no interaction with it. This makes it possible to preserve certain visuals as independent context while other visuals respond to selections. Row-level security restricts data access based on user roles. Incremental refresh controls how partitions of historical and recent data are refreshed. Query folding concerns whether Power Query transformations can be translated and executed by the underlying data source. Therefore, Edit interactions addresses the visual behavior requirement directly.

Q17. A very large fact table contains several years of historical data. Only recent records change regularly. You want scheduled refreshes to process recent data without repeatedly refreshing the entire historical dataset. Which feature should you consider?

1. Drillthrough.
2. Sync slicers.
3. Report tooltips.
4. Incremental refresh.

Correct Answer: 4. Incremental refresh.

Explanation: Incremental refresh is designed for large tables where only a portion of the data changes regularly. Instead of refreshing the entire dataset each time, Power BI can partition data according to a date or date/time column and refresh only the required recent partitions while retaining older historical partitions. This can substantially reduce refresh duration and resource consumption. It normally requires appropriate date-range parameters and filters, and the source should ideally support efficient query execution. Drillthrough, synchronized slicers, and report tooltips are report-consumption features and do not affect how data is partitioned or refreshed. Incremental refresh is primarily a data-management optimization.

Q18. You need the same Region slicer selection to apply across several report pages. Which Power BI feature should you use?

1. Personal bookmarks.
2. Sync slicers.
3. Q&A.
4. Decomposition tree.

Correct Answer: 2. Sync slicers.

Explanation: Sync slicers enables a slicer’s selection to remain synchronized across multiple pages in a Power BI report. You can choose which pages participate in synchronization and whether the slicer itself is visible on each page. This is useful when users should maintain the same region, business unit, year, or other filtering context while navigating among report pages. Personal bookmarks capture personalized report states but do not provide the same centrally designed cross-page filtering behavior. Q&A supports natural-language data exploration, while the decomposition tree is an analytical visual for breaking down measures across dimensions. Sync slicers directly addresses cross-page filter consistency.

Q19. You need to create a measure that counts the number of rows in the Sales table after the current report filters have been applied. Which DAX expression should you use?

1. COUNTROWS(Sales)
2. SUM(Sales)
3. VALUES(Sales)
4. CONCATENATE(Sales, Sales)

Correct Answer: 1. COUNTROWS(Sales)

Explanation: COUNTROWS returns the number of rows in a table. When used in a measure, it is evaluated according to the current filter context, which means slicers, visual filters, relationships, and other filtering conditions can affect the result. This makes COUNTROWS useful for measures such as transaction count, order count when each row represents an order, or the number of records matching current criteria. SUM expects a numeric column rather than an entire table. VALUES returns unique values or rows depending on its argument, and CONCATENATE is a text function. COUNTROWS is therefore the straightforward choice for dynamically counting fact-table rows.

Q20. You created a Power BI report containing a map, charts, and cards. Users say that the report is difficult to interpret because too many visuals compete for attention. What should you do first to improve usability?

1. Add more visuals to provide additional detail.
2. Use as many different colors as possible.
3. Simplify the layout and emphasize the most important information.
4. Duplicate the visuals on every page.

Correct Answer: 3. Simplify the layout and emphasize the most important information.

Explanation: Effective Power BI report design focuses on communicating insights clearly rather than displaying the maximum possible amount of information. Simplifying the page, grouping related information, establishing visual hierarchy, and highlighting important metrics can make a report easier to interpret and navigate. Additional visuals can create unnecessary cognitive load, while excessive colors may distract users and reduce consistency. Duplicating visuals across pages can also make the report harder to maintain without improving understanding. Report designers should consider business requirements, accessibility, appropriate visual selection, consistent formatting, descriptive titles, and sensible spacing so that users can quickly identify the most relevant information.