DATA MODELING & MANAGEMENT II

Question 1

What are the main capabilities of Schema Builder?

Answer 1

View existing objects and relationships; create, edit and delete custom objects, fields and field permissions.

Question 2

What types of fields cannot be built through Schema Builder?

Answer 2

Geolocation, indirect / external lookups and encrypted fields

Question 3

What are Elements in Schema Builder?

Answer 3

Elements are new objects or fields that can be created through Schema Builder.

Question 4

What are some limitations of external objects ?

Answer 4

External objects cannot be used in workflows, approval processes, formulas, roll-up summary fields, validation rules, etc.

Question 5

Which type of relationships are supported by external objects?

Answer 5

Lookup, external lookup, and indirect lookup relationships

Question 6

What needs to be set up to connect to a third-party database and use external objects?

Answer 6

External Data Source

Question 7

What differentiates Data Import Wizard from Data Loader?

Answer 7

Data Import Wizard record limit is 50,000 records, only works for certain objects, allows choosing to trigger workflow, doesn’t allow saving field mapping, and is available within the Salesforce UI.

Question 8

Which options are avaliable for exporting Salesforce data?

Answer 8

Data Loader, Data Export Service, Report Export, and third-party tools

Question 9

How can Knowledge articles be imported to Salesforce?

Answer 9

The ‘Import Articles’ tool in Setup allows articles and any translations to be imported into Salesforce Knowledge.

Question 10

What are the main tools for importing data into Salesforce?

Answer 10

Data Import Wizard and Data Loader

Question 11

Up to how many records can Data Import Wizard and Data Loader import?

Answer 11

Data Import wizard can import up to 50,000 records while Data Loader can import up to 5 million records.

Question 12

In what format is data imported, exported or deleted?

Answer 12

CSV format and XLS format for report exports

Question 13

Which of the data management tools cannot export data?

Answer 13

Data Import Wizard

Question 14

What are the high level-steps to import data?

Answer 14

Data selection, mapping, and import

Question 15

Which of the data import tools can be used by only admins?

Answer 15

Data Loader

Question 16

What is a master-detail relationship?

Answer 16

A special type of parent-child relationship between this object and another object where:
* The relationship field is required on all detail records
*The ownership and sharing of a detail record are determined by the master record
When a user deletes the master record all detail records are deleted
*You can create rollup summary fields on the master record to summarize the details records