{"id":16459,"date":"2026-09-19T07:32:23","date_gmt":"2026-09-19T07:32:23","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=16459"},"modified":"2026-09-19T07:32:23","modified_gmt":"2026-09-19T07:32:23","slug":"servicenow-cis-itsm-practice-test-questions-and-exam-dumps-part4-q61-80","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/servicenow-cis-itsm-practice-test-questions-and-exam-dumps-part4-q61-80\/","title":{"rendered":"ServiceNow CIS-ITSM Practice Test Questions and Exam Dumps Part4 Q61-80"},"content":{"rendered":"

 <\/p>\n

View Full <\/b>ServiceNow CIS-ITSM Exam Dumps<\/b><\/a> and Practice Test Dumps.<\/b><\/p>\n


\n<\/b>Q1. You are using Power Query to import a table that contains duplicate rows. You need to ensure that only unique rows are loaded into the model. Which transformation should you use?<\/b><\/p>\n

    \n
  1. <\/b> Remove Duplicates<\/span><\/li>\n
  2. <\/b> Replace Values<\/span><\/li>\n
  3. <\/b> Fill Down<\/span><\/li>\n
  4. <\/b> Group By<\/span><\/li>\n<\/ol>\n

    Correct Answer: 1. Remove Duplicates<\/b><\/p>\n

    Explanation:<\/b> Remove Duplicates is the appropriate Power Query transformation when you need to eliminate repeated rows or duplicate values based on selected columns. Power Query compares the values in the selected fields and retains only one occurrence of each duplicate combination. This is useful when the source contains repeated records that could otherwise distort totals, counts, and other calculations. Replace Values changes specific values, Fill Down copies values from previous rows into blank rows, and Group By summarizes data. Removing unnecessary duplicate records before loading can improve data quality and help keep the semantic model smaller and more accurate.<\/span><\/p>\n

    Q2. You need to calculate profit margin as Total Profit divided by Total Revenue. Which DAX approach is recommended to safely handle division by zero?<\/b><\/p>\n

      \n
    1. <\/b> SUM(Total Profit \/ Total Revenue)<\/span><\/li>\n
    2. <\/b> COUNT(Total Profit)<\/span><\/li>\n
    3. <\/b> DIVIDE([Total Profit], [Total Revenue])<\/span><\/li>\n
    4. <\/b> CONCATENATE([Total Profit], [Total Revenue])<\/span><\/li>\n<\/ol>\n

      Correct Answer: 3. DIVIDE([Total Profit], [Total Revenue])<\/b><\/p>\n

      Explanation:<\/b> The DIVIDE function is recommended for division calculations in DAX because it safely handles cases where the denominator is zero or blank. Instead of returning an error, DIVIDE can return BLANK() or an optional alternate result. This makes measures more reliable when report filters produce contexts with no revenue. Performing direct division with the slash operator is possible, but DIVIDE is generally preferred when division-by-zero conditions are possible. COUNT is used to count values, while CONCATENATE combines text. For ratios such as profit margin, using measures with DIVIDE produces a dynamic calculation that responds correctly to report filter context.<\/span><\/p>\n

      Q3. A Power BI report must display monthly sales in chronological order. The MonthName column contains January, February, March, and so on, but the visual sorts them alphabetically. What should you do?<\/b><\/p>\n

        \n
      1. <\/b> Convert MonthName to a measure.<\/span><\/li>\n
      2. <\/b> Create a MonthNumber column and use Sort by Column.<\/span><\/li>\n
      3. <\/b> Apply a Top N filter.<\/span><\/li>\n
      4. <\/b> Hide the MonthName column.<\/span><\/li>\n<\/ol>\n

        Correct Answer: 2. Create a MonthNumber column and use Sort by Column.<\/b><\/p>\n

        Explanation:<\/b> Month names are text values, so Power BI may sort them alphabetically instead of chronologically. A common solution is to create a numeric MonthNumber column where January is 1, February is 2, and so on. You can then select MonthName and configure it to sort by MonthNumber. This preserves the readable month labels while enforcing the proper calendar sequence. A measure is not needed for this purpose, and hiding the field does not change its sorting behavior. Top N filtering limits the number of displayed values and is unrelated to chronological ordering.<\/span><\/p>\n

        Q4. You are designing a model with Sales as the fact table and Product as a dimension table. Which cross-filter direction is generally preferred for a standard star schema relationship?<\/b><\/p>\n

          \n
        1. <\/b> Both directions<\/span><\/li>\n
        2. <\/b> No filtering<\/span><\/li>\n
        3. <\/b> From Sales to Product only<\/span><\/li>\n
        4. <\/b> Single direction from Product to Sales<\/span><\/li>\n<\/ol>\n

          Correct Answer: 4. Single direction from Product to Sales<\/b><\/p>\n

          Explanation:<\/b> In a standard star schema, the recommended relationship generally filters from the dimension table on the one side to the fact table on the many side. This allows selections from Product attributes, such as Category or Brand, to filter matching Sales rows. Using single-direction filtering helps keep filter propagation predictable and reduces the possibility of ambiguous relationship paths. Bidirectional filtering can be useful in specific scenarios, but it should not be enabled unnecessarily because it can complicate the model and affect performance. A clear one-to-many relationship from Product to Sales is usually the preferred starting design.<\/span><\/p>\n

          Q5. You need to display the percentage contribution of each product category to total sales. Which DAX function is commonly used to remove the category filter when calculating the denominator?<\/b><\/p>\n

            \n
          1. <\/b> ALL<\/span><\/li>\n
          2. <\/b> FORMAT<\/span><\/li>\n
          3. <\/b> RELATED<\/span><\/li>\n
          4. <\/b> PATH<\/span><\/li>\n<\/ol>\n

            Correct Answer: 1. ALL<\/b><\/p>\n

            Explanation:<\/b> ALL is commonly used in DAX to remove filters from a table or column when calculating totals that should ignore part of the existing filter context. For a percentage-of-total measure, the numerator can use the current category sales, while the denominator can calculate overall sales using CALCULATE together with ALL on the category field. FORMAT converts a value to formatted text, RELATED retrieves a value from a related table, and PATH is used in parent-child hierarchies. Understanding how filter-removal functions work is important when creating ratios, shares, and comparison measures in Power BI.<\/span><\/p>\n

            Q6. Your report includes a Date slicer. Users need to quickly select a continuous period between two dates. Which slicer type should you configure?<\/b><\/p>\n

              \n
            1. <\/b> Dropdown<\/span><\/li>\n
            2. <\/b> Between<\/span><\/li>\n
            3. <\/b> Relative<\/span><\/li>\n
            4. <\/b> List<\/span><\/li>\n<\/ol>\n

              Correct Answer: 2. Between<\/b><\/p>\n

              Explanation:<\/b> A Between slicer is useful when users need to select a continuous range between a starting and ending value, particularly for dates or numeric fields. When configured with a date column, the slicer provides controls that allow users to define the beginning and end of the desired date range. A dropdown or list slicer is better suited for selecting discrete values. A relative date slicer is appropriate for dynamic periods such as the last 30 days or current month. For manually choosing a specific continuous date interval, the Between slicer is the most suitable option.<\/span><\/p>\n

              Q7. You have imported a sales table containing OrderDate and ShipDate. OrderDate is already connected to the Date table using an active relationship. You also need calculations based on ShipDate. What should you do?<\/b><\/p>\n

                \n
              1. <\/b> Delete the OrderDate relationship.<\/span><\/li>\n
              2. <\/b> Create a second Date table only.<\/span><\/li>\n
              3. <\/b> Use a many-to-many relationship.<\/span><\/li>\n
              4. <\/b> Create an inactive relationship for ShipDate and activate it in measures with USERELATIONSHIP.<\/span><\/li>\n<\/ol>\n

                Correct Answer: 4. Create an inactive relationship for ShipDate and activate it in measures with USERELATIONSHIP.<\/b><\/p>\n

                Explanation:<\/b> Power BI typically allows only one active relationship between the same two tables for a given filter path. You can keep the OrderDate relationship active and create another relationship between Date and ShipDate as inactive. Measures that need to analyze data by ShipDate can then use CALCULATE with USERELATIONSHIP to temporarily activate the inactive relationship during evaluation. This is a common technique when a fact table contains multiple business dates. Deleting the OrderDate relationship would remove useful behavior, while many-to-many relationships are unnecessary. A separate date table can be used in some designs, but USERELATIONSHIP is often more efficient.<\/span><\/p>\n

                Q8. A report page contains several visuals. You want users to switch between two different visual layouts without navigating to another page. What should you use?<\/b><\/p>\n

                  \n
                1. <\/b> Row-level security<\/span><\/li>\n
                2. <\/b> Incremental refresh<\/span><\/li>\n
                3. <\/b> Bookmarks and the Selection pane<\/span><\/li>\n
                4. <\/b> Data gateway<\/span><\/li>\n<\/ol>\n

                  Correct Answer: 3. Bookmarks and the Selection pane<\/b><\/p>\n

                  Explanation:<\/b> Bookmarks can capture different report states, including which visuals are visible or hidden. Combined with the Selection pane, you can create alternate layouts on the same page and use buttons to switch between them. For example, one bookmark could show charts while another shows detailed tables. Row-level security controls user access to data, incremental refresh optimizes refresh operations for large tables, and the data gateway provides connectivity between Power BI and on-premises data sources. Bookmarks and visibility settings are well suited for creating interactive report experiences without requiring users to move to a different page.<\/span><\/p>\n

                  Q9. You need to create a measure that returns sales for only the currently selected region. The existing relationships already filter the Sales table correctly. What is the main benefit of using a measure rather than a calculated column?<\/b><\/p>\n

                    \n
                  1. <\/b> Measures are evaluated dynamically in the current filter context.<\/span><\/li>\n
                  2. <\/b> Measures create new rows in the model.<\/span><\/li>\n
                  3. <\/b> Measures are always calculated in Power Query.<\/span><\/li>\n
                  4. <\/b> Measures automatically create relationships.<\/span><\/li>\n<\/ol>\n

                    Correct Answer: 1. Measures are evaluated dynamically in the current filter context.<\/b><\/p>\n

                    Explanation:<\/b> Measures are evaluated at query time based on the current filter context created by slicers, visual selections, filters, and relationships. This makes them ideal for calculations such as total sales by region, year, or product because the result automatically changes as users interact with the report. Calculated columns are evaluated row by row during data refresh and stored in the model. They do not provide the same dynamic aggregation behavior. Measures also generally consume less storage than calculated columns because the result is not stored for every row. They do not create relationships or add rows to tables.<\/span><\/p>\n

                    Q10. You are working with a column containing values such as ” Contoso “. You need to remove leading and trailing spaces. Which Power Query transformation should you use?<\/b><\/p>\n

                      \n
                    1. <\/b> Clean<\/span><\/li>\n
                    2. <\/b> Trim<\/span><\/li>\n
                    3. <\/b> Extract<\/span><\/li>\n
                    4. <\/b> Unpivot<\/span><\/li>\n<\/ol>\n

                      Correct Answer: 2. Trim<\/b><\/p>\n

                      Explanation:<\/b> The Trim transformation removes leading and trailing spaces from text values. This is useful when source data contains inconsistent spacing that could cause duplicate-looking values, incorrect matches, or poor grouping behavior. For example, “Contoso” and ” Contoso ” may appear visually similar but can be treated as different text values until spaces are removed. Clean is designed to remove non-printable characters rather than ordinary surrounding spaces. Extract returns part of a text value, while Unpivot restructures columns into rows. Applying Trim during data preparation improves data consistency before the information reaches the model.<\/span><\/p>\n

                      Q11. You need to identify which individual factors contribute most strongly to a selected metric in an interactive report. Which Power BI visual is designed for this type of analysis?<\/b><\/p>\n

                        \n
                      1. <\/b> Card<\/span><\/li>\n
                      2. <\/b> Gauge<\/span><\/li>\n
                      3. <\/b> Key influencers visual<\/span><\/li>\n
                      4. <\/b> Donut chart<\/span><\/li>\n<\/ol>\n

                        Correct Answer: 3. Key influencers visual<\/b><\/p>\n

                        Explanation:<\/b> The Key influencers visual helps identify factors that influence a selected metric or outcome. It analyzes data to highlight conditions or characteristics associated with increases, decreases, or specific categorical results. This can be useful for understanding factors related to customer satisfaction, sales performance, churn, or other business outcomes. A Card displays a single summary value, while a Gauge compares a metric with a target. A Donut chart shows proportions among categories. The Key influencers visual is specifically intended for exploratory analysis that helps users understand which variables are most strongly associated with the metric being examined.<\/span><\/p>\n

                        Q12. You need to compare sales performance for multiple product categories across several months while emphasizing changes in rank. Which visual should you use?<\/b><\/p>\n

                          \n
                        1. <\/b> Ribbon chart<\/span><\/li>\n
                        2. <\/b> Card<\/span><\/li>\n
                        3. <\/b> Gauge<\/span><\/li>\n
                        4. <\/b> KPI visual<\/span><\/li>\n<\/ol>\n

                          Correct Answer: 1. Ribbon chart<\/b><\/p>\n

                          Explanation:<\/b> A Ribbon chart is designed to show how the ranking of categories changes over time or across an ordered dimension. Each ribbon represents a category, and its position changes as the relative ranking changes. This makes the visual useful when you need to see which product categories move up or down in sales rank across months. A Card displays one value, a Gauge shows progress toward a target, and a KPI visual focuses on performance against a goal or trend. For comparative ranking analysis across multiple periods, the Ribbon chart provides a clear visual representation of changing category positions.<\/span><\/p>\n

                          Q13. You have several queries that connect to the same SQL database. You want to centrally manage the server name so it can be changed once instead of editing every query. What should you use?<\/b><\/p>\n

                            \n
                          1. <\/b> Visual interactions<\/span><\/li>\n
                          2. <\/b> Hierarchies<\/span><\/li>\n
                          3. <\/b> Row-level security<\/span><\/li>\n
                          4. <\/b> Power Query parameters<\/span><\/li>\n<\/ol>\n

                            Correct Answer: 4. Power Query parameters<\/b><\/p>\n

                            Explanation:<\/b> Power Query parameters allow you to define reusable values that can be referenced in queries. For example, you can create a parameter for the SQL Server name and use it in multiple data source connections. If the server changes, you update the parameter rather than modifying every query individually. Parameters can also support development, testing, and production environments or configurable date ranges. Visual interactions affect report visuals, hierarchies organize fields for drill-down, and row-level security restricts data visibility. Parameters are the appropriate tool for centrally managing reusable query values and improving maintainability.<\/span><\/p>\n

                            Q14. You need to create a DAX measure that returns the highest sales amount visible in the current filter context. Which function should you use?<\/b><\/p>\n

                              \n
                            1. <\/b> MIN<\/span><\/li>\n
                            2. <\/b> COUNT<\/span><\/li>\n
                            3. <\/b> MAX<\/span><\/li>\n
                            4. <\/b> DISTINCT<\/span><\/li>\n<\/ol>\n

                              Correct Answer: 3. MAX<\/b><\/p>\n

                              Explanation:<\/b> MAX returns the largest value found in a numeric or date column within the current filter context. When used in a measure, the result can change based on slicers, filters, and relationships. For example, if users filter the report to a specific region, MAX can return the highest sales amount only for transactions in that region. MIN returns the smallest value, while COUNT counts nonblank entries. DISTINCT returns unique values rather than the greatest value. MAX is therefore the appropriate function when the requirement is to identify the highest numeric value under the currently applied report filters.<\/span><\/p>\n

                              Q15. You need to ensure that a sales representative can view only customers assigned to that representative. The user-to-representative mapping changes over time, and you want a scalable security solution. What should you implement?<\/b><\/p>\n

                                \n
                              1. <\/b> Dynamic row-level security<\/span><\/li>\n
                              2. <\/b> Conditional formatting<\/span><\/li>\n
                              3. <\/b> Report page tooltips<\/span><\/li>\n
                              4. <\/b> Personal bookmarks<\/span><\/li>\n<\/ol>\n

                                Correct Answer: 1. Dynamic row-level security<\/b><\/p>\n

                                Explanation:<\/b> Dynamic row-level security allows the same security role to return different rows depending on the signed-in user. A mapping table can associate user accounts with representatives, regions, or other organizational entities, and DAX functions such as USERPRINCIPALNAME can be used to identify the current user. This approach is more scalable than creating a separate static role for every salesperson. Conditional formatting changes appearance, tooltips provide contextual information, and personal bookmarks save individual report states. When data access requirements vary by user and the mappings may change, dynamic RLS provides a centralized and maintainable security design.<\/span><\/p>\n

                                Q16. A large imported table includes ten years of data, but users primarily analyze the most recent two years. Which feature can reduce refresh processing by refreshing only newer partitions after the initial load?<\/b><\/p>\n

                                  \n
                                1. <\/b> Drillthrough<\/span><\/li>\n
                                2. <\/b> Incremental refresh<\/span><\/li>\n
                                3. <\/b> Sync slicers<\/span><\/li>\n
                                4. <\/b> Conditional formatting<\/span><\/li>\n<\/ol>\n

                                  Correct Answer: 2. Incremental refresh<\/b><\/p>\n

                                  Explanation:<\/b> Incremental refresh partitions large tables according to a date or date\/time field and allows Power BI to refresh only the most recent data after the initial load. Historical partitions that are unlikely to change can remain untouched, which reduces refresh duration and resource usage. This is especially helpful for large fact tables containing many years of transactions. Drillthrough provides detailed report navigation, Sync slicers maintains filter selections between pages, and conditional formatting changes visual appearance. Incremental refresh addresses the data management and performance requirement directly by limiting refresh operations to the portions of the data that require updates.<\/span><\/p>\n

                                  Q17. You want to transform columns named January, February, and March into two columns named Month and SalesAmount. Which Power Query transformation should you use?<\/b><\/p>\n

                                    \n
                                  1. <\/b> Merge Columns<\/span><\/li>\n
                                  2. <\/b> Pivot Column<\/span><\/li>\n
                                  3. <\/b> Split Column<\/span><\/li>\n
                                  4. <\/b> Unpivot Columns<\/span><\/li>\n<\/ol>\n

                                    Correct Answer: 4. Unpivot Columns<\/b><\/p>\n

                                    Explanation:<\/b> Unpivot Columns transforms multiple columns into attribute-value row pairs. In this example, January, February, and March can be converted into a Month column containing the month names and a SalesAmount column containing the corresponding values. This produces a normalized structure that is generally better suited for analytical models and time-based reporting. Pivot Column performs the opposite type of transformation by turning row values into separate columns. Merge Columns combines text or field values, while Split Column divides one field into several fields. Unpivoting is particularly useful when source spreadsheets store time periods across separate columns.<\/span><\/p>\n

                                    Q18. You need a measure that returns the number of days between OrderDate and ShipDate for each record before averaging the result. Which DAX iterator can evaluate an expression row by row and then return an average?<\/b><\/p>\n

                                      \n
                                    1. <\/b> AVERAGEX<\/span><\/li>\n
                                    2. <\/b> DISTINCTCOUNT<\/span><\/li>\n
                                    3. <\/b> TOTALYTD<\/span><\/li>\n
                                    4. <\/b> SELECTEDVALUE<\/span><\/li>\n<\/ol>\n

                                      Correct Answer: 1. AVERAGEX<\/b><\/p>\n

                                      Explanation:<\/b> AVERAGEX is an iterator function that evaluates an expression for each row of a specified table and then calculates the average of those results. In this scenario, the expression could calculate the difference between OrderDate and ShipDate for every sales record. AVERAGEX would then return the average shipping duration across the rows visible in the current filter context. DISTINCTCOUNT counts unique values, TOTALYTD performs a year-to-date calculation, and SELECTEDVALUE returns a single selected value when one exists. Iterator functions ending in X are useful when a calculation must first be performed at the row level before aggregation.<\/span><\/p>\n

                                      Q19. A business user wants to explore sales by Year, Quarter, Month, and Day using drill-down in the same visual. What should you configure?<\/b><\/p>\n

                                        \n
                                      1. <\/b> A report tooltip<\/span><\/li>\n
                                      2. <\/b> A date hierarchy<\/span><\/li>\n
                                      3. <\/b> Row-level security<\/span><\/li>\n
                                      4. <\/b> A gateway cluster<\/span><\/li>\n<\/ol>\n

                                        Correct Answer: 2. A date hierarchy<\/b><\/p>\n

                                        Explanation:<\/b> A hierarchy organizes related fields into levels that users can drill through in visuals. A date hierarchy can contain Year, Quarter, Month, and Day, allowing users to move from high-level summaries to more detailed time periods. This provides an intuitive exploration experience without requiring separate visuals for each level. Report tooltips show additional information on hover, row-level security controls access to data, and gateway clusters provide resilient connectivity to on-premises sources. For interactive drill-down across ordered date levels, a hierarchy is the appropriate model and report design feature.<\/span><\/p>\n

                                        Q20. Your report contains a detailed table with thousands of rows. Users want to focus on records where SalesAmount is greater than 10,000. Which feature should you use?<\/b><\/p>\n

                                          \n
                                        1. <\/b> Bookmark<\/span><\/li>\n
                                        2. <\/b> Conditional formatting only<\/span><\/li>\n
                                        3. <\/b> Visual-level filter<\/span><\/li>\n
                                        4. <\/b> Data category<\/span><\/li>\n<\/ol>\n

                                          Correct Answer: 3. Visual-level filter<\/b><\/p>\n

                                          Explanation:<\/b> A visual-level filter restricts the data displayed by a specific visual without necessarily affecting other visuals on the page. You can configure the SalesAmount field to show only records greater than 10,000, allowing users to focus on high-value transactions in the detailed table. Conditional formatting can visually highlight values but does not remove rows that fail the condition. A bookmark captures a report state, while a data category helps Power BI interpret special data types such as geographic fields or web URLs. For limiting rows in one visual according to a numeric condition, a visual-level filter is the appropriate choice.<\/span><\/p>\n

                                           <\/p>\n","protected":false},"excerpt":{"rendered":"

                                            View Full ServiceNow CIS-ITSM Exam Dumps and Practice Test Dumps. Q1. You are using Power Query to import a table that contains duplicate rows. You need to ensure that only unique rows are loaded into the model. Which transformation should you use? Remove Duplicates Replace Values Fill Down Group By Correct Answer: 1. Remove […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1648,1647],"tags":[],"_links":{"self":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16459"}],"collection":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/comments?post=16459"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16459\/revisions"}],"predecessor-version":[{"id":16496,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16459\/revisions\/16496"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=16459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=16459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=16459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}