{"id":16474,"date":"2026-09-19T07:29:40","date_gmt":"2026-09-19T07:29:40","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=16474"},"modified":"2026-09-19T07:29:40","modified_gmt":"2026-09-19T07:29:40","slug":"servicenow-cis-itsm-practice-test-questions-and-exam-dumps-part19-q361-380","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/servicenow-cis-itsm-practice-test-questions-and-exam-dumps-part19-q361-380\/","title":{"rendered":"ServiceNow CIS-ITSM Practice Test Questions and Exam Dumps Part19 Q361-380"},"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 create a staging query in Power Query that is referenced by three final tables. The staging query itself should not appear as a table in the semantic model. What should you configure?<\/b><\/p>\n

    \n
  1. <\/b> Delete the staging query.<\/span><\/li>\n
  2. <\/b> Convert the staging query to DirectQuery.<\/span><\/li>\n
  3. <\/b> Duplicate the staging query three times.<\/span><\/li>\n
  4. <\/b> Disable load for the staging query.<\/span><\/li>\n<\/ol>\n

    Correct Answer: 4. Disable load for the staging query.<\/b><\/p>\n

    Explanation:<\/b> Disabling load allows a Power Query query to remain available for use by other queries without loading it as a separate table into the semantic model. This is useful for staging queries that centralize common extraction or transformation logic. Deleting the query would break dependent references, while duplicating it would create unnecessary maintenance and repeated transformation logic. Changing storage mode does not address whether the query is loaded as a model table. Using staging queries with load disabled can make Power Query solutions cleaner and help prevent unnecessary tables from increasing semantic model complexity.<\/span><\/p>\n

    Q2. You need a measure for average order value. An existing [Total Revenue] measure and [Order Count] measure are available. Which DAX expression is most appropriate?<\/b><\/p>\n

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

      Correct Answer: 1. DIVIDE([Total Revenue], [Order Count])<\/b><\/p>\n

      Explanation:<\/b> Average order value is calculated by dividing total revenue by the number of orders. DIVIDE is preferable to the division operator when the denominator may be zero or blank because it safely handles that condition and can return BLANK() or an alternate result. SUM cannot be applied meaningfully to a measure in the way shown, COUNTROWS requires a table expression, and CONCATENATE produces text rather than a numeric ratio. Building the calculation from existing measures also ensures that the result responds dynamically to slicers, filters, and other report context.<\/span><\/p>\n

      Q3. A financial model contains an Account Balance measure. Users need the balance as of the last available date in each reporting period rather than the sum of all daily balances. What type of calculation is required?<\/b><\/p>\n

        \n
      1. <\/b> Fully additive calculation.<\/span><\/li>\n
      2. <\/b> Text aggregation.<\/span><\/li>\n
      3. <\/b> Semi-additive calculation.<\/span><\/li>\n
      4. <\/b> Distinct-count calculation.<\/span><\/li>\n<\/ol>\n

        Correct Answer: 3. Semi-additive calculation.<\/b><\/p>\n

        Explanation:<\/b> Account balances are typically semi-additive because they can often be aggregated across dimensions such as account or department but should not usually be summed across time. Instead, reports may need the closing balance or the last nonblank balance for the selected period. Summing daily balances would overstate the amount because each value represents a snapshot. Semi-additive logic is also common for inventory balances and headcount snapshots. Understanding whether a measure is additive, semi-additive, or non-additive is important for designing DAX calculations that accurately represent the underlying business process.<\/span><\/p>\n

        Q4. You create a new semantic model and want to quickly generate a commonly used calculation such as percent difference from a filtered value without writing all the DAX manually. Which feature should you consider?<\/b><\/p>\n

          \n
        1. <\/b> Query Diagnostics.<\/span><\/li>\n
        2. <\/b> Quick measures.<\/span><\/li>\n
        3. <\/b> Data alerts.<\/span><\/li>\n
        4. <\/b> Sensitivity labels.<\/span><\/li>\n<\/ol>\n

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

          Explanation:<\/b> Quick measures provide predefined calculation templates that can generate DAX for common analytical patterns. They can help create calculations such as running totals, percentages, differences, and other supported metrics without requiring the author to write every expression from scratch. They are also useful for learning DAX because the generated formula can be inspected afterward. Query Diagnostics analyzes Power Query performance, data alerts provide notifications, and sensitivity labels classify content. Quick measures are particularly useful when a supported template matches the business calculation and rapid report development is required.<\/span><\/p>\n

          Q5. A report visual currently sorts product categories alphabetically. Users instead want categories ordered from highest to lowest based on [Total Profit]. What should you do?<\/b><\/p>\n

            \n
          1. <\/b> Sort the visual by [Total Profit] in descending order.<\/span><\/li>\n
          2. <\/b> Create row-level security.<\/span><\/li>\n
          3. <\/b> Convert Product Category to a date field.<\/span><\/li>\n
          4. <\/b> Enable automatic page refresh.<\/span><\/li>\n<\/ol>\n

            Correct Answer: 1. Sort the visual by [Total Profit] in descending order.<\/b><\/p>\n

            Explanation:<\/b> Visual sorting can be configured based on a measure rather than the category label itself. Sorting Product Category by [Total Profit] descending places the highest-profit categories first and makes the visual easier to interpret for performance analysis. Row-level security controls data access and does not determine display order. Converting a categorical field to a date would be incorrect, while automatic page refresh controls how often data is updated in supported report scenarios. Sorting visuals appropriately helps emphasize the business ranking or sequence most relevant to users.<\/span><\/p>\n

            Q6. You have several overlapping shapes, buttons, and visuals on a report page. You need to control which objects appear in front and temporarily hide selected objects while designing the page. Which feature should you use?<\/b><\/p>\n

              \n
            1. <\/b> Model view.<\/span><\/li>\n
            2. <\/b> Performance Analyzer.<\/span><\/li>\n
            3. <\/b> Query Dependencies.<\/span><\/li>\n
            4. <\/b> Selection pane.<\/span><\/li>\n<\/ol>\n

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

              Explanation:<\/b> The Selection pane allows report designers to manage the visibility and layering order of objects on a report page. It is especially useful when visuals overlap or when bookmarks are used to switch between alternative layouts. Objects can be shown, hidden, and moved forward or backward in the visual stack. Model view focuses on semantic relationships, Performance Analyzer measures visual performance, and Query Dependencies applies to Power Query. The Selection pane is therefore the appropriate report-design feature for managing layered and temporarily hidden visual elements.<\/span><\/p>\n

              Q7. Your semantic model contains a Date table and a Sales table. You need a measure that returns sales from 30 days before the current date context. Which DAX capability is most appropriate?<\/b><\/p>\n

                \n
              1. <\/b> CONCATENATEX.<\/span><\/li>\n
              2. <\/b> A date-shifting time-intelligence function such as DATEADD.<\/span><\/li>\n
              3. <\/b> PATHITEM.<\/span><\/li>\n
              4. <\/b> COUNTROWS on Product.<\/span><\/li>\n<\/ol>\n

                Correct Answer: 2. A date-shifting time-intelligence function such as DATEADD.<\/b><\/p>\n

                Explanation:<\/b> DATEADD can shift the current date context backward or forward by a specified number of days, months, quarters, or years. Used within CALCULATE, it can evaluate an existing sales measure for a prior time period. A properly configured Date table helps make such calculations reliable. CONCATENATEX combines text, PATHITEM works with parent-child hierarchy paths, and COUNTROWS simply counts rows in a table. Date-shifting time intelligence is the appropriate approach when the same measure must be reevaluated for a relative historical period.<\/span><\/p>\n

                Q8. You have created a calculated column in a 50-million-row fact table for a value that is only needed as a dynamic aggregation in visuals. What is generally a more storage-efficient alternative?<\/b><\/p>\n

                  \n
                1. <\/b> Duplicate the calculated column.<\/span><\/li>\n
                2. <\/b> Add the same calculation in Power Query and keep both versions.<\/span><\/li>\n
                3. <\/b> Replace the calculated column with a measure when the business requirement permits.<\/span><\/li>\n
                4. <\/b> Convert the entire table to text.<\/span><\/li>\n<\/ol>\n

                  Correct Answer: 3. Replace the calculated column with a measure when the business requirement permits.<\/b><\/p>\n

                  Explanation:<\/b> Calculated columns are evaluated for every row and stored in the semantic model, which can consume substantial memory in a very large fact table. Measures are calculated at query time according to the current filter context and do not store a separate result for every row. Therefore, when a calculation is only required as an aggregation in visuals, a measure is usually more efficient. Calculated columns remain appropriate for certain row-level categorization, sorting, or relationship requirements. The design choice should reflect how the result will actually be used.<\/span><\/p>\n

                  Q9. A report contains confidential financial details. The organization requires a classification that can travel with supported exported content according to Microsoft information-protection policies. What should you apply?<\/b><\/p>\n

                    \n
                  1. <\/b> A bookmark.<\/span><\/li>\n
                  2. <\/b> A report tooltip.<\/span><\/li>\n
                  3. <\/b> A Top N filter.<\/span><\/li>\n
                  4. <\/b> A sensitivity label.<\/span><\/li>\n<\/ol>\n

                    Correct Answer: 4. A sensitivity label.<\/b><\/p>\n

                    Explanation:<\/b> Sensitivity labels classify Power BI content according to organizational information-protection policies. They can indicate classifications such as confidential or highly confidential and can participate in broader Microsoft Purview protection capabilities where supported. Bookmarks save report states, report tooltips provide contextual information, and Top N filters limit visual categories. Sensitivity labels help users understand how information should be handled and are part of Power BI governance and security practices rather than report presentation or filtering.<\/span><\/p>\n

                    Q10. You are publishing a report that uses DirectQuery and must display rapidly changing operational data while the report page remains open. Which feature should you configure where supported?<\/b><\/p>\n

                      \n
                    1. <\/b> Incremental refresh.<\/span><\/li>\n
                    2. <\/b> Automatic page refresh.<\/span><\/li>\n
                    3. <\/b> A static bookmark.<\/span><\/li>\n
                    4. <\/b> A paginated report.<\/span><\/li>\n<\/ol>\n

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

                      Explanation:<\/b> Automatic page refresh allows a report page to periodically retrieve updated data while the user keeps the page open. It is especially relevant to supported DirectQuery scenarios involving operational dashboards or monitoring where data can change frequently. Incremental refresh optimizes partition refresh for semantic models rather than repeatedly updating an open report page. Bookmarks capture report states, and paginated reports focus on fixed-layout output. Automatic page refresh should be configured with care because frequent source queries can affect database and capacity performance.<\/span><\/p>\n

                      Q11. A Power Query transformation must keep only records where OrderStatus equals “Completed” before the table is loaded. What is the best approach?<\/b><\/p>\n

                        \n
                      1. <\/b> Apply a filter to OrderStatus in Power Query.<\/span><\/li>\n
                      2. <\/b> Create a visual-level filter after publishing.<\/span><\/li>\n
                      3. <\/b> Hide incomplete rows using a bookmark.<\/span><\/li>\n
                      4. <\/b> Apply conditional formatting to OrderStatus.<\/span><\/li>\n<\/ol>\n

                        Correct Answer: 1. Apply a filter to OrderStatus in Power Query.<\/b><\/p>\n

                        Explanation:<\/b> If incomplete orders are outside the scope of the semantic model, filtering them in Power Query prevents unnecessary rows from being loaded. This can reduce model size and ensures all downstream calculations operate only on valid records. A visual-level filter affects just one visual and leaves the unwanted rows in the model. Bookmarks control report states, and conditional formatting changes appearance rather than data content. Filtering unnecessary data early is generally preferable when the business requirement clearly states that those records should not participate in any analysis.<\/span><\/p>\n

                        Q12. You need to evaluate a DAX measure and inspect the query results directly against the semantic model while troubleshooting calculation behavior. Which Power BI Desktop feature is relevant?<\/b><\/p>\n

                          \n
                        1. <\/b> Mobile layout.<\/span><\/li>\n
                        2. <\/b> Column quality.<\/span><\/li>\n
                        3. <\/b> DAX query view.<\/span><\/li>\n
                        4. <\/b> Bookmark navigator.<\/span><\/li>\n<\/ol>\n

                          Correct Answer: 3. DAX query view.<\/b><\/p>\n

                          Explanation:<\/b> DAX query view allows model authors to write and execute DAX queries directly against the semantic model. It can help validate calculations, inspect model results, and troubleshoot complex DAX behavior. Mobile layout is used for phone report design, Column quality is a Power Query profiling feature, and Bookmark navigator provides report navigation controls. DAX query view is particularly useful for analytical development and model troubleshooting because it provides a dedicated environment for interacting with the semantic model using DAX queries.<\/span><\/p>\n

                          Q13. You want a report user to choose a measure and a category dimension dynamically from slicers, allowing one visual to change both its metric and grouping field. Which feature should you consider?<\/b><\/p>\n

                            \n
                          1. <\/b> Row-level security.<\/span><\/li>\n
                          2. <\/b> Field parameters.<\/span><\/li>\n
                          3. <\/b> Gateway clusters.<\/span><\/li>\n
                          4. <\/b> Privacy levels.<\/span><\/li>\n<\/ol>\n

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

                            Explanation:<\/b> Field parameters can contain measures, dimensions, or both and allow users to dynamically determine which fields a visual displays. This can make a single report visual highly flexible, letting users change both the metric and the grouping dimension without the report author creating many duplicate visuals. Row-level security governs data access, gateways handle data-source connectivity, and privacy levels govern Power Query source combinations. Field parameters improve self-service exploration while keeping report layouts compact and manageable.<\/span><\/p>\n

                            Q14. A semantic model must be accessed by users who should create reports from it but must not have broader administrative control over its workspace. Which permission is especially relevant?<\/b><\/p>\n

                              \n
                            1. <\/b> Workspace Admin.<\/span><\/li>\n
                            2. <\/b> Gateway administrator.<\/span><\/li>\n
                            3. <\/b> Build permission.<\/span><\/li>\n
                            4. <\/b> Sensitivity-label owner.<\/span><\/li>\n<\/ol>\n

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

                              Explanation:<\/b> Build permission allows users to create new reports and other supported content based on an existing semantic model. It enables controlled self-service reporting while allowing model owners to retain governance over the shared model. Workspace Admin would grant substantially more control than necessary, while gateway administration concerns connectivity infrastructure. Sensitivity labels classify information rather than grant report-building capabilities. Appropriate semantic-model access combined with least-privilege workspace permissions helps organizations support self-service analytics without sacrificing governance.<\/span><\/p>\n

                              Q15. You need to display uncertainty around forecast values by showing upper and lower ranges on a chart. Which feature should you use?<\/b><\/p>\n

                                \n
                              1. <\/b> Error bars.<\/span><\/li>\n
                              2. <\/b> Page navigation.<\/span><\/li>\n
                              3. <\/b> Data alerts.<\/span><\/li>\n
                              4. <\/b> Query folding.<\/span><\/li>\n<\/ol>\n

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

                                Explanation:<\/b> Error bars display upper and lower ranges around plotted values and can communicate uncertainty, variability, or confidence intervals. They are useful when point estimates alone do not adequately represent the analytical result. Page navigation moves users between report pages, data alerts notify users about supported thresholds, and query folding concerns data-transformation execution at the source. When a chart needs to show uncertainty around estimates or measurements, error bars provide an appropriate visual mechanism to communicate the range rather than only a single value.<\/span><\/p>\n

                                Q16. Your report has been optimized for desktop, but key buttons and charts are difficult to use on a phone. What should you create?<\/b><\/p>\n

                                  \n
                                1. <\/b> A mobile layout.<\/span><\/li>\n
                                2. <\/b> A bridge table.<\/span><\/li>\n
                                3. <\/b> A calculation group.<\/span><\/li>\n
                                4. <\/b> A dataflow.<\/span><\/li>\n<\/ol>\n

                                  Correct Answer: 1. A mobile layout.<\/b><\/p>\n

                                  Explanation:<\/b> Mobile layout provides a dedicated design surface for arranging Power BI report visuals for smaller screens. Report authors can choose the most important visuals, resize them, and arrange them vertically in a way that is easier to read and interact with on phones. A bridge table solves many-to-many modeling requirements, calculation groups centralize measure logic, and dataflows provide reusable data preparation. Designing specifically for mobile users improves accessibility and usability rather than relying on a desktop layout to simply shrink onto a small display.<\/span><\/p>\n

                                  Q17. Your organization has formally approved one semantic model for enterprise reporting and wants users to distinguish it from less-governed models. What should authorized reviewers apply?<\/b><\/p>\n

                                    \n
                                  1. <\/b> Certification.<\/span><\/li>\n
                                  2. <\/b> A visual filter.<\/span><\/li>\n
                                  3. <\/b> A bookmark.<\/span><\/li>\n
                                  4. <\/b> Conditional formatting.<\/span><\/li>\n<\/ol>\n

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

                                    Explanation:<\/b> Certification is the stronger Power BI endorsement used to identify content that has completed an organization’s formal review or governance process. It helps report authors identify authoritative semantic models and reduces the chance that inconsistent or unofficial sources will be used for enterprise reporting. A visual filter controls report content, bookmarks store report states, and conditional formatting changes appearance. Certification is a governance capability and is generally applied by users authorized according to the organization’s certification policies.<\/span><\/p>\n

                                    Q18. A report user wants Power BI to help identify factors associated with a decline in customer satisfaction. Which visual can analyze factors that influence a selected metric?<\/b><\/p>\n

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

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

                                      Explanation:<\/b> The Key influencers visual helps identify factors associated with changes in a selected outcome. For customer satisfaction, it can analyze other fields and highlight conditions correlated with higher or lower satisfaction. The findings should be interpreted as analytical associations rather than automatic proof of causation. A Gauge compares one value with a target, a Card displays a single summarized metric, and a Funnel chart shows stages in a process. Key influencers is specifically designed to support exploratory analysis of potential drivers behind an outcome.<\/span><\/p>\n

                                      Q19. You need to store reusable transformation logic centrally so that several semantic models can consume the same prepared business entities. Which capability is most appropriate?<\/b><\/p>\n

                                        \n
                                      1. <\/b> Report tooltips.<\/span><\/li>\n
                                      2. <\/b> Dataflows.<\/span><\/li>\n
                                      3. <\/b> Personal bookmarks.<\/span><\/li>\n
                                      4. <\/b> Small multiples.<\/span><\/li>\n<\/ol>\n

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

                                        Explanation:<\/b> Dataflows provide reusable cloud-based data preparation that can be consumed by multiple downstream Power BI solutions. Common Power Query transformations can be centralized instead of repeated independently in many semantic models. This can improve consistency and reduce maintenance when several reports depend on the same prepared data entities. Tooltips and bookmarks are report-consumption features, while small multiples are a visualization capability. Dataflows are therefore suitable when an organization wants to reuse standardized transformation logic across multiple analytics solutions.<\/span><\/p>\n

                                        Q20. A column in a dimension table contains values such as Bronze, Silver, Gold, and Platinum. Business users require this exact sequence rather than alphabetical ordering. What should you configure?<\/b><\/p>\n

                                          \n
                                        1. <\/b> A numeric sort-order column and Sort by Column.<\/span><\/li>\n
                                        2. <\/b> Row-level security.<\/span><\/li>\n
                                        3. <\/b> Query Diagnostics.<\/span><\/li>\n
                                        4. <\/b> Automatic page refresh.<\/span><\/li>\n<\/ol>\n

                                          Correct Answer: 1. A numeric sort-order column and Sort by Column.<\/b><\/p>\n

                                          Explanation:<\/b> Business categories often have a logical sequence that differs from alphabetical sorting. A numeric sort column can assign values such as Bronze = 1, Silver = 2, Gold = 3, and Platinum = 4. Power BI can then configure the display field to sort by that numeric column. Row-level security controls data access, Query Diagnostics investigates transformations, and automatic page refresh controls data updates. Sort by Column is the standard model configuration for custom category ordering and ensures consistent sequence across supported visuals.<\/span><\/p>\n

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

                                            View Full ServiceNow CIS-ITSM Exam Dumps and Practice Test Dumps. Q1. You create a staging query in Power Query that is referenced by three final tables. The staging query itself should not appear as a table in the semantic model. What should you configure? Delete the staging query. Convert the staging query to DirectQuery. […]<\/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\/16474"}],"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=16474"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16474\/revisions"}],"predecessor-version":[{"id":16481,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16474\/revisions\/16481"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=16474"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=16474"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=16474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}