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

 

Q1. You are importing a CSV file into Power BI. One column contains dates in the format MM/DD/YYYY, but Power BI is interpreting some values incorrectly. What should you do in Power Query?

1. Change the column data type to Text permanently
2. Use Change Type with Locale and select the appropriate locale
3. Create a calculated column using DAX
4. Load the data into Power BI and change the format in the model

Correct Answer: 2

Explanation:
Power Query provides the Change Type with Locale option, which is useful when dates, numbers, or currencies are formatted according to a specific regional convention. Selecting the correct locale ensures that Power BI interprets values such as 03/04/2026 according to the intended date format. Simply changing the column to Text prevents Power BI from treating the values as dates, which would make date analysis more difficult. Changing the format in the model only affects how a correctly typed date is displayed and does not necessarily correct an incorrect interpretation during import. Therefore, using Change Type with Locale is the appropriate solution for regional date-format issues.

Q2. You have a sales table containing millions of rows and a separate Product dimension table. Which modeling approach should you use to optimize the Power BI model?

1. Create a many-to-many relationship between Sales and Product
2. Create a one-to-one relationship between Sales and Product
3. Create a one-to-many relationship from Product to Sales
4. Merge the Product table into the Sales table

Correct Answer: 3

Explanation:
A star schema is generally the preferred modeling approach in Power BI. In this scenario, the Product table acts as a dimension containing unique product records, while Sales is the fact table containing multiple transactions for each product. Therefore, the appropriate relationship is one-to-many, with Product on the “one” side and Sales on the “many” side. This structure provides efficient filtering and supports clear DAX calculations. A many-to-many relationship should generally be avoided unless the business requirement truly requires it. Merging the tables can unnecessarily increase fact-table size and reduce the benefits of dimensional modeling.

Q3. You need to create a measure that calculates total sales regardless of filters applied to the Product table. Which DAX expression is most appropriate?

1. CALCULATE([Total Sales], ALL(Product))
2. SUM(Product[Sales])
3. FILTER(Product, Product[Sales] > 0)
4. CALCULATE(Product[Sales], VALUES(Product))

Correct Answer: 1

Explanation:
The CALCULATE function modifies the filter context in which a measure is evaluated. Using ALL(Product) removes filters from the Product table while retaining other applicable filters unless they are also removed. For example, a measure such as CALCULATE([Total Sales], ALL(Product)) can calculate total sales across all products even when a report user selects a particular product or category. The other options either use incorrect table/column references or do not remove the Product filter context. Understanding filter context and the behavior of CALCULATE is essential for developing effective DAX measures in Power BI.

Q4. A Power BI report contains a Date table. You want to analyze sales by year, quarter, month, and day. What should you do?

1. Use the automatic date hierarchy only
2. Create a dedicated Date table with appropriate date attributes
3. Convert the Date column to Text
4. Create separate Sales tables for each year

Correct Answer: 2

Explanation:
A dedicated Date table provides greater control over time-based analysis and is a recommended modeling practice. It can contain columns such as Date, Year, Quarter, Month Number, Month Name, and Week. The Date table should normally contain a continuous range of dates and be related to the fact table through the appropriate date column. Marking it as a Date table can also help Power BI recognize the intended time dimension. Although automatic date/time functionality can be convenient for simple reports, a dedicated Date table is more flexible and supports customized time intelligence calculations and consistent filtering across the model.

Q5. You want to allow report users to select a specific product category and have all visuals on the page respond to the selection. Which Power BI feature should you use?

1. Bookmark
2. Slicer
3. Tooltip
4. Drillthrough

Correct Answer: 2

Explanation:
A slicer is an interactive filtering visual designed to allow report users to select values directly on a report page. For example, a Category slicer can contain values such as Electronics, Furniture, and Clothing. When a user selects a category, visuals connected to the same data model generally respond to the filter context. Bookmarks are used primarily to capture report states and navigation configurations. Tooltips provide additional information when users hover over data points, while drillthrough allows users to navigate to a detailed page based on a selected value. Therefore, a slicer is the most appropriate feature for interactive category filtering.

Q6. A company wants to show monthly revenue trends over the past two years. Which visualization is generally most appropriate?

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

Correct Answer: 1

Explanation:
A line chart is well suited for displaying trends over time because it connects data points sequentially, making increases, decreases, and patterns easier to identify. For monthly revenue across two years, the horizontal axis can represent months while the vertical axis represents revenue. A pie chart is more appropriate for showing parts of a whole at a point in time and can become difficult to interpret with many categories. A gauge generally focuses on progress toward a target, while a card displays a single key value. Therefore, a line chart provides the clearest representation of a continuous monthly revenue trend.

Q7. You have a calculated column that determines profit for every sales transaction. You instead want a calculation that dynamically responds to report filters. What should you create?

1. A measure
2. A static column
3. A relationship
4. A Power Query parameter

Correct Answer: 1

Explanation:
Measures are calculated dynamically based on the current filter context of a Power BI report. This makes them appropriate for calculations such as total profit, profit margin, and year-to-date revenue that need to respond to slicers, visual filters, and other report selections. Calculated columns are evaluated during data refresh and store a result for each row, which can increase model size. A relationship connects tables, while a Power Query parameter is primarily used to control query behavior. If the objective is to create a calculation that changes dynamically when users filter the report, a measure is generally the correct choice.

Q8. In Power Query, you need to remove duplicate customer records based on the Customer ID column. What should you do?

1. Remove duplicates after selecting Customer ID
2. Replace Customer ID values with null
3. Group the entire dataset by date
4. Disable query refresh

Correct Answer: 1

Explanation:
Power Query includes a Remove Duplicates operation that can be applied after selecting one or more columns. If Customer ID uniquely identifies a customer, selecting that column and choosing Remove Duplicates retains one row for each distinct Customer ID. This is useful when preparing dimension tables where unique customer records are required. Replacing values with null does not eliminate duplicate records, while grouping by date addresses a completely different transformation requirement. Disabling refresh prevents new data from being retrieved but does not solve duplication. Therefore, selecting Customer ID and using Remove Duplicates is the appropriate Power Query transformation.

Q9. You need to combine two tables that contain customer information from two different regions. The columns have the same structure, and you want to add the rows together. Which Power Query operation should you use?

1. Merge Queries
2. Append Queries
3. Split Column
4. Pivot Column

Correct Answer: 2

Explanation:
Append Queries is used when you need to combine rows from two or more tables with compatible structures. For example, if NorthRegionCustomers and SouthRegionCustomers have the same customer columns, appending them creates a single table containing records from both regions. Merge Queries serves a different purpose: it combines tables horizontally by matching values in one or more key columns, similar to a database join. Split Column separates values into multiple columns, while Pivot Column transforms row values into columns. Therefore, when the requirement is to stack rows from similarly structured tables, Append Queries is the correct Power Query operation.

Q10. A report contains a matrix showing sales by country and city. Users want to click a country and see the cities within that country. Which feature provides this functionality?

1. Drill-down
2. Data refresh
3. Row-level security
4. Query folding

Correct Answer: 1

Explanation:
Drill-down allows users to move through different levels of a hierarchy within a visual. In this example, Country can be the higher level and City can be the lower level. Users can select a country and drill into the corresponding cities to examine more detailed information. Data refresh updates the underlying data, row-level security controls which records users are allowed to see, and query folding concerns how Power Query transformations are translated back to the source system. Therefore, drill-down is the appropriate feature for navigating from country-level information to city-level detail within a matrix.

Q11. You need to calculate sales for the previous year based on the current filter context. Which DAX function is commonly used for this purpose?

1. SAMEPERIODLASTYEAR
2. COUNTROWS
3. DISTINCT
4. CONCATENATE

Correct Answer: 1

Explanation:
SAMEPERIODLASTYEAR is a DAX time-intelligence function that returns a date set corresponding to the same period one year earlier. It is commonly used with CALCULATE to create a previous-year sales measure, such as CALCULATE([Total Sales], SAMEPERIODLASTYEAR(‘Date'[Date])). This allows the measure to dynamically respond to the current date filter context. Functions such as COUNTROWS count rows, DISTINCT returns unique values, and CONCATENATE combines text. Effective time-intelligence calculations generally require a properly configured Date table and an appropriate relationship between the Date table and the fact table.

Q12. A Power BI report needs to display the percentage contribution of each product category to total sales. Which visualization is most suitable for comparing several categories?

1. Bar chart
2. Gauge
3. Card
4. KPI visual only

Correct Answer: 1

Explanation:
A bar chart is effective for comparing values across multiple categories, including percentage contribution to total sales. It allows users to compare category sizes using the length of bars, which is generally easier to interpret than comparing angles or areas. A gauge is designed primarily for showing progress toward a target, while a card is intended to display a single important value. A KPI visual can compare a current value against a target or status, but it is not inherently designed to compare numerous categories. Therefore, a bar chart provides an effective way to display and compare the percentage contribution of multiple product categories.

Q13. You want to prevent certain users from viewing sales records belonging to other regions. Which Power BI feature should you configure?

1. Bookmarks
2. Row-level security
3. Drillthrough
4. Conditional formatting

Correct Answer: 2

Explanation:
Row-level security (RLS) restricts the data that users can access based on defined roles and filtering rules. For example, a regional manager could be assigned a role that allows access only to sales records for their specific region. RLS can be implemented using static filters or dynamic security based on user information. Bookmarks control saved report states, drillthrough provides navigation to detailed report pages, and conditional formatting changes the appearance of visuals based on values. RLS is therefore the appropriate Power BI feature when the requirement is to restrict individual users or groups from viewing unauthorized rows in a dataset.

Q14. A Power Query transformation can be translated into a native query executed by the source database. What is this process called?

1. Query folding
2. Data profiling
3. Data lineage
4. Visual interaction

Correct Answer: 1

Explanation:
Query folding occurs when Power Query translates compatible transformation steps into operations that can be executed by the underlying data source. For example, filtering rows or selecting specific columns from a SQL database may be pushed back to SQL Server rather than processing all data locally. This can improve performance and reduce the amount of data transferred to Power BI. Not every transformation supports query folding, and its availability depends on the connector and source system. Data profiling analyzes data quality, data lineage describes relationships between data assets, and visual interaction controls how report visuals affect each other.

Q15. You have a sales table and a Date table. The Date table contains unique dates, while the Sales table contains many transactions for each date. What relationship should you create?

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

Correct Answer: 3

Explanation:
The Date table should be on the “one” side because each date should appear only once in the Date table. The Sales table is on the “many” side because multiple transactions can occur on the same date. Therefore, the correct relationship is one-to-many from Date to Sales. This relationship allows filters applied through the Date table to propagate to the corresponding sales records. Maintaining this structure is an important part of a star-schema design. A one-to-one relationship would not support multiple transactions per date, while many-to-many is unnecessary when the Date table contains unique dates.

Q16. You want to allow users to navigate from a summary sales page to a detailed customer page based on the selected customer. Which feature should you configure?

1. Drillthrough
2. Query folding
3. Data category
4. Power Query merge

Correct Answer: 1

Explanation:
Drillthrough allows users to navigate from one report page to another while carrying the selected filter context with them. For example, a summary page might display sales by customer. The user can right-click a customer and select a drillthrough option that opens a customer-detail page filtered to that customer. This is useful for creating detailed analysis pages without overcrowding the main report. Query folding relates to Power Query performance, data categories provide metadata for fields such as geographic information, and Merge Queries combines tables. Therefore, Drillthrough is the appropriate feature for this navigation scenario.

Q17. Which DAX function should you use to count the number of rows in a table?

1. SUM
2. COUNTROWS
3. AVERAGE
4. RELATED

Correct Answer: 2

Explanation:
The COUNTROWS DAX function returns the number of rows in a specified table. It is particularly useful when you need to count transactions, orders, records, or other table rows. For example, COUNTROWS(Sales) returns the number of rows currently visible within the relevant filter context. SUM adds numeric values from a column, while AVERAGE calculates an arithmetic mean. RELATED retrieves a related value from another table when an appropriate relationship exists. Understanding the purpose of core DAX functions is important for PL-300 because measures often combine aggregation functions with filter-context functions to produce dynamic analytical results.

Q18. A Power BI report has several visuals, but selecting a value in one visual does not affect another visual. What should you inspect first?

1. Edit interactions
2. Data gateway credentials
3. Workspace capacity
4. Data type formatting

Correct Answer: 1

Explanation:
Power BI provides Edit interactions to control how one visual affects other visuals on the same report page. For example, selecting a bar in a chart can filter or highlight another chart. If a visual does not respond as expected, reviewing the interaction settings is an appropriate first step. Depending on the configuration, an interaction can be set to filter, highlight, or have no effect. Gateway credentials relate to connectivity for certain data sources, workspace capacity relates to service resources, and data type formatting does not determine visual interaction behavior. Therefore, Edit interactions should be inspected first.

Q19. You need to create a visual that displays the current total sales as a single prominent number. Which Power BI visual should you use?

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

Correct Answer: 1

Explanation:
The Card visual is designed to display a single important value prominently. It is commonly used for KPIs such as total sales, total profit, number of customers, or total orders. A measure can be placed in the Card visual so that the displayed value dynamically changes according to the current filter context. Scatter charts are designed to analyze relationships between numerical variables, treemaps show hierarchical proportions, and ribbon charts can illustrate changes in rankings across categories. Therefore, when the primary requirement is to present one key numerical value clearly and prominently, a Card visual is the appropriate choice.

Q20. You have a Power BI semantic model containing a Sales fact table and Product and Date dimension tables. You want to calculate total sales for products in the “Electronics” category while retaining the current date filters. Which DAX approach is appropriate?

1. CALCULATE([Total Sales], Product[Category] = “Electronics”)
2. ALL(Product) without any additional filter
3. REMOVEFILTERS(‘Date’)
4. COUNTROWS(Product)

Correct Answer: 1

Explanation:
CALCULATE is designed to modify filter context while evaluating a measure. The expression CALCULATE([Total Sales], Product[Category] = “Electronics”) applies a filter to the Product Category while allowing existing filters, including Date filters, to continue affecting the calculation. This means a user viewing sales for a particular month can still see Electronics sales for that month. ALL(Product) would remove Product filters rather than specifically selecting Electronics, while REMOVEFILTERS(‘Date’) would remove date filters, producing the opposite of the requirement. COUNTROWS(Product) counts product rows and does not calculate sales. Thus, CALCULATE with the category filter is appropriate.