Data import and export tools, report types, and dashboard components tested on Salesforce Administrator certification exams.
35 cards · basic cards · AI-written, checked twice. Edit anything.
- What is the Data Import Wizard?
Show answer
A web-based tool for importing data from CSV files into Salesforce objects
- What is Data Loader?
Show answer
A client application for batch importing and exporting data between Salesforce and external systems
- What is the maximum batch size for a Data Loader job?
Show answer
10,000 records
- What is the Bulk API designed for?
Show answer
Loading or deleting large volumes of data asynchronously with minimal system overhead
- Name one advantage of Bulk API over synchronous APIs.
Show answer
It consumes fewer API calls and system resources
- What does SOQL stand for?
Show answer
Salesforce Object Query Language
- What are the three main ways to export data from Salesforce?
Show answer
Data Export Service, Data Loader, and export from list views
- What file format is required by the Data Import Wizard?
Show answer
CSV (comma-separated values)
- How often can you perform a full data export using the Data Export Service?
Show answer
Once every 7 days
- What is an external ID field?
Show answer
A field that uniquely identifies a record outside Salesforce, used during upsert operations
- What encryption method does Data Loader use for data in transit?
Show answer
SSL/TLS encryption
- What is the maximum record count for a single Data Import Wizard operation?
Show answer
50,000 records
- What is a tabular report?
Show answer
The simplest report type, displaying data in rows and columns with basic totals
- What is a summary report?
Show answer
A report that groups data by one or more fields and displays subtotals and grand totals
- What is a matrix report?
Show answer
A report that groups data both horizontally and vertically, like a pivot table