{"id":16473,"date":"2026-09-19T07:29:51","date_gmt":"2026-09-19T07:29:51","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=16473"},"modified":"2026-09-19T07:29:51","modified_gmt":"2026-09-19T07:29:51","slug":"servicenow-cis-itsm-practice-test-questions-and-exam-dumps-part18-q341-360","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/servicenow-cis-itsm-practice-test-questions-and-exam-dumps-part18-q341-360\/","title":{"rendered":"ServiceNow CIS-ITSM Practice Test Questions and Exam Dumps Part18 Q341-360"},"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 have a Power BI semantic model that connects to a large SQL database. Users require near-real-time data, and importing the entire dataset is not practical. Which storage mode should you consider?<\/b><\/p>\n

    \n
  1. <\/b> Import<\/span><\/li>\n
  2. <\/b> Dual only<\/span><\/li>\n
  3. <\/b> Calculated table<\/span><\/li>\n
  4. <\/b> DirectQuery<\/span><\/li>\n<\/ol>\n

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

    Explanation:<\/b> DirectQuery keeps the data in the underlying source rather than importing all rows into the Power BI semantic model. When users interact with the report, Power BI sends queries to the source to retrieve the required results. This can be appropriate for very large datasets or scenarios requiring fresher data than scheduled Import refresh can provide. Performance depends heavily on the source system, network latency, model design, and DAX efficiency. Import typically provides faster interactive performance but requires data to be loaded into memory. Calculated tables do not provide near-real-time source access.<\/span><\/p>\n

    Q2. A table imported into Power Query has columns arranged as rows and rows arranged as columns. You need to reverse this orientation. Which transformation should you use?<\/b><\/p>\n

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

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

      Explanation:<\/b> Transpose switches the rows and columns of a table. Values previously displayed across a row become values in a column, while existing columns become rows. This is useful when source files have been structured for human presentation rather than analytical processing. Unpivot Columns converts selected columns into attribute-value pairs but does not simply exchange the table’s entire row and column orientation. Group By summarizes records, while Append Queries stacks rows from multiple tables. Transpose is therefore the correct transformation when the complete table orientation needs to be reversed before further preparation.<\/span><\/p>\n

      Q3. You need to create a measure that returns the total sales value when a report has filters applied but ignores only the filter on Salesperson. Which DAX approach is most appropriate?<\/b><\/p>\n

        \n
      1. <\/b> CALCULATE with REMOVEFILTERS on the Salesperson field or table<\/span><\/li>\n
      2. <\/b> FORMAT with Salesperson<\/span><\/li>\n
      3. <\/b> COUNTROWS on the Date table<\/span><\/li>\n
      4. <\/b> CONCATENATE the salesperson names<\/span><\/li>\n<\/ol>\n

        Correct Answer: 1. CALCULATE with REMOVEFILTERS on the Salesperson field or table<\/b><\/p>\n

        Explanation:<\/b> CALCULATE can modify the filter context in which a measure is evaluated. By using REMOVEFILTERS specifically on Salesperson, the calculation can ignore salesperson selections while continuing to respect filters such as Date, Product, Region, or Customer. This is useful for benchmarks, percentages, and comparisons against broader totals. FORMAT only changes how values are displayed, COUNTROWS performs a row count, and CONCATENATE combines text. Targeted filter removal is important because clearing all filters would produce a different result and could ignore report context that should remain active.<\/span><\/p>\n

        Q4. You need to visualize the stages of a recruitment process: Applied, Screened, Interviewed, Offered, and Hired. Which visual is generally most suitable?<\/b><\/p>\n

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

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

          Explanation:<\/b> A Funnel chart is designed to represent sequential stages in a process and is especially useful when the number of records typically decreases from one stage to the next. Recruitment, sales pipelines, and conversion journeys are common use cases. The visual makes it easy to see where the largest drop-offs occur between stages. A Scatter chart is intended for relationships between numeric variables, a Gauge compares a value with a target, and a Map displays geographic information. For stage-based process analysis, a Funnel chart communicates progression and attrition clearly.<\/span><\/p>\n

          Q5. Your model contains a very large DirectQuery fact table. Most reports analyze data only by month and product category. What feature can improve performance by answering high-level queries from summarized data?<\/b><\/p>\n

            \n
          1. <\/b> Report bookmarks<\/span><\/li>\n
          2. <\/b> Aggregation tables<\/span><\/li>\n
          3. <\/b> Conditional formatting<\/span><\/li>\n
          4. <\/b> Mobile layout<\/span><\/li>\n<\/ol>\n

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

            Explanation:<\/b> Aggregation tables store pre-summarized data at a higher grain, such as Month and Product Category, and can answer suitable analytical queries without repeatedly querying detailed fact rows. In large DirectQuery or composite-model scenarios, this can significantly improve performance when many reports operate at summarized levels. Bookmarks control report states, conditional formatting changes visual appearance, and mobile layout optimizes reports for phones. Aggregations should be carefully designed so Power BI can map high-level queries to the summarized table while still allowing detailed analysis to use the underlying fact data when necessary.<\/span><\/p>\n

            Q6. A report user needs to choose a discount assumption from a range of 0% to 30% and immediately see projected revenue. Which Power BI feature is designed for this scenario?<\/b><\/p>\n

              \n
            1. <\/b> Drillthrough<\/span><\/li>\n
            2. <\/b> Query Diagnostics<\/span><\/li>\n
            3. <\/b> Data alert<\/span><\/li>\n
            4. <\/b> What-if parameter<\/span><\/li>\n<\/ol>\n

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

              Explanation:<\/b> A What-if parameter creates a user-selectable numeric value that can be incorporated into DAX calculations. It is well suited to scenario analysis involving assumptions such as discounts, growth rates, interest rates, or targets. Power BI can create a supporting parameter table, a selected-value measure, and a slicer for user interaction. Drillthrough provides navigation to detail pages, Query Diagnostics investigates Power Query behavior, and data alerts notify users about supported threshold conditions. What-if parameters allow users to test assumptions without changing the original source data.<\/span><\/p>\n

              Q7. You are importing a text file where the first row contains data instead of column names. Power Query automatically assigned generic names such as Column1 and Column2. What should you do?<\/b><\/p>\n

                \n
              1. <\/b> Keep the generic names.<\/span><\/li>\n
              2. <\/b> Create calculated measures for the headings.<\/span><\/li>\n
              3. <\/b> Rename the columns to meaningful business names.<\/span><\/li>\n
              4. <\/b> Convert all fields to Boolean.<\/span><\/li>\n<\/ol>\n

                Correct Answer: 3. Rename the columns to meaningful business names.<\/b><\/p>\n

                Explanation:<\/b> Meaningful column names improve model usability, maintainability, and report authoring. If the source does not contain a valid header row, Power Query may create generic names such as Column1 and Column2. These should be renamed according to the business meaning of each field before the data is loaded. Generic names make relationships, transformations, DAX formulas, and report fields harder to understand. Calculated measures are unrelated to column naming, while changing every field to Boolean would corrupt the data types. Clear naming is an important part of preparing a professional Power BI dataset.<\/span><\/p>\n

                Q8. You need to calculate the smallest value produced by multiplying Quantity by UnitCost for every row in a table. Which DAX function should you use?<\/b><\/p>\n

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

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

                  Explanation:<\/b> MINX iterates over a table, evaluates an expression for each row, and returns the smallest result. In this scenario, it can calculate Quantity multiplied by UnitCost for every row and then identify the minimum calculated amount. MIN is appropriate when the minimum comes directly from an existing column, but it does not evaluate a custom row-by-row expression in the same way. COUNTX counts evaluated values, while SUM adds a numeric column. Iterator functions ending in X are useful when a calculation must be performed before an aggregation such as minimum, maximum, average, or sum.<\/span><\/p>\n

                  Q9. Your organization wants users to identify which semantic models are recommended by content owners but have not completed the formal certification process. Which endorsement should you use?<\/b><\/p>\n

                    \n
                  1. <\/b> Promoted<\/span><\/li>\n
                  2. <\/b> Certified<\/span><\/li>\n
                  3. <\/b> Confidential<\/span><\/li>\n
                  4. <\/b> Featured<\/span><\/li>\n<\/ol>\n

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

                    Explanation:<\/b> Promotion is an endorsement that indicates content is useful or recommended without implying that it has gone through a formal organizational certification process. Certification is typically reserved for content that has been reviewed and approved according to established governance standards. A sensitivity classification such as Confidential serves a different purpose by identifying information-protection requirements. Promotion is therefore useful when content owners want to improve discoverability and signal that a semantic model is suitable for reuse while maintaining a clear distinction from formally certified enterprise content.<\/span><\/p>\n

                    Q10. A report contains a long list of products in a table. You want users to quickly locate one product by typing part of its name. Which report feature should you provide?<\/b><\/p>\n

                      \n
                    1. <\/b> Gauge<\/span><\/li>\n
                    2. <\/b> Search-enabled slicer<\/span><\/li>\n
                    3. <\/b> Waterfall chart<\/span><\/li>\n
                    4. <\/b> Query parameter<\/span><\/li>\n<\/ol>\n

                      Correct Answer: 2. Search-enabled slicer<\/b><\/p>\n

                      Explanation:<\/b> A slicer with search enabled allows users to type part of a product name and quickly locate matching values without scrolling through a long list. This improves usability when categorical fields contain many distinct members. A Gauge compares one value with a target, while a Waterfall chart explains positive and negative contributions to a total. Query parameters affect data retrieval or transformation rather than interactive report filtering. Searchable slicers are particularly helpful for customer names, product names, locations, employee names, and other high-cardinality categorical fields used for report filtering.<\/span><\/p>\n

                      Q11. You have a measure that should return a different result depending on whether the report is filtered to a specific product. Which DAX function can detect direct filtering on the Product column?<\/b><\/p>\n

                        \n
                      1. <\/b> ISFILTERED<\/span><\/li>\n
                      2. <\/b> SUMMARIZE<\/span><\/li>\n
                      3. <\/b> DATE<\/span><\/li>\n
                      4. <\/b> CROSSJOIN<\/span><\/li>\n<\/ol>\n

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

                        Explanation:<\/b> ISFILTERED tests whether a specified column or table is directly filtered in the current context. This can support conditional measures, dynamic messages, or alternative calculations depending on how users interact with slicers and filters. SUMMARIZE creates grouped table expressions, DATE constructs a date value, and CROSSJOIN produces combinations of rows from tables. ISFILTERED differs from functions that test whether only one value exists; it specifically determines whether a direct filter has been applied. This makes it useful when report logic needs to react to the presence of filtering.<\/span><\/p>\n

                        Q12. You need to display sales performance for each store as a separate repeated chart using the same axes and formatting. Which visual feature should you use?<\/b><\/p>\n

                          \n
                        1. <\/b> Drillthrough<\/span><\/li>\n
                        2. <\/b> Report tooltip<\/span><\/li>\n
                        3. <\/b> Small multiples<\/span><\/li>\n
                        4. <\/b> Row-level security<\/span><\/li>\n<\/ol>\n

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

                          Explanation:<\/b> Small multiples create repeated versions of the same chart for each value of a selected category. For example, a sales trend chart can be repeated for every store while maintaining consistent axes and formatting, making cross-store comparisons easier. Drillthrough navigates to detail pages, tooltips provide extra information on hover, and row-level security limits which data users can access. Small multiples are useful when a report author wants consistent side-by-side visual comparisons without manually building and maintaining a separate visual for every category.<\/span><\/p>\n

                          Q13. A query uses several steps after connecting to a relational database. You want to move a filtering transformation as early as possible. Why is this generally beneficial?<\/b><\/p>\n

                            \n
                          1. <\/b> It can reduce the amount of data processed by later steps.<\/span><\/li>\n
                          2. <\/b> It automatically creates row-level security.<\/span><\/li>\n
                          3. <\/b> It creates additional model relationships.<\/span><\/li>\n
                          4. <\/b> It makes every column high cardinality.<\/span><\/li>\n<\/ol>\n

                            Correct Answer: 1. It can reduce the amount of data processed by later steps.<\/b><\/p>\n

                            Explanation:<\/b> Filtering unnecessary rows early in the data-preparation process can reduce the volume of information processed by later transformations. When query folding is available, the filter may also be delegated to the source system, further improving refresh efficiency by reducing transferred data. Early filtering does not create security roles or relationships and does not increase cardinality intentionally. Power Query transformations should generally be ordered to minimize unnecessary processing while preserving the required business logic. Reducing data as early as practical is an important optimization technique for large datasets.<\/span><\/p>\n

                            Q14. You need a calculation that returns the number of working days between two dates while excluding weekends. Which type of logic should you implement?<\/b><\/p>\n

                              \n
                            1. <\/b> Geographic binning<\/span><\/li>\n
                            2. <\/b> Business-day date calculation<\/span><\/li>\n
                            3. <\/b> Row-level security<\/span><\/li>\n
                            4. <\/b> Visual interaction editing<\/span><\/li>\n<\/ol>\n

                              Correct Answer: 2. Business-day date calculation<\/b><\/p>\n

                              Explanation:<\/b> Calculating working days requires date logic that excludes weekends and, when required, holidays. This can be implemented using suitable DAX date functions or a Date table containing an IsWorkingDay indicator. A dedicated calendar can provide greater flexibility when organizational holidays must also be considered. Geographic binning groups numeric or location data, row-level security controls data access, and visual interactions govern how selections affect other visuals. Business-day calculations are common in service delivery, fulfillment, project management, and operational reporting scenarios where calendar-day differences are not sufficient.<\/span><\/p>\n

                              Q15. A Power BI model contains a column with long product descriptions that are never used in reports, relationships, or calculations. What should you do to optimize an Import model?<\/b><\/p>\n

                                \n
                              1. <\/b> Remove the column before loading.<\/span><\/li>\n
                              2. <\/b> Create a duplicate of the column.<\/span><\/li>\n
                              3. <\/b> Add it to every visual.<\/span><\/li>\n
                              4. <\/b> Convert it into a hierarchy.<\/span><\/li>\n<\/ol>\n

                                Correct Answer: 1. Remove the column before loading.<\/b><\/p>\n

                                Explanation:<\/b> Unused long text fields can consume substantial memory, especially when they contain many distinct values. If the product descriptions are not required for visuals, filtering, relationships, calculations, drillthrough, or other business needs, removing them before loading can reduce semantic model size and improve refresh efficiency. Duplicating the field would make the model larger, while adding it to visuals would not provide a performance benefit. Hierarchies are intended for ordered drill levels rather than model optimization. Efficient Power BI models should contain only data required to satisfy reporting and analytical requirements.<\/span><\/p>\n

                                Q16. You need to prevent one visual from responding to selections made in a slicer while all other visuals should continue responding normally. Which feature should you use?<\/b><\/p>\n

                                  \n
                                1. <\/b> Sensitivity labels<\/span><\/li>\n
                                2. <\/b> Data source privacy<\/span><\/li>\n
                                3. <\/b> Deployment pipelines<\/span><\/li>\n
                                4. <\/b> Edit interactions<\/span><\/li>\n<\/ol>\n

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

                                  Explanation:<\/b> Edit interactions lets the report author control how each visual responds to selections from another visual or slicer. A target visual can be configured to be filtered, highlighted, or unaffected. This allows one chart to remain constant as a reference while other visuals update with user selections. Sensitivity labels classify information, privacy settings govern how Power Query combines data sources, and deployment pipelines manage lifecycle stages. Edit interactions is specifically designed to customize the interactive behavior between visuals on a report page.<\/span><\/p>\n

                                  Q17. You need to create a table containing all values from two DAX table expressions that have compatible columns. Which function should you use?<\/b><\/p>\n

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

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

                                    Explanation:<\/b> UNION combines rows from two or more compatible table expressions into a single table expression. It is conceptually similar to appending tables, although it operates within DAX rather than Power Query. DIVIDE performs numerical division, RELATED retrieves a value through an existing relationship, and DATEDIFF calculates the difference between two dates using a specified interval. UNION can be useful when calculated tables or intermediate DAX expressions need to consolidate records from multiple compatible sets while retaining a common column structure.<\/span><\/p>\n

                                    Q18. A report author wants visual titles, button text, and other elements to follow a consistent company style across reports. Which feature can help standardize formatting?<\/b><\/p>\n

                                      \n
                                    1. <\/b> Query folding<\/span><\/li>\n
                                    2. <\/b> Report theme<\/span><\/li>\n
                                    3. <\/b> Bridge table<\/span><\/li>\n
                                    4. <\/b> Incremental refresh<\/span><\/li>\n<\/ol>\n

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

                                      Explanation:<\/b> A report theme can standardize visual formatting, including fonts, colors, and other supported stylistic properties. Themes help organizations maintain a consistent brand identity and reduce the amount of manual formatting required across reports. Query folding concerns data transformation execution, bridge tables resolve modeling relationships, and incremental refresh improves refresh efficiency for large datasets. Consistent report styling improves usability and professionalism, but designers should also consider accessibility requirements such as sufficient contrast and readable text rather than relying exclusively on brand colors.<\/span><\/p>\n

                                      Q19. You need to test how a report appears for a row-level security role before publishing it. Which Power BI Desktop feature should you use?<\/b><\/p>\n

                                        \n
                                      1. <\/b> View as<\/span><\/li>\n
                                      2. <\/b> Performance Analyzer<\/span><\/li>\n
                                      3. <\/b> Query Dependencies<\/span><\/li>\n
                                      4. <\/b> Column Profile<\/span><\/li>\n<\/ol>\n

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

                                        Explanation:<\/b> View as allows developers to test row-level security roles inside Power BI Desktop. Selecting a role simulates the filters that users assigned to that role would experience, helping verify whether data is properly restricted. This testing is important before publishing because incorrectly configured security rules can expose unauthorized information or hide valid data. Performance Analyzer measures visual performance, Query Dependencies displays Power Query relationships, and Column Profile provides data-quality information. View as is specifically intended to validate RLS behavior during development.<\/span><\/p>\n

                                        Q20. A report includes a monthly time series, and you need to show a three-month rolling average to smooth short-term fluctuations. Which approach should you use?<\/b><\/p>\n

                                          \n
                                        1. <\/b> Convert Month to text.<\/span><\/li>\n
                                        2. <\/b> Use a data alert.<\/span><\/li>\n
                                        3. <\/b> Create a rolling-average measure or appropriate visual calculation.<\/span><\/li>\n
                                        4. <\/b> Create a many-to-many relationship.<\/span><\/li>\n<\/ol>\n

                                          Correct Answer: 3. Create a rolling-average measure or appropriate visual calculation.<\/b><\/p>\n

                                          Explanation:<\/b> A rolling average evaluates a measure across a moving window, such as the current month and the previous two months. It smooths short-term fluctuations and helps users recognize longer-term trends. This can be implemented with DAX using a proper Date table or through an appropriate visual calculation where supported. Converting month values to text does not create a rolling window, data alerts provide notifications, and relationship cardinality is unrelated. The rolling period should be clearly defined so users understand exactly which months contribute to each displayed average.<\/span><\/p>\n

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

                                            View Full ServiceNow CIS-ITSM Exam Dumps and Practice Test Dumps. Q1. You have a Power BI semantic model that connects to a large SQL database. Users require near-real-time data, and importing the entire dataset is not practical. Which storage mode should you consider? Import Dual only Calculated table DirectQuery Correct Answer: 4. DirectQuery Explanation: […]<\/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\/16473"}],"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=16473"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16473\/revisions"}],"predecessor-version":[{"id":16482,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/16473\/revisions\/16482"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=16473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=16473"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=16473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}