更新されたPDF（2024年最新）実際にあるSalesforce Data-Architect試験問題
検証済みのData-Architect試験問題集PDF[2024年最新] 成功の秘訣はGoShiken
Salesforce Certified Data Architectは、Salesforceプラットフォームでデータアーキテクチャソリューションを設計および実装する際の専門家の知識とスキルを検証する高度なレベルの認定です。この認定は、データモデリング、データベース設計、データ統合、およびデータガバナンスの豊富な経験を持つ個人を対象としています。また、プラットフォームのデータモデル、データストレージオプション、データセキュリティ、データ管理機能など、Salesforceデータアーキテクチャを深く理解する必要があります。
質問 # 70
Universal Containers (UC) is transitioning from Classic to Lightning Experience.
What does UC need to do to ensure users have access to its notices and attachments in Lightning Experience?
- A. Migrate Notes and Attachment to Enhanced Notes and Files a migration tool
- B. Manually upload Notes in Lighting Experience.
- C. Add Notes and Attachments Related List to page Layout in Lighting Experience.
- D. Manually upload Attachments in Lighting Experience.
正解：A
解説：
The correct answer is C, migrate Notes and Attachment to Enhanced Notes and Files using a migration tool. Enhanced Notes and Files are the new features in Lightning Experience that replace the classic Notes and Attachments. They offer more functionality and security than the classic version. To access them in Lightning Experience, you need to migrate your existing Notes and Attachments using a migration tool provided by Salesforce. Adding Notes and Attachments Related List, manually uploading Notes or Attachments, or doing nothing are not valid solutions, as they will not enable you to use the enhanced features in Lightning Experience.
質問 # 71
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. Master Data Management systems determine system of record, and the Architect doesn't have to think about what data is controlled by what system.
- B. Key stakeholders should review any fields that share the same purpose between systems to see how they will be used in Salesforce.
- C. The database schema for each external system should be reviewed, and fields with different names should always be separate fields in Salesforce.
- D. Any field that is an input field in either external system will be overwritten by the last record integrated and can never have a system of record.
正解：B
解説：
Key stakeholders from both systems should collaborate with the Architect to determine which system is the system of record on a field level is what the Architect should do to achieve this goal of integrating two different systems with customer records into the Salesforce Account object using Master Data Management.
The system of record is the authoritative source of truth for a given entity or field in a given context. Different systems may have different levels of accuracy, completeness, timeliness, or relevance for different fields.
Therefore, it is important to involve key stakeholders from both systems who have knowledge and expertise about their data quality and business needs to decide which system should be the system of record for each field. The Architect should facilitate this collaboration and document the decisions and rationale for each field.
The other options are not correct or feasible, as they would either delegate or abdicate the responsibility of determining the system of record, ignore or disregard the input from key stakeholders, or assume or impose a default system of record without considering the data quality and business needs.
質問 # 72
UC has migrated its Back-office data into an on-premise database with REST API access. UC recently implemented Sales cloud for its sales organization. But users are complaining about a lack of order data inside SF.
UC is concerned about SF storage limits but would still like Sales cloud to have access to the data.
Which design patterns should a data architect select to satisfy the requirement?
- A. Develop a bidirectional integration between the on-premise system and Salesforce.
- B. Use SF Connect to virtualize the data in SF and avoid storage limits.
- C. Build a UI for the on-premise system and iframe it in Salesforce
- D. Migrate and persist the data in SF to take advantage of native functionality.
正解：B
解説：
The best design pattern to satisfy the requirement of accessing order data from an on-premise database with REST API access without consuming SF storage limits is to use SF Connect to virtualize the data in SF and avoid storage limits. SF Connect is an integration tool that allows users to access and integrate data from external sources using external objects. External objects are similar to custom objects, except that the data resides in another system and is accessed in real time via web service callouts. SF Connect supports various adapters to connect to different types of external data sources, such as OData, cross-org, or Apex custom adapter11. Migrate and persist the data in SF to take advantage of native functionality is not a good option because it would consume SF storage limits and require data synchronization between systems. Develop a bidirectional integration between the on-premise system and Salesforce is not a good option because it would be complex and costly to implement and maintain, and it would also consume SF storage limits. Build a UI for the on-premise system and iframe it in Salesforce is not a good option because it would not provide a seamless user experience and it would not allow users to search, report, or perform actions on the external data.
質問 # 73
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?
- A. Modify the export job header to specify Export-in-Parallel.
- B. Modify the export query that includes standard index fields(s).
- C. Modify the export query with LIMIT clause with Batch size 10,000.
- D. Modify the export job header to specify Sforce-Enable-PKChunking.
正解：D
解説：
The Sforce-Enable-PKChunking header enables you to extract large data sets from Salesforce by using a technique called primary key (PK) chunking. PK chunking splits your query into multiple queries based on the record IDs of the queried object. This reduces the query time and avoids the query timeout issues that can occur with large data volumes
質問 # 74
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. Duplicate customer records across the system and provide a two-way sync of data between the systems.
- B. Invest in data duplicate tool to de-dupe and merge duplicate records across all systems.
- C. Use Salesforce CDC to sync customer data cross all systems to keep customer record in sync.
- D. Create a unique global customer ID for each customer and store that in all system for referential identity.
- E. Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.
正解：B、D、E
質問 # 75
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?
- A. Mandate the selection of a custom product for each discount request.
- B. Create a placeholder product record for the generic discount request.
- C. Change the master-detail relationship to a lookup relationship.
- D. Remove the master-detail relationship and keep the objects separate.
正解：C
解説：
Changing the master-detail relationship to a lookup relationship is the best solution for allowing the creation of generic discount requests without the custom product object as its master record. A lookup relationship allows you to create child records without requiring a parent record. It also gives you more flexibility in defining the sharing and security settings for each object
質問 # 76
For a production cutover, a large number of Account records will be loaded into Salesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load. Which two recommended options assign Account ownership to mitigate potential performance problems?
- A. Let a "system user" own all the Account records and make this user part of the highest-level role in the Role Hierarchy.
- B. Let the VP of the Sales department, who will report directly to the senior VP, own all the Account records.
- C. Let a "system user" own all the Account records without assigning any role to this user in Role Hierarchy.
- D. Let a "system user" own the Account records and assign this user to the lowest-level role in the Role Hierarchy.
正解：C、D
解説：
The two recommended options to assign Account ownership to mitigate potential performance problems are to let a "system user" own all the Account records without assigning any role to this user in Role Hierarchy, or to let a "system user" own the Account records and assign this user to the lowest-level role in the Role Hierarchy. This is because these options would reduce the number of sharing calculations and rules that need to be applied to the Account records, and improve the performance and scalability of the system34. The other options are not recommended, as they would increase the sharing complexity and overhead, and potentially expose sensitive data to unauthorized users.
質問 # 77
Universal Containers has a large number of Opportunity fields (100) that they want to track field history on.
Which two actions should an architect perform in order to meet this requirement? Choose 2 answers
- A. Create a custom object to store a copy of the record when changed.
- B. Use Analytic Snapshots to store a copy of the record when changed.
- C. Create a custom object to store the previous and new field values.
- D. Select the 100 fields in the Opportunity Set History Tracking page.
正解：A、C
解説：
Creating a custom object to store a copy of the record when changed and creating a custom object to store the previous and new field values are two possible actions that an architect can perform to meet the requirement of tracking field history on 100 Opportunity fields. A custom object can store more fields and records than the standard field history tracking feature, which has a limit of 20 fields per object and 18 or 24 months of data retention. A custom object can also be used for reporting and analysis of field history data. The other options are not feasible or effective for meeting the requirement
質問 # 78
Northern Trail Outfitters (NTO) has recently implemented Salesforce to track opportunities across all their regions. NTO sales teams across all regions have historically managed their sales process in Microsoft Excel. NTO sales teams are complaining that their data from the Excel files were not migrated as part of the implementation and NTO is now facing low Salesforce adoption.
What should a data architect recommend to increase Salesforce adoption?
- A. Use the Excel connector to Salesforce to sync data from individual Excel files.
- B. Define a standard mapping and train sales users to import opportunity data.
- C. Load data in external database and provide access to database to sales users.
- D. Create a chatter group and upload all Excel files to the group.
正解：B
質問 # 79
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. Purchase more data storage to support case object
- C. Use a custom object to store archived case data.
- D. Use a custom Big object to store archived case data.
正解：D
解説：
The best solution to store historical cases for 10 years for audit purpose is to use a custom Big object to store archived case data. Big objects are a type of custom object that can store massive amounts of data on the Salesforce platform without affecting performance or storage limits. They also support point-and-click tools, triggers, and Apex code. Big objects can be used for archiving historical data that needs to be retained for compliance or analytics purposes3. Archiving case data using Salesforce Archiving process is not a good option because it only supports archiving cases that are closed for more than one year, and it does not allow customizing the archival criteria or accessing the archived data via Apex or APIs4. Purchasing more data storage to support case object is expensive and may impact performance. Using a custom object to store archived case data is not scalable and may consume a lot of storage space.
質問 # 80
A customer needs a sales model that allows the following:
Opportunities need to be assigned to sales people based on the zip code.
Each sales person can be assigned to multiple zip codes.
Each zip code is assigned to a sales area definition. Sales is aggregated by sales area for reporting.
What should a data architect recommend?
- A. Allow sales users to manually assign opportunity ownership based on zip code.
- B. Configure territory management feature to support opportunity assignment.
- C. Assign opportunities using list views using zip code.
- D. Add custom fields in opportunities for zip code and use assignment rules.
正解：B
解説：
The best solution to assign opportunities based on zip code and sales area is to configure territory management feature to support opportunity assignment. Territory management is a feature that allows you to organize your sales team into territories based on criteria such as geography, industry, product line, or customer segment. You can assign accounts and opportunities to territories using assignment rules or manual sharing. You can also define forecast managers and roll up forecasts by territory45. Assign opportunities using list views using zip code is not a good solution because it is inefficient and does not support reporting by sales area. Add custom fields in opportunities for zip code and use assignment rules is not a good solution because it requires creating additional fields and does not support reporting by sales area. Allow sales users to manually assign opportunity ownership based on zip code is not a good solution because it is prone to errors and does not support reporting by sales area.
質問 # 81
Universal Containers (UC) wants to ensure their data on 100,000 Accounts pertaining mostly to US-based companies is enriched and cleansed on an ongoing basis. UC is looking for a solution that allows easy monitoring of key data quality metrics. What should be the recommended solution to meet this requirement?
- A. Implement an Apex Trigger on Account that queries a third-party data quality API to monitor Account data quality.
- B. Use declarative approach by installing and configuring Data.com Prospector to monitor Account data quality.
- C. Implement Batch Apex that calls out a third-party data quality API in order to monitor Account data quality.
- D. Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality.
正解：D
解説：
Using a declarative approach by installing and configuring Data.com Clean to monitor Account data quality can help UC meet their requirement. Data.com Clean can enrich and cleanse data on an ongoing basis by comparing Salesforce records with Data.com records and providing suggestions for updates. Data.com Clean can also provide dashboards and reports to monitor key data quality metrics such as match rate, field fill rate, and record completeness
質問 # 82
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. Use SOQL queries without WHERE conditions.
- D. Reduce the number of triggers on Order _c object.
正解：A、B
質問 # 83
Universal Containers (UC) uses Salesforce for tracking opportunities (Opportunity). UC uses an internal ERP system for tracking deliveries and invoicing. The ERP system supports SOAP API and OData for bi-directional integration between Salesforce and the ERP system. UC has about one million opportunities. For each opportunity, UC sends 12 invoices, one per month. UC sales reps have requirements to view current invoice status and invoice amount from the opportunity page. When creating an object to model invoices, what should the architect recommend, considering performance and data storage space?
- A. Create an external object Invoice _x with a Lookup relationship with Opportunity.
- B. Use Streaming API to get the current status from the ERP and display on the Opportunity page.
- C. Create a custom object Invoice _c with a master -detail relationship with Opportunity.
- D. Create a custom object Invoice _c with a Lookup relationship with Opportunity.
正解：A
解説：
Creating an external object Invoice_x with a Lookup relationship with Opportunity is the best option for modeling invoices, considering performance and data storage space. An external object allows the data to be stored in the ERP system and accessed via OData in Salesforce. This reduces the data storage consumption in Salesforce and improves the performance of queries and reports. A Lookup relationship allows the sales reps to view the invoice status and amount from the opportunity page. The other options would either consume more data storage space, require additional customization, or not provide real-time data access
質問 # 84
Northern Trail Outfitters (NTO) has multiple Salesforce orgs based on regions. Users need read-only access to customers across all Salesforce orgs.
Which feature in Salesforce can be used to provide access to customer records across all NTO orgs?
- A. External APIs
- B. Salesforce Connect
- C. Federated Search
- D. Salesforce 2 Salesforce
正解：B
解説：
Salesforce Connect is a feature that allows users to access data from external sources and multiple Salesforce orgs, using either clicks or code. Salesforce Connect can provide read-only access to customer records across all NTO orgs, without replicating or storing the data in Salesforce.
質問 # 85
Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting performance issues and time-outs while running case reports in the Salesforce org.
Which solution should a data architect recommend to improve reporting performance?
- A. Contact Salesforce support to enable skinny table for cases.
- B. Move data off of the platform and run reporting outside Salesforce, and give access to reports.
- C. Build reports using custom Lightning components.
- D. Create a custom object to store aggregate data and run reports.
正解：D
質問 # 86
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. Implement de-duplication strategy to prevent duplicate leads
- B. Implement third-party solution to clean and event lead data.
- C. Standard lead information across all channels.
- D. Build a custom solution to identify and merge duplicate leads.
- E. Build process is manually search and merge duplicates.
正解：A、B、C
解説：
According to the Salesforce documentation2, duplicate leads are leads that have the same or similar information as other leads in Salesforce. Duplicate leads can cause poor customer experience, higher costs, and inaccurate reporting. To mitigate the issues caused by duplicate leads, some of the recommended practices are:
Standardize lead information across all channels (option B). This means using consistent formats, values, and fields for capturing lead data from different sources, such as web forms, email campaigns, or third-party vendors. This can help reduce data quality issues and make it easier to identify and prevent duplicate leads.
Implement a third-party solution to clean and enrich lead data (option D). This means using an external service or tool that can validate, correct, update, and enhance lead data before or after importing it into Salesforce. This can help improve data quality and accuracy, and reduce duplicate leads.
Implement a de-duplication strategy to prevent duplicate leads (option E). This means using Salesforce features or custom solutions that can detect and block duplicate leads from being created or imported into Salesforce. For example, using Data.com Duplicate Management3, which allows defining matching rules and duplicate rules for leads and other objects.
Building a process to manually search and merge duplicates (option A) is not a good practice, as it can be time-consuming, error-prone, and inefficient. Building a custom solution to identify and merge duplicate leads (option C) is also not a good practice, as it can be complex, costly, and difficult to maintain. It is better to use existing Salesforce features or third-party solutions that can handle duplicate leads more effectively.
質問 # 87
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?
- A. Add custom indexes to all fields on Application without a standard index.
- B. Run multiple reports to get different pieces of the data and combine them.
- C. Ask support to create a skinny table for Application with the necessary reporting fields.
- D. Add custom indexes to the Date fields used for filtering the report.
正解：C、D
解説：
Ask support to create a skinny table for Application with the necessary reporting fields. This is an option that can improve report performance by creating a custom table that contains frequently used fields and copies their values from standard or custom objects. Skinny tables are kept in sync with their source tables and are used in place of them for reports and queries4. Add custom indexes to the Date fields used for filtering the report. This is another option that can improve report performance by creating custom indexes on fields that are often used as filters or join conditions in reports and queries. Custom indexes can speed up data retrieval and reduce query execution time
質問 # 88
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. Create a custom object to store case history and run reports on it.
- B. Export data out of salesforce and store in Flat files on external system.
- C. Leverage on premise data archival and build integration to view archived data.
- D. Leverage big object to archive case data and lightning components to show archived data.
正解：C、D
質問 # 89
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?
- A. Master Detail Field on VTOTime_ c to Project_c with rollup summary field on Project __c showing sum of hours from VTOTime_c records.
- B. Lookup field on VTOTime_c to Project_c with formula filed on Project__ c showing Sum of hours from VTOTime__c records.
- C. Lookup Field on Project_c to VTOTime_c displaying a list of VTOTime__c in a related list.
- D. Master Detail field on Project _c to VTOTime _c showing a list of VTOTime_c Records in a related list.
正解：A
解説：
A master-detail field on VTOTime__c to Project__c is the data relationship that the data architect should use to support the requirement when creating the custom VTOTime__c object. A master-detail relationship creates a parent-child relationship between two objects, where the master record controls certain behaviors of the detail record, such as security, ownership, deletion, and roll-up summary fields. By using a master-detail field on VTOTime__c to Project__c, you can ensure that the ability to view or edit the VTOTime__c object is the same as the Project__c record, and that managers can see the total hours volunteered while viewing the Project__c record using a roll-up summary field.
質問 # 90
For a production cutover, a large number of Account records will be loaded into Salesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load. Which two recommended options assign Account ownership to mitigate potential performance problems?
- A. Let a "system user" own all the Account records and make this user part of the highest-level role in the Role Hierarchy.
- B. Let the VP of the Sales department, who will report directly to the senior VP, own all the Account records.
- C. Let a "system user" own all the Account records without assigning any role to this user in Role Hierarchy.
- D. Let a "system user" own the Account records and assign this user to the lowest-level role in the Role Hierarchy.
正解：C、D
質問 # 91
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. Use Bulk API serial mode for data migration
- B. Use Bulk API parallel mode for data migration
- C. Insert the order in another custom object and use Batch Apex to move the records to Service_ Order__ c object.
- D. Change the lookup configuration to "Clear the value of this field" when lookup record is deleted.
正解：A
解説：
According to the official Salesforce guide1, using Bulk API serial mode for data migration can help avoid locking issues by processing batches in a single thread. This mode ensures that batches are processed in the order they are received and that only one batch is processed at a time. This reduces the risk of lock contention and deadlocks, especially when updating parent and child records in a lookup relationship. Option B is the correct answer because it suggests using Bulk API serial mode for data migration. Option A is incorrect because using Bulk API parallel mode for data migration can cause locking issues by processing batches in multiple threads. This mode does not guarantee the order of batch processing and can result in concurrent updates to the same records, which can lead to lock contention and deadlocks. Option C is incorrect because inserting the order in another custom object and using Batch Apex to move the records to Service_Order__c object adds unnecessary complexity and overhead to the data migration process. Option D is incorrect because changing the lookup configuration to "Clear the value of this field" when lookup record is deleted does not address the locking issues caused by data migration, but rather by record deletion.
質問 # 92
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 master-detail field 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 an Apex trigger to synchronize the Product Family standard picklist field on the Product object.
- D. Create a custom lookup filed on the standard Product to reference the child record in the hierarchy.
正解：B
質問 # 93
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?
- A. As needed, make call outs into Heroku postgres and persist the data in salesforce.
- B. Virtualize the remaining set of data with salesforce connect and external objects.
- C. Migrate the data to big objects and leverage async SOQL with custom objects.
- D. Use Heroku connect to bi-directional, sync all data between systems.
正解：B
解説：
Virtualizing the remaining set of data with salesforce connect and external objects is the best way to meet the requirements with minimal effort, as it allows salesforce to access data stored in Heroku Postgres without storing it in salesforce. This reduces the storage limitations and avoids data duplication. Heroku connect can bi-directionally sync data between systems, but it requires more configuration and maintenance. Making callouts to Heroku Postgres and persisting the data in salesforce may not be feasible for 1 billion records. Migrating the data to big objects may incur additional costs and require custom code to use async SOQL
質問 # 94
......
Salesforce Data-Architect認定試験は、Salesforceのツールや技術を使用してデータソリューションを設計、開発、実装する能力を評価するシナリオを含みます。この試験は、データモデリング、データ統合、データ移行、データガバナンス、およびデータセキュリティに関する知識を試験します。候補者は、Salesforceのデータアーキテクチャについての深い理解を持ち、実世界のビジネスシナリオへの適用を理解していることが期待されています。また、Salesforce Data Loader、Salesforce Connect、およびSalesforce Shieldなどのツールの使用にも熟練している必要があります。
ベストを体験せよ！Data-Architect試験問題トレーニングを提供しています：https://www.goshiken.com/Salesforce/Data-Architect-mondaishu.html
練習サンプルと問題集と秘訣には2024年最新のData-Architect有効なテスト問題集：https://drive.google.com/open?id=1BYSLKEnzbJ64jA_5Eue1LgwjPyjZVNgi