View Full ServiceNow CIS-ITSM Exam Dumps and Practice Test Dumps.

Q1. A Power BI solution uses data stored in Microsoft Fabric. You want to query the data directly from OneLake without importing a separate copy into the semantic model while retaining high analytical performance. Which storage mode should you consider?

1. Import
   2. DirectQuery
   3. DirectLake
   4. Live connection only

Correct Answer: 3. DirectLake

Explanation: DirectLake is designed for supported Microsoft Fabric scenarios where Power BI can analyze data directly from OneLake without creating a traditional imported copy of the data. It can provide performance closer to Import mode while reducing duplication and refresh requirements. DirectQuery sends queries to an underlying source at query time and can introduce source and network latency. Import loads a separate copy of the data into the model. DirectLake is particularly relevant when the data already resides in Fabric and the organization wants scalable analytics with less data movement.

Q2. You have created a Power Query parameter named ServerName that is referenced by several queries. The organization moves the solution from a development SQL Server to a production SQL Server. What is the main advantage of using the parameter?

1. You can update the server value once instead of editing every query individually.
   2. The parameter automatically creates row-level security.
   3. The parameter automatically converts the model to DirectQuery.
   4. The parameter removes duplicate rows from every table.

Correct Answer: 1. You can update the server value once instead of editing every query individually.

Explanation: Power Query parameters provide reusable values that can be referenced across multiple queries. When values such as server names, file paths, dates, or environment settings change, the parameter can be updated centrally rather than requiring repeated edits throughout the transformation logic. This improves maintainability and reduces the risk of inconsistent configuration. Parameters do not automatically create security roles, change storage mode, or clean duplicate data. They are particularly useful when moving solutions between development, testing, and production environments or when a configurable value is referenced by many queries.

Q3. You combine confidential employee data with information from a public website in Power Query. Which configuration should you review to help control how data from these sources is combined?

1. Visual interaction settings
   2. Mobile layout
   3. Default summarization
   4. Data source privacy levels

Correct Answer: 4. Data source privacy levels

Explanation: Privacy levels help Power Query control how data from different sources can be combined and are designed to reduce the risk of information being unintentionally passed from a sensitive source to a less trusted source. Sources can be classified according to appropriate privacy boundaries, such as Private, Organizational, or Public. Visual interactions and mobile layout affect report presentation, while default summarization affects how columns behave in visuals. When sensitive organizational information is being combined with external public information, reviewing data source privacy levels is an important part of responsible data preparation.

Q4. You want Power BI to generate a written summary that describes important trends and notable values from report data. Which capability is most relevant?

1. Row-level security
   2. A narrative visual with Copilot
   3. Query Dependencies
   4. Incremental refresh

Correct Answer: 2. A narrative visual with Copilot

Explanation: A narrative visual with Copilot can create natural-language summaries based on Power BI data and help communicate important findings in a more accessible form. This can supplement charts by describing notable patterns, changes, or metrics for report consumers. Row-level security controls access to data rather than creating summaries. Query Dependencies is a Power Query feature for understanding how queries depend on one another, while incremental refresh optimizes refresh processing. Narrative capabilities are useful for data storytelling, especially when users benefit from concise written explanations in addition to visual analysis.

Q5. A report author wants Power BI Copilot to suggest useful content for a new report page based on the semantic model. Which activity does this represent?

1. Configuring gateway credentials
   2. Applying item-level security
   3. Creating a calculated relationship
   4. Using Copilot to suggest report-page content

Correct Answer: 4. Using Copilot to suggest report-page content

Explanation: Current Power BI capabilities include using Copilot to assist with report creation and suggest content for report pages based on the available semantic model. This can help report authors explore useful ways to present data while still requiring human review of the resulting content and business relevance. Gateway credentials concern source connectivity, item-level security governs access to Power BI assets, and calculated relationships are not what Copilot page suggestions represent. Copilot-assisted authoring is part of modern Power BI report creation and analysis capabilities covered by the current PL-300 objectives.

Q6. You want report consumers to modify a supported visual for their own view by changing the displayed measure without altering the published report for other users. Which feature should you enable?

1. Drillthrough
   2. Query folding
   3. Personalize visuals
   4. Incremental refresh

Correct Answer: 3. Personalize visuals

Explanation: Personalize visuals allows report consumers to make supported changes to visuals for their own analytical experience without modifying the original published report for everyone else. Depending on configuration, users may be able to change fields, measures, or visual types. Drillthrough provides contextual navigation to a detailed page, query folding concerns data transformation execution, and incremental refresh optimizes refresh processing. Personalization supports self-service exploration while preserving the report author’s baseline design, making it useful when users have different analytical needs but share the same governed report.

Q7. You publish a report containing confidential information. The report should be viewable by selected users, but they should not be able to export underlying data. What should you configure?

1. Report export settings
   2. A calculated table
   3. A page navigator
   4. Query Diagnostics

Correct Answer: 1. Report export settings

Explanation: Power BI report settings can control whether users are permitted to export summarized or underlying data from visuals. This is important when users are allowed to interact with a report but organizational policy restricts downloading or extracting the underlying information. A calculated table adds model data, page navigators support report navigation, and Query Diagnostics investigates Power Query performance. Export settings should be considered alongside other governance controls such as permissions, row-level security, and sensitivity labels because each control addresses a different aspect of data access and protection.

Q8. Your organization has prepared a set of approved reports and dashboards for employees. You want to distribute the content through a curated experience rather than granting users direct editing access to the workspace. What should you create?

1. A bridge table
   2. A Power BI app
   3. A calculated column
   4. A visual calculation

Correct Answer: 2. A Power BI app

Explanation: A Power BI app provides a curated distribution experience for reports, dashboards, and related content. Content creators can continue managing assets in the workspace while consumers access the published app without needing broad workspace editing permissions. This separation supports governance and provides a cleaner user experience for large audiences. A bridge table resolves certain modeling relationships, calculated columns create stored row-level results, and visual calculations perform report-layer calculations. Power BI apps are specifically designed for packaging and distributing approved analytical content to consumers.

Q9. A department manager wants an email containing a Power BI report update every Monday morning. Which feature should be configured?

1. Query parameter
   2. Bookmark navigator
   3. Subscription
   4. Calculation group

Correct Answer: 3. Subscription

Explanation: Power BI subscriptions can deliver scheduled email updates related to reports or dashboards, allowing users to receive regular information without manually opening the service. They are appropriate for recurring distribution scenarios such as weekly management reporting. Query parameters affect data retrieval or transformation, bookmark navigators help users move among saved report states, and calculation groups centralize reusable DAX calculation behavior. Subscriptions are a content-consumption and distribution feature and can help stakeholders stay informed about reports that require regular review.

Q10. A KPI on a dashboard must notify a business user when inventory drops below a specified level. Which feature should be used where supported?

1. Data alert
   2. Role-playing dimension
   3. Field parameter
   4. Query folding

Correct Answer: 1. Data alert

Explanation: Data alerts can notify users when supported dashboard values meet specified conditions. For example, an alert can be configured when inventory drops below a defined threshold or a performance measure exceeds a target. Role-playing dimensions address modeling scenarios where one dimension serves multiple business roles, field parameters provide dynamic field selection, and query folding concerns Power Query execution. Alerts are useful for proactive monitoring because users do not have to continually inspect a dashboard to know whether an important threshold has been crossed.

Q11. A user needs to create new Power BI reports from a centrally governed semantic model but should not be allowed to administer the workspace. Which permission is particularly important?

1. Gateway administrator
   2. Workspace Admin
   3. Build permission
   4. Sensitivity-label ownership

Correct Answer: 3. Build permission

Explanation: Build permission enables users to create new reports and supported analytical content based on an existing semantic model. This supports governed self-service analytics because the centralized model can retain approved relationships, calculations, and security while users build additional reports. Granting Workspace Admin would provide broader administrative permissions than required. Gateway administration concerns connectivity infrastructure, and sensitivity labels classify information rather than authorize report creation. Combining Build permission with appropriate workspace or item-level access helps follow the principle of least privilege.

Q12. You need to grant a user access to one specific Power BI item without giving the user the same level of access to every item in the workspace. What should you configure?

1. A custom visual
   2. Item-level access
   3. Query folding
   4. A new Date table

Correct Answer: 2. Item-level access

Explanation: Item-level access allows permissions to be granted for specific Power BI assets rather than automatically providing broad access to all workspace content. This supports least-privilege governance when a user needs access to one report, semantic model, or other item but should not receive wider workspace capabilities. Query folding is a data-preparation concept, a Date table supports time analysis, and custom visuals affect report presentation. Effective Power BI governance often involves combining workspace roles, item permissions, semantic model permissions, and security rules according to each user’s responsibilities.

Q13. A large imported table contains five years of data. Records older than two years will never change, while recent records are updated daily. Which configuration is most appropriate for improving refresh efficiency?

1. Report tooltips
   2. Mobile layout
   3. Page navigation
   4. Incremental refresh

Correct Answer: 4. Incremental refresh

Explanation: Incremental refresh can partition a table so that recent data is refreshed while older historical partitions remain unchanged. This can significantly reduce refresh duration and resource usage for large datasets in which only a relatively small recent period changes. Report tooltips, mobile layouts, and page navigation are presentation features and do not change semantic model refresh processing. Incremental refresh policies should be designed around the actual retention and change patterns of the data and typically rely on a suitable date or date/time field.

Q14. You need to configure a semantic model so that it refreshes automatically every night in the Power BI service. Which capability should you configure?

1. Drill mode
   2. Scheduled refresh
   3. Data bars
   4. Focus mode

Correct Answer: 2. Scheduled refresh

Explanation: Scheduled refresh allows a semantic model to update automatically according to a configured timetable in the Power BI service. The necessary credentials and, when appropriate, gateway connectivity must also be correctly configured. Drill mode controls hierarchy navigation in visuals, data bars are a conditional-formatting feature, and focus mode enlarges a visual for analysis. Scheduled refresh is a core management capability for Import models that need regular updates from their source systems without requiring users or administrators to initiate every refresh manually.

Q15. A semantic model uses an on-premises Oracle database. The model is published to the Power BI service and must refresh on a schedule. What is typically required?

1. An on-premises data gateway
   2. A report tooltip
   3. A bookmark
   4. A field parameter

Correct Answer: 1. An on-premises data gateway

Explanation: An on-premises data gateway provides secure connectivity between the Power BI service and supported data sources located inside an organization’s network. If a semantic model requires scheduled access to an on-premises Oracle database, a properly configured gateway is typically required. Report tooltips and bookmarks are report-design features, while field parameters allow users to dynamically change fields displayed in visuals. Gateway configuration should include the correct data source information, credentials, permissions, and availability so the Power BI service can access the source during refresh operations.

Q16. You are assigning users to a workspace. One user should be able to view content but should not edit reports or manage workspace membership. Which concept should you review?

1. Column distribution
   2. Query parameter
   3. Workspace roles
   4. Conditional formatting

Correct Answer: 3. Workspace roles

Explanation: Workspace roles define the levels of access users have within a Power BI workspace. They allow organizations to distinguish between users who administer, create, contribute to, or simply consume workspace content. Selecting an appropriate role supports the principle of least privilege and helps protect assets from unauthorized modification. Column distribution is a Power Query profiling feature, query parameters control configurable values in transformations, and conditional formatting affects visual appearance. Workspace role assignment is therefore the relevant management task when deciding how users can interact with workspace content.

Q17. Your organization has formally reviewed a semantic model and approved it as the authoritative source for enterprise reporting. Which action should an authorized reviewer take?

1. Apply certification to the semantic model.
   2. Add a personal bookmark.
   3. Enable visual personalization only.
   4. Create a Top N filter.

Correct Answer: 1. Apply certification to the semantic model.

Explanation: Certification is a Power BI endorsement used to identify content that has completed a formal organizational review and is considered trusted for enterprise use. It helps users distinguish authoritative semantic models from less-governed or experimental assets. Promotion is a lighter endorsement for recommended content but does not necessarily represent formal approval. Bookmarks, personalization, and filters are report-experience features rather than governance endorsements. Certification supports consistency by encouraging report authors to build from trusted analytical sources with standardized business definitions.

Q18. You need a Power BI report to restrict users so they see only rows belonging to their assigned sales territory. Which feature should you implement?

1. Data alert
   2. Mobile layout
   3. Report theme
   4. Row-level security

Correct Answer: 4. Row-level security

Explanation: Row-level security restricts the records users can access based on role filters. In a territory-based scenario, security rules can filter the relevant dimension or mapping table so that users see only the sales data associated with their permitted territory. Dynamic RLS can make this scalable by using user identity and a mapping table rather than creating a separate role for every person. Data alerts, mobile layouts, and themes do not enforce data access restrictions. RLS is therefore the appropriate Power BI security feature for controlling visibility at the row level.

Q19. You need to verify which users or groups are assigned to an existing row-level security role after the semantic model has been published. What should you review in the Power BI service?

1. Visual interactions
   2. Row-level security role membership
   3. Query Dependencies
   4. Mobile layout

Correct Answer: 2. Row-level security role membership

Explanation: After row-level security roles are defined and the semantic model is published, users or groups must be assigned appropriately so the security rules apply to the intended audience. Reviewing role membership helps verify that the correct identities are associated with each security role. Visual interactions affect report filtering behavior, Query Dependencies applies to Power Query, and mobile layout affects report presentation. Security role membership is a management task that complements the role definitions themselves and should be maintained as organizational responsibilities change.

Q20. A Power BI report contains confidential HR information. You want the content to be visibly classified according to your organization’s information-protection policy. What should you apply?

1. A report bookmark
   2. A field parameter
   3. A sensitivity label
   4. A Top N filter

Correct Answer: 3. A sensitivity label

Explanation: Sensitivity labels classify Power BI content according to an organization’s information-protection policies. They can identify content as confidential, internal, or another defined classification and can participate in broader governance and protection workflows where supported. Bookmarks capture report states, field parameters enable dynamic field selection, and Top N filters restrict categories shown in a visual. Applying sensitivity labels helps users recognize how information should be handled and is an important part of governing reports and semantic models containing confidential or regulated data.