Data Flashcards
What operations can be performed directly through the graphical user interface of Data Loader? Choose 3
A. Migrate attachments from source to the target organization
B. Upload documents and links into content libraries
C. Upload Attachments
D. Hard Delete Records
E. Export content from content libraries
B. Upload documents and links into content libraries
C. Upload Attachments
D. Hard Delete Records
There are three custom objects, namely Position, Job Application, and Candidate. Lookup relationships have been created from Job Application to Position and Job Application to Candidate. What are valid reasons for creating lookup relationships instead of master-detail relationships? Choose 3
A. Job applications may be processed in a queue
B.) The owner of the job application could be different from the owner of the position record
C.) The total field for the number of applications for each position is required on the position object
D.) The Job Application object may already have two master detail relationships defined
E.) Security and permission settings of job applications should be dependent on the Position object
A. Job applications may be processed in a queue
B.) The owner of the job application could be different from the owner of the position record
D.) The Job Application object may already have two master detail relationships defined
It is possible to have the owner field separately for the detail record only when the relationship is lookup and not master-detail. So with lookup relationships, a job application record can have an owner different from the owner of its position record.
Job application records can be processed in a queue by assigning the queue as the owner.
Only 2 master-detail relationships are allowed per object.
While trying to define a new custom field, the admin noticed that the “Master-detail relationship” field type is grayed out. What could be the reason? Choose 1
A.)There is already two master-detail relationships fields on the object
B.) There is already a master-detail relationship field on the object
A.)There is already two master-detail relationships fields on the object
What is true regarding master-detail relationship with a standard and custom object? Choose 2
A. The standard object can only be the master side of this relationship
B. The standard object can be on the master or detail side of this relationship
C. The custom object can be on the master or detail side of this relationship
D. The object on the detail side will inherit the security and sharing settings of the master object
A. The standard object can only be the master side of this relationship
D. The object on the detail side will inherit the security and sharing settings of the master object
In master-detail relationships between standard and custom objects, the standard object is always the master. A standard object cannot be on the detail side with a custom object being on the master side. The detail records inherit the security and sharing settings of the master.
What is is true about lookup relationships? Choose 2
A.) Lookup fields are always optional
B.) A lookup relationship is used when two objects need to be linked tightly
C.) The objects in the relationship can have different owners
D.) Both objects in the lookup relationship can have independent sharing rules
C.) The objects in the relationship can have different owners
D.) Both objects in the lookup relationship can have independent sharing rules
In a lookup relationship, the two objects can have independent ownership and security settings. The objects are loosely linked, and the lookup fields can be optional or required
Global Containers would like to create quotes related to opportunities. What would be the recommended data model to meet this requirement? Choose 1
A.) Use the standard Opportunity and Quote objects
B.) Create a Quote custom object and link it to the Opportunity standard object
C.) Install an AppExchange product to add custom Quote objects
D.) Extend the Opportunity object by including custom fields for Quotes
A.) Use the standard Opportunity and Quote objects
Which of the following statements are true with regard to enabling the Bulk API in Data Loader? Choose 3
A.) Parallel processing is used to load data faster
B.) Data will be loading faster when using the Bulk API
C.) Serial processing is used to load data faster
D.) Synchronous processing is used to load data faster
E.) Data is processed in batches
A.) Parallel processing is used to load data faster
B.) Data will be loading faster when using the Bulk API
E.) Data is processed in batches
The bulk API loads data faster as it uses parallel processing of batches. Serial mode can be enabled via the “Settings” screen if data contention is a problem with parallel processing, but this will result in a slower overall process.
The Sales team at Global Containers has created a list of opportunities which need to be imported to SFDC. There are about 200 records in the import file. Which of the following solutions should be used for the import? Choose 1
A.) Manually enter the records
B.) Use an AppExchange solution
C.) Use Data Loader
D.) Use Data Import Wizard
C.) Use Data Loader
The Opportunity object is not supported by the Data Import Wizard. It is only possible to import opportunity records using the Data Loader.
The Admin working for company recently tried the Schema Builder, but found that it displays too many objects and relationships, has long loading times, and is too difficult to work with. Which of the following features could help with these issues? Choose 3
A.) The filter can be used to only display objects of interest
B.) Performance can be improved by selecting the “Hide Relationships” option.
C.) The map can be used to navigate to objects of interest
D.) Performance can be improved by selecting the “Hide Grids” option
E.) Fields can be hidden and only the objects can be displayed
A.) The filter can be used to only display objects of interest
B.) Performance can be improved by selecting the “Hide Relationships” option.
C.) The map can be used to navigate to objects of interest
Company is migrating customer data from a legacy CRM application into SFDC and needs to ensure that the original created date of the account records is retained when the records are imported into SFDC. How can a developer meet this requirement? Choose 1
A.) Request Salesforce to enable the “Update System Fields” setting
B.) Enable the “Set Audit Fields upon Record Creation” setting in Setup
C.) Disable the “Lock System Fields” setting on the Account object
D.) No Action is required since the Created Date can always be updated but only via the API
B.) Enable the “Set Audit Fields upon Record Creation” setting in Setup
You have determined that you need to store information about Prospects, Customers, Policies, Claims and Benefits in SFDC. Which of the following statements is true regarding the types of objects what would be required? Choose 1
A.) Customers could be stored in the Account standard object, but all other data would require custom objects
B.) Both standard and custom objects could be used to store the data
C.) Custom objects would need to be created to store all of the required data
D.) Standard objects could store all of the required data
B.) Both standard and custom objects could be used to store the data
While it is possible to use custom objects to store all of the data, standard objects should be examined first to determine if they are appropriate for the use case. The Lead standard object could be used for prospects. The Account standard object could be used for both individual and business customers. All other data would require a custom object to be created.
Which of the following are true about external objects and Salesforce Connect? Choose 3
A.) External objects support lookup relationships
B.) External objects can be created for any data source that supports OData 2.0 or OData 4.0
C.) External object data can be viewed together with data from within Salesforce on the same page
D.) External objects do not support lookup relationships
A.) External objects support lookup relationships
B.) External objects can be created for any data source that supports OData 2.0 or OData 4.0
C.) External object data can be viewed together with data from within Salesforce on the same page
External Data is available in the Salesforce mobile app and Global Search. External objects require the creation of an external data source. While defining an external data source, it is possible to specify its type as either Salesforce Connect: OData 2.0 or Salesforce Connect: OData 4.0. External object data can be viewed with data from standard or custom Salesforce objects through related lists. Lookup relationship fields can be created on external objects.
Which of the following statements are true about a master-detail relationship in Salesforce? Choose 2
A.) The relationship field is not required on the page layout of the detail object
B.) The security settings of the detail records depend on the master record
C.) The master objects can be a standard or custom object
D.) By default, records can be reparented in master-detail relationships
B.) The security settings of the detail records depend on the master record
C.) The master objects can be a standard or custom object
Reparenting of detail records can be set up, but it is not the default setting. The master-detail relationship field is required on the page layout of the detail record.
Which of the following is used for record matching when using the Data Loader. Choose 1
A.) External ID or Record ID
B.) Record ID
C.) External ID
D) Record owner
A.) External ID or Record ID
The data model for company includes Policy and Claim object. A Claim should always be related to a Policy. Related Claims must be visible on the Policy detail page. Claims are processed by the claims team, which requires an efficient way to organize, assign, and manage claims. What type of relationship would be required in this situation to be able to use queue functionality? Choose 1
A.) A one-to-many relationship between the two objects
B.) A master-detail relationship between the two objects as they are tightly linked
C.) A lookup relationship since child records cannot have an owner in a master-detail relationship
D.) A master-detail relationship with sharing rules on the detail object
C.) A lookup relationship since child records cannot have an owner in a master-detail relationship
Company wants to track the location of each container it owns. Which of the following are valid reasons for creating a Location custom object and a lookup relationship field on the Container object instead of using a picklist field? Choose 3
A.) Validation needs to be performed on the location value
B.) Additional information about the location needs to be recorded
C.) Location values need to be maintained by end users
D.) The criteria for a workflow rule should use the location value
E.) There is a very large number of locations
B.) Additional information about the location needs to be recorded
C.) Location values need to be maintained by end users
E.) There is a very large number of locations
Company has a list of leads that need to be imported. The company follows a very strict data quality policy and does not want any duplicate leads to be created in the system as part of the import. What would a Salesforce developer recommend? Choose 1
A.) Use Data Loader
B.) Use Data Import Wizard
C.) use Data import CLI
D.) User Data Loader CLI
B.) Use Data Import Wizard
One advantage the Data Import Wizard has over Data Loader is that it is possible to prevent duplicates by uploading records according to account name and site, contact email address, or lead email address
Company wants to insert new customer records daily at 11am in the morning. How could this be automated? Choose 2
A.) Download and install an app from the AppExchange
B.) Data Loader GUI
C.) Data Loader Command Line Interface
D.) Force.com Excel Connector
A.) Download and install an app from the AppExchange
C.) Data Loader Command Line Interface
Data Loader’s command line interface or a third party app from the AppExchange can be used for this. The Data Loader GUI does not allow scheduling jobs. The Force.com Excel Connector is useful for cleaning and mass-updating Salesforce-based data from within a spreadsheet.
Company uses custom objects extensively. Which of the following tools can be used to import data into custom objects? Choose 3
A.) Data Loader Command-Line Interface
B.) Data Import Wizard
C.) Data Loader
D.) Data Importer
A.) Data Loader Command-Line Interface
B.) Data Import Wizard
C.) Data Loader
Custom object data can be imported through Data Import Wizard as well as Data Loader. Data Loader can also be run from the command line for automated batch operations such as nightly scheduled loads and extractions.
There is a requirement to view real-time data stored in SAP within the SFDC account record. What is the best way to meet this requirement? Choose 1
A.) Export the data from SAP and import into SFDC with a nightly batch job
B.) Create a custom integration between SFDC and SAP
C.) use a third-party integration tool to connect SFDC and SAP in real-time
D.) Define an external object in SFDC to access the SAP data
D.) Define an external object in SFDC to access the SAP data
External objects can be used to access data stored in an external system such as SAP in Salesforce
Which of the following are NOT capabilities of the Schema Builder? Choose 1
A.) Create formula fields
B.) Create lookup and master-detail relationships
C.) Create custom objects
D.) Create validation rules
D.) Create validation rules
Schema Builder provides the ability to add custom objects, lookup relationships, master-detail relationships, and all custom fields (including formula fields) except Geolocation.
Which of the following are valid reasons for using external objects instead of a third-party application for integrating data with Salesforce? Choose 2
A.) There is a large amount of external data, but users need to access only a small amount at a time
B.) External object records need to be shared with users based on certain criteria
C.) External data needs to be stored in the Salesforce org
D.) Real-time access to the latest external data is required
A.) There is a large amount of external data, but users need to access only a small amount at a time
D.) Real-time access to the latest external data is required
Sharing is not supported for external objects. It is also not possible to store external data in Salesforce using external objects. However, external data can be made available in real-time and on demand.
When adding a custom field to an object using the Schema Builder, which of the following is true? Choose 1
A.) The field-level security of custom fields is set to “Visible” for all profiles
B.) Custom fields are not automatically added to page layouts
C.) Custom fields are added to page layouts but the page layout needs to be edited to specify where the field should be displayed
D.) Roll-up summary fields cannot be added using the schema builder
B.) Custom fields are not automatically added to page layouts
Sam has completed the solution design for a SFDC application project and is ready to create the data model for the new application in Salesforce. There are several custom objects, each with a number of custom fields. What would be the most efficient way to complete the task? Choose 1
A.) use the Schema Builder to create custom objects and fields, and then navigate to “Objects” in Setup to create relationships
B.) use the Schema Builder to create custom objects, and then navigate to “Objects” in Setup to create fields and relationships
C.) use the Schema Builder to create custom objects, fields and relationships
D.) Create the custom objects, fields and relationships by navigating to “Objects” in Setup, and use the Schema Builder to verify that the data model has been setup correctly
C.) use the Schema Builder to create custom objects, fields and relationships
The admin has determined that he needs a junction object to model a many to many relationship between Students and Subjects. He creates the junction object “Student Subjects” and then creates the first master detail relationship between Students and “Student Subjects”. What will be the result of creating this primary relationship? Choose 2
A.) The junction object detail and edit page uses the color from the primary object
B.) The junction object inherits the owner from the primary object
C.) The primary relationship cannot be deleted if there is a second master detail relationship
D.) Junction object records can always be created. edited or deleted if the users have at least Read access to the primary object
A.) The junction object detail and edit page uses the color from the primary object
B.) The junction object inherits the owner from the primary object
After a review, it was decided that custom objects A and B need to be in a master-detail relationship instead of the current lookup relationship. A is the proposed master. Which of these items would you investigate before making the change? Choose 2
A.) Number of null values in the existing Lookup field on Object B
B.) Existing roll-up summary fields on Object A
C.) Number of existing master-detail relationships on Object B
D.) Validation rules applicable to the existing Lookup field on Object B
A.) Number of null values in the existing Lookup field on Object B
C.) Number of existing master-detail relationships on Object B
A developer wants to link a custom object called Bug with itself to show how two different bugs are related to the same problem. Which type of relationship field should the developer use? Choose 1
A.) Self
B.) Lookup
C.) Master-Detail
D.) Hierarchical
B.) Lookup
Which of the following is true about changing the field type of a Text Area (Rich) field? Choose 1
A.) Text Area (Rich) field can be converted to a Text Area (Long) field type but data may be truncated
B.) Test Area (Rich) field can be converted but only to a Text Area (Long) field type
C.) Images in a Text Area (Rich) field are deleted as soon as the field type is converted
D.) It is not possible to change the field type of a Text Area (Rich) field
B.) Test Area (Rich) field can be converted but only to a Text Area (Long) field type
A Rich text area can only be converted into a Long text Area. Rich text area fields and long text area fields have exactly the same quantitative capacity in storing characters such that converting a rich text area into a long text area does not result to truncation - that is cutting off the top or the end of a string
While adding a custom field to a newly created custom object, you have determined that you need a field that can store up to 500 characters of text on separate lines. Which data type would you select? Choose 1
A.) Text Area
B.) Text
C.) Multi-Line Text
D.) Text Area (Long)
D.) Text Area (Long)
A Text field allows entering a single line of text. A Text Area field allows entering up to 255 characters on separate lines. Text Area (Long) can store up to 131,072 characters. Multi-Line Text is not a Salesforce field type.
A master-detail relationship can exist between which of the following? Choose 2
A.) Standard object master and custom object detail
B.) Custom object master and custom object detail
C.) Custom object master and standard object detail
D.) External object master and custom object detail
A.) Standard object master and custom object detail
B.) Custom object master and custom object detail
What can be used to model a many-to-many relationship between two custom objects? Choose 2
A.) Junction object
B.) Lookup relationship
C.) Master-detail relationship
D.) Hierarchical relationship
A.) Junction object
C.) Master-detail relationship
While designing a custom application in Salesforce, the admin is reviewing the data types that would be suitable for the fields. Which standard field types are available for custom fields? Choose 2
A.) Checkbox, Picklist, and Address
B.) Email, Phone and URL
C.) Text, Radio Button, and Date/Time
D.) Number, Currency, and Percent
B.) Email, Phone and URL
D.) Number, Currency, and Percent
Address fields are a special compound data type that is only used in standard fields on standard objects. Radio Button is not a salesforce field type.