Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

salesforce data architecture and management designer > Data Modeling > Flashcards

Data Modeling Flashcards

1
Q

Why is planning the data model in advance critical?

A

You have to plan to accommodate LDV up front with the goal of designing for scale.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the three types of data skew?

A

Account data skew
Ownership skew
Lookup skew

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is Data Skew?

A

Data skew happens when more than 10k child records are associated with the same parent record within an org.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Describe Account Data Skew

A

more than 10K child records assigned to a single parent under a private sharing model.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Describe Ownership Skew

A

When a large number of records with the same object type are owned by a single user.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Describe Lookup Skew

A

Lookup skew happens when a very large number of records are associated with a single record in the look up object.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are the two major concerns with Account Data Skew?

A

Record Locking

Sharing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Why are ownership changes considered to be one of the most costly Salesforce transactions?

A

Because deleting or updating the owner must remove sharing from the old owner and all parent users within the role hierarchy, and from all users given access by sharing rules.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

If ownership skew can’t be avoided, how can the performance hit from sharing calculations be mitigated?

A

By not assigning the owner a role, or by putting the owner at the top of the hierarchy and not moving him down.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

True/False:

Data Skew negatively impacts performance?

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Describe the record locking scenario associated with Account Data Skew

A

Having a large number of child records “parked” under a single Account.

An update will lock both the parent and the child records during update, which creates the possibility that the parent will be locked for a different child update.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is the major concern regarding lookup skew?

A

Lookup fields can be placed on any object, thus any object can be problematic.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

True/False:

Every time a record is inserted or updated, Salesforce must lock the target records that are selected for each lookup field?

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

How can a LDV be leveraged without bringing data into Salesforce?

A

Using an external object

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is an advantage to using an external object?

A

You don’t have to manage a copy of the data in Salesforce (reduced storage & resources to maintain the data)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

When should you consider using an external object?

A

When you have a large amount of data that you can’t or don’t want to store in SFDC and you only need a small amount of the data at anyone time.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What three types of lookups are supported with External Objects?

A

Standard Look up (18-char record ID)
External Lookup
Indirect Lookup

18
Q

Describe an external lookup

A

An external lookup is used when the parent is an external object

19
Q

Describe an indirect lookup

A

An indirect lookup links a child external object to a parent standard or custom object.

20
Q

In a standard lookup relationship, what types of objects can be the parent?

A

Standard objects

Custom objects

21
Q

In a standard lookup relationship, what types of objects can be the child?

A

Standard objects

Custom objects

22
Q

In an external lookup, what types of objects can be the parent?

A

Standard objects
Custom objects
External Objects

23
Q

In an external lookup, what types of objects can be the child?

A

External

24
Q

In an indirect lookup, what types of objects can be the parent?

A

Standard Object

Custom Object

25
Q

In an indirect lookup, what types of objects can be the child?

A

Standard objects

Custom objects

26
Q

What are four strategies for mitigating locking issues related to lookup skew?

RDUR

A

Reducing record saving time
Distributing the skew
Using a picklist field
Reducing the load

27
Q

How can record saving time be reduced?

A

increase the performance of apex code
remove unnecessary workflow
Only process what’s required

28
Q

How can Apex be tuned to reduce lock time?

A

Consolidate code to a single trigger per object

29
Q

What is the alternative to a workflow to improve record saving time?

A

consolidate workflow logic into the object trigger.

30
Q

How should logic that isn’t immediately required on save be executed to reduce lock time?

A

Process additional logic asynchronously.

31
Q

How is skew mitigated when a small number of possible values exist?

A

using a picklist field.

32
Q

How can skew be distributed?

A

by adding additional lookup values

33
Q

What is a foreign key?

A

A FOREIGN KEY is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table.

34
Q

What is a system of record?

A

Established packaged applications or legacy homegrown systems that support core transaction processing and manage the organization’s critical master data.

35
Q

What is a system of differentiation?

A

Applications that enable unique company processes or industryspeci€c capabilities.

36
Q

What is a system of innovation?

A

New applications that are built on an ad hoc basis to address new
business requirements or opportunities.

37
Q

What are the two categories of storage in Salesforce?

A

File storage and data storage

38
Q

What should be considered for file storage?

A 
attachments
Files home
Salesforce CRM Content
Chatter files (incl. photos)
Documents Tab
Custom File field on Knowledge articles
Site.com assets
39
Q

Name 10 standard objects that count against data storage

A 
Accounts
Campaigns
Campaign Members
Cases
Case Teams
Contacts
Contracts
Custom Objects
Email Messages
Events
Forecast Items
Google docs 
Ideas
Leads
List email
Notes
Opportunities
Opportunity Splits
Orders
Quotes
Quite Template Rich text data
Solutions
Tags: Unique tags
Tasks
All FSL Objects
40
Q

T/F - orgs are allocated additional file storage based on the number of standard user licenses

A

true

salesforce data architecture and management designer (16 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions