[2023年12月02日] トップクラスのData-Architect練習試験問題
実際問題を使ってData-Architect無料問題集サンプル問題と練習テストエンジン
質問 # 47
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. Create reports to identify which users are leaving blank, and use external data sources o agreement the missing data.
- B. Add description fields to explain why the field is used, and mark the field as required.
- C. Create validation rules with error messages to explain why the fields is used
- D. Create and manage a data dictionary and ups a governance process for changes made to common objects.
正解：D
質問 # 48
Northern Trail Outfitters <NTO> is streaming IoT data from connected devices to a cloud database. Every 24 hours. 100,000 records are generated.
NIO employees will need to see these lol records within Salesforce and generate weekly reports on it. Developers may also need to write programmatic logic to aggregate the records and incorporate them into workflows.
Which data pattern will allow a data architect to satisfy these requirements, while also keeping limits in mind?
- A. Bidirectional integration
- B. Virtualization
- C. Unidirectional integration
- D. Persistence
正解：B
質問 # 49
Universal Containers (UC) wants to capture information on how data entities are stored within the different applications and systems used within the company. For that purpose, the architecture team decided to create a data dictionary covering the main business domains within UC. Which two common techniques are used building a data dictionary to store information on how business entities are defined?
- A. Use an entity relationship diagram.
- B. Use the Salesforce Metadata API.
- C. Use a data definition language.
- D. Use Salesforce Object Query Language.
正解：A、B
解説：
A data dictionary is a document that describes the structure, format, and meaning of data entities and attributes. A common technique to build a data dictionary is to use an entity relationship diagram (ERD), which shows the logical relationships between objects and fields in a graphical way. Another technique is to use the Salesforce Metadata API, which allows you to retrieve and deploy the metadata that defines your Salesforce org
質問 # 50
Universal Containers has defined a new Data Quality Plan for their Salesforce data and wants to know how they can enforce it throughout the organization. Which two approaches should an architect recommend to enforce this new plan?
Choose 2 answers
- A. Store all data in an external system and set up an integration to Salesforce for view -only access.
- B. Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.
- C. Schedule reports that will automatically catch duplicates and merge or delete the records every week.
- D. Use Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes.
正解：B、D
解説：
Scheduling a weekly dashboard displaying records that are missing information to be sent to managers for review and using Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes are two approaches that an architect should recommend to enforce the new Data Quality Plan for UC's Salesforce data. Scheduling a weekly dashboard can provide a regular and visual way of monitoring the data quality and identifying any gaps or issues that need to be addressed by the managers or users. Using Workflow, Validation Rules, and Apex can provide various ways of enforcing data quality standards and business logic by automating actions, displaying error messages, or executing custom code when users create or edit records. The other options are not suitable or helpful for enforcing the Data Quality Plan, as they would either not provide real-time feedback, not prevent data quality issues, or not leverage the capabilities of Salesforce
質問 # 51
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. Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.
- C. Export legacy data into CSV files and leverage data loader to load data into Salesforce.
- D. Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.
正解：A
解説：
According to this article, migrating the legacy data leveraging an ETL tool to transform data types and load data into Salesforce can be a way to ensure successful data migrations. The article states that ETL tools can help with data cleansing, mapping, transformation, and loading, and that they can handle different data types and formats. The article also provides some best practices for data migration, such as identifying the data to migrate, creating templates for the data, preparing the destination org, and validating the data.
質問 # 52
Universal Containers (UC) is expecting to have nearly 5 million shipments records in its Salesforce org. Each shipment record has up to 10 child shipment item records. The Shipment custom object has an Organization-wide Default (OWD) sharing model set to Private and the Shipment Item custom object has a Master-Detail relationship to Shipment. There are 25 sharing rules set on the Shipment custom object, which allow shipment records to be shared to each of UC's 25 business areas around the globe. These sharing rules use public groups, one for each business area plus a number of groups for management and support roles. UC has a high turnover of Sales Reps and often needs to move Sales Reps between business areas in order to meet local demand. What feature would ensure that performance, when moving Sales Reps between regions, remains adequate while meeting existing requirements?
- A. Implement data archiving for old Shipment records.
- B. Contact Salesforce to create Skinny tables on Shipment.
- C. Contact Salesforce to enable Defer Sharing Rules
- D. Configure shipment OWD to Public Read/Write.
正解：C
解説：
Contacting Salesforce to enable Defer Sharing Rules is the feature that would ensure that performance, when moving Sales Reps between regions, remains adequate while meeting existing requirements. Defer Sharing Rules allows you to defer sharing rule recalculation when you make changes to public groups or roles that are used in sharing rules. This can improve performance and avoid locking issues when you move users between groups or roles2. Implementing data archiving for old Shipment records will not help with the performance issue related to sharing rules. Contacting Salesforce to create Skinny tables on Shipment will not help with the performance issue related to sharing rules. Configuring shipment OWD to Public Read/Write will not meet the existing requirements of having a Private sharing model.
質問 # 53
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. Create a skinny table to represent account and contact objects.
- B. Add custom indexes on frequently searched account and contact objects fields
- C. Load only the data that the users is permitted to access
- D. Limit data loading to the 2000 most recently created records.
正解：B
質問 # 54
Universal Container (US) is replacing a home grown CRM solution with Salesforce, UC has decided to migrate operational (Open and active) records to Salesforce, while keeping historical records in legacy system, UC would like historical records to be available in Salesforce on an as needed basis.
Which solution should a data architect recommend to meet business requirement?
- A. Leverage real-time integration to pull records into Salesforce.
- B. Build a chair solution to go the legacy system and display records.
- C. Bring all data Salesforce, and delete it after a year.
- D. Leverage mashup to display historical records in Salesforce.
正解：D
質問 # 55
A customer wants to maintain geographic location information including latitude and longitude in a custom object. What would a data architect recommend to satisfy this requirement?
- A. Create custom fields to maintain latitude and longitude information
- B. Create formula fields with geolocation function for this requirement.
- C. Create a geolocation custom field to maintain this requirement
- D. Recommend app exchange packages to support this requirement.
正解：C
解説：
The correct answer is C, create a geolocation custom field to maintain this requirement. A geolocation custom field is a compound field that can store both latitude and longitude information in a single field. It also supports geolocation functions and distance calculations. Creating formula fields or custom fields for latitude and longitude separately would be inefficient and redundant. Recommending app exchange packages would not be a direct solution to the requirement.
質問 # 56
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?
- A. Use scheduled batch Apex to copy aggregate information into a custom object and delete the original records.
- B. Use Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records.
- C. Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.
- D. Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.
正解：A、C
質問 # 57
UC has millions of case records with case history and SLA dat
a. 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. Use a custom Big object to store archived case data.
- B. Archive Case data using Salesforce Archiving process
- C. Use a custom object to store archived case data.
- D. Purchase more data storage to support case object
正解：A
質問 # 58
A customer wants to maintain geographic location information including latitude and longitude in a custom object. What would a data architect recommend to satisfy this requirement?
- A. Create a geolocation custom field to maintain this requirement
- B. Create formula fields with geolocation function for this requirement.
- C. Recommend app exchange packages to support this requirement.
- D. Create custom fields to maintain latitude and longitude information
正解：D
質問 # 59
Universal Containers has provided a web order form for its customer and has noticed invalid data coming in on orders.
What should be used to mitigate this problem?
- A. Apex Trigger
- B. Formatted Fields
- C. Validation Rules
- D. Work Flow Rules
正解：C
解説：
Using validation rules to mitigate this problem is the best option. Validation rules can help you prevent invalid data from being entered in your web order form. You can use validation rules to check for data quality, format, range, or consistency. For example, you can use validation rules to ensure that the order quantity is positive, the product code is valid, or the shipping address is complete.
質問 # 60
NTO uses salesforce to manage relationships and track sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining 10 minutes to run and sometimes failed to load, throwing a time out error.
Which 3 options should help improve the dashboard performance?
Choose 3 answers:
- A. De-normalize the data by reducing the number of joins.
- B. Reduce the amount of data queried by archiving unused opportunity records.
- C. Use selective queries to reduce the amount of data being returned.
- D. Run the dashboard for CEO and send it via email.
- E. Remove widgets from the dashboard to reduce the number of graphics loaded.
正解：A、B、C
解説：
To improve the dashboard performance, the data architect should use selective queries to reduce the amount of data being returned, de-normalize the data by reducing the number of joins, and reduce the amount of data queried by archiving unused opportunity records. These options will help optimize the query performance, reduce the query complexity, and free up storage space. Option C is incorrect because removing widgets from the dashboard to reduce the number of graphics loaded will not affect the dashboard performance significantly, and may reduce the usability and functionality of the dashboard. Option D is incorrect because running the dashboard for CEO and sending it via email will not improve the dashboard performance, but rather shift the burden to another user.
質問 # 61
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. Custom report types cannot contain Opportunity data.
- C. A report cannot contain data from Accounts and Contacts.
- D. Salesforce does not support Orders or Order Line Items.
正解：A
質問 # 62
Cloud Kicks has the following requirements:
* Their Shipment custom object must always relate to a Product, a Sender, and a Receiver (all separate custom objects).
* If a Shipment is currently associated with a Product, Sender, or Receiver, deletion of those records should not be allowed.
* Each custom object must have separate sharing models.
What should an Architect do to fulfill these requirements?
- A. Create a required Lookup relationship to each of the three parent records.
- B. Associate the Shipment to each parent record by using a VLOOKUP formula field.
- C. Create two Master-Detail and one Lookup relationship to the parent records.
- D. Create a Master-Detail relationship to each of the three parent records.
正解：A
解説：
A required Lookup relationship ensures that the Shipment record must have a value for each of the three parent records, and also prevents the deletion of those parent records if they are referenced by a Shipment record. A Master-Detail relationship would not allow separate sharing models for each custom object, and a VLOOKUP formula field would not enforce the relationship or prevent deletion
質問 # 63
Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report will regularly timeout.
What is the fastest and most effective way for a data architect to solve the time-out issue?
- A. Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on It.
- B. Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.
- C. Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.
- D. Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.
正解：C
質問 # 64
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. Master Detail field on Project _c to VTOTime _c showing a list of VTOTime_c Records in a related list.
- D. Lookup Field on Project_c to VTOTime_c displaying a list of VTOTime__c in a related list.
正解：A
質問 # 65
Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the possibility of adding ad-hoc filters while on the move. What is a recommended solution for building data exploration dashboards in Salesforce?
- A. Create a Dashboard in an external reporting tool, export data to the tool, and add link to the dashboard in Salesforce.
- B. Create a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lenses and drill down.
- C. Create a standard Salesforce Dashboard and connect it to reports with the appropriate filters.
- D. Create a Dashboard in an external reporting tool, export data to the tool, and embed the dashboard in Salesforce using the Canval toolkit.
正解：B
質問 # 66
Universal Containers is planning out their archiving and purging plans going forward for their custom objects Topic__c and Comment__c. Several options are being considered, including analytics snapshots, offsite storage, scheduled purges, etc. Which three questions should be considered when designing an appropriate archiving strategy?
- A. Which profiles and users currently have access to these custom object records?
- B. If reporting is necessary, can the information be aggregated into fewer, summary records?
- C. Are there any regulatory restrictions that will influence the archiving and purging plans?
- D. How many fields are defined on the custom objects that need to be archived?
- E. Will the data being archived need to be reported on or accessed in any way in the future?
正解：B、C、E
解説：
The three questions that should be considered when designing an appropriate archiving strategy are: If reporting is necessary, can the information be aggregated into fewer, summary records? Will the data being archived need to be reported on or accessed in any way in the future? Are there any regulatory restrictions that will influence the archiving and purging plans? These questions are important because they help determine the scope, frequency, and method of archiving and purging data from Salesforce. For example, if reporting is necessary, then summary records or analytics snapshots can be used to store aggregated data and reduce the number of records that need to be archived1. If the data being archived needs to be accessed in the future, then offsite storage or external objects can be used to retain the data and make it available on demand2. If there are any regulatory restrictions, such as GDPR or HIPAA, then the archiving and purging plans need to comply with them and ensure data security and privacy
質問 # 67
A company wants to document the data architecture of a Salesforce organization.
What are two valid metadata types that should be included? (Choose two.)
- A. Document
- B. CustomField
- C. SecuritySettings
- D. RecordType
正解：B、D
解説：
Option A is correct because RecordType is a valid metadata type that should be included in documenting the data architecture of a Salesforce organization1. RecordType defines different business processes, picklist values, and page layouts for different users2. Option C is correct because CustomField is another valid metadata type that should be included in documenting the data architecture of a Salesforce organization1. CustomField defines custom attributes for standard or custom objects3. Option B is not correct because Document is not a valid metadata type, but a standard object that stores documents in folders4. Option D is not correct because SecuritySettings is not a valid metadata type, but a setup menu that allows administrators to configure various security features such as password policies, network access, session settings, etc.
質問 # 68
Northern Trail Outfitters needs to implement an archive solution for Salesforce dat a. This archive solution needs to help NTO do the following:
1. Remove outdated Information not required on a day-to-day basis.
2. Improve Salesforce performance.
Which solution should be used to meet these requirements?
- A. Identify a location to store archived data, and move data to the location using a time-based workflow.
- B. Identify a location to store archived data and use scheduled batch jobs to migrate and purge the aged data on a nightly basis,
- C. Create a full copy sandbox, and use it as a source for retaining archived data.
- D. Use a formula field that shows true when a record reaches a defined age and use that field to run a report and export a report into SharePoint.
正解：B
解説：
Identifying a location to store archived data and using scheduled batch jobs to migrate and purge the aged data on a nightly basis can be a way to meet the requirements for an archive solution. The article provides a use case of how to use Heroku Connect, Postgres, and Salesforce Connect to archive old data, free up space in the org, and still retain the option to unarchive the data if needed. The article also explains how this solution can improve Salesforce performance and meet data retention policies.
質問 # 69
Northern trail Outfitters (NTO) runs its entire out of an enterprise data warehouse (EDW), NTD's sales team starting to use Salesforce after a recent implementation, but currently lacks data required to advanced and opportunity to the next stage.
NTO's management has research Salesforce Connect and would like to use It to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.
What should a data architect consider before implementing Salesforce Connect for reporting?
- A. Maximum external objects per org
- B. OData callout limits per day
- C. Maximum number for records returned
- D. Maximum page size for server-driven paging
正解：B
解説：
According to the Salesforce Connect Reporting blog post, one of the considerations for using Salesforce Connect for reporting is the OData callout limits per day. The blog post states that "Salesforce Connect has a limit of 100,000 callouts per day. This limit is shared across all external data sources in your org. If you exceed this limit, you will receive an error message and no more callouts will be allowed until the next day." Therefore, a data architect should consider this limit before implementing Salesforce Connect for reporting.
質問 # 70
......
合格させるSalesforce Data-Architect試験問題でテスト復刻エンジンとPDF：https://jp.fast2test.com/Data-Architect-premium-file.html
2023年最新の実際に出ると確認されたSalesforce Data-Architect無料試験問題：https://drive.google.com/open?id=1GKCGxZaHpCMGqD2QlGhdopwkiSnuBRrA