Best Data-Architect Exam Dumps for the Preparation of Latest Exam Questions
Data-Architect Actual Questions 100% Same Braindumps with Actual Exam!
Salesforce Certified Data Architect exam is a challenging and comprehensive test that evaluates a candidate's expertise in various areas of data architecture. Data-Architect exam covers topics such as data modeling, data integration, data governance, data security, data migration, and data quality. Data-Architect exam consists of 60 multiple-choice questions and has a duration of 120 minutes. A passing score of 70% or higher is required to obtain the certification.
NEW QUESTION # 110
Universal Containers (UC) is migrating from an on-premise homegrown customer relationship management (CRM) system- During analysis, UC users highlight a pain point that there are multiple versions of many customers.
What should the data architect do for a successful migration to mitigate the pain point?
- A. Hire an intern manually de-duplicate the records after migrating to Salesforce.
- B. Store the data in a staging database, and de-duplicate identical records.
- C. Migrate the data as is, and use Salesforce's de-duplicating feature.
- D. Have the users manually clean the data in the old system prior to migration.
Answer: B
NEW QUESTION # 111
Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise -wide data governance. Which two roles are appropriate as members of this team? Choose 2 answers
- A. Analytics/BI Owners
- B. Salesforce Administrators
- C. Data Domain Stewards
- D. Operational Data Users
Answer: A,C
NEW QUESTION # 112
Universal Containers would like to remove data silos and connect their legacy CRM together with their ERP and with Salesforce. Most of their sales team has already migrated to Salesforce for daily use, although a few users are still on the old CRM until some functionality they require is completed. Which two techniques should be used for smooth interoperability now and in the future.
- A. Do not connect Salesforce and the legacy CRM to each other during this transition period, but do allow both to interact with the ERP.
- B. Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.
- C. Replicate ongoing changes in the legacy CRM to Salesforce to facilitate a smooth transition when the legacy CRM is eventually retired.
- D. Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.
Answer: B,D
Explanation:
Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce. This is a good technique to ensure data consistency and avoid conflicts between the two systems. Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields. This is another good technique to define the data governance and stewardship policies and processes for managing data quality and integrity across multiple systems
NEW QUESTION # 113
A customer is operating in a highly reputated industry and is planning to implement SF. The customer information maintained in SF, includes the following:
Personally, identifiable information (PII)
IP restrictions on profiles organized by Geographic location
Financial records that need to be private and accessible only by the assigned Sales associate.
User should not be allowed to export information from Salesforce.
Enterprise security has mandate access to be restricted to users within a specific geography and detail monitoring of user activity. Which 3 Salesforce shield capabilities should a data architect recommend? Choose
3 answers:
- A. Transaction security policies to prevent export of SF Data.
- B. Prevent Sales users access to customer PII information
- C. Restrict access to SF from users outside specific geography
- D. Event monitoring to monitor all user activities
- E. Encrypt Sensitive Customer information maintained in SF.
Answer: A,C,E
Explanation:
The best Salesforce Shield capabilities for the customer are to restrict access to SF from users outside specific geography, implement transaction security policies to prevent export of SF data, and encrypt sensitive customer information maintained in SF. Salesforce Shield is a set of security features that help protect enterprise data on the Salesforce platform. It includes three components: Event Monitoring, Platform Encryption, and Field Audit Trail. Restricting access to SF from users outside specific geography can be done using network-based security features, such as IP whitelisting or VPN. Transaction security policies can be used to define actions or notifications based on user behavior patterns, such as exporting data or logging in from an unknown device. Platform Encryption can be used to encrypt data at rest using a tenant secret key that is controlled by the customer.
NEW QUESTION # 114
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. Virtualization
- B. Persistence
- C. Bidirectional integration
- D. Unidirectional integration
Answer: A
NEW QUESTION # 115
DreamHouse Realty has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout.
DreamHouse Realty has noticed that many of the records coming from the external system are missing data in this field.
The Architect needs to ensure this field always contains data coming from the source system.
Which two approaches should the Architect take? Choose 2 answers
- A. Mark the field required in setup at the field level.
- B. Create a Workflow to default a value into this field.
- C. Blame the customer's external system for bad data.
- D. Set up a Validation Rule to prevent blank values.
Answer: A,D
Explanation:
Setting up a Validation Rule to prevent blank values and marking the field required in setup at the field level are two approaches that the Architect should take to ensure that the field always contains data coming from the source system. A Validation Rule can display an error message when a record is created or edited with a blank value for the field, and prevent it from being saved. Marking the field required in setup at the field level can enforce the requirement for all records, regardless of the page layout or the source system. The other options are not effective or recommended for ensuring data quality, as they would either not prevent blank values, not apply to all records, or not address the root cause of the problem
NEW QUESTION # 116
Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ""key"" fields which are important to their sales reps.
What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency?
(Choose two.)
- A. Run a report which shows the last time the key fields were updated.
- B. Run a process that can fill in default values for blank fields.
- C. Run one report per key field, grouped by that field, to understand its data variability.
- D. Run a report that shows the percentage of blanks for the important fields.
Answer: A,D
Explanation:
Running a report that shows the last time the key fields were updated can help Get Cloudy Consulting identify stale or outdated data and prioritize data cleansing activities. Running a report that shows the percentage of blanks for the important fields can help Get Cloudy Consulting measure the completeness of their data and identify gaps or missing value
NEW QUESTION # 117
Universal Container (UC) stores 10 million rows of inventory data in a cloud database, As part of creating a connected experience in Salesforce, UC would like to this inventory data to Sales Cloud without a import. UC has asked its data architect to determine if Salesforce Connect is needed.
Which three consideration should the data architect make when evaluating the need for Salesforce Connect?
- A. You have a large amount of data that you don't want to copy into your Salesforce org.
- B. You need to small amounts of external data at any one time.
- C. You have a large amount of data and would like to copy subsets of it into Salesforce.
- D. You want real-time access to the latest data, from other systems.
- E. You need to expose data via a virtual private connection.
Answer: A,B,D
Explanation:
The correct answer is A, D, and E. The data architect should consider these three factors when evaluating the need for Salesforce Connect: You want real-time access to the latest data from other systems, you have a large amount of data that you don't want to copy into your Salesforce org, and you need to small amounts of external data at any one time. These factors indicate that Salesforce Connect is a suitable solution for creating a connected experience in Salesforce without importing inventory data from a cloud database. Salesforce Connect allows Salesforce to access external data via OData or custom adapters without storing it in Salesforce, which reduces storage costs and ensures data freshness. Salesforce Connect also supports pagination and caching to optimize performance when accessing small amounts of external data at any one time. Option B is incorrect because if you have a large amount of data and would like to copy subsets of it into Salesforce, you may not need Salesforce Connect but rather use other tools such as Data Loader or API integration. Option C is incorrect because if you need to expose data via a virtual private connection, you may not need Salesforce Connect but rather use other tools such as VPN or VPC peering.
NEW QUESTION # 118
Which two statements are accurate with respect to performance testing a Force.com application?
- A. Applications with highly customized code or large volumes should be performance tested.
- B. All Force.com applications must be performance tested in a sandbox as well as production.
- C. A performance test plan must be created and submitted to Salesforce customer support.
- D. Application performance benchmarked in a sandbox can also be expected in production.
Answer: A,C
NEW QUESTION # 119
DreamHouse Realty has 15 million records in the Order_c custom object. When running a bulk query, the query times out.
What should be considered to address this issue?
- A. Streaming API
- B. Metadata API
- C. PK Chunking
- D. Tooling API
Answer: C
Explanation:
PK Chunking is a feature of the Bulk API that allows splitting a large query into smaller batches based on the primary key of the object. This can improve the performance and avoid query timeouts when querying large data sets
NEW QUESTION # 120
Universal Containers (UC) is concerned about the accuracy of their Customer information in Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they have certified to be accurate. UC has over 20 million unique customer records in the trusted source and Salesforce. What should an Architect recommend to ensure the data in Salesforce is identical to the MDM?
- A. Extract the Salesforce data into Excel and manually compare this against the trusted source.
- B. Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.
- C. Leave the data in Salesforce alone and assume that it will auto-correct itself over time.
- D. Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.
Answer: D
NEW QUESTION # 121
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. A Field Set that determines which fields to send in an HTTP callout.
- 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. Enable the field -level security permissions for the fields to send.
Answer: A,B
NEW QUESTION # 122
Which three characteristics of a skinny table help improve report and query performance?
- A. Skinny tables can contain frequently used fields and thereby help avoid joins.
- B. Skinny tables do not include records that are available in the recycle bin.
- C. Skinny tables provide a view across multiple objects for easy access to combined data.
- D. Skinny tables can be used to create custom indexes on multi-select picklist fields.
- E. Skinny tables are kept in sync with changes to data in the source tables.
Answer: A,B,E
Explanation:
The three characteristics of a Skinny table that help improve report and query performance are: Skinny tables can contain frequently used fields and thereby help avoid joins. Skinny tables are kept in sync with changes to data in the source tables. Skinny tables do not include records that are available in the recycle bin. These characteristics are beneficial because they reduce the query complexity and execution time, and improve the data accuracy and freshness. For example, skinny tables can contain frequently used fields from multiple objects, such as Account and Contact, and thereby help avoid joins that can slow down queries4. Skinny tables are updated automatically when the source tables are modified, so they always reflect the latest data5. Skinny tables do not include records that are available in the recycle bin, so they only contain active records that are relevant for reports and queries.
NEW QUESTION # 123
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. Limit data loading to the 2000 most recently created records.
- B. Load only the data that the users is permitted to access
- C. Create a skinny table to represent account and contact objects.
- D. Add custom indexes on frequently searched account and contact objects fields
Answer: D
NEW QUESTION # 124
Universal Containers (UC) 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. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com?
- A. Use triggers to calculate summary values instead of Roll -Up.
- B. Use workflow to calculate summary values instead of Roll -Up.
- C. Load all data using external IDs to link to parent records.
- D. Load all data after deferring sharing calculations.
Answer: D
Explanation:
Loading all data after deferring sharing calculations can improve the performance and avoid locking issues when loading a large amount of time entry records into Salesforce.com. This is because deferring sharing calculations can temporarily suspend the calculation of sharing rules until all the data is loaded, and then recalculate them in one operation
NEW QUESTION # 125
Company S was recently acquired by Company T. As part of the acquisition, all of the data for the Company S's Salesforce instance (source) must be migrated into the Company T's Salesforce instance (target). Company S has 6 million Case records.
An Architect has been tasked with optimizing the data load time.
What should the Architect consider to achieve this goal?
- A. Load the data in multiple sets using Bulk API parallel processes.
- B. Directly leverage Salesforce-to-Salesforce functionality to load Case data.
- C. Pre-process the data, then use Data Loader with SOAP API to upsert with zip compression enabled.
- D. Utilize the Salesforce Org Migration Tool from the Setup Data Management menu.
Answer: C
NEW QUESTION # 126
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 does not support Orders or Order Line Items.
- B. Salesforce allows up to four objects in a single report type.
- C. A report cannot contain data from Accounts and Contacts.
- D. Custom report types cannot contain Opportunity data.
Answer: B
NEW QUESTION # 127
NTO has a loyalty program to reward repeat customers. The following conditions exists:
1. Reward levels are earned based on the amount spent during the previous 12 months.
2. The program will track every item a customer has bought and grant them points for discount.
3. The program generates 100 million records each month.
NTO customer support would like to see a summary of a customer's recent transaction and reward level(s) they have attained.
Which solution should the data architect use to provide the information within the salesforce for the customer support agents?
- A. Provide a button so that the agent can quickly open the point of sales system displaying the customer history.
- B. Create a custom big object to capture the reward program data and display it on the contact record and update nightly from the point-of-scale system.
- C. Create a custom object in salesforce to capture and store all reward program. Populate nightly from the point-of-scale system, and present on the customer record.
- D. Capture the reward program data in an external data store and present the 12 months trailing summary in salesforce using salesforce connect and then external object.
Answer: B
NEW QUESTION # 128
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. Bring all data Salesforce, and delete it after a year.
- B. Leverage mashup to display historical records in Salesforce.
- C. Leverage real-time integration to pull records into Salesforce.
- D. Build a chair solution to go the legacy system and display records.
Answer: B
NEW QUESTION # 129
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. Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.
- B. Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.
- C. Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.
- D. Export legacy data into CSV files and leverage data loader to load data into Salesforce.
Answer: B
Explanation:
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.
NEW QUESTION # 130
Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record.
What should a data architect recommend to guarantee that records are not being updated at the same time?
- A. Embed the keywords FOR UPDATE after SOQL statements.
- B. Refactor or optimize classes and trigger for maximum CPU performance.
- C. Migrate programmatic logic to processes and flows.
- D. Disable classes or triggers that have the potential to obtain the same record.
Answer: A
NEW QUESTION # 131
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. Create a chatter group and upload all Excel files to the group.
- B. Use the Excel connector to Salesforce to sync data from individual Excel files.
- C. Load data in external database and provide access to database to sales users.
- D. Define a standard mapping and train sales users to import opportunity data.
Answer: D
NEW QUESTION # 132
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. Virtualize the remaining set of data with salesforce connect and external objects.
- B. As needed, make call outs into Heroku postgres and persist the data in salesforce.
- 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.
Answer: A
NEW QUESTION # 133
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. Use Salesforce CDC to sync customer data cross all systems to keep customer record in sync.
- B. Invest in data duplicate tool to de-dupe and merge duplicate records across all systems.
- C. Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.
- D. Create a unique global customer ID for each customer and store that in all system for referential identity.
- E. Duplicate customer records across the system and provide a two-way sync of data between the systems.
Answer: B,C,D
Explanation:
Creating a unique global customer ID for each customer and storing that in all systems for referential identity (option A), investing in a data duplicate tool to de-dupe and merge duplicate records across all systems (option C), and creating a customer master database external to Salesforce as a system of truth and syncing the customer data with all systems (option E) are the three options that a data architect should perform to resolve the issues with the customer data. Option A ensures that each customer can be uniquely identified across different systems, option C eliminates duplicate records and improves data quality, and option E provides a consistent and reliable source of customer data for all systems. Using Salesforce CDC to sync customer data across all systems (option B) is not a good option, as it does not address the duplication or inconsistency issues. Duplicating customer records across the system and providing a two-way sync of data between the systems (option D) is also not a good option, as it may create more confusion and conflicts with customer data.
NEW QUESTION # 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. Create a Custom Object Individual Consumer c to load all individual consumers.
- B. Load one Account record and one Contact record for each individual consumer.
- C. Load all individual consumers as Account records and avoid using the Contact object.
- D. Create one Account and load individual consumers as Contacts linked to that one Account.
Answer: B
NEW QUESTION # 135
......
Data-Architect Study Material, Preparation Guide and PDF Download: https://www.troytecdumps.com/Data-Architect-troytec-exam-dumps.html
Free Data-Architect Certification Sample Questions with Online Practice Test: https://drive.google.com/open?id=1I7OWbGY67QHsVHoytPw29lwqCDWyPTJ4