Certified Data Architect v1.0 (Certified Data Architect)

Page:    1 / 8   
Total 120 questions

Northern Trail Outfitters (NTO) has a complex Salesforce org which has been developed over the past five years. Internal users are complaining about 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 three key factors should a data architect consider while defining data quality standards? (Choose three.)

  • A. Measure data timeliness and consistency.
  • B. Define key fields in a staging database for data cleansing.
  • C. Identify an extract, transform, load (ETL) tool for more complete data migrations.
  • D. Measure data completeness and accuracy.
  • E. Define data duplication standards and rules.


Answer : ADE

Universal Containers is implementing Sales Cloud for patient management and would like to encrypt sensitive patient records being stored in files.
Which solution should a data architect recommend to solve this requirement?

  • A. Implement a third-party AppExchange app to encrypt files.
  • B. Store files outside of Salesforce and access them in real time.
  • C. Use classic encryption to encrypt files.
  • D. Implement Shield Platform Encryption to encrypt files.


Answer : D

Northern Trail Outfitters (NTO) has one million customer records spanning 25 years. As part of its new Salesforce project, NTO would like to create a master data management strategy to help preserve the history and relevance of its customer data.
Which three activities will be required to identify a successful master data management strategy? (Choose three.)

  • A. Choose a business intelligence tool.
  • B. Install a data warehouse.
  • C. Create a data archive strategy.
  • D. Identify data to be replicated.
  • E. Define the system of record for critical data.


Answer : CDE

Universal Containers uses classic encryption for custom fields and Is leveraging weekly data export for data backups. During a validation process, UC discovered that encrypted field values are still being exported as part of the data export.
What should a data architect recommend to make sure decrypted values are exported during data export?

  • A. Set up a custom profile for the data migration user, and assign View Encrypted Data.
  • B. Set up a standard profile for the data migration user, and assign View Encrypted Data.
  • C. Create another field to copy data from the encrypted field, and use this field in export.
  • D. Leverage an Apex class to decrypt data before exporting it.


Answer : A

Northern Trail Outfitters (NTO) has multiple Salesforce orgs based on geographical regions (AMER, EMEA, APAC). NTO products are mastered in the AMER org and need to be created in the EMEA and APAC orgs after the products are approved.
Which two features should a data architect recommend to share records between Salesforce orgs? (Choose two.)

  • A. Federated Search
  • B. Salesforce 2 Salesforce
  • C. Change Data Capture (CDC)
  • D. Salesforce Connect


Answer : BC

A large healthcare provider wishes to use Salesforce to track patient care. The following actors are in Salesforce:
1. Payment providers: Organizations who pay for the care to patients.
2. Doctors: They provide care plans for patients and need to support multiple patients. They are provided access to patient information.
3. Patients: These are individuals who need care.
A data architect needs to map the actors to Salesforce objects.
What should be the optimal selection by the data architect?

  • A. Patients as Person Accounts, Payment providers as Accounts, and Doctors as Person Accounts
  • B. Patients as Person Accounts, Payment providers as Accounts, and Doctors as Contacts
  • C. Patients as Contacts, Payment providers as Accounts, and Doctors as Accounts
  • D. Patients as Accounts, Payment providers as Accounts, and Doctors as Person Accounts


Answer : A

Universal Containers (UC) has a variety of systems across its technology landscape, including Salesforce, legacy enterprise resource planning (ERP) applications, and homegrown CRM tools. UC has decided that they would like to consolidate all customer, opportunity, and order data into Salesforce as part of its master data management strategy.
What are the three key steps that a data architect should take when merging data from multiple systems into Salesforce? (Choose three.)

  • A. Work with stakeholders to define record and field survivorship rules.
  • B. Analyze each system's data model and perform gap analysis.
  • C. Utilize an ETL tool to migrate, transform, and deduplicate data.
  • D. Install a third-party AppExchange tool to handle the merger.
  • E. Create new fields to store additional values from all of the systems.


Answer : ABC

Northern Trail Outfitters (NTO) has multiple systems across its enterprise landscape, including Salesforce, with disparate versions of the customer record. In Salesforce. the customer is represented by the Contact object. NTO utilizes a master data management (MDM) solution with these attributes:
1. The MDM solution keeps track of the Customer Master with a Master Key.
2. The Master Key is a map to the record IDs from each external system that customer data is stored within.
3. The MDM solution provides deduplication features, so it acts as the Single Source of Truth.
How should a Data Architect implement the storage of the Master Key within Salesforce?

  • A. Create a custom object to store the Master Key with a lookup field to Contact.
  • B. Store the Master Key in Heroku Postgres and use Heroku Connect for synchronization.
  • C. Create an external object to store the Master Key with a lookup field to Contact.
  • D. Store the Master Key on the Contact object as an External ID field for referential integrity.


Answer : D

Northern Trail Outfitters (NTO) has decided to franchise its brand. Upon implementation 1,000 franchisees will be able to access NTO's product information and track large customer sales and opportunities through a portal. The franchisees will also be able to run monthly and quarterly sales reports and projections as well as view the reports in dashboards.
Which license does NTO need to provide these features to the franchisees?

  • A. Customer Community License
  • B. Lighting Platform License
  • C. Salesforce Sales Cloud License
  • D. Partner Community License


Answer : D

Universal Containers (UC) has built a B2C ecommerce site on Heroku that shares customer and order data with a Heroku Postgres database. UC is currently utilizing Postgres as the Single Source of Truth for both customers and orders. UC has asked a data architect to replicate this data into Salesforce so that Salesforce can now act as the System of Record.
What are the three considerations that a data architect should weigh before implementing this requirement? (Choose three.)

  • A. Ensure there is a tight relationship between order data and an enterprise resource planning (ERP) application.
  • B. Determine if the data is a driver of key processes implemented within Salesforce.
  • C. Consider whether the data is required for sales reports, dashboards, and KPIs.
  • D. Ensure the data is CRM-centric and able to populate standard or custom objects.
  • E. A selection of the tool required to replicate the data.


Answer : BDE

Universal Containers has millions of cases and are running out storage. Some user groups need to have access to historical cases for up to seven years.
Which two solutions should a data architect recommend in order to minimize performance and storage issues? (Choose two.)

  • A. Export data out of Salesforce and store in flat files on external system.
  • B. Leverage Salesforce Privacy Center to archive case data and view archived cases through an external object.
  • C. Create a custom object to store case history and run reports on it.
  • D. Leverage big objects to archive case data and Lightning components to show archived data.


Answer : BD

United Containers (UC) has released a new disaster recovery (DR) policy that states that cloud solutions need a business continuity plan in place separate from the cloud provider's built-in data recovery solution.
Which solution should a data architect use to comply with the DR policy?

  • A. Leverage a third-party tool that extracts Salesforce data/metadata, and stores the information in an external protected system.
  • B. Utilize an ETL tool to migrate data to an on-premise archival solution.
  • C. Leverage Salesforce weekly exports, and store data in flat files on a protected system.
  • D. Write a custom batch Job to extract data changes nightly, and store on an external protected system.


Answer : A

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. Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.
  • C. Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.
  • D. Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.


Answer : D

Northern Trail Outfitters (NTO) has outgrown its current Salesforce org and will be migrating to a new org shortly. As part of this process, NTO will be migrating all of its metadata and data. NTO's data model in the source org has a complex relationship hierarchy with several master-detail and lookup relationships across objects, which should be maintained in the target org.
Which three things should a data architect do to maintain the relationship hierarchy during migration? (Choose three.)

  • A. Redefine the master-detail relationship fields to lookup relationship fields in the target org.
  • B. Use Data Loader to export the data from the source org and then import/upsert into the target org in sequential order.
  • C. Keep the relationship fields populated with the source record IDs in the import file.
  • D. Replace source record IDs with new record IDs from the target org in the import file.
  • E. Create an external ID field for each object in the target org and map source record IDs to this field.


Answer : BDE

Universal Containers (UC) has millions of case records with case history and service level agreement data. UC's compliance team would like historical cases to be accessible for 10 years for audit purposes.
What solution should a data architect recommend?

  • A. Purchase more data storage to support the case object.
  • B. Use a custom big object to store archived case data.
  • C. Archive case data using a Salesforce Archival solution.
  • D. Use a custom object to store archived case data.


Answer : D

Page:    1 / 8   
Total 120 questions