Data & analytics Flashcards
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?
- CREATE A REPORTING SNAPSHOT GROUPED BY SALES REP.
- CREATE A REPORT WITH A CROSS FILTER BY MY OPPORTUNITIES.
- CREATE A REPORT FILTERED BY MY OPPORTUNITIES.
- CREATE A REPORT SCHEDULE FOR EACH SALES REP.
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
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?
- GROUPED BAR CHART
- PIE CHART
- DONUT CHART
- LINE CHART
- GROUPED BAR CHART: Incorrect. A grouped bar chart shows siloed, individual lead information.
- PIE CHART:
- 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.
- LINE CHART: Incorrect. A line chart does not show a percentage of leads relative to the whole
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?
- 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.
What should an administrator configure to provide each Sales Rep a dashboard that shows their current Opportunity pipeline?
- Set a dashboard filter to the current user
- Create a dashboard folder for each user
- Filter the dashboard with a dynamic view set to the VP of sales
- Set the Dashboard running user to “the dashboard viewer”
- Set the Dashboard running user to “the dashboard viewer”
- *This will ensure the Dashboard shows only data relevant to the**
- *user viewing it.**
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?
- 3
- 15
- 20
- 50
- 20
Each dashboard can have up to 20 components
What should the system administrator check when users are unable to find a Custom Report Type?
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.
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?
- CREATE A SHARING RULE BASED ON CRITERIA
- SAVE ALL OPPORTUNITY REPORTS IN A PUBLIC FOLDER
- MOVE ALL PRODUCT MANAGERS TO A ROLE BELOW THE SALES REPRESENTATIVES.
- CREATE A NEW ROLE FOR PRODUCT MANAGERS AND SALES REPRESENTATIVES
CREATE A SHARING RULE BASED ON CRITERIA.
Criteria-based sharing rules determine what records to share based on field values other than ownership
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?
- IMPORT THE DATA USING THE DATA LOADER.
- USE THE ID FROM THE ORDER SYSTEM IN PLACE OF THE SALESFORCE ID.
- CREATE A UNIQUE EXTERNAL ID FIELD ON ACCOUNTS IN SALESFORCE FOR MATCHING.
- CREATE A FORMULA FIELD THAT IDENTIFIES MATCHES.
- 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.
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?
- API ENABLED
- MODIFY ALL FOR THOSE OBJECTS
- VIEW ALL DATA
- WEEKLY DATA EXPORT
- API ENABLED: To use the Data Loader for importing and exporting the profile permissions need API Enabled.
- 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
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?
Validation rules can be used to make fields conditionally
required based on the Opportunity stage
Ursa Major Solar is importing data and has many records that do not meet the data validation criteria.
What will occur?
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.
How long is data stored in the Recycle Bin?
Up to 15 days
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?
Mass update addresses
Which set of Salesforce records is exported by choosing the “Export All” option instead of “Export” in Data Loader?
- *Records for a specified object including records in**
- *the recycle bin.**
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?
- 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.
Which configuration option shows sales representatives the fields they must fill in prior to saving an opportunity?
Required fields in the Page Layout
Lookup filter
- *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.)**
Data Import Wizard
- 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
Validation Rules
Verify that the data a user enters in a record meets
the standards you specify before the user can save
the record
Data Loader vs Import Wizard
Use Data Loader when:
- 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.
Data Loader vs Import Wizard
Use the import wizard when:
- 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.
What report should an administrator use to display the number of contacts related to an account?
Summary report with a report formula
- *Which three reports can be used to display a list of**
- *the Top 10 Accounts on a dashboard?**
- Tabular report with Rows to Display set to 10
- Summary report with a chart
- Summary report without a chart