Data and Analytics Management

An administrator needs to configure a weekly automated backup of all organizational data using the native Salesforce Data Export Service. Arrange the steps in the correct chronological order to complete this setup.

A Salesforce Administrator is designing a complex executive dashboard in Lightning Experience to monitor sales performance across multiple territories. The leadership team requests the ability to dynamically filter the dashboard by four independent fields: Opportunity Stage, Close Date Quarter, Account Industry, and Lead Source. Additionally, they want a component displaying a stacked bar chart to show total opportunity amount grouped simultaneously by Account Industry and Opportunity Stage. Which combination of constraints and requirements must the administrator consider when building this dashboard?

Universal Containers requires an analytics solution to evaluate cross-departmental customer metrics. The Leadership team needs to view a side-by-side comparative analysis of Account records, displaying related Opportunities in one section and related Cases in another. Both data sets must be grouped by Account Owner along the rows and Calendar Quarter along the columns. Standard single-object report types cannot combine these two independent related objects into a unified view. Which report configuration should an administrator implement to meet these requirements while respecting record-level security?

A financial operations manager at a global logistics firm requires a Salesforce report to analyze individual billing transaction records against custom target benchmarks. The manager needs a calculated column evaluating a record-by-record variance formula ($Transaction\_Amount - Benchmark\_Amount$) for every individual transaction row. Additionally, the final report must summarize total transaction values formatted in a multi-dimensional grid grouped by Region along rows and Billing Quarter along columns. Which configuration should the Salesforce Administrator implement to fulfill these requirements?

An administrator for a logistics organization is building a Lightning dashboard to analyze inventory performance across multiple fulfillment centers. The VP of Operations requests four dynamic dashboard filters: Fulfillment Region, Inventory Status, Product Family, and Supplier Tier. Additionally, the VP wants a stacked bar chart component that displays total inventory value grouped by Fulfillment Region and sub-grouped by Product Family. Which combination of configuration adjustments must the administrator make to successfully meet these requirements within standard Salesforce limits?

A Salesforce Administrator is building an executive leadership dashboard in Lightning Experience to monitor cross-departmental operations. The dashboard includes components sourced from three distinct custom report types: 'Opportunities with Products', 'Accounts with Assets', and 'Cases with Solutions'. The administrator needs to configure global dashboard filters and visual component displays. Which TWO statements accurately describe the technical requirements and constraints for this dashboard configuration? (Select 2)

A Salesforce Administrator is configuring a sales operations dashboard in Lightning Experience that incorporates components derived from both Account and Opportunity report types. The management team wants to filter the dashboard by Region and requires that managers see only the data they have permission to access. Which two considerations must the administrator keep in mind when configuring the dashboard components and dynamic filters? (Select 2)

A Salesforce Administrator at Ursa Major Solar is creating an Account report to target key clients for an upcoming marketing campaign. The report must satisfy the following business requirements:

1. Include Accounts where the Type is either 'Customer - Direct' or 'Customer - Channel'.
2. Include Accounts that have at least one Closed Won Opportunity with an Amount exceeding $50,000.
3. Exclude any Accounts that currently have open Cases with a Priority of 'High'.

The administrator has created the following initial standard field filters on the Account report:
1. Account Type equals 'Customer - Direct'
2. Account Type equals 'Customer - Channel'

Which combination of filter logic and cross filters should the administrator configure to meet these requirements?

A Salesforce Administrator is configuring a Custom Report Type to analyze relationships between Accounts (Primary Object) and Partner Surveys (Secondary Custom Object). The management team wants full flexibility to traverse lookup relationships for field selection and ensure accurate record inclusion based on survey responses. Which TWO configuration capabilities or constraints apply when defining the object relationships and field layout for this Custom Report Type? (Select TWO answers)

A Salesforce Administrator at a nationwide logistics provider needs to configure a custom Cases report to analyze service operations. The report must satisfy the following business requirements:
1. Categorize records into three resolution timeframe categories based on the numeric custom field 'Age (Days)': 'Critical' (greater than 14 days), 'Moderate' (5 to 14 days), and 'Prompt' (less than 5 days).
2. Display only Accounts that have closed cases with a Priority of 'High', while explicitly excluding Accounts that currently have any open Escalated cases.

Which two report builder configurations should the administrator implement to meet these requirements? (Select two.)

Aegis Solar Solutions enforces a Private sharing model for Opportunities. A Salesforce administrator configures an executive sales dashboard to run as a static user, specifically the VP of Sales. When sales representatives view this dashboard and interact with its components, which two statements accurately describe how data visibility and security are applied? (Select 2 options.)

An enterprise administrator needs to bulk-import thousands of new child Service Contract records and automatically link them to existing parent Account records using Data Loader. The parent Account records already contain a unique custom External ID field named Legacy_Account_ID__c. What is the correct sequence of steps the administrator must follow to successfully map and relate the child records to parent Accounts using Data Loader?

A system administrator at a logistics enterprise is tasked with executing two data maintenance operations: importing 80,000 custom object records named Equipment_Track__c, and deleting 5,000 obsolete Opportunity records from the org. Which two operational constraints dictate that Data Loader MUST be used instead of the Data Import Wizard? (Choose 2 options)

A Salesforce administrator is setting up an automated weekly data backup for an enterprise organization using the native Data Export Service. Which two statements represent key capabilities or limitations of the Data Export Service that the administrator must consider? (Select 2 options)

An organization requires a bulk cleanup of 500,000 obsolete custom log records while maintaining strict data governance compliance. What is the correct sequence of administrative steps to safely back up the data and permanently purge the records using Salesforce native tools and Data Loader?

An enterprise administrator is performing data maintenance and planning mass deletion operations across multiple standard objects in a Salesforce org. Management requires clarification on data recovery safety nets and storage behaviors associated with deleted records. Which statement accurately describes the retention policy and capacity behavior of the Salesforce Recycle Bin?

A Salesforce Administrator is configuring a customer support dashboard containing multiple components built from case reports. The administrator wants to add dashboard filters so managers can dynamically slice the displayed data by Case Origin and Case Priority.

Which two limits or requirements apply when configuring dashboard filters? (Select 2)

A Salesforce administrator at a healthcare company needs to insert 75,000 Opportunity records into Salesforce while linking them to existing Account records using a custom External ID field. Which data utility should the administrator use to complete this requirement?

A Salesforce administrator needs to insert 80,000 new Contact records into Salesforce from a CSV file. Which tool should the administrator use to complete this task?

A Salesforce administrator is reviewing data management requests across different departments. Match each operational requirement on the left with the appropriate native Salesforce data tool or configuration on the right.