{"id":16471,"date":"2026-09-19T07:30:15","date_gmt":"2026-09-19T07:30:15","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=16471"},"modified":"2026-09-19T07:30:15","modified_gmt":"2026-09-19T07:30:15","slug":"servicenow-cis-itsm-practice-test-questions-and-exam-dumps-part16-q301-320","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/servicenow-cis-itsm-practice-test-questions-and-exam-dumps-part16-q301-320\/","title":{"rendered":"ServiceNow CIS-ITSM Practice Test Questions and Exam Dumps Part16 Q301-320"},"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 importing a customer table that contains one column with values such as “London, United Kingdom” and “Paris, France”. You need separate City and Country columns. Which Power Query transformation should you use?<\/b><\/p>\n

    \n
  1. <\/b> Group By<\/span><\/li>\n
  2. <\/b> Unpivot Columns<\/span><\/li>\n
  3. <\/b> Split Column by Delimiter<\/span><\/li>\n
  4. <\/b> Pivot Column<\/span><\/li>\n<\/ol>\n

    Correct Answer: 3. Split Column by Delimiter<\/b><\/p>\n

    Explanation:<\/b> Split Column by Delimiter is appropriate when a text field contains multiple attributes separated by a consistent character such as a comma. In this scenario, the transformation can separate City and Country into individual columns, which makes each field available independently for filtering, mapping, grouping, and modeling. Group By aggregates rows, Unpivot converts columns into attribute-value rows, and Pivot turns row values into columns. Separating combined attributes during data preparation generally produces a cleaner semantic model and improves the usability of geographic fields in Power BI reports.<\/span><\/p>\n

    Q2. You need a DAX measure that calculates sales only for transactions where the DiscountAmount is greater than zero. Which approach is most appropriate?<\/b><\/p>\n

      \n
    1. <\/b> CALCULATE with a filter condition on DiscountAmount<\/span><\/li>\n
    2. <\/b> CONCATENATE SalesAmount and DiscountAmount<\/span><\/li>\n
    3. <\/b> FORMAT the DiscountAmount column<\/span><\/li>\n
    4. <\/b> Create a hierarchy containing DiscountAmount<\/span><\/li>\n<\/ol>\n

      Correct Answer: 1. CALCULATE with a filter condition on DiscountAmount<\/b><\/p>\n

      Explanation:<\/b> CALCULATE evaluates an expression under a modified filter context. You can use it to calculate total sales while adding a condition such as Sales[DiscountAmount] > 0. This allows the result to remain responsive to other report filters such as date, region, or product. CONCATENATE is a text function, FORMAT changes how a value is displayed, and a hierarchy organizes fields for drill-down. When a measure needs to evaluate an aggregation for a subset of rows based on a business condition, CALCULATE is a central DAX function for implementing that logic.<\/span><\/p>\n

      Q3. A company stores monthly performance targets in one table and actual transaction data in another. The targets are defined only at Region and Month level. What should you do when modeling the target table?<\/b><\/p>\n

        \n
      1. <\/b> Relate it directly to individual transaction IDs.<\/span><\/li>\n
      2. <\/b> Duplicate every target row for each sales transaction.<\/span><\/li>\n
      3. <\/b> Convert the target amount to text.<\/span><\/li>\n
      4. <\/b> Preserve its Region-Month grain and relate it through appropriate dimensions.<\/span><\/li>\n<\/ol>\n

        Correct Answer: 4. Preserve its Region-Month grain and relate it through appropriate dimensions.<\/b><\/p>\n

        Explanation:<\/b> A fact table should retain the level of detail at which its values are defined. If targets exist at Region and Month level, the model should not imply that they exist at transaction or product level. Appropriate Date and Region dimensions can filter both target and actual data while calculations respect the different grains. Duplicating target values across transactions could lead to overcounting, while text conversion does not solve modeling issues. Accurately documenting and preserving fact-table grain is essential for reliable calculations and meaningful comparisons between actual and target values.<\/span><\/p>\n

        Q4. You want users to compare the distribution of sales values across several numeric ranges rather than viewing every individual sales value. Which feature is most useful?<\/b><\/p>\n

          \n
        1. <\/b> Drillthrough<\/span><\/li>\n
        2. <\/b> Binning<\/span><\/li>\n
        3. <\/b> Sensitivity labels<\/span><\/li>\n
        4. <\/b> Page navigation<\/span><\/li>\n<\/ol>\n

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

          Explanation:<\/b> Binning groups continuous numeric values into intervals, making it easier to analyze distributions. Instead of displaying hundreds of individual SalesAmount values, Power BI can group them into ranges such as 0-999, 1,000-1,999, and so on. This is useful for histogram-like analysis and understanding concentration, spread, or outliers. Drillthrough provides detail-page navigation, sensitivity labels classify information, and page navigation moves users among report pages. Binning is specifically intended for converting continuous numeric values into meaningful analytical ranges.<\/span><\/p>\n

          Q5. A report uses several measures that all require the same year-over-year comparison logic. You want to avoid creating a separate YoY measure for each base measure. Which modeling feature can help?<\/b><\/p>\n

            \n
          1. <\/b> Calculation groups<\/span><\/li>\n
          2. <\/b> Query dependencies<\/span><\/li>\n
          3. <\/b> Visual-level filters<\/span><\/li>\n
          4. <\/b> Data source privacy levels<\/span><\/li>\n<\/ol>\n

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

            Explanation:<\/b> Calculation groups allow reusable calculation logic to be applied across multiple measures. Instead of creating separate year-over-year, year-to-date, and previous-year versions of every base measure, a model author can define calculation items that modify the selected measure dynamically. This reduces duplicated DAX and helps ensure consistent logic across the semantic model. Query dependencies relate to Power Query structure, visual filters affect individual visuals, and privacy levels govern source combinations. Calculation groups are especially valuable in models with many measures and repeated time-intelligence patterns.<\/span><\/p>\n

            Q6. You are troubleshooting a report where selecting a product unexpectedly filters a customer visual through several relationships. What should you inspect first?<\/b><\/p>\n

              \n
            1. <\/b> Report theme colors<\/span><\/li>\n
            2. <\/b> Page dimensions<\/span><\/li>\n
            3. <\/b> Relationship cross-filter directions and filter paths<\/span><\/li>\n
            4. <\/b> Mobile layout<\/span><\/li>\n<\/ol>\n

              Correct Answer: 3. Relationship cross-filter directions and filter paths<\/b><\/p>\n

              Explanation:<\/b> Unexpected filtering is often caused by relationship configuration, particularly bidirectional cross-filtering or multiple filter paths through the model. Inspecting relationship directions and how filters propagate between dimensions and fact tables can reveal why a product selection affects a customer visual. Report themes, page dimensions, and mobile layouts control presentation rather than semantic filtering. Clear star-schema relationships with deliberate filter directions make model behavior easier to understand. Bidirectional filtering should generally be used only when the business requirement justifies it and the potential for ambiguous propagation has been evaluated.<\/span><\/p>\n

              Q7. You need to create a measure that returns the value selected from a single-value slicer containing currency codes such as USD, EUR, and GBP. Which DAX function is most appropriate?<\/b><\/p>\n

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

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

                Explanation:<\/b> SELECTEDVALUE returns the single value in the current filter context and can also return an alternate result when no value or multiple values are selected. This makes it ideal for slicer-driven logic involving currencies, scenarios, metrics, or thresholds. SUMX performs iterative summation, DISTINCTCOUNT counts unique values, and PATH supports parent-child hierarchy scenarios. A measure can retrieve the selected currency code using SELECTEDVALUE and then use SWITCH or other conditional logic to apply the appropriate conversion or calculation.<\/span><\/p>\n

                Q8. You need to compare actual expenses and planned expenses by department in a compact tabular view that includes totals and subtotals. Which visual should you use?<\/b><\/p>\n

                  \n
                1. <\/b> Scatter chart<\/span><\/li>\n
                2. <\/b> Matrix<\/span><\/li>\n
                3. <\/b> Gauge<\/span><\/li>\n
                4. <\/b> Funnel chart<\/span><\/li>\n<\/ol>\n

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

                  Explanation:<\/b> A Matrix visual is designed for structured tabular analysis and supports rows, columns, hierarchies, subtotals, and grand totals. It is well suited to comparing Actual and Planned Expense measures across departments while preserving detailed and summarized views. Scatter charts show relationships between numeric variables, Gauges compare a metric to a target, and Funnel charts represent sequential processes. When users need exact values, multiple measures, and subtotal behavior in the same visual, a Matrix provides the strongest fit.<\/span><\/p>\n

                  Q9. You import a column containing values “TRUE”, “FALSE”, and blanks as text. You need to use it as a logical field in the model. What should you do?<\/b><\/p>\n

                    \n
                  1. <\/b> Convert the column to a decimal number.<\/span><\/li>\n
                  2. <\/b> Leave it as text permanently.<\/span><\/li>\n
                  3. <\/b> Clean the values and convert the column to True\/False.<\/span><\/li>\n
                  4. <\/b> Create a many-to-many relationship.<\/span><\/li>\n<\/ol>\n

                    Correct Answer: 3. Clean the values and convert the column to True\/False.<\/b><\/p>\n

                    Explanation:<\/b> When a source contains logical values stored as text, the data should be standardized and converted to the appropriate True\/False data type when the business meaning supports it. Blank values should also be handled according to the business rule, such as keeping them null or replacing them with a defined default. A decimal type is inappropriate for logical data, and leaving the values as text reduces semantic clarity. Relationships are unrelated to correcting the field’s data type. Proper data typing improves consistency and helps Power BI interpret fields correctly.<\/span><\/p>\n

                    Q10. A report must show the percentage of employees who completed training out of the total number of employees. Which DAX function is safest for the division?<\/b><\/p>\n

                      \n
                    1. <\/b> SUM<\/span><\/li>\n
                    2. <\/b> RELATED<\/span><\/li>\n
                    3. <\/b> CONCATENATE<\/span><\/li>\n
                    4. <\/b> DIVIDE<\/span><\/li>\n<\/ol>\n

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

                      Explanation:<\/b> DIVIDE is designed for division in DAX and handles zero or blank denominators safely. A completion-rate measure can divide the number of employees who completed training by the total employee count without risking division errors. DIVIDE can return BLANK() or an optional alternate value if the denominator is zero. SUM aggregates numeric values, RELATED retrieves values from a related table, and CONCATENATE combines text. Ratios and percentages are common Power BI calculations, and DIVIDE is generally preferred when the denominator may be zero or unavailable.<\/span><\/p>\n

                      Q11. A table contains many duplicate records because the same file was imported twice. You need to preserve only one copy of each completely identical row. What should you do in Power Query?<\/b><\/p>\n

                        \n
                      1. <\/b> Pivot the table.<\/span><\/li>\n
                      2. <\/b> Remove Duplicates across the relevant columns.<\/span><\/li>\n
                      3. <\/b> Create a calculated measure.<\/span><\/li>\n
                      4. <\/b> Add a report filter.<\/span><\/li>\n<\/ol>\n

                        Correct Answer: 2. Remove Duplicates across the relevant columns.<\/b><\/p>\n

                        Explanation:<\/b> Remove Duplicates eliminates repeated records based on the selected columns. If duplicate rows resulted from importing the same data twice, selecting the columns that define row uniqueness and removing duplicates can restore the correct dataset. Pivoting changes the shape of data, while measures and report filters do not remove duplicate records from the semantic model. Duplicate removal should be used only after confirming that repeated rows are genuinely erroneous rather than valid repeated transactions. Data-quality corrections are generally best performed before the data is loaded.<\/span><\/p>\n

                        Q12. You need to create a DAX measure that returns total sales while preserving an existing Region filter and adding a filter for Product Category = “Premium”. Which function allows the added filter to intersect with existing filters instead of replacing them?<\/b><\/p>\n

                          \n
                        1. <\/b> KEEPFILTERS<\/span><\/li>\n
                        2. <\/b> FORMAT<\/span><\/li>\n
                        3. <\/b> CALENDAR<\/span><\/li>\n
                        4. <\/b> SUBSTITUTE<\/span><\/li>\n<\/ol>\n

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

                          Explanation:<\/b> KEEPFILTERS changes how a filter argument in CALCULATE interacts with the existing filter context. Instead of replacing an existing filter on the same column or table, it causes the new condition to intersect with the current filtering. This can be useful when a calculation should narrow an already filtered set rather than overwrite it. FORMAT changes presentation, CALENDAR creates date tables, and SUBSTITUTE modifies text. Understanding how filters are added, replaced, or preserved is important for building precise DAX measures in complex reports.<\/span><\/p>\n

                          Q13. A report contains many visuals, and users want to view only the data associated with a single chart in a larger workspace temporarily. Which capability should they use?<\/b><\/p>\n

                            \n
                          1. <\/b> Focus mode<\/span><\/li>\n
                          2. <\/b> Incremental refresh<\/span><\/li>\n
                          3. <\/b> Deployment pipelines<\/span><\/li>\n
                          4. <\/b> Data source settings<\/span><\/li>\n<\/ol>\n

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

                            Explanation:<\/b> Focus mode enlarges a selected visual so users can analyze it with more screen space while remaining within the Power BI report experience. This is useful when a visual contains many categories or detailed labels that are difficult to examine at the original page size. Incremental refresh optimizes semantic model refresh, deployment pipelines support lifecycle management, and data source settings control connections and credentials. Focus mode improves report consumption without requiring the report designer to create a separate page for every detailed visual.<\/span><\/p>\n

                            Q14. You need a Power Query transformation that replaces all occurrences of “Unknown” in a Region column with null. Which operation should you use?<\/b><\/p>\n

                              \n
                            1. <\/b> Group By<\/span><\/li>\n
                            2. <\/b> Replace Values<\/span><\/li>\n
                            3. <\/b> Unpivot Columns<\/span><\/li>\n
                            4. <\/b> Append Queries<\/span><\/li>\n<\/ol>\n

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

                              Explanation:<\/b> Replace Values is designed to substitute one value with another in a Power Query column. In this case, “Unknown” can be replaced with null so the data accurately represents the absence of a known region. Group By aggregates records, Unpivot transforms columns into rows, and Append combines rows from multiple tables. Standardizing placeholder text such as “Unknown”, “N\/A”, or “-” can improve data quality, but the chosen replacement should reflect the intended business meaning and downstream reporting requirements.<\/span><\/p>\n

                              Q15. You need to return the second-highest sales value from a table by first ranking or selecting a subset of rows. Which DAX table function could be part of the solution?<\/b><\/p>\n

                                \n
                              1. <\/b> TOPN<\/span><\/li>\n
                              2. <\/b> CONCATENATE<\/span><\/li>\n
                              3. <\/b> PATHLENGTH<\/span><\/li>\n
                              4. <\/b> DATE<\/span><\/li>\n<\/ol>\n

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

                                Explanation:<\/b> TOPN returns a specified number of rows from a table based on an ordering expression. It can be used as part of a DAX pattern to retrieve the highest two sales rows, after which another function can identify the lower of those two values as the second-highest result. CONCATENATE is a text function, PATHLENGTH works with parent-child hierarchy paths, and DATE constructs a date value. TOPN is useful for calculations involving ranked subsets, such as top customers, second-highest values, or best-performing categories.<\/span><\/p>\n

                                Q16. A company wants a report distributed to many users, but those users should consume a curated experience rather than work directly inside the source workspace. Which feature should you use?<\/b><\/p>\n

                                  \n
                                1. <\/b> Calculation group<\/span><\/li>\n
                                2. <\/b> Power BI app<\/span><\/li>\n
                                3. <\/b> Query parameter<\/span><\/li>\n
                                4. <\/b> Custom column<\/span><\/li>\n<\/ol>\n

                                  Correct Answer: 2. Power BI app<\/b><\/p>\n

                                  Explanation:<\/b> A Power BI app provides a curated distribution experience for reports, dashboards, and related content. Content creators continue working in the source workspace while consumers access the published app without requiring broad workspace permissions. This separates authoring from consumption and supports governance for larger audiences. Calculation groups are modeling features, query parameters make data preparation configurable, and custom columns add derived row-level data. Apps are specifically designed for packaging and distributing approved Power BI content to users.<\/span><\/p>\n

                                  Q17. You are creating a model where one customer can belong to multiple account groups and each account group can contain multiple customers. Which structure can explicitly manage these assignments?<\/b><\/p>\n

                                    \n
                                  1. <\/b> A bridge table<\/span><\/li>\n
                                  2. <\/b> A report tooltip<\/span><\/li>\n
                                  3. <\/b> A visual hierarchy<\/span><\/li>\n
                                  4. <\/b> A sensitivity label<\/span><\/li>\n<\/ol>\n

                                    Correct Answer: 1. A bridge table<\/b><\/p>\n

                                    Explanation:<\/b> A bridge table can represent valid many-to-many associations by containing one row for each Customer-Account Group combination. It can then relate separately to the Customer and Account Group dimensions, making the relationship structure more explicit and easier to manage. Tooltips and visual hierarchies affect report interaction rather than model relationships, while sensitivity labels classify content. Bridge tables are commonly used in dimensional modeling when two entities legitimately have multiple associations and direct one-to-many relationships are insufficient.<\/span><\/p>\n

                                    Q18. A report contains a chart with monthly values. You want users to see a moving average across the most recent three months rather than only raw monthly values. Which approach is appropriate?<\/b><\/p>\n

                                      \n
                                    1. <\/b> Create a three-month rolling measure or visual calculation.<\/span><\/li>\n
                                    2. <\/b> Convert Month to Boolean.<\/span><\/li>\n
                                    3. <\/b> Use a geographic hierarchy.<\/span><\/li>\n
                                    4. <\/b> Apply row-level security.<\/span><\/li>\n<\/ol>\n

                                      Correct Answer: 1. Create a three-month rolling measure or visual calculation.<\/b><\/p>\n

                                      Explanation:<\/b> A moving average evaluates a metric across a rolling window, such as the current month plus the previous two months. This can be implemented with DAX using date-filter logic or, where suitable, a visual calculation. Moving averages smooth short-term fluctuations and help users identify broader trends. Boolean conversion, geographic hierarchies, and row-level security are unrelated to rolling analytical calculations. A proper Date table and clear definition of the rolling window are important for producing consistent results.<\/span><\/p>\n

                                      Q19. A business requires users to see the report title, visual titles, and screen-reader descriptions in an accessible report. Which design feature should you configure for visuals?<\/b><\/p>\n

                                        \n
                                      1. <\/b> Alt text<\/span><\/li>\n
                                      2. <\/b> Query folding<\/span><\/li>\n
                                      3. <\/b> Data source credentials<\/span><\/li>\n
                                      4. <\/b> Incremental refresh<\/span><\/li>\n<\/ol>\n

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

                                        Explanation:<\/b> Alt text provides a textual description of a visual that can be interpreted by screen readers, helping users with visual impairments understand the purpose or content of the visual. Accessible report design also includes logical tab order, sufficient contrast, readable fonts, and avoiding reliance on color alone. Query folding and incremental refresh relate to data processing, while source credentials control authentication. Adding meaningful alt text supports inclusive report consumption and is an important Power BI accessibility practice.<\/span><\/p>\n

                                        Q20. A semantic model contains a Date table with every date for several years. You need to create a calculated column that returns the fiscal quarter based on a fiscal year starting in July. What is the most appropriate approach?<\/b><\/p>\n

                                          \n
                                        1. <\/b> Use a geographic data category.<\/span><\/li>\n
                                        2. <\/b> Create a bookmark for each quarter.<\/span><\/li>\n
                                        3. <\/b> Use conditional DAX or Power Query logic based on the month number.<\/span><\/li>\n
                                        4. <\/b> Enable bidirectional filtering.<\/span><\/li>\n<\/ol>\n

                                          Correct Answer: 3. Use conditional DAX or Power Query logic based on the month number.<\/b><\/p>\n

                                          Explanation:<\/b> A fiscal calendar that starts in July does not align with standard calendar quarters, so custom logic is needed. The month number can be mapped to fiscal quarters\u2014for example, July through September as Fiscal Q1 and October through December as Fiscal Q2. This can be created in Power Query during data preparation or as a calculated column in the Date table. Geographic categories, bookmarks, and bidirectional filtering do not define fiscal periods. A well-designed Date dimension should contain the fiscal attributes required by business reporting.<\/span><\/p>\n

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

                                            View Full ServiceNow CIS-ITSM Exam Dumps and Practice Test Dumps. Q1. You are importing a customer table that contains one column with values such as “London, United Kingdom” and “Paris, France”. You need separate City and Country columns. Which Power Query transformation should you use? Group By Unpivot Columns Split Column by Delimiter Pivot […]<\/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\/16471"}],"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=16471"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16471\/revisions"}],"predecessor-version":[{"id":16484,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16471\/revisions\/16484"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=16471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=16471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=16471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}