Which of the following steps can be used to import new data into ServiceNow from a spreadsheet?
Correct Answer: B
The steps to import new data into ServiceNow from a spreadsheet are: Load Data, Create Transform Map, Run Transform. Load Data is the process of uploading the spreadsheet file and creating an Import Set table that contains the data to be imported. Create Transform Map is the process of defining how the fields from the Import Set table map to the fields of the target table in ServiceNow. Run Transform is the process of executing the Transform Map and copying the data from the Import Set table to the target table. Reference: Import sets, Transform maps
CAD Exam Question 107
Modules must have a Link type. Which one of the following is a list of Link types?
Correct Answer: B
Reference: A module is a navigation item that provides access to a feature or functionality in ServiceNow. Modules must have a link type, which determines how the module behaves when clicked. The following is a list of link types: Assessment. This is a link type that opens an assessment, which is a survey or questionnaire that measures the effectiveness of a process or service. List of Records. This is a link type that opens a list of records from a table or a saved filter. Separator. This is a link type that creates a horizontal line to separate modules in the application menu. Timeline Page. This is a link type that opens a timeline page, which is a graphical representation of the duration and sequence of events or tasks. The following are not link types, but other module attributes or field types: List of Records, Separator, Catalog Type, Roles. These are not link types, but a combination of a link type (List of Records), a module attribute (Separator), a field type (Catalog Type), and a user attribute (Roles). List of Records, Content Page, Order, URL (from arguments:). These are not link types, but a combination of a link type (List of Records), a module attribute (Content Page), a field name (Order), and a link type argument (URL). Assessment, List of Records, Content Page, Roles. These are not link types, but a combination of a link type (Assessment), a link type (List of Records), a module attribute (Content Page), and a user attribute (Roles). Reference: Modules, Create a Module
CAD Exam Question 108
What field type would you select if you want to query records from another table on a form?
Correct Answer: D
A). Use the Date field type: This is incorrect. The Date field type is designed to store date values and does not facilitate referencing records from other tables. B). Use the Phone Number field type: This is incorrect. The Phone Number field type is intended for storing phone number data and does not support referencing other table records. C). Use the String field type: This is incorrect. The String field type stores text data and does not inherently provide functionality to reference records from other tables. D). Use the Reference field type: This is correct. The Reference field type is specifically designed to create a link to a record in another table, enabling the incorporation of related data into the form. For example, in the Incident table, the "Caller" field is a reference to the User [sys_user] table, allowing the selection of a user as the caller for the incident. This setup ensures data consistency and leverages existing records without data duplication. For more detailed information, refer to the official ServiceNow documentation on Reference Fields. Explanation: In ServiceNow, to include data from another table within a form, the Reference field type is utilized. A Reference field creates a relationship between the current table and another table by storing a reference to a record in the target table. This allows users to select a record from the referenced table and display related information seamlessly within the form.
CAD Exam Question 109
Which one of the following is NOT an example of when an application might use a Scheduled Script Execution (Scheduled Job)?
Correct Answer: D
An example of when an application might not use a Scheduled Script Execution (Scheduled Job) is when the application needs to run a client-side script at the same time every day. A Scheduled Script Execution is a server-side script that runs on a specified schedule and performs some action on the server or database. A client-side script runs on the user's browser and cannot be scheduled by ServiceNow. The other options are examples of when an application might use a Scheduled Script Execution, such as sending email reminders, running a clean up script, or querying the database for unassigned records. Reference: Scheduled Script Execution, Client scripts
CAD Exam Question 110
Which one of the following is true for this script fragment? g_user.hasRole(,x_my_app_user');
Correct Answer: A
The statement that is true for this script fragment is that the method returns true if the currently logged in user has the x_my_app_user role or the admin role. The g_user.hasRole() method is a client-side method that checks whether the current user has a specified role or set of roles. If no role is specified, it returns true if the user has any role. If one or more roles are specified, it returns true if the user has any one of the specified roles. However, this method always returns true if the user has the admin role, regardless of the role parameter. Therefore, in this case, the method returns true if the user has either the x_my_app_user role or the admin role. Reference: User Object Cheat Sheet, Checking user permissions