Home / Salesforce / Certified Data Architect

Salesforce Certified Data Architect Practice Test - Questions Answers, Page 7

Question list

List of questions

Question 61

(0)

Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contact

Question 62

(0)

A customer wishes to migrate 700,000 Account records in a single migration into Salesforce. What is the recommended solution to migrate these records while minimizing migration time?

Question 63

(0)

Universal Containers has millions of rows of data in Salesforce that are being used in reports to evaluate historical trends. Performance has become an issue, as well as data storage limits. Which t

Question 64

(0)

Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monit

Question 65

(0)

A shipping and logistics company has created a large number of reports within Sales Cloud since Salesforce was introduced. Some of these reports analyze large amounts of data regarding the whereabou

Question 66

(0)

Due to security requirements, Universal Containers needs to capture specific user actions, such as login, logout, file attachment download, package install, etc. What is the recommended approach for

Question 67

(0)

Universal Containers (UC) is concerned about the accuracy of their Customer information in Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they h

Question 68

(0)

Which two statements are accurate with respect to performance testing a Force.com application?

Question 69

(0)

Universal Containers (UC) is launching an RFP to acquire a new accounting product available on AppExchange. UC is expecting to issue 5 million invoices per year, with each invoice containing an aver

Question 70

(0)

Universal Containers (UC) has a custom discount request object set as a detail object with a custom product object as the master. There is a requirement to allow the creation of generic discount req

Related questions

Universal Containers (UC) is migrating data from legacy system to Salesforce. During data analysis it was discovered that data types of fields being migrated do not match with Salesforce data types. Which solution should a data architect use to ensure successful data migrations?

Universal Containers (UC) is migrating from a legacy system to Salesforce CRM, UC is concerned about the quality of data being entered by users and through external integrations. Which two solutions should a data architect recommend to mitigate data quality issues?

DreamHouse Realty has a data model as shown in the image. The Project object has a private sharing model, and it has Roll-Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project. There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce. What should the Architect consider in this situation?

Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise -wide data governance. Which two roles are appropriate as members of this team? Choose 2 answers

Get Cloud Consulting needs to integrate two different systems with customer records into the Salesforce Account object. So that no duplicate records are created in Salesforce, Master Data Management will be used. An Architect needs to determine which system is the system of record on a field level. What should the Architect do to achieve this goal?

A national nonprofit organization is using Salesforce to recruit members. The recruitment process requires a member to be matched with a volunteer opportunity. Given the following: 1. A record is created in Project__ c and used to track the project through completion. 2. The member may then start volunteering and is required to track their volunteer hours, which is stored in VTOTime_c object related to the project. 3. Ability to view or edit the VTOTime__c object needs to be the same as the Project__ c record. 4. Managers must see total hours volunteered while viewing the Project__ c record. Which data relationship should the data architect use to support this requirement when creating the custom VTOTime__c object?

Northern Trail Outfitters <NTO> is streaming IoT data from connected devices to a cloud database. Every 24 hours. 100,000 records are generated. NIO employees will need to see these lol records within Salesforce and generate weekly reports on it. Developers may also need to write programmatic logic to aggregate the records and incorporate them into workflows. Which data pattern will allow a data architect to satisfy these requirements, while also keeping limits in mind?

Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect 1. The data model for Org B will drastically change with different objects, fields, and picklist values. 2. Three million records will need to be migrated from org A to org B for compliance reasons. 3. The migrate will need occur within the next two month, prior to be split. Which migrate strategy should a data architect use to successfully migrate the date?

Universal Containers (UC) uses the following Salesforce products: Sales Cloud for customer management. Marketing Cloud for marketing. Einstein Analytics for business reporting. UC occasionally gets a list of prospects from third-party source as comma-separated values (CSV) files for marketing purposes. Historically, UC would load contact Lead object in Salesforce and sync to Marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing process. What should a data architect recommend to UC in order to immediately avoid storage issues in the future?

Universal Containers keeps its Account data in Salesforce and its Invoice data in a third -party ERP system. They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place. What two approaches should an architect suggest for achieving this solution? Choose 2 answers

Question 61

Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?

Use triggers to populate denormalized related fields on the Account.

Use an indexed data field with bounded data filters.

Use Formula fields to surface information I related entities on the report.

Use unbounded date ranges to filter the report.

Show Answer Comment (0)

Question 62

A customer wishes to migrate 700,000 Account records in a single migration into Salesforce. What is the recommended solution to migrate these records while minimizing migration time?

Use Salesforce Soap API in parallel mode.

Use Salesforce Bulk API in serial mode.

Use Salesforce Bulk API in parallel mode.

Use Salesforce Soap API in serial mode.

Show Answer Comment (0)

Question 63

Universal Containers has millions of rows of data in Salesforce that are being used in reports to evaluate historical trends. Performance has become an issue, as well as data storage limits. Which two strategies should be recommended when talking with stakeholders?

Use scheduled batch Apex to copy aggregate information into a custom object and delete the original records.

Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.

Use Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records.

Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.

Show Answer Comment (0)

Question 64

Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics. What solution addresses this requirement?

Use third-party AppExchange tools to monitor and measure data quality.

Generate reports to view the quality of sample data.

Use custom objects and fields to calculate data quality.

Export the data to an enterprise data warehouse and use BI tools for data quality.

Show Answer Comment (0)

Question 65

A shipping and logistics company has created a large number of reports within Sales Cloud since Salesforce was introduced. Some of these reports analyze large amounts of data regarding the whereabouts of the company's containers, and they are starting to time out when users are trying to run the reports. What is a recommended approach to avoid these time-out issues?

Improve reporting performance by creating a custom Visualforce report that is using a cache of the records in the report.

Improve reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud.

Improve reporting performance by creating an Apex trigger for the Report object that will pre-fetch data before the report is run.

Improve reporting performance by creating a dashboard that is scheduled to run the reports only once per day.

Show Answer Comment (0)

Question 66

Due to security requirements, Universal Containers needs to capture specific user actions, such as login, logout, file attachment download, package install, etc. What is the recommended approach for defining a solution for this requirement?

Use a field audit trail to capture field changes.

Use a custom object and trigger to capture changes.

Use Event Monitoring to capture these changes.

Use a third-party AppExchange app to capture changes.

Show Answer Comment (0)

Question 67

Universal Containers (UC) is concerned about the accuracy of their Customer information in Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they have certified to be accurate. UC has over 20 million unique customer records in the trusted source and Salesforce. What should an Architect recommend to ensure the data in Salesforce is identical to the MDM?

Extract the Salesforce data into Excel and manually compare this against the trusted source.

Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.

Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

Leave the data in Salesforce alone and assume that it will auto-correct itself over time.

Show Answer Comment (0)

Question 68

Which two statements are accurate with respect to performance testing a Force.com application?

All Force.com applications must be performance tested in a sandbox as well as production.

A performance test plan must be created and submitted to Salesforce customer support.

Applications with highly customized code or large volumes should be performance tested.

Application performance benchmarked in a sandbox can also be expected in production.

Show Answer Comment (0)

Question 69

Universal Containers (UC) is launching an RFP to acquire a new accounting product available on AppExchange. UC is expecting to issue 5 million invoices per year, with each invoice containing an average of 10 line items. What should UC's Data Architect recommend to ensure scalability?

Ensure invoice line items simply reference existing Opportunity line items.

Ensure the account product vendor includes Wave Analytics in their offering.

Ensure the account product vendor provides a sound data archiving strategy.

Ensure the accounting product runs 100% natively on the Salesforce platform.

Show Answer Comment (0)

Question 70

Universal Containers (UC) has a custom discount request object set as a detail object with a custom product object as the master. There is a requirement to allow the creation of generic discount requests without the custom product object as its master record. What solution should an Architect recommend to UC?

Mandate the selection of a custom product for each discount request.

Create a placeholder product record for the generic discount request.

Remove the master-detail relationship and keep the objects separate.

Change the master-detail relationship to a lookup relationship.

Show Answer Comment (0)

Total 260 questions

5 6 7 8 9

Go to page: of 26