Data-Architect試験無料問題集（260題）「Salesforce Certified Data Architect 認定」

出題：1

UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.
Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers.

A. Limit associating 10000 opportunities to one account.

B. Limit assigning one user 10000 records ownership.

C. Use picklist fields rather than lookup to custom object.

D. Assign 10000 opportunities to one account.

E. Limit associating 10000 records looking up to same records.

正解：A,B,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Northern Trail outfitters in migrating to salesforce from a legacy CRM system that identifies the agent relationships in a look-up table.
What should the data architect do in order to migrate the data to Salesfoce?

A. Assign record owner based on relationship.

B. Create custom objects to store agent relationships.

C. Migrate to Salesforce without a record owner.

D. Migrate the data and assign to a non-person system user.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

A large insurance provider is looking to implement Salesforce. The following exist.
1. Multiple channel for lead acquisition
2. Duplication leads across channels
3. Poor customer experience and higher costs
On analysis, it found that there are duplicate leads that are resulting to mitigate the issues?

A. Build process is manually search and merge duplicates.

B. Build a custom solution to identify and merge duplicate leads.

C. Implement de-duplication strategy to prevent duplicate leads

D. Standard lead information across all channels.

E. Implement third-party solution to clean and event lead data.

正解：C,D,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Saiesforce Is implemented as follows:
1. Sales users enter their opportunities in Salesforce for forecasting and reporting purposes.
2. NTO has a product pricing system (PPS) that is used to update the Opportunity Amount field on opportunities on a daily basis.
3. PPS is the trusted source within NTO for Opportunity Amount.
4. NTO uses Opportunity Forecast for its sales planning and management.
Sales users have noticed that their updates to the Opportunity Amount field are overwritten when PPS updates their opportunities.
How should a data architect address this overwriting issue?

A. Create a custom field for Opportunity amount that sales users update separating the field that PPS updates.

B. Change Opportunity Amount field access to Read Only for sales users field-level security.

C. Create a custom field for Opportunity amount that PSS updates separating the field sales user updates.

D. Change PSS integration to update only Opportunity Amount field when the value is null.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

UC has millions of Cases and are running out of storage. Some user groups need to have access to historical cases for up to 7 years.
Which 2 solutions should a data architect recommend in order to minimize performance and storage issues?
Choose 2 answers:

A. Export data out of salesforce and store in Flat files on external system.

B. Leverage big object to archive case data and lightning components to show archived data.

C. Leverage on premise data archival and build integration to view archived data.

D. Create a custom object to store case history and run reports on it.

正解：B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

Universal Containers (UC) is in the process of migrating legacy inventory data from an enterprise resources planning (ERP) system into Sales Cloud with the following requirements:
Legacy inventory data will be stored in a custom child object called Inventory_c.
Inventory data should be related to the standard Account object.
The Inventory object should Invent the same sharing rules as the Account object.
Anytime an Account record is deleted in Salesforce, the related Inventory_c record(s) should be deleted as well.
What type of relationship field should a data architect recommend in this scenario?

A. Indirect lookup relationship field on Account, related to Inventory_c

B. Master-detail relationship filed on Inventory_c, related to Account

C. Lookup relationship fields on Inventory related to Account

D. Master-detail relationship filed on Account, related to Inventory_c

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Universal Containers is establishing a call center that will use Salesforce. UC receives 10 million calls and creates 100 million cases every month. Cases are linked to a custom call object using lookup relationship. UC would like to run reports and dashboard to better understand different case types being created on calls to better serve customers.
What solution should a data architect recommend to meet the business requirement?

A. Leverage out-of-the-box reports and dashboard on case and interactive voice response (IVR) custom object.

B. Leverage custom objects to store aggregate data and run analytics.

C. Archive records to a data warehouse and run analytics on the data warehouse.

D. Leverage big objects to archive records and Einstein Analytics to run reports.

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

UC has millions of case records with case history and SLA data. UC's compliance team would like historical cases to be accessible for 10 years for Audit purpose.
What solution should a data architect recommend?

A. Archive Case data using Salesforce Archiving process

B. Use a custom Big object to store archived case data.

C. Use a custom object to store archived case data.

D. Purchase more data storage to support case object

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

Universal Containers (UC) manages Vehicle and Service History in Salesforce. Vehicle (Vehicle__ c) and Service History (Service-History__ c) are both custom objects related through a lookup relationship.
Every week a batch synchronization process updates the Vehicle and Service History records in Salesforce.
UC has two hours of migration window every week and is facing locking issues as part of the data migration process.
What should a data architect recommend to avoid locking issues without affecting performance of data migration?

A. Insert the order in another custom object and use Batch Apex to move the records to Service_ Order__ c object.

B. Use Bulk API serial mode for data migration

C. Change the lookup configuration to "Clear the value of this field" when lookup record is deleted.

D. Use Bulk API parallel mode for data migration

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：10

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 that shows the percentage of blanks for the important fields.

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

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

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

正解：A,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：11

Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department with missing States and incorrectly formatted Postal Codes.
Which two actions should Cloud Kicks take to improve data quality? (Choose two.)

A. Change each address field to require on the Page Layout.

B. Utilize a Validation Rule with a CONTAINS operator on address fields.

C. Utilize a Validation Rule with a REGEX operator on Postal Code.

D. Write an Apex Trigger to require all fields to be populated.

正解：B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：12

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. Make the queries more selective using indexed fields.

D. Reduce the number of triggers on Order _c object.

正解：B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：13

NTO has 1 million customer records spanning 25 years. As part of its new SF project, NTO would like to create a master data management strategy to help preserve the history and relevance of its customer data.
Which 3 activities will be required to identify a successful master data management strategy? Choose 3 answers:

A. Identify data to be replicated

B. Create a data archive strategy

C. Choose a Business Intelligence tool.

D. Install a data warehouse

E. Define the systems of record for critical data

正解：A,B,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：14

A large multinational B2C Salesforce customer is looking to implement their distributor management application is Salesforce. the application has the following capabilities:
1.Distributor create sales order in salesforce
2.Sales order are based on product prices applicable to their region
3. Sales order are closed once they are fulfilled
4. It is decided to maintain the order in opportunity object
How should the data architect model this requirement?

A. Configure price Books for each region and share with distributors.

B. Manually update Opportunities with Prices application to distributors.

C. Add custom fields in Opportunity and use triggers to update prices.

D. Create lookup to Custom Price object and share with distributors.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：15

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. Import the data in smaller batches over a 24-hour period.

B. Ensure duplication and matching rules and defined.

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

D. Bulkily the trigger to handle import leads.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：16

Which API should a data architect use if exporting 1million records from Salesforce?

A. SOAP API

B. REST API

C. Streaming API

D. Bulk API

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：17

In their legacy system. Universal Containers has a monthly accounts receivable report that compiles data from Accounts, Contacts, Opportunities, Orders. and Order Line Items. What difficulty will an architect run into when implementing this in Salesforce?

A. Salesforce allows up to four objects in a single report type.

B. A report cannot contain data from Accounts and Contacts.

C. Salesforce does not support Orders or Order Line Items.

D. Custom report types cannot contain Opportunity data.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：18

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?

A. Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.

B. Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.

C. Export legacy data into CSV files and leverage data loader to load data into Salesforce.

D. Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：19

Northern Trail Outfitters (NTO) has a variety of customers that include householder, businesses, and individuals.
The following conditions exist within its system:
NTO has a total of five million customers.
Duplicate records exist, which is replicated across many systems, including Salesforce.
Given these conditions, there is a lack of consistent presentation and clear identification of a customer record.
Which three option should a data architect perform to resolve the issues with the customer data?

A. Use Salesforce CDC to sync customer data cross all systems to keep customer record in sync.

B. Invest in data duplicate tool to de-dupe and merge duplicate records across all systems.

C. Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.

D. Duplicate customer records across the system and provide a two-way sync of data between the systems.

E. Create a unique global customer ID for each customer and store that in all system for referential identity.

正解：B,C,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：20

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?

A. Use unbounded date ranges to filter the report.

B. Use triggers to populate denormalized related fields on the Account.

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

D. Use an indexed data field with bounded data filters.

正解：C,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

Data-Architect試験無料問題集「Salesforce Certified Data Architect 認定」