Data & Analytics Management (14%)
Quiz by Hope Pate
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
- Q1
Where can you make a field required? (Choose 3)
1. Record Type
2. Validation Rules
3. Workflow Rule
1. Validation Rules
2. Field Edit page
3. Page Layouts
1. Flow Builder
2. Record Type
3. Field Edit page
1. Page Layouts
2. Workflow Rule
3. Flow Builder
120s - Q2
As the Salesforce Administrator, what do you need to set up to define what happens when duplicate records are detected?
Data.com Rules
Matching Rules
Duplicate Rules
Deduplication Rules
120s - Q3
When can the Data Export Service be run? (Choose 3)
1. Immediately
2. Weekly
3. Monthly
1. Daily
2. Monthly
3. Yearly
1. Bi-weekly
2. Monthly
3. Yearly
1. Immediately
2. Daily
3. Bi-weekly
120s - Q4
Which statements about custom summary formulas in reports are TRUE? (Choose 2)
1. Custom summary formulas can reference another custom summary formula
2. Reports can be grouped by a custom summary formula result
1. Custom summary formulas can reference another custom summary formula
2. Custom summary formulas can reference a formula field within a report
1. Custom summary formulas can reference a formula field within a report
2. Custom summary formulas can be used in a report built from a custom report type
1. Custom summary formulas can be used in a report built from a custom report type
2. Reports can be grouped by a custom summary formula result
120s - Q5
What is NOT a chart available to use on a Lightning dashboard?
Donut
Pie
Line
Funnel
120s - Q6
A custom picklist you have created has ‘Restrict picklist values’ selected. What is the default functionality if you attempt to upload a value that doesn’t exist using the Data Loader?
The value will be blocked and the record will fail
The value will be inserted into the picklist
The value will be inserted into the inactive picklist values
The record will be inserted but the picklist value will not
120s - Q7
What is TRUE of both the Data Import Wizard and Data Loader? (Choose 2)
1. The source file must be a CSV file
2. Running workflow rules and processes is optional
1. Validation rules and triggers will fire
2. The source file must be a CSV file
1. They can import over 100,000 records
2. Validation rules and triggers will fire
1. They can import over 100,000 records
2. Running workflow rules and processes is optional
120s - Q8
Report types control which of the following? (Choose 3)
1. The filters that can be applied to the report
2. The chart components that can be added to the report
3. Which users can access the report
1. The filters that can be applied to the report
2. The objects and fields that can be added to a report as columns
3. The default columns that are displayed in the report
1. The default columns that are displayed in the report
2. Which users can access the report
3. The chart components that can be added to the report
1. Which users can access the report
2. The objects and fields that can be added to a report as columns
3. The chart components that can be added to the report
120s - Q9
Only certain users should be able to export reports in Salesforce. Where can this permission be controlled? (Choose 2)
1. Enable ‘Export Reports’ at Profile level
2. Enable ‘Export Report’ on an individual report
1. Enable ‘Export Reports’ at Permission Set level
2. Enable ‘Export Reports’ at Profile level
1. Add the ‘Export Report’ feature license for specific users
2. Enable ‘Export Reports’ at Permission Set level
1. Add the ‘Export Report’ feature license for specific users
2. Enable ‘Export Report’ on an individual report
120s - Q10
Cloudy Computing are concerned that a large portion of their storage allowance is being used up by specific users uploading files and attachments to Salesforce. As the Salesforce Administrator, what could you do to support? (Choose 2)
1. Check Cloudy Computing’s file storage via Storage Usage in Setup
2. Check Cloudy Computing’s data storage via Storage Usage in Setup
1. Check ‘Top Users by Data Storage Usage’
2. Check ‘Top Users by File Storage Usage’
1. Check ‘Top Users by File Storage Usage’
2. Check Cloudy Computing’s file storage via Storage Usage in Setup
1. Check ‘Top Users by Data Storage Usage’
2. Check Cloudy Computing’s data storage via Storage Usage in Setup
120s - Q11
How many child objects can be selected when creating a custom report type?
1
4
2
3
120s - Q12
As the Salesforce Administrator you have been asked to create a dynamic dashboard, however, when you ‘Save’ your dashboard you receive an error that this option is not available to you. Your company is using Enterprise edition. What could be the cause?
You need to ask Salesforce Support to enable dynamic dashboards
You need to upgrade to Unlimited Edition
Your company has exceeded the limit of 5 dynamic dashboards
Your company has exceeded the limit of 10 dynamic dashboards
120s - Q13
What is TRUE about summary formula fields in reports? (Choose 3)
1. Summary formulas can be COUNT, AVG, MAX and MIN
2. You can filter report data by summary formula columns
3. Data in reports must be grouped before a summary formula field can be added
1. You cannot group report data by summary formula columns
2. Summary formulas can be SUM, AVG, MAX, MIN, and UNIQUE
3. Data in reports must be grouped before a summary formula field can be added
1. You can filter report data by summary formula columns
2. Summary formulas can be COUNT, AVG, MAX and MIN
3. You cannot group report data by summary formula columns
1. Summary formulas can be SUM, AVG, MAX, MIN, and UNIQUE
2. You can filter report data by summary formula columns
3. Data in reports must be grouped before a summary formula field can be added
120s - Q14
What is TRUE about IDs in Salesforce? (Choose 3)
1. The 18 character ID is displayed in the record web browser
2. Data Loader and the Data Export Service return the 18 digit ID
3. ID’s are always case sensitive
1. If a record is deleted and subsequently restored it’s ID will change
2. ID’s are always case sensitive
3. The 18 character ID is displayed in the record web browser
1. Reports return the 15 digit ID
2. Data Loader and the Data Export Service return the 18 digit ID
3. The 18 character ID is displayed in the record web browser
1. ID’s are always case sensitive
2. If a record is deleted and subsequently restored it’s ID will change
3. Reports return the 15 digit ID
120s - Q15
A field is included in a report but is not visible on the record page layout. What is true in this scenario?
If the user viewing the report has at least ‘View’ access to the field, regardless of the page layout, the field will be displayed on the report
If the user viewing the report has at least ‘View’ access to the field, regardless of the page layout, the field will be displayed on the report
If a field is included in a report, a user will always have visibility, regardless of other sharing settings
A user requires ‘Edit’ access to view fields in reports that are not displayed on the record page layout
120s