Data & analytics

Question 1

A sales manager at Ursa Major Solar wants a team of sales reps to know how many open opportunities they have at any given time. How should an administrator configure a report for each sales rep to see their own open opportunities?

1. CREATE A REPORTING SNAPSHOT GROUPED BY SALES REP.
2. CREATE A REPORT WITH A CROSS FILTER BY MY OPPORTUNITIES.
3. CREATE A REPORT FILTERED BY MY OPPORTUNITIES.
4. CREATE A REPORT SCHEDULE FOR EACH SALES REP.

Answer 1

3.CREATE A REPORT FILTERED BY MY OPPORTUNITIES.

This report would show a sales rep their own open opportunities. ///The Cross Filters choice is incorrect bc they are are used in reports to filter for cross object

Question 2

Which two of these report charts show how many leads are in the marketing pipeline based on lead status and what percent each lead status represents?

1. GROUPED BAR CHART
2. PIE CHART
3. DONUT CHART
4. LINE CHART

Answer 2

1. GROUPED BAR CHART: Incorrect. A grouped bar chart shows siloed, individual lead information.
2. PIE CHART:
3. DONUT CHART Correct. A pie and a Donut chart shows the number of leads as well as the percentage of leads as part of the whole.
4. LINE CHART: Incorrect. A line chart does not show a percentage of leads relative to the whole

Question 3

A finance user with the View All Data permission enabled sees no opportunities when opening a sales pipeline report. However, a Sales Rep sees opportunities as expected. opportunities should be visible to only those with permission. Which two actions should the administrator perform to resolve this problem?

Answer 3

• Select Save Hierarchy Level on the pipeline report. ensure that the hierarchy level that was used when creating a report will stay intact. so, if the Finance User had permission to see reports originally, that will be the case when any subsequent report is created.
• Updating the report filter to show all opportunities would allow users with
  the View All Data permission enabled to see all of the opportunities on
  the report.

Question 4

What should an administrator configure to provide each Sales Rep a dashboard that shows their current Opportunity pipeline?

1. Set a dashboard filter to the current user
2. Create a dashboard folder for each user
3. Filter the dashboard with a dynamic view set to the VP of sales
4. Set the Dashboard running user to “the dashboard viewer”

Answer 4

4. Set the Dashboard running user to “the dashboard viewer”

• *This will ensure the Dashboard shows only data relevant to the**
• *user viewing it.**

Question 5

A sales user wants to add components to their dashboard. What is the maximum number of components that can be added to a single Dashboard?

1. 3
2. 15
3. 20
4. 50

Answer 5

3. 20

Each dashboard can have up to 20 components

Question 6

What should the system administrator check when users are unable to find a Custom Report Type?

Answer 6

MAKE SURE THE NEW REPORT TYPE IS DEPLOYED.

Users will not be able to access a custom report type if it hasn’t been deployed.

Question 7

Ursa Major Solar uses a private data access model. Product managers and sales representatives are in different branches of the role hierarchy. What should an administrator do to ensure that product managers can report on opportunities in their product line?

1. CREATE A SHARING RULE BASED ON CRITERIA
2. SAVE ALL OPPORTUNITY REPORTS IN A PUBLIC FOLDER
3. MOVE ALL PRODUCT MANAGERS TO A ROLE BELOW THE SALES REPRESENTATIVES.
4. CREATE A NEW ROLE FOR PRODUCT MANAGERS AND SALES REPRESENTATIVES

Answer 7

CREATE A SHARING RULE BASED ON CRITERIA.

Criteria-based sharing rules determine what records to share based on field values other than ownership

Question 8

Ursa Major Solar regularly imports accounts from an external order system that has its own ID field for each record. What should the system administrator do to help prevent duplicates during these imports?

1. IMPORT THE DATA USING THE DATA LOADER.
2. USE THE ID FROM THE ORDER SYSTEM IN PLACE OF THE SALESFORCE ID.
3. CREATE A UNIQUE EXTERNAL ID FIELD ON ACCOUNTS IN SALESFORCE FOR MATCHING.
4. CREATE A FORMULA FIELD THAT IDENTIFIES MATCHES.

Answer 8

3. CREATE A UNIQUE EXTERNAL ID FIELD ON ACCOUNTS IN SALESFORCE FOR MATCHING.

Creating a unique External ID field on Accounts would guarantee no duplicates from an external order system.

Question 9

The sales operations team at Ursa Major Solar needs to import and export accounts, contacts, opportunities, and orders. Which two profile permissions does the sales operation team need to be able to perform this task?

1. API ENABLED
2. MODIFY ALL FOR THOSE OBJECTS
3. VIEW ALL DATA
4. WEEKLY DATA EXPORT

Answer 9

1. API ENABLED: To use the Data Loader for importing and exporting the profile permissions need API Enabled.
2. MODIFY ALL FOR THOSE OBJECTS: The Modify All setting on those objects means users with this permission can view, edit and delete all records regardless of sharing. This meets the need of importing and exporting on just the stated objects

Question 10

The director of operations at Ursa Major Solar has noticed that when sales reps move opportunities to the closed stage, they don’t always fill in the product installation date. When the date is not logged, the operations team has to reach out to the sales rep to confirm the installation date. The director of operations has requested that sales reps not be able to close an opportunity without first logging the product installation date.
Which feature allows Ursa Major Solar to require a value in the product installation date, a custom date field, when the opportunity stage changes to Closed?

Answer 10

Validation rules can be used to make fields conditionally
required based on the Opportunity stage

Question 11

Ursa Major Solar is importing data and has many records that do not meet the data validation criteria.
What will occur?

Answer 11

THE IMPORT PROCESS WILL FAIL, BUT ONLY FOR THE RECORDS WITH INVALID DATA.

Salesforce runs validation rules on records before they are imported. Records that fail validation are not imported.

Question 12

How long is data stored in the Recycle Bin?

Answer 12

Up to 15 days

Question 13

Ursa Major Solar has inconsistent data in its 20,000 existing Accounts and asked the System Administrator to convert all of the standards
country fields to ISO codes. Which method should the System Administrator use?

Answer 13

Mass update addresses

Question 14

Which set of Salesforce records is exported by choosing the “Export All” option instead of “Export” in Data Loader?

Answer 14

• *Records for a specified object including records in**
• *the recycle bin.**

Question 15

A System Administrator will use the Import Wizard to update existing Account records. Which two values can the Import Wizard use to find matching records?

Answer 15

• Account Name
• Site fields

You want to prevent duplicates by uploading records according to account name and site, contact email address, or lead email address.

Question 16

Which configuration option shows sales representatives the fields they must fill in prior to saving an opportunity?

Answer 16

Required fields in the Page Layout

Question 17

Lookup filter

Answer 17

• *Administrator settings that restrict the valid values and lookup dialog results for lookup, master-detail, and hierarchical relationship fields**
• *(For example, restrict the Account Name field on opportunities to allow only active accounts.)**

Question 18

Data Import Wizard

Answer 18

• A tool to import data for many standard Salesforce objects, including accounts, contacts, leads, solutions, campaign members, and person accounts.
• Can also import data for custom objects
• Can import up to 50,000 records at a time

Question 19

Validation Rules

Answer 19

Verify that the data a user enters in a record meets
the standards you specify before the user can save
the record

Question 20

Data Loader vs Import Wizard

Use Data Loader when:

Answer 20

• An application for the bulk import or export of data. Use it to insert, update, delete, or export Salesforce records.
• You need to load 50,000 to 5,000,000 records. Data Loader is supported for loads of up to 5 million records
• You want to schedule regular data loads, such as nightly imports
• You want to export your data for backup purposes
• You need to load into an object that is not yet supported by the import wizards.

Question 21

Data Loader vs Import Wizard

Use the import wizard when:

Answer 21

• You are loading less than 50,000 records
• You want to prevent duplicates by uploading records according to account name and site, contact email address, or lead email address.

Question 22

What report should an administrator use to display the number of contacts related to an account?

Answer 22

Summary report with a report formula

Question 23

• *Which three reports can be used to display a list of**
• *the Top 10 Accounts on a dashboard?**

Answer 23

• Tabular report with Rows to Display set to 10
• Summary report with a chart
• Summary report without a chart

Question 24

What should an administrator do to organize the
fields available on a report?

Answer 24

Create a custom report type.

Question 25

Tabular Report

Answer 25

* *This report is the simplest and fastest way to look at data. Similar to a spreadsheet, they consist simply of an ordered set of fields in columns, with** * *each matching record listed in a row. Tabular reports are best for creating lists of records or a list with a single grand total. They can't be used to create groups of data or charts, and can't be used in dashboards unless rows are limited. Examples include contact mailing lists and activity reports.**

Question 26

Summary Report

Answer 26

This report is similar to tabular reports, but also allow users to group rows of data, view subtotals, and create charts. They can be used as the source report for dashboard components. Use this type for a report to show subtotals based on the value of a particular field or when you want to create a hierarchical list, such as all opportunities for your team, subtotal by Stage and Owner.

Question 27

Ursa Major Solar created an action that sends a follow-up email to the customer two days after a case is closed. The administrator wants to verify that the process functions correctly. Which queue should the administrator view to monitor pending actions?

Answer 27

The Process Action Queue shows process actions and the administrator would be able to monitor pending process actions in this Queue.

Question 28

Ursa Major Solar has an auto-response rule to send emails when a customer submits a new case and an assignment rule to determine case ownership for new cases. In addition, the case object has validation rules to ensure that each case includes values for all fields needed by its owner to resolve the case. In which order does Salesforce process the immediate actions associated with workflow rules and related business automation for a newly created record?

Answer 28

1. **VALIDATION RULES,** 2. **ASSIGNMENT RULES,** 3. **AUTO-RESPONSE RULES,** 4. **WORKFLOW RULES,** 5. **ESCALATION RULES**

Question 29

* *Ursa Major Solar has a team of account managers that requested email alerts any time an opportunity or case is created on accounts that they own.** * *What is the minimum number of workflows needed to accomplish this task?**

Answer 29

**TWO WORKFLOW RULES WITH ONE EMAIL ALERT EACH** **Each workflow rule applies to a single object. Opportunity and/or case would need a separate workflow for each object.**

Question 30

**Ursa Major Solar has created an automated approval process to quickly communicate and improve their customer service. What are two final approval actions in an approval process?** 1. **CREATE A CHATTER POST** 2. **ADD AN EMAIL ALERT** 3. **SEND AN OUTBOUND MESSAGE** 4. **CALL APEX**

Answer 30

**2. ADD AN EMAIL ALERT** **3. SEND AN OUTBOUND MESSAGE**

Question 31

Data Export

Answer 31

* schedule automatic or manual backup files to generate automatically at weekly (limited edition) or monthly intervals (29 days)

Question 32

**Mass Transfer Records**

Answer 32

* **Use the Mass Transfer tool to transfer multiple accounts, leads, service contracts, and custom objects from one user to another.** * **Use search criteria to transfer only certain records**

Question 33

Which tool, accessible through the Setup menu would you use to import 10,000 records into a Custom Object without the need for automation?

Answer 33

Data Import Wizard

Question 34

Which tool would you use to import 70,000 records into an object?

Answer 34

**Use Data Loader** load 50,000 to 5,000,000 records

Question 35

Which tool would you use to automatically import new records into an object every night?

Answer 35

**Data Loader** **schedule regular data loads, such as nightly imports**

Question 36

Which tool would you use to automatically Export data for backup?

Answer 36

**Data Loader** **You can use Data Loader to insert, update, delete, and export Salesforce records**

Question 37

What tool would you use to manually Export or schedule data from your org every 29 days?

Answer 37

Use the Data Export Service Setup/Data Export

Question 38

What are 2 methods to export Data In salesforce?

Answer 38

* **Data Export Service (accessible through the Setup menu)** * **Data Loader (Install with AppExchange)**

Question 39

Factors that determine data quality

Answer 39

* Missing Records * Duplicate Records * No Data Standards * Incomplete Records * **Stale Data**

Question 40

**How do you determine your Data Quality** **in Salesforce?**

Answer 40

Install and Run the Data Quality Analysis Dashboards App

Question 41

Ursa Major Solar is looking into backup methods. **Which sets of small and large data backup methods are available in native Salesforce?** A. Mass Export Wizard, Weekly Data Export Service, and Data Loader Exports B. Data Loader Exports, Report Exports, and Weekly Data Export Service C. Report Exports, Dashboard Exports, and Weekly Data Export Service D. Data Loader Exports, Mass Exports, and Weekly Data Export Service

Answer 41

**B. Data Loader Exports, Report Exports, and Weekly Data Export Service** **Correct. Data can be backed up via Data Loader Exports, Report Exports, and Weekly Data Export Service.**

Question 42

Ursa Major Solar uses data from the grand total of a custom report to create their dashboard. **Which two components will populate the grand total properly?** A. Metric B. Table C. Chart D. Gauge

Answer 42

**A. Metric / Correct. Use a metric when you have one key value to display.** B. Incorrect. Use a table to show a set of report data in column form. C. Incorrect. Use a chart when you want to show data graphically. **D. Gauge / Correct. Use a gauge when you have a single value that you want to show within a range of custom values.**

Question 43

Ursa Major Solar uses a validation rule to prevent invalid data. **What are three conditions where this rule is used?** A. When records are imported. B. When records are edited and saved by a user. C. When records are updated by a workflow rule. D. When records are submitted using web-to-lead. E. When records are deleted by a user.

Answer 43

**A. When records are imported.** **Correct. Validation rules are triggered by creating a record.** **B. When records are edited and saved by a user.** **Correct. Validation rules are triggered by saving or editing a record.** C. Incorrect. A workflow rule does not trigger a validation rule. **D. When records are submitted using web-to-lead.** **Correct. Validation rules are triggered by creating a record.** E. Incorrect. Deleting a record would not trigger a validation rule.

Question 44

Sales reps use a custom report type for Account reports. New fields have been created on the Account Object. An administrator needs to report on the newly created fields. **What should the administrator do to achieve this goal?** A. Create a new account report and add the new fields from the Report Builder. B. From the Custom Report Type, Edit Layout, then add the new fields to the report. C. From the Custom Report Type, Edit Object Relationships, then add the new fields to the report. D. Create a new account report folder, go to share, and then add the new fields.

Answer 44

A. Incorrect. Add fields to a custom report in the custom report type field layout. **B. From the Custom Report Type, Edit Layout, then add the new fields to the report. Correct. Add fields to a custom report in the custom report type field layout.** C. Incorrect. Add fields to a custom report in the custom report type field layout. D. Incorrect. Add fields to a custom report in the custom report type field layout.

Question 45

Which set of small and large data backup methods are available in native Salesforce?

Answer 45

1. Data Loader Exports, 2. Report Exports, 3. Weekly Data Export Service

Question 46

What is the benefit of using a Lookup Filter instead of a Validation Rule?

Answer 46

To Improve user efficiency: - when selecting a related record - By limiting the number of available options in a lookup search dialog.

Question 47

When using the Data Loader which fields can you match against when updating contacts?

Answer 47

External Ids or Salesforce Ids. **Import Wizard allows you to de-duplicate records matching on Name, Email & Salesforce Id. But Data Loader can only match using External Ids or Salesforce Ids.**

Question 48

What Salesforce features could potentially block Data Loader from creating records in Salesforce?

Answer 48

Validation Rules & Duplicate Management Page layouts only affect people entering information from the web page of Salesforce, it doesn’t impact Data Loader or any other applications creating records. Workflow Rules can’t stop a record from being created but Validation Rules & Duplicate Management can.

Question 49

When uploading new data into Salesforce what should you do before uploading the data?

Answer 49

It's best practice to make sure the data is clean before uploading it to Salesforce.

Question 50

**What application should be used to create multiple users?**

Answer 50

**Users can be created in Batch by using the Data Loader app.** **At least, All the required fields in the user record should be included in the import file**

Question 51

**Data Modeling Tool**

Answer 51

**Schema Builder** *Access Via Setup*

Question 52

**Custom Objects features**

Answer 52

* Can add standard & Custom Fields * Can build page layouts * Can Build reports and dashboards * Can Create a custom Tab * Can track tasks and events * Can create Audit Trail with Field history tracking * Can import Custom Object reports

Question 53

**Data Import / Export** **Available tools**

Answer 53

* Data Import * Data Export Service * Exports * Data Loader

Question 54

**2 tools to import data into Salesforce** **# 1: The In-built tool: Data Import Wizard**

Answer 54

* Access via Setup * import up to 50,000 records at a time * Record duplication management with error message * Can Mass create or update data - Delete is not possible * For simple import data * Support custom objects + standards (Account, person account, contacts, campaign members, leads, and solution) * Support schedule Export * No import Cases or Opportunities

Question 55

**2 tools to import data into Salesforce** **# 2: 3rd party ap: Data Loader**

Answer 55

* Up to 5 million records at a time * Into any standard or custom object * Add, update or delete record * No Duplicate management * Does not support scheduled export * For Complex imports * Can export data Manualy

Question 56

**How to Export Backup Data from Salesforce?**

Answer 56

1. **Data export Service** Access from Setup menu. Export manually or automatically- weekly export **or** Monthly export 2. **Data Loader (3rd party app)** Manual export only

Question 57

**How to Delete Multiple Records and Reports** 1. **Data loader** 2. **Data Wizard Import** 3. **Mass Delete** 4. **Export Backup Data**

Answer 57

Response: #3 * The record types you can mass-delete include cases, solutions, accounts, contacts, leads, products, and activities. * Run a report to archive with **Data Export** from Setup * If you did not select P**ermanently delete the selected records**, deleted items are moved to the Recycle Bin.

Question 58

**How to transfer Records Salesforce?** 1. **Data loader** 2. **Data Wizard Import** 3. **Mass Delete** 4. **Mass Transfer**

Answer 58

Response: #4 * from Setup → **Mass Transfer Records**

Question 59

**which field type cannot be imported and why?**

Answer 59

**Formula fields, because they are read-only**