{"id":16466,"date":"2026-09-19T07:31:06","date_gmt":"2026-09-19T07:31:06","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=16466"},"modified":"2026-09-19T07:31:06","modified_gmt":"2026-09-19T07:31:06","slug":"servicenow-cis-itsm-practice-test-questions-and-exam-dumps-part11-q201-220","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/servicenow-cis-itsm-practice-test-questions-and-exam-dumps-part11-q201-220\/","title":{"rendered":"ServiceNow CIS-ITSM Practice Test Questions and Exam Dumps Part11 Q201-220"},"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 creating a Power BI model that contains Sales and Returns fact tables. Both tables need to be analyzed by the same Product, Customer, and Date dimensions. Which modeling approach is most appropriate?<\/b><\/p>\n

    \n
  1. <\/b> Create duplicate dimensions for each fact table.<\/span><\/li>\n
  2. <\/b> Use shared dimension tables connected to both fact tables.<\/span><\/li>\n
  3. <\/b> Combine every table into one flat table.<\/span><\/li>\n
  4. <\/b> Leave the fact tables disconnected from dimensions.<\/span><\/li>\n<\/ol>\n

    Correct Answer: 2. Use shared dimension tables connected to both fact tables.<\/b><\/p>\n

    Explanation:<\/b> Shared dimensions are commonly used when multiple fact tables describe different business processes but use the same descriptive entities. Product, Customer, and Date can each serve as conformed dimensions that filter both Sales and Returns. This supports consistent reporting and allows measures from different fact tables to be compared using the same categories. Duplicating dimensions creates unnecessary redundancy, while flattening everything into one table can make maintenance difficult. Disconnected fact tables would also prevent consistent filtering. Using shared dimensions is a strong dimensional-modeling approach for multi-fact semantic models.<\/span><\/p>\n

    Q2. You need a DAX measure that returns the first nonblank value of a product price based on the current context. Which function should you consider?<\/b><\/p>\n

      \n
    1. <\/b> FIRSTNONBLANK<\/span><\/li>\n
    2. <\/b> SUMX<\/span><\/li>\n
    3. <\/b> CONCATENATEX<\/span><\/li>\n
    4. <\/b> RANKX<\/span><\/li>\n<\/ol>\n

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

      Explanation:<\/b> FIRSTNONBLANK returns the first value in a column for which an expression evaluates to a nonblank result. It can be useful when a calculation needs to identify an available value based on the current filter context. SUMX is an iterator used to sum row-level expressions, CONCATENATEX joins text values from multiple rows, and RANKX ranks items according to an expression. FIRSTNONBLANK should be used carefully because the concept of “first” depends on the evaluation context and ordering logic, but it is the appropriate function among these choices for retrieving an initial nonblank value.<\/span><\/p>\n

      Q3. You have a Power Query table containing several columns that should be combined into a single text value such as FirstName and LastName. Which transformation should you use?<\/b><\/p>\n

        \n
      1. <\/b> Unpivot Columns<\/span><\/li>\n
      2. <\/b> Merge Columns<\/span><\/li>\n
      3. <\/b> Group By<\/span><\/li>\n
      4. <\/b> Fill Down<\/span><\/li>\n<\/ol>\n

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

        Explanation:<\/b> Merge Columns combines values from multiple columns into a single column using a selected separator. For example, FirstName and LastName can be merged using a space to create a FullName field. Unpivot Columns converts columns into attribute-value rows, Group By summarizes records, and Fill Down copies previous nonblank values into blank rows. Merge Columns is appropriate when several text fields need to be combined into one display or key value. Before merging, it is useful to confirm that nulls, spaces, and data types are handled correctly to avoid unexpected output.<\/span><\/p>\n

        Q4. You need users to compare two measures with different scales, such as Revenue and Margin Percentage, in a single visual. Which visual is most appropriate?<\/b><\/p>\n

          \n
        1. <\/b> Donut chart<\/span><\/li>\n
        2. <\/b> Matrix<\/span><\/li>\n
        3. <\/b> Combo chart with a secondary axis<\/span><\/li>\n
        4. <\/b> Treemap<\/span><\/li>\n<\/ol>\n

          Correct Answer: 3. Combo chart with a secondary axis<\/b><\/p>\n

          Explanation:<\/b> A combo chart can combine columns and lines and can use a secondary axis when measures have different scales. Revenue may be displayed as columns while Margin Percentage is shown as a line, making both measures readable despite their different units. A Donut chart is best for proportions, while a Matrix is useful for detailed tabular analysis. A Treemap displays category proportions using area. When users need to compare a large monetary measure and a percentage trend in the same time-based visual, a combo chart with a secondary axis is generally suitable.<\/span><\/p>\n

          Q5. You are creating a calculated column that should return “High” when SalesAmount exceeds 10,000 and “Standard” otherwise. Which DAX function is most appropriate?<\/b><\/p>\n

            \n
          1. <\/b> DIVIDE<\/span><\/li>\n
          2. <\/b> ALL<\/span><\/li>\n
          3. <\/b> DATEADD<\/span><\/li>\n
          4. <\/b> IF<\/span><\/li>\n<\/ol>\n

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

            Explanation:<\/b> IF evaluates a logical condition and returns one result when the condition is true and another result when it is false. In this scenario, IF can test whether SalesAmount is greater than 10,000 and return “High” or “Standard.” DIVIDE is used for safe division, ALL modifies filter behavior, and DATEADD shifts date context. IF is well suited to straightforward two-outcome business logic in calculated columns or measures. For scenarios involving many possible categories, SWITCH may sometimes be easier to maintain, but IF is the clearest solution for a simple binary condition.<\/span><\/p>\n

            Q6. A Power BI report contains several slicers, and you want one button to return all slicers and visuals to a predefined default state. Which feature should you use?<\/b><\/p>\n

              \n
            1. <\/b> A bookmark linked to a button.<\/span><\/li>\n
            2. <\/b> Incremental refresh.<\/span><\/li>\n
            3. <\/b> Query folding.<\/span><\/li>\n
            4. <\/b> A calculated table.<\/span><\/li>\n<\/ol>\n

              Correct Answer: 1. A bookmark linked to a button.<\/b><\/p>\n

              Explanation:<\/b> A bookmark can capture a predefined report state, including slicer selections, filters, and certain visual states. By linking that bookmark to a button, users can quickly reset the report to the saved configuration. Incremental refresh manages data-refresh partitions, while query folding affects Power Query execution at the source. A calculated table creates data in the semantic model and does not reset report interactions. Bookmarks are commonly used for reset buttons, navigation, alternate layouts, and guided report experiences.<\/span><\/p>\n

              Q7. You need to calculate the number of unique customers who purchased products during the selected period. Which DAX function should you use?<\/b><\/p>\n

                \n
              1. <\/b> COUNTROWS<\/span><\/li>\n
              2. <\/b> SUM<\/span><\/li>\n
              3. <\/b> DISTINCTCOUNT<\/span><\/li>\n
              4. <\/b> MAXX<\/span><\/li>\n<\/ol>\n

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

                Explanation:<\/b> DISTINCTCOUNT counts the unique values in a specified column. If customers can make several purchases during the selected period, counting rows would overstate the number of individual customers. DISTINCTCOUNT(CustomerID) ensures that each customer is counted only once within the current report filter context. SUM adds numeric values, while MAXX finds the maximum result of a row-level expression. DISTINCTCOUNT is frequently used for customer counts, unique orders, unique products, and similar metrics where identifiers may appear multiple times in the fact table.<\/span><\/p>\n

                Q8. You need to calculate sales for the previous month relative to the current date context. Which DAX function is designed for shifting date context by a specified interval?<\/b><\/p>\n

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

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

                  Explanation:<\/b> DATEADD shifts a set of dates forward or backward by a specified number of intervals, such as days, months, quarters, or years. It is commonly combined with CALCULATE to create previous-period comparisons. For example, Sales for the previous month can be calculated by shifting the current date context back one month. FORMAT changes value presentation, COUNTROWS counts table rows, and RELATED retrieves a value from a related table. A proper Date table is important for reliable date-based calculations and makes DATEADD suitable for flexible time-intelligence scenarios.<\/span><\/p>\n

                  Q9. A report designer wants a visual to display only when a specific condition is met, such as when a single customer is selected. Which DAX function can help determine whether exactly one value is filtered?<\/b><\/p>\n

                    \n
                  1. <\/b> HASONEVALUE<\/span><\/li>\n
                  2. <\/b> SUMX<\/span><\/li>\n
                  3. <\/b> UNION<\/span><\/li>\n
                  4. <\/b> PATHITEM<\/span><\/li>\n<\/ol>\n

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

                    Explanation:<\/b> HASONEVALUE returns TRUE when the current filter context contains exactly one distinct value for a specified column. It can be used in conditional measures to show meaningful results only when a single customer, product, or other entity is selected. SUMX performs iterative summation, UNION combines tables, and PATHITEM works with parent-child hierarchy paths. HASONEVALUE is particularly useful for controlling calculation output, dynamic text, and certain report interactions where a single selected value is required.<\/span><\/p>\n

                    Q10. You need to reuse the same Power Query logic across multiple Power BI solutions without recreating the transformations in every PBIX file. Which feature is most suitable?<\/b><\/p>\n

                      \n
                    1. <\/b> Report bookmarks<\/span><\/li>\n
                    2. <\/b> Dataflows<\/span><\/li>\n
                    3. <\/b> Drillthrough<\/span><\/li>\n
                    4. <\/b> Personalization of visuals<\/span><\/li>\n<\/ol>\n

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

                      Explanation:<\/b> Dataflows allow organizations to centralize and reuse Power Query-based data preparation in the Power BI service or Fabric environment. Multiple semantic models can consume the prepared entities rather than repeating the same transformations in separate files. This improves consistency and reduces duplicated maintenance effort. Bookmarks control report states, Drillthrough supports navigation to detailed pages, and visual personalization affects report consumption. Dataflows are particularly valuable when several reports or models rely on the same cleaned, standardized, or transformed source data.<\/span><\/p>\n

                      Q11. You are analyzing a parent-child employee hierarchy in which each employee row contains EmployeeID and ManagerID. Which DAX function family is designed for this type of hierarchy?<\/b><\/p>\n

                        \n
                      1. <\/b> PATH functions<\/span><\/li>\n
                      2. <\/b> Time-intelligence functions<\/span><\/li>\n
                      3. <\/b> Statistical functions only<\/span><\/li>\n
                      4. <\/b> Financial functions only<\/span><\/li>\n<\/ol>\n

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

                        Explanation:<\/b> DAX PATH functions are designed to work with parent-child hierarchies, where each row identifies both an entity and its parent. In an employee hierarchy, PATH can generate a hierarchy path from an employee through management levels, while related functions such as PATHITEM can retrieve specific members from that path. Time-intelligence functions handle date calculations, while statistical and financial functions serve other analytical purposes. Parent-child structures are common in organizational, account, and category hierarchies, and the PATH family provides specialized support for them.<\/span><\/p>\n

                        Q12. A table visual contains sales values and users need to visually compare magnitude across rows without adding another chart. Which conditional formatting option is most appropriate?<\/b><\/p>\n

                          \n
                        1. <\/b> Data bars<\/span><\/li>\n
                        2. <\/b> Drillthrough<\/span><\/li>\n
                        3. <\/b> Sync slicers<\/span><\/li>\n
                        4. <\/b> Report page tooltip<\/span><\/li>\n<\/ol>\n

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

                          Explanation:<\/b> Data bars provide an in-cell visual representation of numeric magnitude within table or matrix columns. Longer bars indicate larger values, helping users compare rows without requiring a separate chart. Drillthrough is used for navigation, Sync slicers maintains cross-page filter consistency, and report page tooltips provide hover details. Data bars are a form of conditional formatting and work especially well when users need both exact numeric values and an immediate visual comparison in the same table or matrix.<\/span><\/p>\n

                          Q13. Your semantic model contains a Date table that is not automatically recognized for time-intelligence purposes. What should you consider doing?<\/b><\/p>\n

                            \n
                          1. <\/b> Convert every date to text.<\/span><\/li>\n
                          2. <\/b> Mark the table as a date table.<\/span><\/li>\n
                          3. <\/b> Remove the Date table.<\/span><\/li>\n
                          4. <\/b> Change all relationships to many-to-many.<\/span><\/li>\n<\/ol>\n

                            Correct Answer: 2. Mark the table as a date table.<\/b><\/p>\n

                            Explanation:<\/b> Marking a table as a date table tells Power BI that the table contains the authoritative date structure for the model. This can support certain time-intelligence scenarios and ensures the designated date column meets expected requirements such as uniqueness and continuity. Converting dates to text would reduce date functionality, while removing the Date table would make many time-based calculations harder to manage. Many-to-many relationships are unrelated to date-table configuration. A dedicated and properly configured Date table improves consistency across time-based calculations and reporting.<\/span><\/p>\n

                            Q14. You need to create a measure that returns the median sales amount rather than the average. Which DAX function should you use for an existing numeric column?<\/b><\/p>\n

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

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

                              Explanation:<\/b> MEDIAN returns the middle value in a set of numeric values when they are ordered. It is useful when the average could be distorted by unusually high or low values. For example, median transaction size may better represent a typical transaction when a small number of very large purchases exist. SUM adds values, MIN returns the smallest value, and COUNT returns the number of nonblank values. Choosing the correct statistical aggregation helps ensure that a measure accurately reflects the business question being analyzed.<\/span><\/p>\n

                              Q15. A report must show how customers move through stages such as Lead, Qualified, Proposal, and Won. Which visual is generally suitable?<\/b><\/p>\n

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

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

                                Explanation:<\/b> A Funnel chart is commonly used to visualize sequential stages in a process, especially when the number of items tends to decrease as they progress. Sales pipelines, recruitment stages, and conversion processes are common examples. A Scatter chart shows relationships between numerical variables, a Gauge compares a measure to a target, and a Map displays geographic data. Funnel charts help users quickly identify where large drop-offs occur between stages and can support analysis of process effectiveness.<\/span><\/p>\n

                                Q16. Your model contains multiple measures that should use a common format depending on a selected scenario. Which modeling feature can centralize reusable calculation behavior?<\/b><\/p>\n

                                  \n
                                1. <\/b> Page navigator<\/span><\/li>\n
                                2. <\/b> Query diagnostics<\/span><\/li>\n
                                3. <\/b> Calculation groups<\/span><\/li>\n
                                4. <\/b> Mobile layout<\/span><\/li>\n<\/ol>\n

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

                                  Explanation:<\/b> Calculation groups allow reusable calculation logic to be applied across multiple measures. They can support patterns such as current period, prior period, year-to-date, variance, or dynamic formatting without creating a separate version of every measure. This reduces duplicated DAX and improves consistency. Page navigators manage report navigation, query diagnostics investigate Power Query performance, and mobile layouts optimize reports for phones. Calculation groups are a semantic-model feature designed to centralize common measure transformations and simplify complex models.<\/span><\/p>\n

                                  Q17. You need to determine whether a column contains unusually high numbers of distinct values that may increase model size. Which Power Query profiling capability is useful?<\/b><\/p>\n

                                    \n
                                  1. <\/b> Column distribution<\/span><\/li>\n
                                  2. <\/b> Bookmarks<\/span><\/li>\n
                                  3. <\/b> Drill mode<\/span><\/li>\n
                                  4. <\/b> View as role<\/span><\/li>\n<\/ol>\n

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

                                    Explanation:<\/b> Column distribution provides information about the distinct and unique values in a column. This can help identify high-cardinality fields that may affect model compression and storage, especially when the column contains IDs, timestamps, or detailed text. Bookmarks belong to report-state management, Drill mode supports hierarchy navigation, and View as role is used to test row-level security. Data profiling features such as column distribution help analysts better understand source data before deciding which fields should be loaded into the model.<\/span><\/p>\n

                                    Q18. You are testing row-level security and want to verify what a specific role can see before publishing the report. Which Power BI Desktop feature should you use?<\/b><\/p>\n

                                      \n
                                    1. <\/b> Performance Analyzer<\/span><\/li>\n
                                    2. <\/b> View as<\/span><\/li>\n
                                    3. <\/b> Query dependencies<\/span><\/li>\n
                                    4. <\/b> Data category<\/span><\/li>\n<\/ol>\n

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

                                      Explanation:<\/b> View as allows a report designer to test row-level security roles in Power BI Desktop. By selecting a role, the designer can preview the report from the perspective of users assigned to that security definition. This helps validate whether the intended rows are visible and whether filters propagate correctly through the model. Performance Analyzer measures visual performance, Query dependencies displays Power Query relationships, and data categories define field semantics. Testing security before publishing is important because incorrectly configured RLS can expose too much data or unnecessarily restrict legitimate users.<\/span><\/p>\n

                                      Q19. A report user wants to personalize a visual by changing the measure or dimension shown without editing the underlying report. Which capability can allow this when enabled by the report author?<\/b><\/p>\n

                                        \n
                                      1. <\/b> Personalize visuals<\/span><\/li>\n
                                      2. <\/b> Incremental refresh<\/span><\/li>\n
                                      3. <\/b> Query folding<\/span><\/li>\n
                                      4. <\/b> Sensitivity labels<\/span><\/li>\n<\/ol>\n

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

                                        Explanation:<\/b> Personalize visuals allows report consumers to modify certain aspects of supported visuals for their own view, such as changing the visualization type or replacing fields, when the feature is enabled. This supports self-service exploration without changing the original report for other users. Incremental refresh optimizes model refreshes, query folding affects data transformations, and sensitivity labels classify information. Personalization gives consumers additional flexibility while allowing the report author to maintain the published baseline design.<\/span><\/p>\n

                                        Q20. A report page contains many visuals and users are unsure which data points should receive attention first. You want to use color intensity based on measure values in a matrix. Which feature should you use?<\/b><\/p>\n

                                          \n
                                        1. <\/b> Drillthrough filters<\/span><\/li>\n
                                        2. <\/b> Background color conditional formatting<\/span><\/li>\n
                                        3. <\/b> Data source settings<\/span><\/li>\n
                                        4. <\/b> Deployment pipelines<\/span><\/li>\n<\/ol>\n

                                          Correct Answer: 2. Background color conditional formatting<\/b><\/p>\n

                                          Explanation:<\/b> Background color conditional formatting can apply different color intensity or rule-based colors according to measure values in a table or matrix. This can make high, low, or exceptional values stand out and help users identify important patterns quickly. Drillthrough filters control contextual navigation, data source settings manage connections and credentials, and deployment pipelines support lifecycle management. Conditional formatting should be designed carefully so that colors are meaningful, accessible, and not the only method used to communicate important information.<\/span><\/p>\n

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

                                            View Full ServiceNow CIS-ITSM Exam Dumps and Practice Test Dumps. Q1. You are creating a Power BI model that contains Sales and Returns fact tables. Both tables need to be analyzed by the same Product, Customer, and Date dimensions. Which modeling approach is most appropriate? Create duplicate dimensions for each fact table. Use shared […]<\/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\/16466"}],"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=16466"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16466\/revisions"}],"predecessor-version":[{"id":16489,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16466\/revisions\/16489"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=16466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=16466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=16466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}