{"id":16463,"date":"2026-09-19T07:31:39","date_gmt":"2026-09-19T07:31:39","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=16463"},"modified":"2026-09-19T07:31:39","modified_gmt":"2026-09-19T07:31:39","slug":"servicenow-cis-itsm-practice-test-questions-and-exam-dumps-part8-q141-160","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/servicenow-cis-itsm-practice-test-questions-and-exam-dumps-part8-q141-160\/","title":{"rendered":"ServiceNow CIS-ITSM Practice Test Questions and Exam Dumps Part8 Q141-160"},"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 loading a fact table into Power BI and discover that several columns contain unique transaction IDs that are not used in relationships, visuals, filters, or calculations. What should you do to optimize the model?<\/b><\/p>\n

    \n
  1. <\/b> Keep all columns to preserve source fidelity.<\/span><\/li>\n
  2. <\/b> Remove the unused high-cardinality columns before loading.<\/span><\/li>\n
  3. <\/b> Convert the columns to calculated columns.<\/span><\/li>\n
  4. <\/b> Place the columns in a hierarchy.<\/span><\/li>\n<\/ol>\n

    Correct Answer: 2. Remove the unused high-cardinality columns before loading.<\/b><\/p>\n

    Explanation:<\/b> Unused high-cardinality columns can significantly increase the size of a Power BI semantic model because they contain many distinct values that require storage. If the transaction IDs are not needed for relationships, filtering, drillthrough, calculations, or auditing, removing them in Power Query is generally the best choice. Keeping them adds unnecessary storage and can increase refresh and processing costs. Calculated columns would add even more model data, while creating a hierarchy does not reduce storage. A well-designed model should load only the fields that support reporting, analysis, security, or business logic.<\/span><\/p>\n

    Q2. You need a measure that calculates total sales only for customers marked as Active. Which DAX function is most appropriate for changing the filter context of [Total Sales]?<\/b><\/p>\n

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

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

      Explanation:<\/b> CALCULATE evaluates an expression after modifying the current filter context. For example, you can evaluate [Total Sales] while applying a condition such as Customer[Status] = “Active”. This makes CALCULATE essential for filtered measures, time intelligence, percentages, and many comparison scenarios. RELATED retrieves a value from a related table in row context, VALUES returns distinct values, and FORMAT converts a value to text using a specified format. Because this requirement involves recalculating an existing measure under an additional filter condition, CALCULATE is the correct DAX function.<\/span><\/p>\n

      Q3. You have two tables with matching CustomerID columns and need to add the customer segment from one table to the other. Which Power Query operation should you use?<\/b><\/p>\n

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

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

        Explanation:<\/b> Merge Queries combines tables horizontally by matching rows based on one or more key columns. In this scenario, CustomerID can be used to match records and bring the customer segment into the other table. Append Queries is used to stack rows from similarly structured tables. Unpivot Columns changes columns into attribute-value rows, while Group By performs aggregation. Merge Queries is similar to a database join and is the appropriate transformation when you need to enrich one dataset with related attributes from another based on a shared key.<\/span><\/p>\n

        Q4. You need users to compare actual revenue against a predefined revenue target and quickly identify whether performance is above or below goal. Which visual is most appropriate?<\/b><\/p>\n

          \n
        1. <\/b> Treemap<\/span><\/li>\n
        2. <\/b> Scatter chart<\/span><\/li>\n
        3. <\/b> Matrix<\/span><\/li>\n
        4. <\/b> KPI visual<\/span><\/li>\n<\/ol>\n

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

          Explanation:<\/b> A KPI visual is designed to communicate performance against a target while often showing trend information over time. It is useful for business metrics such as revenue, profit, margin, or service levels where users need to understand whether current performance is meeting expectations. A Treemap focuses on proportional values across categories, a Scatter chart shows relationships between numeric variables, and a Matrix supports detailed tabular analysis. When the business question centers on performance relative to a target, a KPI visual provides a direct and easily understood presentation.<\/span><\/p>\n

          Q5. Your Date table contains a Date column and is related to the Sales table. You need a measure that calculates sales from the beginning of the current year through the current date context. Which DAX function is appropriate?<\/b><\/p>\n

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

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

            Explanation:<\/b> TOTALYTD calculates an expression from the beginning of the year through the current date context. It is a time-intelligence function commonly used for cumulative year-to-date metrics such as sales, profit, or expenses. A properly configured Date table and relationship are important for reliable time-intelligence calculations. DISTINCTCOUNT counts unique values, RANKX ranks items based on an expression, and LOOKUPVALUE retrieves a value based on matching conditions. TOTALYTD directly addresses the requirement for cumulative year-to-date analysis and responds dynamically to date filters applied in the report.<\/span><\/p>\n

            Q6. A Power Query column contains values such as “USA-California-San Diego”. You need separate Country, State, and City columns. What should you use?<\/b><\/p>\n

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

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

              Explanation:<\/b> Split Column by Delimiter divides a text column into multiple columns based on a specified separator. In this case, the hyphen can be used to split the original string into Country, State, and City. Pivot Column is used to transform row values into separate columns, Fill Up propagates a value upward into blank cells, and Group By summarizes rows. Separating combined fields into individual attributes improves model usability because each component can then be used independently in filters, hierarchies, relationships, and report visuals.<\/span><\/p>\n

              Q7. You want to calculate the average sales amount per transaction using a measure based on the SalesAmount column. Which DAX function should you use?<\/b><\/p>\n

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

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

                Explanation:<\/b> AVERAGE returns the arithmetic mean of the numeric values in a column within the current filter context. When used in a measure, it dynamically recalculates as users apply filters for date, region, product, or other dimensions. COUNT would return the number of nonblank values, SUMX is an iterator used for row-by-row expressions, and DISTINCT returns unique values. If the requirement is simply to calculate the average of an existing numeric column such as SalesAmount, AVERAGE is the most direct and appropriate DAX function.<\/span><\/p>\n

                Q8. Your Power BI model contains Product and Sales tables. ProductID is unique in Product but repeated in Sales. Which relationship should you configure?<\/b><\/p>\n

                  \n
                1. <\/b> One-to-one<\/span><\/li>\n
                2. <\/b> Many-to-many<\/span><\/li>\n
                3. <\/b> One-to-many from Sales to Product<\/span><\/li>\n
                4. <\/b> One-to-many from Product to Sales<\/span><\/li>\n<\/ol>\n

                  Correct Answer: 4. One-to-many from Product to Sales<\/b><\/p>\n

                  Explanation:<\/b> The Product table is a dimension with one unique row per ProductID, while the Sales fact table can contain many transactions for the same product. Therefore, the appropriate relationship is one-to-many from Product to Sales. This is a standard star-schema design that allows Product attributes to filter related Sales records. A one-to-one relationship would require ProductID to be unique in both tables. Many-to-many is unnecessary when the dimension contains unique keys. Correct cardinality supports predictable filter propagation and more maintainable DAX calculations.<\/span><\/p>\n

                  Q9. You need to prevent a particular chart from being affected when users select a value in another visual on the same report page. Which feature should you use?<\/b><\/p>\n

                    \n
                  1. <\/b> Edit interactions<\/span><\/li>\n
                  2. <\/b> Drillthrough<\/span><\/li>\n
                  3. <\/b> Row-level security<\/span><\/li>\n
                  4. <\/b> Data alerts<\/span><\/li>\n<\/ol>\n

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

                    Explanation:<\/b> Edit interactions allows report designers to control how one visual responds when users select data in another visual. You can configure a target visual to be filtered, highlighted, or unaffected by the source visual. This provides flexible control over the report experience. Drillthrough is used for navigation to detailed pages, row-level security restricts data access, and data alerts monitor certain values. Since the requirement is to stop one visual from responding to another visual’s selection, Edit interactions is the correct report-design feature.<\/span><\/p>\n

                    Q10. You have monthly budget tables for January, February, and March with identical columns. You want one combined budget table. Which Power Query operation should you use?<\/b><\/p>\n

                      \n
                    1. <\/b> Merge Queries<\/span><\/li>\n
                    2. <\/b> Append Queries<\/span><\/li>\n
                    3. <\/b> Transpose<\/span><\/li>\n
                    4. <\/b> Replace Values<\/span><\/li>\n<\/ol>\n

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

                      Explanation:<\/b> Append Queries combines tables vertically by adding the rows of one table beneath another. This is the correct operation when multiple monthly tables share the same structure and should become one consolidated dataset. Merge Queries combines tables horizontally by matching keys, while Transpose switches rows and columns. Replace Values changes specified data values. For recurring monthly, quarterly, or regional datasets with matching schemas, appending is a common data preparation technique that simplifies downstream modeling and analysis.<\/span><\/p>\n

                      Q11. A sales report needs to show only the top 7 products based on the [Total Sales] measure. What should you configure?<\/b><\/p>\n

                        \n
                      1. <\/b> A relative date filter<\/span><\/li>\n
                      2. <\/b> A drillthrough filter<\/span><\/li>\n
                      3. <\/b> A Top N filter<\/span><\/li>\n
                      4. <\/b> Row-level security<\/span><\/li>\n<\/ol>\n

                        Correct Answer: 3. A Top N filter<\/b><\/p>\n

                        Explanation:<\/b> A Top N filter limits a visual to the highest or lowest number of categories based on a selected measure. You can configure the Product field to show the top seven items using [Total Sales] as the ranking measure. A relative date filter limits data by time, a drillthrough filter passes context to a destination page, and row-level security controls what data users are authorized to access. Top N filtering is specifically designed for focusing a visual on the strongest or weakest performers according to a numeric metric.<\/span><\/p>\n

                        Q12. You have an inactive relationship between the Date table and Sales[DeliveryDate]. Which DAX function can activate it temporarily inside a measure?<\/b><\/p>\n

                          \n
                        1. <\/b> USERELATIONSHIP<\/span><\/li>\n
                        2. <\/b> DISTINCT<\/span><\/li>\n
                        3. <\/b> RELATEDTABLE<\/span><\/li>\n
                        4. <\/b> PATH<\/span><\/li>\n<\/ol>\n

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

                          Explanation:<\/b> USERELATIONSHIP is used within CALCULATE or CALCULATETABLE to temporarily activate an existing inactive relationship while evaluating a measure. This is useful when a fact table contains several date fields, such as OrderDate, ShipDate, and DeliveryDate, but only one relationship can be active by default. DISTINCT returns unique values, RELATEDTABLE returns related rows, and PATH supports parent-child hierarchies. USERELATIONSHIP provides a clean way to build measures that use alternative date relationships without redesigning the model.<\/span><\/p>\n

                          Q13. A report page contains a line chart showing daily sales. You want Power BI to highlight unexpected spikes or drops automatically. Which feature should you use?<\/b><\/p>\n

                            \n
                          1. <\/b> Conditional formatting<\/span><\/li>\n
                          2. <\/b> Anomaly detection<\/span><\/li>\n
                          3. <\/b> Sync slicers<\/span><\/li>\n
                          4. <\/b> Bookmarks<\/span><\/li>\n<\/ol>\n

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

                            Explanation:<\/b> Anomaly detection can identify unusual data points in a time-series visual that differ significantly from expected patterns. It can help users discover unexpected spikes, drops, or other changes that may require investigation. Conditional formatting changes visual styling based on rules but does not perform the same type of statistical anomaly analysis. Sync slicers maintains filter selections across pages, and bookmarks capture report states. When the objective is to automatically identify unexpected behavior in a time series, anomaly detection is the most appropriate analytical feature.<\/span><\/p>\n

                            Q14. A report must allow a user to right-click a customer in a chart and navigate to a page containing that customer’s detailed transactions. Which feature should you configure?<\/b><\/p>\n

                              \n
                            1. <\/b> Report tooltip<\/span><\/li>\n
                            2. <\/b> Drillthrough<\/span><\/li>\n
                            3. <\/b> Bookmark<\/span><\/li>\n
                            4. <\/b> Q&A<\/span><\/li>\n<\/ol>\n

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

                              Explanation:<\/b> Drillthrough enables users to navigate from a summarized value to a dedicated report page that is automatically filtered by the selected context. For example, selecting a customer and using drillthrough can open a detail page containing only that customer’s transactions. Tooltips provide information on hover without leaving the current page, bookmarks save report states, and Q&A allows natural-language querying. Drillthrough is the correct choice when users need contextual navigation from a summary visual to detailed information on another page.<\/span><\/p>\n

                              Q15. You need to calculate Revenue minus Cost for every row and then sum those row-level results. Which DAX function is best suited to this calculation?<\/b><\/p>\n

                                \n
                              1. <\/b> SUMX<\/span><\/li>\n
                              2. <\/b> COUNTROWS<\/span><\/li>\n
                              3. <\/b> VALUES<\/span><\/li>\n
                              4. <\/b> MAX<\/span><\/li>\n<\/ol>\n

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

                                Explanation:<\/b> SUMX is an iterator that evaluates an expression for each row of a table and then sums the results. For example, SUMX can iterate through the Sales table, calculate Revenue minus Cost for each row, and then total all row-level profit values. SUM alone can aggregate a single column but cannot directly evaluate a multi-column expression row by row unless the result has already been stored. COUNTROWS counts records, VALUES returns distinct values, and MAX returns the highest value. SUMX is therefore appropriate for row-level arithmetic followed by aggregation.<\/span><\/p>\n

                                Q16. Your organization wants different department managers to see only records associated with their departments. What should you configure?<\/b><\/p>\n

                                  \n
                                1. <\/b> Conditional formatting<\/span><\/li>\n
                                2. <\/b> Row-level security<\/span><\/li>\n
                                3. <\/b> Visual tooltips<\/span><\/li>\n
                                4. <\/b> Mobile layout<\/span><\/li>\n<\/ol>\n

                                  Correct Answer: 2. Row-level security<\/b><\/p>\n

                                  Explanation:<\/b> Row-level security restricts which rows of data users can access based on role filters. For example, a Department table can be filtered so that each manager sees only records associated with the departments they are authorized to access. Dynamic RLS can make this more scalable by mapping signed-in users to departments. Conditional formatting changes visual appearance, tooltips provide additional context, and mobile layout changes report presentation on phones. RLS is the feature specifically designed to enforce row-level data access restrictions within Power BI semantic models.<\/span><\/p>\n

                                  Q17. You need users to drill from Year to Quarter to Month within the same visual. What should you configure?<\/b><\/p>\n

                                    \n
                                  1. <\/b> A hierarchy<\/span><\/li>\n
                                  2. <\/b> A sensitivity label<\/span><\/li>\n
                                  3. <\/b> A gateway<\/span><\/li>\n
                                  4. <\/b> A calculated table only<\/span><\/li>\n<\/ol>\n

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

                                    Explanation:<\/b> A hierarchy groups related fields into ordered levels, enabling users to drill down or drill up within supported visuals. A time hierarchy can contain Year, Quarter, Month, and Day, providing an intuitive way to explore increasingly detailed periods. Sensitivity labels classify information, gateways provide connectivity to certain external data sources, and calculated tables create model data but do not by themselves provide drill navigation. Hierarchies improve report usability when business dimensions naturally contain multiple levels of detail.<\/span><\/p>\n

                                    Q18. A large imported fact table contains 8 years of data, but only the latest 60 days are updated regularly. Which feature should you use to reduce refresh processing?<\/b><\/p>\n

                                      \n
                                    1. <\/b> Automatic page refresh<\/span><\/li>\n
                                    2. <\/b> Incremental refresh<\/span><\/li>\n
                                    3. <\/b> Data alerts<\/span><\/li>\n
                                    4. <\/b> Personal bookmarks<\/span><\/li>\n<\/ol>\n

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

                                      Explanation:<\/b> Incremental refresh partitions a large table according to date and refreshes only the recent portion that is expected to change. Historical data can remain unchanged, reducing refresh duration and resource usage. This is especially valuable for large transactional datasets where only recent records are modified. Automatic page refresh updates an open report page in supported scenarios, while data alerts and personal bookmarks are consumption features. Incremental refresh directly addresses scheduled-refresh efficiency by limiting the amount of data that must be processed after the initial load.<\/span><\/p>\n

                                      Q19. A column contains age values from 18 through 80. You want a chart to show ranges such as 18\u201329, 30\u201339, and 40\u201349 rather than individual ages. Which feature should you use?<\/b><\/p>\n

                                        \n
                                      1. <\/b> Binning<\/span><\/li>\n
                                      2. <\/b> Drillthrough<\/span><\/li>\n
                                      3. <\/b> Data category<\/span><\/li>\n
                                      4. <\/b> Query folding<\/span><\/li>\n<\/ol>\n

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

                                        Explanation:<\/b> Binning groups continuous numeric values into intervals so that they can be analyzed as ranges rather than individual values. For age data, bins can create groups such as 18\u201329 or 30\u201339, making patterns easier to visualize. Drillthrough supports navigation to detailed pages, data categories provide semantic meaning to certain fields, and query folding relates to pushing transformations to the source. Binning is specifically useful for histograms, distributions, customer segmentation, and similar analyses involving continuous numeric fields.<\/span><\/p>\n

                                        Q20. A semantic model published to the Power BI service connects to an on-premises SQL Server and must refresh automatically each night. What is typically required?<\/b><\/p>\n

                                          \n
                                        1. <\/b> An on-premises data gateway<\/span><\/li>\n
                                        2. <\/b> A report bookmark<\/span><\/li>\n
                                        3. <\/b> A decomposition tree<\/span><\/li>\n
                                        4. <\/b> A page navigator<\/span><\/li>\n<\/ol>\n

                                          Correct Answer: 1. An on-premises data gateway<\/b><\/p>\n

                                          Explanation:<\/b> An on-premises data gateway enables secure communication between the Power BI service and supported data sources located within an organization’s internal network. When a semantic model uses an on-premises SQL Server and must refresh on a schedule, the gateway is typically required so the service can access the database securely. A bookmark stores report states, a decomposition tree supports exploratory analysis, and a page navigator provides report navigation. The gateway addresses the connectivity requirement between cloud-based Power BI services and on-premises data infrastructure.<\/span><\/p>\n

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

                                            View Full ServiceNow CIS-ITSM Exam Dumps and Practice Test Dumps. Q1. You are loading a fact table into Power BI and discover that several columns contain unique transaction IDs that are not used in relationships, visuals, filters, or calculations. What should you do to optimize the model? Keep all columns to preserve source fidelity. […]<\/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\/16463"}],"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=16463"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16463\/revisions"}],"predecessor-version":[{"id":16492,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16463\/revisions\/16492"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=16463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=16463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=16463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}