GoShiken Data-Architectリアル試験問題解答は更新された[2024年01月04日]
お手軽に合格させる 最新Salesforce Data-Architect問題集には259問があります
Salesforce Certified Data Architect認定は、Salesforceに複雑なデータアーキテクチャを設計および実装する候補者の能力を示しているため、業界で非常に評価されています。これは、データ管理、ビジネスインテリジェンス、分析、データサイエンスなどの分野で働く専門家に特に関連しています。この認定は、世界中の主要な組織によって認識されており、Salesforceエコシステムでのキャリアを促進しようとしている人にとって貴重な資産です。
質問 # 115
Universal Containers (UC) has multi -level account hierarchies that represent departments within their major Accounts. Users are creating duplicate Contacts across multiple departments. UC wants to clean the data so as to have a single Contact across departments. What two solutions should UC implement to cleanse their data? Choose 2 answers
- A. Make use of a third -party tool to help merge duplicate Contacts across Accounts.
- B. Make use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.
- C. Use Data.com to standardize Contact address information to help identify duplicates.
- D. Use Workflow rules to standardize Contact information to identify and prevent duplicates.
正解：A、C
質問 # 116
Universal Containers (UC) has a requirement to create an Account plan object that is related to the Account object. Each Account plan needs to have an Account object, but the accessibility requirement of the Account plan is different from the Account object. What should an Architect recommend?
- A. Create a custom account plan object as detail with Account as mater in a master-detail relationship.
- B. Create an account plan object with a lookup relations to Account without any validation rules to enforce the Account association.
- C. Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.
- D. Create a custom account plan object as detail with Account as master with additional sharing rules to allow access.
正解：C
質問 # 117
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?
- A. Use a field audit trail to capture field changes.
- B. Use Event Monitoring to capture these changes.
- C. Use a third-party AppExchange app to capture changes.
- D. Use a custom object and trigger to capture changes.
正解：B
質問 # 118
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?
- A. Errors when a duplicate Contact name is found cause upsert to fail.
- B. Errors with duplicate external Id values within the same CSV file.
- C. Errors with records being updated and inserted in the same CSV file.
- D. Errors with using the wrong external Id will cause the load to fail.
正解：B
解説：
Data Loader uses external Id fields to match records in the CSV file with records in Salesforce during an upsert operation. If the CSV file contains duplicate external Id values within the same file, Data Loader will throw an error saying "Duplicate Id Specified" and will not process those records. Therefore, it is important to ensure that the CSV file does not have any duplicate external Id values before using Data Loader to upsert records.
質問 # 119
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. Select the 100 fields in the Opportunity Set History Tracking page.
- C. Create a custom object to store the previous and new field values.
- D. Use Analytic Snapshots to store a copy of the record when changed.
正解：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
質問 # 120
NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5 years. Internal users are complaining abt multiple data issues, including incomplete and duplicate data in the org. NTO has decided to engage a data architect to analyze and define data quality standards.
Which 3 key factors should a data architect consider while defining data quality standards? Choose 3 answers:
- A. Finalize an extract transform load (ETL) tool for data migration
- B. Measure data completeness and accuracy
- C. Define data duplication standards and rules
- D. Define key fields in staging database for data cleansing
- E. Measure data timeliness and consistency
正解：B、C、E
質問 # 121
What makes Skinny tables fast? Choose three answers.
- A. They avoid resource intensive joins
- B. They do not include soft-deleted records
- C. Their tables are kept in sync with their source tables when the source tables are modified
- D. They can contain fields from other objects
- E. They support up to a max of 100 of columns
正解：A、B、C
解説：
Skinny tables are custom tables that contain frequently used fields from a standard or custom object. They are used to improve performance by reducing the number of database joins required for queries. Skinny tables have the following characteristics1:
They do not include soft-deleted records, which means they only contain active records and save space.
They avoid resource intensive joins by storing data from multiple objects in one table, which reduces the query time and complexity.
Their tables are kept in sync with their source tables when the source tables are modified, which ensures data consistency and accuracy.
質問 # 122
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?
- A. Use Data Loader for export and Data Import Wizard for import
- B. use as ETL tool to orchestrate the migration.
- C. Use the Salesforces CLI to query, export, and import
- D. Write a script to use the Bulk API
正解：B
解説：
Using an ETL tool to orchestrate the migration is the best strategy for this scenario, as it can handle the data model changes, the large volume of records, and the tight timeline. Writing a script to use the Bulk API (option C) is also possible, but it would require more coding and testing effort. Using Data Loader and Data Import Wizard (option B) is not suitable for migrating three million records, as they have limitations on the batch size and the number of records per operation. Using Salesforce CLI (option D) is also not recommended for large data migration, as it is mainly designed for development and testing purposes
質問 # 123
UC has a roll-up summary field on Account to calculate the count of contacts associated with an account. During the account load, SF is throwing an "Unable to lock a row" error.
Which solution should a data architect recommend, to resolve the error?
- A. Leverage data loader platform API to load data.
- B. Defer roll-up summary fields calculation during data migration.
- C. Perform Batch job in parallel mode and reduce Batch size
- D. Perform Batch job in serial mode and reduce batch size
正解：C
質問 # 124
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. Add Notes and Attachments Related List to page Layout in Lighting Experience.
- B. Manually upload Attachments in Lighting Experience.
- C. Manually upload Notes in Lighting Experience.
- D. Migrate Notes and Attachment to Enhanced Notes and Files a migration tool
正解：D
解説：
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.
質問 # 125
Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system. How should an Architect design the data migration solution to meet this requirement?
- A. Write an Apex trigger on the Contact object, before insert event to set the original value in a standard CreatedDate field.
- B. Enable "Set Audit Fields" and assign the permission to the user loading the data for the duration of the migration.
- C. Create a new field on Contact object to capture the Created Date. Hide the standard CreatedDate field using Field -Level Security.
- D. After the data is migrated, perform an update on all records to set the original date in a standard CreatedDate field.
正解：B
質問 # 126
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 the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.
- B. Export legacy data into CSV files and leverage data loader to load data into Salesforce.
- C. Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.
- D. Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.
正解：A
質問 # 127
Universal Containers (UC) loads bulk leads and campaigns from third-party lead aggregators on a weekly and monthly basis. The expected lead record volume is 500K records per week, and the expected campaign records volume is 10K campaigns per week. After the upload, Lead records are shared with various sales agents via sharing rules and added as Campaign members via Apex triggers on Lead creation. UC agents work on leads for 6 months, but want to keep the records in the system for at least 1 year for reference. Compliance requires them to be stored for a minimum of 3 years. After that, data can be deleted. What statement is true with respect to a data archiving strategy for UC?
- A. UC can leverage recycle bin capability, which guarantees record storage for 15 days after deletion.
- B. UC can leverage a "tier"-based approach to classify the record storage need.
- C. UC can store long-term lead records in custom storage objects to avoid counting against storage limits.
- D. UC can leverage the Salesforce Data Backup and Recovery feature for data archival needs.
正解：B
質問 # 128
UC has multiple SF orgs that are distributed across regional branches. Each branch stores local customer data inside its org's Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs.
UC has an initiative to create a 360-degree view of the customer, as UC would like to see Account and Contact data from all orgs in one place.
What should a data architect suggest to achieve this 360-degree view of the customer?
- A. Use an ETL tool to migrate gap Accounts and Contacts into each org.
- B. Consolidate the data from each org into a centralized datastore
- C. Use Salesforce Connect's cross-org adapter.
- D. Build a bidirectional integration between all orgs.
正解：B
質問 # 129
UC is using SF CRM. UC sales managers are complaining about data quality and would like to monitor and measure data quality.
Which 2 solutions should a data architect recommend to monitor and measure data quality?
Choose 2 answers.
- A. Export data and check for data completeness outside of Salesforce.
- B. Review data quality reports and dashboards.
- C. Use custom objects and fields to identify issues.
- D. Install and run data quality analysis dashboard app
正解：B、D
解説：
Reviewing data quality reports and dashboards and installing and running data quality analysis dashboard app are two solutions that can help monitor and measure data quality. Data quality reports and dashboards can provide insights into the completeness, accuracy, and consistency of the data. Data quality analysis dashboard app is a free app from AppExchange that can help analyze and improve data quality by identifying duplicate, incomplete, or inaccurate records.
質問 # 130
Cloud Kicks has the following requirements:
- Data needs to be sent from Salesforce to an external system to generate invoices from their Order Management System (OMS).
- A Salesforce administrator must be able to customize which fields will be sent to the external system without changing code.
What are two approaches for fulfilling these requirements? (Choose two.)
- A. Enable the field -level security permissions for the fields to send.
- B. An Outbound Message to determine which fields to send to the OMS.
- C. A set<sobjectFieldset> to determine which fields to send in an HTTP callout.
- D. A Field Set that determines which fields to send in an HTTP callout.
正解：B、D
質問 # 131
Northern trail Outfitters (NTO) uses Sales Cloud and service Cloud to manage sales and support processes. Some of NTOs team are complaining they see new fields on their page unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesforce.
Which governance measure should a data architect recommend to solve this issue?
- A. Add description fields to explain why the field is used, and mark the field as required.
- B. Create and manage a data dictionary and ups a governance process for changes made to common objects.
- C. Create validation rules with error messages to explain why the fields is used
- D. Create reports to identify which users are leaving blank, and use external data sources o agreement the missing data.
正解：B
解説：
To solve the issue of lack of governance in making changes to Salesforce, a data architect should recommend creating and managing a data dictionary and setting up a governance process for changes made to common objects. A data dictionary is a document that defines the metadata, structure, and relationship of each object and field in Salesforce. A governance process is a set of rules and procedures that govern how changes are proposed, reviewed, approved, and deployed in Salesforce. These measures will help NTO to maintain consistency, quality, and clarity of their data model and avoid confusion and errors among users. Option A is incorrect because adding description fields to explain why the field is used, and marking the field as required will not prevent unauthorized or unnecessary changes to Salesforce. Option C is incorrect because creating reports to identify which users are leaving blank, and using external data sources to augment the missing data will not address the root cause of the issue, which is the lack of governance in making changes to Salesforce. Option D is incorrect because creating validation rules with error messages to explain why the fields are used will not stop users from seeing new fields on their page that they are unsure of.
質問 # 132
UC developers have created a new lightning component that uses an Apex controller using a SOQL query to populate a custom list view. Users are complaining that the component often fails to load and returns a time-out error.
What tool should a data architect use to identify why the query is taking too long?
- A. Use salesforce's query optimizer to analyze the query in the developer console.
- B. Open a ticket with salesforce support to retrieve transaction logs to e analyzed for processing time.
- C. Enable and use the query plan tool in the developer console.
- D. Use Splunk to query the system logs looking for transaction time and CPU usage.
正解：C
解説：
According to the Salesforce documentation1, the query plan tool is a tool that can be enabled and used in the developer console to analyze the performance of a SOQL query. The query plan tool shows the cost, cardinality, sObject type, and relative cost of each query plan that Salesforce considers for a query. The relative cost indicates how expensive a query plan is compared to the Force.com query optimizer threshold. A query plan with a relative cost above 1.0 is likely to cause a time-out error.
To identify why the query is taking too long, a data architect should use the query plan tool in the developer console (option B). This way, the data architect can see which query plan is chosen by Salesforce and how it affects the performance of the query. The data architect can also use the query plan tool to optimize the query by adding indexes, filters, or limits to reduce the cost and improve the efficiency of the query.
Using Splunk to query the system logs looking for transaction time and CPU usage (option A) is not a good solution, as it can be complex, costly, and difficult to integrate with Salesforce. It may also not provide enough information or insights to identify and optimize the query performance. Using Salesforce's query optimizer to analyze the query in the developer console (option C) is also not a good solution, as it is not a separate tool that can be used in the developer console. The query optimizer is a feature that runs automatically when a SOQL query is executed and chooses the best query plan based on various factors2. Opening a ticket with Salesforce support to retrieve transaction logs to be analyzed for processing time (option D) is also not a good solution, as it can be time-consuming, dependent, and inefficient. It may also not provide enough information or insights to identify and optimize the query performance.
質問 # 133
Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage.
Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?
- A. Number of characters in report query.
- B. Number of queries running at a time.
- C. Number of records returned by report query.
- D. Number of joins used in report query.
正解：C、D
質問 # 134
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. Load all individual consumers as Account records and avoid using the Contact object.
- B. Create one Account and load individual consumers as Contacts linked to that one Account.
- C. Create a Custom Object Individual Consumer c to load all individual consumers.
- D. Load one Account record and one Contact record for each individual consumer.
正解：B
解説：
According to the exam guide, one of the objectives is to "describe best practices for implementing a single-org strategy in a B2C scenario"1. This implies that option D is the best practice for loading individual consumers as contacts in Salesforce. This approach avoids creating unnecessary accounts and reduces data duplication. Option C is not correct because it creates one account per contact, which increases data volume and complexity. Options A and B are not correct because they do not leverage the standard contact object, which provides native functionality and integration with other Salesforce features.
質問 # 135
UC has a classic encryption for Custom fields and is leveraging weekly data reports for data backups. During the data validation of exported data UC discovered that encrypted field values are still being exported as part of data exported. What should a data architect recommend to make sure decrypted values are exported during data export?
- A. Leverage Apex class to decrypt data before exporting it.
- B. Create another field to copy data from encrypted field and use this field in export
- C. Set a standard profile for Data Migration user, and assign view encrypted data
- D. Set up a custom profile for data migration user and assign view encrypted data.
正解：B
解説：
The best solution to make sure decrypted values are exported during data export is to create another field to copy data from encrypted field and use this field in export. This is because classic encryption does not support exporting decrypted values of encrypted fields. The view encrypted data permission only allows users to view decrypted values in the user interface, but not in reports or data exports. Therefore, a workaround is to create a formula field or a workflow field update that copies the value of the encrypted field to another field, and use that field for data export. However, this solution has some drawbacks, such as exposing sensitive data in plain text and consuming extra storage space. A better solution would be to use Shield Platform Encryption, which supports exporting decrypted values of encrypted fields with the Export Encrypted Data permission
質問 # 136
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. Lookup field on VTOTime_c to Project_c with formula filed on Project__ c showing Sum of hours from VTOTime__c records.
- B. Master Detail field on Project _c to VTOTime _c showing a list of VTOTime_c Records in a related list.
- C. Lookup Field on Project_c to VTOTime_c displaying a list of VTOTime__c in a related list.
- D. Master Detail Field on VTOTime_ c to Project_c with rollup summary field on Project __c showing sum of hours from VTOTime_c records.
正解：D
質問 # 137
Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used 20 Venues. Which two things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers
- A. Standard list view in -line editing.
- B. Bulk API limitations on picklist fields.
- C. Limitations on master -detail relationships.
- D. Org data storage limitations.
正解：A、B
質問 # 138
Which two statements are accurate with respect to performance testing a Force.com application?
- A. All Force.com applications must be performance tested in a sandbox as well as production.
- B. Applications with highly customized code or large volumes should be performance tested.
- C. Application performance benchmarked in a sandbox can also be expected in production.
- D. A performance test plan must be created and submitted to Salesforce customer support.
正解：B、D
質問 # 139
......
最新のData-Architect学習ガイド2024年最新の- 提供するのはテストエンジンとPDF：https://www.goshiken.com/Salesforce/Data-Architect-mondaishu.html
最新版を今すぐ試そうData-Architect練習テスト問題解答：https://drive.google.com/open?id=1DvAFGJUwTEkdTvHueMVgWuy12j6If9D-