Data-Architect Exam Questions

Total 257 Questions

Last Updated Exam : 22-Oct-2024

US is implementing salesforce and will be using salesforce to track customer complaints, provide white papers on products and provide subscription (Fee) – based support. Which license type will US users need to fulfil US’s requirements?


A.

Lightning platform starter license.


B.

Service cloud license.


C.

Salesforce license.


D.

Sales cloud license





B.
  

Service cloud license.



Northern Trail Outfitters (NTO) plans to maintain contact preferences for customers and employees. NTO has implemented the following:
1. Customers are Person Accounts for their retail business.
2. Customers are represented as Contacts for their commercial business.
3. Employees are maintained as Users.
4. Prospects are maintained as Leads.
NTO needs to implement a standard communication preference management model for Person Accounts, Contacts, Users, and Leads. Which option should the data architect recommend NTO to satisfy this requirement?


A.

Create custom fields for contact preferences in Lead, Person Account, and Users objects.


B.

Create case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users.


C.

Create a custom object to maintain preferences and build relationships to Lead, Person Account, and Users.


D.

Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.





D.
  

Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.



A large retail company has recently chosen SF as its CRM solution. They have the following record counts:
2500000 accounts
25000000 contacts
When doing an initial performance test, the data architect noticed an extremely slow response for reports and list views. What should a data architect do to solve the performance issue?


A.

Load only the data that the users is permitted to access


B.

Add custom indexes on frequently searched account and contact objects fields


C.

Limit data loading to the 2000 most recently created records.


D.

Create a skinny table to represent account and contact objects.





B.
  

Add custom indexes on frequently searched account and contact objects fields



Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ""key"" fields which are important to their sales reps. What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency? (Choose two.)


A.

Run a report which shows the last time the key fields were updated.


B.

Run one report per key field, grouped by that field, to understand its data variability.


C.

Run a report that shows the percentage of blanks for the important fields.


D.

Run a process that can fill in default values for blank fields.





A.
  

Run a report which shows the last time the key fields were updated.



C.
  

Run a report that shows the percentage of blanks for the important fields.



Universal Containers wants to implement a data -quality process to monitor the data that users are manually entering into the system through the Salesforce UI. Which approach should the architect recommend?


A.

Allow users to import their data using the Salesforce Import tools.


B.

Utilize a 3rd -party solution from the AppExchange for data uploads.


C.

Utilize an app from the AppExchange to create data -quality dashboards.


D.

Use Apex to validate the format of phone numbers and postal codes.





C.
  

Utilize an app from the AppExchange to create data -quality dashboards.



Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers


A.

Use SOQL queries without WHERE conditions.


B.

Work with Salesforce Support to enable Skinny Tables.


C.

Reduce the number of triggers on Order _c object.


D.

Make the queries more selective using indexed fields.





B.
  

Work with Salesforce Support to enable Skinny Tables.



D.
  

Make the queries more selective using indexed fields.



Universal Containers (UC) has a very large and complex Salesforce org with hundreds of validation rules and triggers. The triggers are responsible for system updates and data manipulation as records are created or updates by users. A majority of the automation tool within UC’’ org were not designed to run during a data load. UC is importing 100,000 records into Salesforce across several objects over the weekend. What should a data architect do to mitigate any unwanted results during the import?


A.

Ensure validation rules, triggers and other automation tools are disabled.


B.

Ensure duplication and matching rules and defined.


C.

Import the data in smaller batches over a 24-hour period.


D.

Bulkily the trigger to handle import leads.





A.
  

Ensure validation rules, triggers and other automation tools are disabled.



Universal Containers (UC) wants to store product data in Salesforce, but the standard Product object does not support the more complex hierarchical structure which is currently being used in the product master system. How can UC modify the standard Product object model to support a hierarchical data structure in order to synchronize product data from the source system to Salesforce?


A.

Create a custom lookup filed on the standard Product to reference the child record in the hierarchy.


B.

Create a custom lookup field on the standard Product to reference the parent record in the hierarchy.


C.

Create a custom master-detail field on the standard Product to reference the child record in the hierarchy.


D.

Create an Apex trigger to synchronize the Product Family standard picklist field on the Product object.





B.
  

Create a custom lookup field on the standard Product to reference the parent record in the hierarchy.



Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field -level audit and recovery plan?


A.

Reduce data storage by purging old data.


B.

Implement an AppExchange package.


C.

Review projected data storage needs.


D.

Schedule a weekly export file.





A.
  

Reduce data storage by purging old data.



Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following:
- Accounts
- Contacts
- Opportunities
- Orders
- Order Line Items
Which issue will an architect have when implementing this in Salesforce?


A.

Custom report types CANNOT contain Opportunity data.


B.

Salesforce does NOT support Orders or Order Line Items.


C.

Salesforce does NOT allow more than four objects in a single report type.


D.

A report CANNOT contain data from Accounts and Contacts.





C.
  

Salesforce does NOT allow more than four objects in a single report type.




Page 2 out of 26 Pages
Previous