[Dec 08, 2022] Data-Architect Free Exam Questions with Quality Guaranteed [Q113-Q133]

Rate this post

[Dec 08, 2022] Data-Architect Free Exam Questions with Quality Guaranteed

Data-Architect Free Exam Files Downloaded Instantly

Salesforce Data-Architect Exam Syllabus Topics:

Topic	Details
Topic 1	Compare and contrast various approaches and considerations for designing and implementing an enterprise data governance program Discuss criteria and methodology for picking the winning attributes
Topic 2	Compare and contrast the different reasons for implementing Big Objects vs Standard Custom objects within a production instance Discuss the various options to identify, classify and protect personal and sensitive information
Topic 3	Recommend a design to effectively consolidate and or leverage data from multiple Salesforce instances Compare and contrast various techniques, approaches and considerations
Topic 4	Describe techniques to represent a single view of the customer on the Salesforce platform Recommend appropriate techniques and methods for ensuring high data quality at load time
Topic 5	Recommend techniques to ensure data is persisted in a consistent manner Design a data model that scales considering large data volume and solution performance
Topic 6	Recommend and use techniques for establishing a “golden record” or “system of truth” Recommend a data archiving and purging plan that is optimal for customer’s data storage management needs
Topic 7	Decide when to use virtualised data and describe virtualised data options Compare and contrast various techniques and considerations for exporting data from Salesforce
Topic 8	Recommend appropriate approaches and techniques to capture and maintain customer reference & metadata Compare and contrast various techniques for improving performance when migrating large data volumes into Salesforce

NO.113 Universal Containers (UC) has an Application custom object, which has tens of millions of records created in the past 5 years. UC needs the last 5 years of data to exist in Salesforce at all times for reporting and queries. UC is currently encountering performance issues when reporting and running queries on this Object using date ranges as filters. Which two options can be used to improve report performance?

Ask support to create a skinny table for Application with the necessary reporting fields.

Add custom indexes to the Date fields used for filtering the report.

Add custom indexes to all fields on Application without a standard index.

Run multiple reports to get different pieces of the data and combine them.

NO.114 Universal Containers is creating a new B2C service offering for consumers to ship goods across continents. This is in addition to their well-established B2B offering. Their current Salesforce org uses the standard Account object to track B2B customers. They are expecting to have over 50,000,000 consumers over the next five years across their 50 business regions. B2C customers will be individuals. Household data is not required to be stored. What is the recommended data model for consumer account data to be stored in Salesforce?

Create a new picklist value for B2C customers on the Account Type field.

Use the Account object with Person Accounts and a new B2C page layout.

Use 50 umbrella Accounts for each region, with customers as associated Contacts.

Use the Account object with a newly created Record Type for B2C customers.

NO.115 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 unbounded date ranges to filter the report.

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

Use an indexed data field with bounded data filters.

Use triggers to populate denormalized related fields on the Account.

NO.116 To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?

Errors with records being updated and inserted in the same CSV file.

Errors when a duplicate Contact name is found cause upsert to fail.

Errors with using the wrong external Id will cause the load to fail.

Errors with duplicate external Id values within the same CSV file.

NO.117 UC needs to load a large volume of leads into salesforce on a weekly basis. During this process the validation rules are disabled.
What should a data architect recommend to ensure data quality is maintained in salesforce.

Develop custom APEX batch process to improve quality once the load is completed.

Ensure the lead data is preprocessed for quality before loading into salesforce.

Allow validation rules to be activated during the load of leads into salesforce.

Activate validation rules once the leads are loaded into salesforce to maintain quality.

NO.118 Cloud Kicks currently has a Public Read/Write sharing model for the company’s Contacts. Cloud Kicks management team requests that only the owner of a contact record be allowed to delete that contact.
What should an Architect do to meet these requirements?

Set the profile of the users to remove delete permission from the Contact object.

Check if the current user is NOT the owner by creating a “before delete” trigger.

Set the Sharing settings as Public Read Only for the Contact object.

Check if the current user is NOT the owner by creating a validation rule on the Contact object.

NO.119 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 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.

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

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

NO.120 Universal Container is using Salesforce for Opportunity management and enterprise resource planning (ERP) for order management. Sales reps do not have access to the ERP and have no visibility into order status.
What solution a data architect recommend to give the sales team visibility into order status?

Leverage Canvas to bring the order management UI in to the Salesforce tab.

leverage Salesforce Connect top bring the order line item from the legacy system to Salesforce.

Build real-time integration to pull order line items into Salesforce when viewing orders.

Build batch jobs to push order line items to salesforce.

NO.121 Universal Containers is exporting 40 million Account records from Salesforce using Informatica Cloud. The ETL tool fails and the query log indicates a full table scan time-out failure. What is the recommended solution?

Modify the export query that includes standard index fields(s).

Modify the export job header to specify Export-in-Parallel.

Modify the export query with LIMIT clause with Batch size 10,000.

Modify the export job header to specify Sforce-Enable-PKChunking.

NO.122 What 2 data management policies does the data classification feature allow customers to classify in salesforce? Choose 2 answers:

Reference data policy.

Data sensitivity policy.

Data governance policy.

Compliance categorization policy.

NO.123 An architect is planning on having different batches to load one million Opportunities into Salesforce using the Bulk API in parallel mode. What should be considered when loading the Opportunity records?

Order batches by Auto -number field.

Group batches by the AccountId field.

Sort batches by Name field values.

Create indexes on Opportunity object text fields.

NO.124 What makes Skinny tables fast? Choose three answers.

They do not include soft-deleted records

Their tables are kept in sync with their source tables when the source tables are modified

They can contain fields from other objects

They avoid resource intensive joins

They support up to a max of 100 of columns

NO.125 A customer is facing locking issued when importing large data volumes of order records that are children in a master-detail relationship with the Account object. What is the recommended way to avoid locking issues during import?

Import Order records and Account records separately and populate AccountID in orders using batch Apex.

Import Account records first followed by order records after sorting order by OrderID.

Change the relationship to Lookup and update the relationship to master-detail after import.

Import Account records first followed by order records after sorting orders by AccountID.

NO.126 UC recently migrated 1 Billion customer related records from a legacy data store to Heroku Postgres. A subset of the data need to be synchronized with salesforce so that service agents are able to support customers directly within the service console. The remaining non- synchronized set of data will need to be accessed by salesforce at any point in time, but UC management is concerned about storage limitations.
What should a data architect recommend to meet these requirements with minimal effort?

Use Heroku connect to bi-directional, sync all data between systems.

Virtualize the remaining set of data with salesforce connect and external objects.

Migrate the data to big objects and leverage async SOQL with custom objects.

As needed, make call outs into Heroku postgres and persist the data in salesforce.

NO.127 Universal Containers has successfully migrated 50 million records into five different objects multiple times in a full copy sandbox. The Integration Engineer wants to re-run the test again a month before it goes live into Production. What is the recommended approach to re-run the test?

Refresh the full copy sandbox and re-run the data migration test.

Hard delete all 5 objects’ data and re-run the data migration test.

Truncate all 5 objects quickly and re-run the data migration test.

Truncate all 5 objects and hard delete before running the migration test.

NO.128 Universal Containers has a custom object with millions of rows of data.
When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)

Using leading % wildcards.

Using NOT and != operators.

Using trailing % wildcards.

Using a custom index on a deterministic formula field.

Performing large loads and deletions.

NO.129 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?

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

Generate reports to view the quality of sample data.

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

Use custom objects and fields to calculate data quality.

NO.130 Universal Containers (UC) 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. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com?

Load all data after deferring sharing calculations.

Load all data using external IDs to link to parent records.

Use triggers to calculate summary values instead of Roll -Up.

Use workflow to calculate summary values instead of Roll -Up.

NO.131 Universal Containers is integrating a new Opportunity engagement system with Salesforce. According to their Master Data Management strategy, Salesforce is the system of record for Account, Contact, and Opportunity dat a. However, there does seem to be valuable Opportunity data in the new system that potentially conflicts with what is stored in Salesforce. What is the recommended course of action to appropriately integrate this new system?

Stakeholders should be brought together to discuss the appropriate data strategy moving forward.

The Opportunity engagement system should become the system of record for Opportunity records.

The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts.

A policy should be adopted so that the system whose record was most recently updated should prevail in conflicts.

NO.132 Universal Containers (UC) is a business that works directly with individual consumers (B2C). They are moving from a current home-grown CRM system to Salesforce. UC has about one million consumer records. What should the architect recommend for optimal use of Salesforce functionality and also to avoid data loading issues?

Create one Account and load individual consumers as Contacts linked to that one Account.

Create a Custom Object Individual Consumer c to load all individual consumers.

Load one Account record and one Contact record for each individual consumer.

Load all individual consumers as Account records and avoid using the Contact object.

NO.133 Get Cloudy Consulting is migrating their legacy system’s users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.
Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.
Which two approaches will accomplish this goal? (Choose two.)

Create the users, upload all data, and then deploy the sharing rules.

Contact Salesforce to activate indexing before uploading the data.

Defer sharing calculations until the data has finished uploading.

First, load all account records, and then load all user records.