{"id":16465,"date":"2026-09-19T07:31:17","date_gmt":"2026-09-19T07:31:17","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=16465"},"modified":"2026-09-19T07:31:17","modified_gmt":"2026-09-19T07:31:17","slug":"servicenow-cis-itsm-practice-test-questions-and-exam-dumps-part10-q181-200","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/servicenow-cis-itsm-practice-test-questions-and-exam-dumps-part10-q181-200\/","title":{"rendered":"ServiceNow CIS-ITSM Practice Test Questions and Exam Dumps Part10 Q181-200"},"content":{"rendered":"

 <\/p>\n

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


\n<\/b>Q1. A Power BI report contains multiple measures, and users want to switch a chart dynamically between Total Sales, Total Profit, and Quantity without creating three separate visuals. Which feature should you use?<\/b><\/p>\n

    \n
  1. <\/b> Drillthrough<\/span><\/li>\n
  2. <\/b> Calculation groups<\/span><\/li>\n
  3. <\/b> Sync slicers<\/span><\/li>\n
  4. <\/b> Field parameters<\/span><\/li>\n<\/ol>\n

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

    Explanation:<\/b> Field parameters allow report users to dynamically change the measures or dimensions displayed in a visual by making a selection from a slicer. In this scenario, a field parameter can include Total Sales, Total Profit, and Quantity, allowing one chart to switch between the three measures without requiring duplicate visuals. This improves report flexibility and reduces unnecessary page clutter. Drillthrough is used for navigating to detailed pages, while Sync slicers maintains selections across pages. Calculation groups can modify measure behavior but are not primarily intended to let users directly switch the fields displayed in a visual.<\/span><\/p>\n

    Q2. You are examining a large Power Query transformation against SQL Server. You want to verify whether a filter step is being sent back to SQL Server for processing. Which action should you take?<\/b><\/p>\n

      \n
    1. <\/b> Open Performance Analyzer.<\/span><\/li>\n
    2. <\/b> View the native query for the transformation step.<\/span><\/li>\n
    3. <\/b> Create a bookmark.<\/span><\/li>\n
    4. <\/b> Enable row-level security.<\/span><\/li>\n<\/ol>\n

      Correct Answer: 2. View the native query for the transformation step.<\/b><\/p>\n

      Explanation:<\/b> Viewing the native query can help determine whether Power Query is successfully folding transformation steps back to the underlying data source. If query folding is occurring, operations such as filtering can be translated into a source-native query and processed by SQL Server rather than locally by Power BI. This often improves refresh performance and reduces the amount of data transferred. Performance Analyzer focuses mainly on report visual performance rather than Power Query folding. Bookmarks preserve report states, and row-level security restricts data visibility. Checking the native query is therefore an appropriate method for investigating folding behavior.<\/span><\/p>\n

      Q3. Your semantic model contains a column with complete URLs such as<\/b> https:\/\/contoso.com\/product\/100<\/b><\/a>. You want users to click the values directly from a table visual. What should you configure?<\/b><\/p>\n

        \n
      1. <\/b> Set the column’s data category to Web URL.<\/span><\/li>\n
      2. <\/b> Convert the column into a measure.<\/span><\/li>\n
      3. <\/b> Create a numeric hierarchy.<\/span><\/li>\n
      4. <\/b> Configure incremental refresh.<\/span><\/li>\n<\/ol>\n

        Correct Answer: 1. Set the column’s data category to Web URL.<\/b><\/p>\n

        Explanation:<\/b> Setting a text column’s data category to Web URL tells Power BI that the values represent hyperlinks. Supported visuals can then display those values as clickable links or use them for URL-based formatting. This improves the semantic meaning of the field and provides users with direct navigation to the associated external resources. A measure is unnecessary because the values already exist at the row level. Hierarchies are used for drillable dimensional structures, while incremental refresh controls data refresh behavior. Correct data categories help Power BI understand how specific fields should be interpreted and presented.<\/span><\/p>\n

        Q4. A report contains a map that uses latitude and longitude columns. Power BI is incorrectly summarizing the coordinate values. What should you configure for these columns?<\/b><\/p>\n

          \n
        1. <\/b> Set both columns to Count.<\/span><\/li>\n
        2. <\/b> Convert both columns to text.<\/span><\/li>\n
        3. <\/b> Set their summarization to Do not summarize.<\/span><\/li>\n
        4. <\/b> Create a many-to-many relationship between them.<\/span><\/li>\n<\/ol>\n

          Correct Answer: 3. Set their summarization to Do not summarize.<\/b><\/p>\n

          Explanation:<\/b> Latitude and longitude values identify specific geographic coordinates and generally should not be added together, averaged, or otherwise automatically aggregated. Setting their default summarization to Do not summarize helps ensure that Power BI interprets individual coordinates correctly in map visuals. Converting them to text could interfere with geographic functionality, while counting them would not provide location information. Relationships between latitude and longitude are also unnecessary. Configuring the semantic properties of columns correctly is important because default aggregation behavior can otherwise lead to inaccurate or unexpected visual results.<\/span><\/p>\n

          Q5. Your organization has a semantic model where some tables should be imported for high performance while another large table must query the source in real time. Which model design should you consider?<\/b><\/p>\n

            \n
          1. <\/b> A report containing only calculated tables.<\/span><\/li>\n
          2. <\/b> A paginated report.<\/span><\/li>\n
          3. <\/b> A model with no relationships.<\/span><\/li>\n
          4. <\/b> A composite model.<\/span><\/li>\n<\/ol>\n

            Correct Answer: 4. A composite model.<\/b><\/p>\n

            Explanation:<\/b> A composite model allows a Power BI semantic model to use more than one storage mode, such as Import and DirectQuery. Frequently accessed dimension or aggregation tables can be imported for fast performance, while a very large or rapidly changing table can remain in DirectQuery mode. This provides flexibility when a single storage approach does not meet every requirement. Paginated reports address fixed-layout reporting rather than storage architecture. Calculated tables do not solve real-time source access, and eliminating relationships would reduce analytical functionality. Composite models are useful for balancing performance, scale, and freshness requirements.<\/span><\/p>\n

            Q6. You want report users to change a numeric assumption from 0 to 20 percent and immediately see how projected revenue changes. Which feature is most appropriate?<\/b><\/p>\n

              \n
            1. <\/b> A What-if parameter.<\/span><\/li>\n
            2. <\/b> A drillthrough page.<\/span><\/li>\n
            3. <\/b> A data alert.<\/span><\/li>\n
            4. <\/b> A paginated report.<\/span><\/li>\n<\/ol>\n

              Correct Answer: 1. A What-if parameter.<\/b><\/p>\n

              Explanation:<\/b> A What-if parameter provides an interactive numeric input that users can select from a slicer and use within DAX calculations. It is ideal for scenario analysis involving assumptions such as discount percentages, growth rates, interest rates, or price changes. A measure can reference the selected parameter and calculate projected revenue dynamically. Drillthrough is designed for detail navigation, while data alerts monitor changes to supported metrics. Paginated reports are intended for highly formatted output. What-if parameters are specifically designed for interactive modeling and sensitivity analysis without modifying the underlying source data.<\/span><\/p>\n

              Q7. A model contains a Sales table and a Geography dimension. Some fact rows have GeographyKey values that do not exist in the Geography table. What problem can this cause?<\/b><\/p>\n

                \n
              1. <\/b> Power BI automatically creates new dimension records for every missing key.<\/span><\/li>\n
              2. <\/b> The unmatched fact rows can appear under a blank member in reports.<\/span><\/li>\n
              3. <\/b> The Sales table will automatically become DirectQuery.<\/span><\/li>\n
              4. <\/b> All report filters will stop functioning.<\/span><\/li>\n<\/ol>\n

                Correct Answer: 2. The unmatched fact rows can appear under a blank member in reports.<\/b><\/p>\n

                Explanation:<\/b> When fact-table foreign keys do not match values on the one side of a relationship, Power BI can represent those unmatched rows through a blank member in the dimension. This behavior helps preserve fact rows but can produce unexpected “(Blank)” categories in visuals. Analysts should investigate referential integrity issues in the source or transformation logic to determine whether the missing keys represent data-quality problems. Power BI does not automatically create complete business dimension records for the missing values, nor does it change the storage mode. Relationship integrity is important for clean and understandable analytical models.<\/span><\/p>\n

                Q8. You are building a report for phone users. The desktop layout contains many visuals that are difficult to read on a small screen. What should you configure?<\/b><\/p>\n

                  \n
                1. <\/b> A gateway cluster.<\/span><\/li>\n
                2. <\/b> Dynamic row-level security.<\/span><\/li>\n
                3. <\/b> A mobile layout.<\/span><\/li>\n
                4. <\/b> Query diagnostics.<\/span><\/li>\n<\/ol>\n

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

                  Explanation:<\/b> A mobile layout allows report designers to arrange and size visuals specifically for phone-sized screens. Instead of relying on the desktop report layout to shrink automatically, you can select the most important visuals and place them in a vertical, touch-friendly design. This improves readability and usability for mobile consumers. A gateway cluster relates to data-source connectivity and resilience, while dynamic row-level security controls access to rows. Query diagnostics are used to investigate query behavior. Mobile layout addresses the presentation requirements of users consuming reports on smaller devices.<\/span><\/p>\n

                  Q9. You have two measures, [Sales] and [Target]. You need a third measure that returns the difference between the two measures and responds to all report filters. What should you create?<\/b><\/p>\n

                    \n
                  1. <\/b> A measure defined as [Sales] – [Target].<\/span><\/li>\n
                  2. <\/b> A Power Query custom column only.<\/span><\/li>\n
                  3. <\/b> A relationship between the measures.<\/span><\/li>\n
                  4. <\/b> A hierarchy containing both measures.<\/span><\/li>\n<\/ol>\n

                    Correct Answer: 1. A measure defined as [Sales] – [Target].<\/b><\/p>\n

                    Explanation:<\/b> Measures are designed for dynamic calculations evaluated within the current report filter context. A measure such as [Variance] = [Sales] – [Target] will automatically recalculate when users filter by date, region, product, or another dimension. A Power Query custom column is evaluated during refresh and operates at the row level, so it is not the appropriate solution for combining two dynamic aggregate measures. Relationships connect model columns rather than measures, and hierarchies organize fields for navigation. A DAX measure is therefore the simplest and most flexible way to calculate dynamic variance.<\/span><\/p>\n

                    Q10. You need a Power BI visual that shows how a total value is increased and decreased by a sequence of positive and negative contributions. Which visual should you use?<\/b><\/p>\n

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

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

                      Explanation:<\/b> A Waterfall chart is designed to show how an initial value changes through a sequence of positive and negative contributions until a final value is reached. It is commonly used for analyses such as profit bridges, budget versus actual changes, revenue movements, or headcount changes. A Pie chart displays proportions, a Funnel chart typically represents stages in a process, and a Scatter chart shows relationships between numeric variables. When users need to understand which components increased or decreased a total, a Waterfall chart provides an effective visual explanation.<\/span><\/p>\n

                      Q11. You need to create a calculated column in the Sales table that retrieves the Product Category from a related Product table. Which DAX function should you use?<\/b><\/p>\n

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

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

                        Explanation:<\/b> RELATED retrieves a single value from a related table by following an existing relationship. In a Sales calculated column, it can retrieve Product[Category] for the product associated with each Sales row. This is a row-context operation and is useful when a related dimension attribute must be brought into another table. CALCULATE modifies filter context, DISTINCTCOUNT counts unique values, and DATEADD changes date context for time-intelligence calculations. Although duplicating dimension attributes into fact tables should be done only when necessary, RELATED is the appropriate function when the business requirement specifically calls for such a calculated column.<\/span><\/p>\n

                        Q12. You want a report user to choose either Revenue, Profit, or Margin and have the same matrix display the selected metric. Which feature can provide this dynamic measure selection?<\/b><\/p>\n

                          \n
                        1. <\/b> A field parameter.<\/span><\/li>\n
                        2. <\/b> A dataflow.<\/span><\/li>\n
                        3. <\/b> A gateway.<\/span><\/li>\n
                        4. <\/b> A tooltip page.<\/span><\/li>\n<\/ol>\n

                          Correct Answer: 1. A field parameter.<\/b><\/p>\n

                          Explanation:<\/b> Field parameters allow users to dynamically choose which fields or measures appear in a visual. A parameter containing Revenue, Profit, and Margin can be exposed through a slicer, and the matrix will update to show the selected measure. This avoids creating separate matrices for each metric and simplifies report maintenance. A dataflow handles reusable data preparation, while a gateway supports connectivity to certain on-premises sources. Tooltip pages provide additional hover information. Field parameters are specifically intended to create flexible visuals where users can control the dimensions or measures being analyzed.<\/span><\/p>\n

                          Q13. Your Power BI model contains a Product dimension that is related to Sales. You need a calculated table containing only products that have at least one related Sales row. Which DAX concept would be most relevant?<\/b><\/p>\n

                            \n
                          1. <\/b> FORMAT<\/span><\/li>\n
                          2. <\/b> PATH<\/span><\/li>\n
                          3. <\/b> FILTER combined with related sales logic.<\/span><\/li>\n
                          4. <\/b> CONCATENATE only.<\/span><\/li>\n<\/ol>\n

                            Correct Answer: 3. FILTER combined with related sales logic.<\/b><\/p>\n

                            Explanation:<\/b> FILTER returns a table containing only rows that satisfy a specified logical expression. In this scenario, FILTER can iterate over products and retain only those for which related sales records exist, using an appropriate related-table or counting expression. FORMAT changes how values are represented as text, PATH supports parent-child hierarchies, and CONCATENATE combines text strings. Calculated tables should be created only when they provide a clear modeling benefit, but when table rows must be selected based on related data, FILTER is one of the key DAX functions used to express the required logic.<\/span><\/p>\n

                            Q14. A report contains a hierarchy of Country, State, and City. Users want to expand multiple hierarchy levels simultaneously without replacing the previous level. Which visual capability should they use?<\/b><\/p>\n

                              \n
                            1. <\/b> Drillthrough<\/span><\/li>\n
                            2. <\/b> Expand all down one level.<\/span><\/li>\n
                            3. <\/b> Row-level security.<\/span><\/li>\n
                            4. <\/b> Personal bookmarks.<\/span><\/li>\n<\/ol>\n

                              Correct Answer: 2. Expand all down one level.<\/b><\/p>\n

                              Explanation:<\/b> Expand all down one level displays the next hierarchy level while retaining the parent-level context. For example, a visual can show countries together with the states beneath each country rather than replacing countries entirely with states. Standard drill-down typically moves the visual to a more detailed level, whereas expanding preserves the hierarchical grouping. Drillthrough navigates to a separate report page, row-level security restricts access to data, and personal bookmarks save an individual user’s report state. The hierarchy expansion capability is the best fit for displaying multiple hierarchy levels together.<\/span><\/p>\n

                              Q15. A column contains product descriptions with inconsistent capitalization, such as “LAPTOP”, “Laptop”, and “laptop”. You need standardized values before creating categories. Which Power Query transformation is appropriate?<\/b><\/p>\n

                                \n
                              1. <\/b> Change text to a consistent case.<\/span><\/li>\n
                              2. <\/b> Append Queries.<\/span><\/li>\n
                              3. <\/b> Pivot Column.<\/span><\/li>\n
                              4. <\/b> Enable incremental refresh.<\/span><\/li>\n<\/ol>\n

                                Correct Answer: 1. Change text to a consistent case.<\/b><\/p>\n

                                Explanation:<\/b> Standardizing text case in Power Query can prevent logically identical values from appearing as inconsistent categories and helps improve data quality. Depending on the desired convention, the values can be converted to lowercase, uppercase, or proper case. Append Queries combines rows from multiple tables, while Pivot Column restructures data. Incremental refresh optimizes refresh processing and has nothing to do with text normalization. Data cleansing should generally occur before information is loaded into the semantic model so that categories, relationships, grouping, and report filters behave consistently.<\/span><\/p>\n

                                Q16. Your report uses DirectQuery and users complain about slow performance caused by many interactions with the data source. Which design decision could help reduce unnecessary queries?<\/b><\/p>\n

                                  \n
                                1. <\/b> Add more slicers to every page.<\/span><\/li>\n
                                2. <\/b> Configure query reduction options where appropriate.<\/span><\/li>\n
                                3. <\/b> Add bidirectional filtering to every relationship.<\/span><\/li>\n
                                4. <\/b> Convert all columns to high-cardinality text.<\/span><\/li>\n<\/ol>\n

                                  Correct Answer: 2. Configure query reduction options where appropriate.<\/b><\/p>\n

                                  Explanation:<\/b> Query reduction options can reduce the number of queries generated by report interactions, especially in DirectQuery scenarios. For example, slicers can be configured to require users to apply selections before sending queries, which can help avoid repeated source queries while users make multiple choices. Adding unnecessary slicers or bidirectional relationships can increase complexity and potentially hurt performance. High-cardinality text fields can also be expensive. DirectQuery models require thoughtful report and model design because many user actions can result in queries being sent directly to the underlying data source.<\/span><\/p>\n

                                  Q17. You have quarterly sales values and need to display each quarter as a percentage of the annual total in a matrix. Which DAX approach is most appropriate?<\/b><\/p>\n

                                    \n
                                  1. <\/b> Use FORMAT on Quarter.<\/span><\/li>\n
                                  2. <\/b> Create a calculated text column.<\/span><\/li>\n
                                  3. <\/b> Divide the quarter sales measure by a total measure that removes the Quarter filter.<\/span><\/li>\n
                                  4. <\/b> Use COUNTROWS on the Date table.<\/span><\/li>\n<\/ol>\n

                                    Correct Answer: 3. Divide the quarter sales measure by a total measure that removes the Quarter filter.<\/b><\/p>\n

                                    Explanation:<\/b> A percentage-of-total measure usually requires two calculations: the numerator evaluated in the current context and the denominator evaluated with the relevant category filter removed. In this case, quarterly sales can be divided by annual sales calculated using CALCULATE with an appropriate filter-removal function on Quarter while retaining the Year context. FORMAT only changes display appearance, and a text column would not provide a dynamic percentage. COUNTROWS would count dates rather than calculate sales contribution. This DAX pattern produces percentages that respond correctly to other report filters.<\/span><\/p>\n

                                    Q18. You need to make a report more accessible to users who cannot distinguish certain colors. What is the best design approach?<\/b><\/p>\n

                                      \n
                                    1. <\/b> Rely only on red and green to indicate status.<\/span><\/li>\n
                                    2. <\/b> Remove all visual titles.<\/span><\/li>\n
                                    3. <\/b> Use smaller fonts so more visuals fit.<\/span><\/li>\n
                                    4. <\/b> Combine color with labels, icons, or other visual cues.<\/span><\/li>\n<\/ol>\n

                                      Correct Answer: 4. Combine color with labels, icons, or other visual cues.<\/b><\/p>\n

                                      Explanation:<\/b> Accessible report design should not rely exclusively on color to communicate important meaning. Users with color-vision deficiencies may have difficulty distinguishing colors such as red and green. Adding labels, icons, shapes, or other cues ensures that status and meaning remain understandable even when color differences cannot be perceived. Clear text, sufficient contrast, readable font sizes, and meaningful titles also improve accessibility. Removing titles or shrinking text would generally reduce usability. Combining multiple visual signals is a stronger and more inclusive design practice for Power BI reports.<\/span><\/p>\n

                                      Q19. You want several reports to reuse the same prepared data entities before they are loaded into individual semantic models. Which Power BI capability can support reusable cloud-based data preparation?<\/b><\/p>\n

                                        \n
                                      1. <\/b> Dataflows.<\/span><\/li>\n
                                      2. <\/b> Bookmarks.<\/span><\/li>\n
                                      3. <\/b> Drillthrough.<\/span><\/li>\n
                                      4. <\/b> Visual calculations.<\/span><\/li>\n<\/ol>\n

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

                                        Explanation:<\/b> Dataflows support reusable, cloud-based data preparation and transformation. Organizations can centralize common Power Query logic and expose prepared entities for use by multiple downstream semantic models and reports. This helps reduce duplicated transformation work and promotes consistent definitions across solutions. Bookmarks preserve report states, drillthrough provides contextual navigation, and visual calculations operate within report visuals rather than providing shared data preparation. Dataflows are useful when multiple Power BI solutions rely on the same cleaned and transformed source data and the organization wants to manage that preparation more centrally.<\/span><\/p>\n

                                        Q20. You need to compare actual sales with budget by month and display both values over time while preserving the ability to see the trend clearly. Which visual is generally appropriate?<\/b><\/p>\n

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

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

                                          Explanation:<\/b> A Line chart is well suited to comparing trends for multiple measures across time. Actual Sales and Budget can be added as separate series, while Month is placed on the time axis. This allows users to see not only the values for each period but also how the measures diverge or converge over time. A Card emphasizes a single number, a Gauge focuses on progress toward a target at one point, and a Donut chart shows proportions. For month-by-month comparison of two time-based measures, a Line chart provides a clear and effective analytical view.<\/span><\/p>\n

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

                                            View Full ServiceNow CIS-ITSM Exam Dumps and Practice Test Dumps. Q1. A Power BI report contains multiple measures, and users want to switch a chart dynamically between Total Sales, Total Profit, and Quantity without creating three separate visuals. Which feature should you use? Drillthrough Calculation groups Sync slicers Field parameters Correct Answer: 4. Field […]<\/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\/16465"}],"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=16465"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16465\/revisions"}],"predecessor-version":[{"id":16490,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16465\/revisions\/16490"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=16465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=16465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=16465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}