2023年最新の認定サンプル問題Data-Architect問題集と練習試験合格させます
Data-Architect豪華セット学習ガイドにはオンライン試験エンジン
質問 # 38
Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers
- A. Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
- B. Turn on field Contact object history tracking for these ten fields, then create reports on contact history.
- C. Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.
- D. Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.
正解：A、B
解説：
To capture and report on any changes made to ten text fields on the Contact object for the past 3 months, the data architect should write an Apex trigger on Contact after insert and after update events and store the old values in another custom object, or turn on field Contact object history tracking for these ten fields and create reports on contact history. An Apex trigger can capture the old and new values of the fields, as well as the user and time of the change, and store them in a custom object that can be used for reporting. Field history tracking can also track the changes to the fields and store them in a history table that can be used for reporting. However, field history tracking only retains data for up to 18 months or 24 months with an extension, so it may not be suitable for longer-term reporting needs. The other options are not feasible or effective for capturing and reporting on field data changes.
質問 # 39
NTO has multiple systems across its enterprise landscape including salesforce, with disparate version the customer records.
In salesforce, the customer is represented by the contact object.
NTO utilizes an MDM solution with these attributes:
1. The MDM solution keeps track of customer master with a master key.
2. The master key is a map to the record ID's from each external system that customer data is stored within.
3. The MDM solution provides de-duplication features, so it acts as the single source of truth.
How should a data architect implement the storage of master key within salesforce?
- A. Create an external object to store the master key with a lookup field to contact.
- B. Store the master key in Heroku postgres and use Heroku connect for synchronization.
- C. Store the master key on the contact object as an external ID (Field for referential imports)
- D. Create a custom object to store the master key with a lookup field to contact.
正解：C
解説：
The best way to implement the storage of master key within Salesforce is to store it on the contact object as an external ID field for referential imports. This way, the data architect can use the master key as a unique identifier to match records from different systems and avoid duplicates. The other options are not feasible because they either require additional storage or do not support referential imports.
質問 # 40
Universal containers is implementing Salesforce lead management. UC Procure lead data from multiple sources and would like to make sure lead data as company profile and location information. Which solution should a data architect recommend to make sure lead data has both profile and location information? Option
- A. Leverage external data providers populate company profile and location data
- B. Run reports to identify records which does not have company profile and location data
- C. Ask sales people to search for populating company profile and location data
- D. Export data out of Salesforce and send to another team to populate company profile and location data
正解：B
質問 # 41
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. Limit data loading to the 2000 most recently created records.
- B. Create a skinny table to represent account and contact objects.
- C. Load only the data that the users is permitted to access
- D. Add custom indexes on frequently searched account and contact objects fields
正解：D
解説：
The correct answer is B, add custom indexes on frequently searched account and contact object fields. Custom indexes are a way to improve the performance of your queries and reports by creating indexes on specific fields that are often used in filters or joins. By adding custom indexes on frequently searched account and contact object fields, you can speed up the response time for reports and list views. Loading only the data that users are permitted to access, limiting data loading to the 2000 most recent records, or creating a skinny table are also possible solutions, but they are either not feasible, not scalable, or not supported by Salesforce.
質問 # 42
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. Make the queries more selective using indexed fields.
- B. Work with Salesforce Support to enable Skinny Tables.
- C. Reduce the number of triggers on Order _c object.
- D. Use SOQL queries without WHERE conditions.
正解：A、B
質問 # 43
Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records. When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?
- A. Create a picklist field, values sorted alphabetically.
- B. Create a Lookup to custom object ShippingStatus c.
- C. Create a text field and make it an external I
- D. Create a Master -Detail to custom object ShippingStatus c.
正解：A
質問 # 44
UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items. What two steps can you take to help correct this? Choose two answers.
- A. Limit Batch to 10K records
- B. Use PK Chunking
- C. Export in multiple batches
- D. Export Bulk API in parallel mode
正解：B、C
解説：
Exporting in multiple batches and using PK Chunking are two steps that can help correct the issues with exporting large volumes of Order records using Informatica Cloud Loader. Exporting in multiple batches can reduce the load on the system and avoid timeouts or errors. Using PK Chunking can split a large data set into smaller chunks based on the record IDs and enable parallel processing of each chunk.
質問 # 45
DreamHouse Realty has a Salesforce deployment that manages Sales, Support, and Marketing efforts in a multi-system ERP environment. The company recently reached the limits of native reports and dashboards and needs options for providing more analytical insights.
What are two approaches an Architect should recommend? (Choose two.)
- A. AppExchange Apps
- B. Einstein Analytics
- C. Weekly Snapshots
- D. Setup Audit Trails
正解：A、B
質問 # 46
Which three characteristics of a Skinny table help improve report and query performance?
- A. Skinny tables can contain frequently used fields and thereby help avoid joins.
- B. Skinny tables provide a view across multiple objects for easy access to combined data.
- C. Skinny tables can be used to create custom indexes on multi-select picklist fields.
- D. Skinny tables are kept in sync with changes to data in the source tables.
- E. Skinny tables do not include records that are available in the recycle bin.
正解：A、B、D
質問 # 47
Universal Containers (UC) has a multi-level master-detail relationship for opportunities, a custom opportunity line item object, and a custom discount request. UC has opportunity as master and custom line item object as detail in master-detail relationship. UC also has a custom line item object as master and a custom discount request object as detail in another master-detail relationship. UC has a requirement to show all sums of discounts across line items at an opportunity level. What is the recommended solution to address these requirements?
- A. Roll-up discount request amount at the line-item-level and line-item-level summary discount at the opportunity level.
- B. Update the master-detail relationships to lookup relationships in order to allow the discount amount to roll up.
- C. Remove the master-detail relationships and rely completely on workflow/triggers to summarize the discount amount.
- D. Use roll-up for the line-item-level summary and a trigger for the opportunity amount summary, as only one level roll-up is allowed.
正解：A
質問 # 48
Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system. Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality?
- A. Use Duplicate Management.
- B. Use Data.com Clean
- C. Use a data wharehouse.
- D. Use an Enterprise Service Bus.
正解：A、B
質問 # 49
Universal Containers (UC) maintains a collection of several million Account records that represent business in the United Sates. As a logistics company, this list is one of the most valuable and important components of UC's business, and the accuracy of shipping addresses is paramount. Recently it has been noticed that too many of the addresses of these businesses are inaccurate, or the businesses don't exist. Which two scalable strategies should UC consider to improve the quality of their Account addresses?
- A. Build a team of employees that validate Accounts by searching the web and making phone calls.
- B. Contact each business on the list and ask them to review and update their address information.
- C. Leverage Data.com Clean to clean up Account address fields with the D&B database.
- D. Integrate with a third-party database or services for address validation and enrichment.
正解：C、D
質問 # 50
NTO has multiple systems across its enterprise landscape including salesforce, with disparate version the customer records.
In salesforce, the customer is represented by the contact object.
NTO utilizes an MDM solution with these attributes:
1. The MDM solution keeps track of customer master with a master key.
2. The master key is a map to the record ID's from each external system that customer data is stored within.
3. The MDM solution provides de-duplication features, so it acts as the single source of truth.
How should a data architect implement the storage of master key within salesforce?
- A. Create an external object to store the master key with a lookup field to contact.
- B. Store the master key in Heroku postgres and use Heroku connect for synchronization.
- C. Store the master key on the contact object as an external ID (Field for referential imports)
- D. Create a custom object to store the master key with a lookup field to contact.
正解：C
質問 # 51
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 case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users.
- B. Create a custom object to maintain preferences and build relationships to Lead, Person Account, and Users.
- C. Create custom fields for contact preferences in Lead, Person Account, and Users objects.
- D. Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.
正解：D
質問 # 52
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?
- A. Create one Account and load individual consumers as Contacts linked to that one Account.
- B. Create a Custom Object Individual Consumer c to load all individual consumers.
- C. Load one Account record and one Contact record for each individual consumer.
- D. Load all individual consumers as Account records and avoid using the Contact object.
正解：C
質問 # 53
Universal Container (UC) stores 10 million rows of inventory data in a cloud database, As part of creating a connected experience in Salesforce, UC would like to this inventory data to Sales Cloud without a import. UC has asked its data architect to determine if Salesforce Connect is needed.
Which three consideration should the data architect make when evaluating the need for Salesforce Connect?
- A. You want real-time access to the latest data, from other systems.
- B. You need to small amounts of external data at any one time.
- C. You have a large amount of data that you don't want to copy into your Salesforce org.
- D. You have a large amount of data and would like to copy subsets of it into Salesforce.
- E. You need to expose data via a virtual private connection.
正解：A、B、C
質問 # 54
......
Data-Architect問題集レビュー専門クイズで学習材料：https://www.goshiken.com/Salesforce/Data-Architect-mondaishu.html
Data-Architectテスト準備トレーニング練習試験問題練習テスト：https://drive.google.com/open?id=1burmOwAQf9fA8OfftFG-fIsfZbmYpn0t