Data-Architect無料問題集「Salesforce Certified Data Architect」

質問 1

Universal Containers (CU) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW.
What data extraction strategy should a data architect use for maximum performance?

（A）Use the Bulk API in parallel mode.

（B）Utilize PK Chunking with the Bulk API.

（C）Call the REST API in successive queries.

（D）Install a third-party AppExchange tool.

正解：B 解答を投票する

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

質問 2

Universal Container is Implementing salesforce and needs to migrate data from two legacy systems. UC would like to clean and duplicate data before migrate to Salesforce.
Which solution should a data architect recommend a clean migration?

（A）Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.

（B）Define external IDs for an object, Insert data from one database, and use upsert for a second database

（C）Define external IDs for an object, migrate second database to first database, and load into Salesforce.

（D）Define duplicate rules in Salesforce, and load data into Salesforce from both databases.

正解：A 解答を投票する

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

質問 3

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）Migrate Notes and Attachment to Enhanced Notes and Files a migration tool

（C）Manually upload Attachments in Lighting Experience.

（D）Manually upload Notes in Lighting Experience.

正解：B 解答を投票する

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

質問 4

Northern Trail Outfitters needs to implement an archive solution for Salesforce data. 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）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）Identify a location to store archived data, and move data to the location using a time-based workflow.

（C）Identify a location to store archived data and use scheduled batch jobs to migrate and purge the aged data on a nightly basis,

（D）Create a full copy sandbox, and use it as a source for retaining archived data.

正解：C 解答を投票する

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

質問 5

A customer is facing locking issued when importing large data volumes of order records that are children in a master-detail relationship with the Account object. What is the recommended way to avoid locking issues during import?

（A）Change the relationship to Lookup and update the relationship to master-detail after import.

（B）Import Account records first followed by order records after sorting orders by AccountID.

（C）Import Order records and Account records separately and populate AccountID in orders using batch Apex.

（D）Import Account records first followed by order records after sorting order by OrderID.

正解：B 解答を投票する

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

質問 6

Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records. What should the architect recommend to reduce data load processing time?

（A）Delete all existing records, and then load all records together via the Insert operation.

（B）Load all records via the Upsert operation to determine new records vs. existing records.

（C）Load new records via the Insert operation and existing records via the Update operation.

（D）Load Contact records together using the Streaming API via the Upsert operation.

正解：C 解答を投票する

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

質問 7

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）Load data in external database and provide access to database to sales users.

（B）Define a standard mapping and train sales users to import opportunity data.

（C）Create a chatter group and upload all Excel files to the group.

（D）Use the Excel connector to Salesforce to sync data from individual Excel files.

正解：B 解答を投票する

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

質問 8

Northern Trail Outfitters (NTO) has the following systems:
Customer master-source of truth for customer information
Service cloud-customer support
Marketing cloud-marketing support
Enterprise data warehouse-business reporting
The customer data is duplicated across all these systems and are not kept in sync. Customers are also complaining that they get repeated marketing emails and have to call into update their information.
NTO is planning to implement master data management (MDM) solution across the enterprise.
Which three data will an MDM tool solve?
Choose 3 answers

（A）Data completeness

（B）Data loss and recovery

（C）Data duplication

（D）Data accuracy and quality

（E）Data standardization

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

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

質問 9

NTO processes orders from its website via an order management system (OMS). The OMS stores over 2 million historical records and is currently not integrated with SF. The Sales team at NTO using Sales cloud and would like visibility into related customer orders yet they do not want to persist millions of records directly in Salesforce. NTO has asked the data architect to evaluate SF connect and the concept of data verification. Which 3 considerations are needed prior to a SF Connect implementation?
Choose 3 answers:

（A）Develop an object relationship strategy.

（B）Identify the external tables to sync into external objects

（C）Configure a middleware tool to poll external table data

（D）Assess whether the external data source is reachable via an ODATA endpoint.

（E）Create a 2nd system Admin user for authentication to the external source.

正解：A、B、D 解答を投票する

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

質問 10

Ursa Major Solar has defined a new Data Quality Plan for their Salesforce data.
Which two approaches should an Architect recommend to enforce the plan throughout the organization?
(Choose two.)

（A）Enforce critical business processes by using Workflow, Validation Rules, and Apex code.

（B）Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

（C）Ensure all data is stored in an external system and set up an integration to Salesforce for view-only access.

（D）Schedule reports that will automatically catch duplicates and merge or delete the records every week.

正解：A、B 解答を投票する

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

質問 11

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）Perform Batch job in parallel mode and reduce Batch size

（B）Leverage data loader platform API to load data.

（C）Perform Batch job in serial mode and reduce batch size

（D）Defer roll-up summary fields calculation during data migration.

正解：C 解答を投票する

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

質問 12

Universal Containers (UC) is going thought major reorganization of their sales team. This would require changes to a large a number of group members and sharing rules. UCs administrator is concerned about long processing time and failure during the process.
What should a Data architect implement to make changes efficiently?

（A）Enable Defer Sharing Calculation prior to making sharing rule changes.

（B）Delete old sharing rules and build new sharing rules

（C）Log a case with salesforce to make sharing rule changes.

（D）Log out all users and make changes to sharing rules.

正解：A 解答を投票する

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

質問 13

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）Contact Salesforce to enable Defer Sharing Rules

（B）Implement data archiving for old Shipment records.

（C）Configure shipment OWD to Public Read/Write.

（D）Contact Salesforce to create Skinny tables on Shipment.

正解：A 解答を投票する

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

質問 14

Universal Containers has successfully migrated 50 million records into five different objects multiple times in a full copy sandbox. The Integration Engineer wants to re-run the test again a month before it goes live into Production. What is the recommended approach to re-run the test?

（A）Refresh the full copy sandbox and re-run the data migration test.

（B）Truncate all 5 objects and hard delete before running the migration test.

（C）Truncate all 5 objects quickly and re-run the data migration test.

（D）Hard delete all 5 objects' data and re-run the data migration test.

正解：A 解答を投票する

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

質問 15

Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following:
- Accounts
- Contacts
- Opportunities
- Orders
- Order Line Items
Which issue will an architect have when implemented this in Salesforce?

（A）Salesforce does NOT allow more than four objects in a single report type.

（B）Salesforce does NOT support Orders or Order Line Items.

（C）Custom report types CANNOT contain Opportunity data.

（D）A report CANNOT contain data from Accounts and Contacts.

正解：A 解答を投票する

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

質問 16

All accounts and opportunities are created in Salesforce. Salesforce is integrated with three systems:
* An ERP system feeds order data into Salesforce and updates both Account and Opportunity records.
* An accounting system feeds invoice data into Salesforce and updates both Account and Opportunity records.
* A commission system feeds commission data into Salesforce and updates both Account and Opportunity records.
How should the architect determine which of these systems is the system of record?

（A）Whatever system updates the attribute or object should be the system of record for that field or object.

（B）Account and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.

（C）Whatever integration data flow runs last will, by default, determine which system is the system of record.

（D）Data flows should be reviewed with the business users to determine the system of record per object or field.

正解：D 解答を投票する

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

質問 17

A large telecommunication provider that provides internet services to both residence and business has the following attributes:
A customer who purchases its services for their home will be created as an Account in Salesforce.
Individuals within the same house address will be created as Contact in Salesforce.
Businesses are created as Accounts in Salesforce.
Some of the customers have both services at their home and business.
What should a data architect recommend for a single view of these customers without creating multiple customer records?

（A）Customers are created as Person Accounts and related to Business and Residential Accounts using the Account Contact relationship.

（B）Customer are created as individual objects and relate with Accounts for Business and Residence accounts.

（C）Costumers are created as Accounts for Residence Account and use Parent Account to relate Business Account.

（D）Customers are created as Contacts and related to Business and Residential Accounts using the Account Contact Relationships.

正解：A 解答を投票する

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

質問 18

DreamHouse Realty has a data model as shown in the image. The Project object has a private sharing model, and it has Roll-Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project.
There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.

What should the Architect consider in this situation?

（A）Load all data using external IDs to link to parent records.

（B）Calculate summary values instead of Roll-Up by using workflow.

（C）Calculate summary values instead of Roll-Up by using triggers.

（D）Load all data after deferring sharing calculations.

正解：D 解答を投票する

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

質問 19

UC is trying to switch from legacy CRM to salesforce and wants to keep legacy CRM and salesforce in place till all the functionality is deployed in salesforce. The want to keep data in synch b/w Salesforce, legacy CRM and SAP. What is the recommendation.

（A）Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce

（B）Integrate legacy CRM to salesforce and keep data in synch till new functionality is in place

（C）Suggest MDM solution and link MDM to salesforce and SAP

（D）Do not integrate legacy CRM to Salesforce, but integrate salesforce to SAP

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

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

質問 20

UC has been using SF for 10 years. Lately, users have noticed, that the pages load slowly when viewing Customer and Account list view.
To mitigate, UC will implement a data archive strategy to reduce the amount of data actively loaded.
Which 2 tasks are required to define the strategy? Choose 2 answers:

（A）Identify the recovery point objective.

（B）Identify the data retention requirements

（C）Identify how the archive data will be accessed and used.

（D）Identify the recovery time objective.

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

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

Data-Architect 無料問題集「Salesforce Certified Data Architect」

弊社を連絡する

関連リンク

トップ試験