Free CAS-PA sample questions

Correct answer: var total = [[# of Successful Changes]] + [[# of Unsuccessful Changes]]; if (total > 0) { ( [[# of Successful Changes]] / total ) * 100; } else { 0; }

This formula correctly uses JavaScript within the formula indicator to first calculate the total, then checks if the total is greater than zero before performing the division. This prevents a 'division by zero' error, which would result in an invalid score (NaN). The `if/else` block provides a safe fallback value of 0 when no changes have occurred.

Correct answer: Use the 'Resolve time' metric from the Metric Definition [metric_definition] table and ensure the 'On Hold' state is excluded in its definition.

ServiceNow's metric engine is designed for this purpose. By ensuring the Metric Definition for resolution time (e.g., 'Incident State Duration') is configured to exclude the 'On Hold' state from its calculation, any indicator based on this metric will automatically reflect the accurate, active resolution time without the need for complex indicator scripts.

Correct answers: Set the 'Facts table' to the Location [cmn_location] table.; Specify the 'Parent' field on the Breakdown Source record, pointing to the field that defines the parent-child link (e.g., 'parent').

The breakdown source must be based on the table that contains the hierarchy itself, which in this case is the Location [cmn_location] table.

The 'Parent' field explicitly tells Performance Analytics how to traverse the hierarchy. You must specify the field in the facts table (cmn_location) that links a record to its parent.

Correct answer: Analyze the conditions on the indicator source and create a composite database index on the 'incident_metric' table for the fields used in those conditions.

A timeout caused by a full table scan on a large table is a classic database performance problem. The most direct and effective solution is to create a database index that matches the fields used in the `WHERE` clause of the query (defined by the indicator source conditions). This allows the database to quickly find the relevant records without scanning the entire table, drastically improving query performance and resolving the timeout.

Correct answer: An Interactive Filter

Interactive Filters are dashboard components that allow users to filter the data displayed in multiple widgets on the same dashboard simultaneously. By setting up an 'Assignment Group' interactive filter and configuring the widgets to follow it, a user can select a group and see all related widgets update accordingly.

Correct answer: False

False. ServiceNow's development best practices recommend copying and customizing (or extending) out-of-the-box components rather than modifying them directly. However, even if you do modify a content pack component, the platform upgrade process tracks these changes as 'Customer Updates'. During an upgrade, you can review conflicts and choose to retain your customizations rather than having them overwritten by the new version.

Correct answer: Bucket Groups

Bucket Groups are specifically designed to group multiple values from a field into a single, logical bucket for reporting and analysis. This allows for creating higher-level categorizations without altering the source data or writing complex scripts.

Correct answer: The Spotlight Group record's 'Weight' field

Within a Spotlight Group, you define multiple criteria, each based on an indicator. Each criterion has a 'Weight' field. This weight determines how much that specific indicator contributes to the overall calculated score for the ranked items. A higher weight means the indicator has more influence on the final ranking.

Correct answer: Aggregate: COUNT DISTINCT, Value when nil: 0, Field: approver

To count the number of unique or distinct values in a field, the `COUNT DISTINCT` aggregate function is used. By applying this aggregate to the 'approver' field (which references the user record), the data collection job will count each unique user only once within the specified time period, correctly calculating the number of distinct approvers.

Correct answer: A Custom Business Calendar with fiscal period start and end dates defined, and then associate indicators with this calendar.

The Performance Analytics application provides the ability to create Custom Business Calendars. This feature allows organizations to define their own time periods, such as a 4-4-5 fiscal calendar. Once the custom calendar and its periods are defined, indicators can be associated with it, enabling score collection and analysis that aligns perfectly with the organization's fiscal reporting structure.