PDF (New 2024) Actual Salesforce Data-Architect Exam Questions [Q95-Q120]

PDF (New 2024) Actual Salesforce Data-Architect Exam Questions

Dumps Moneyack Guarantee - Data-Architect Dumps UpTo 90% Off

The Salesforce Data-Architect exam covers a wide range of topics including data modeling, data management, data integration, data governance, data security, and data analytics. It also requires candidates to have an in-depth understanding of the Salesforce platform and its various components such as Sales Cloud, Service Cloud, Marketing Cloud, and Commerce Cloud. Passing the Salesforce Data-Architect exam requires a deep understanding of data architecture principles, as well as hands-on experience working with Salesforce data solutions. It is a challenging exam that requires dedication and preparation, but the rewards of becoming a Salesforce Certified Data Architect are well worth the effort.

 

NEW QUESTION # 95
Universal Containers (UC) has an Application custom object, which has tens of millions of records created in the past 5 years. UC needs the last 5 years of data to exist in Salesforce at all times for reporting and queries. UC is currently encountering performance issues when reporting and running queries on this Object using date ranges as filters. Which two options can be used to improve report performance?

• A. Run multiple reports to get different pieces of the data and combine them.
• B. Ask support to create a skinny table for Application with the necessary reporting fields.
• C. Add custom indexes to the Date fields used for filtering the report.
• D. Add custom indexes to all fields on Application without a standard index.

Answer: B,C

NEW QUESTION # 96
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 new records via the Insert operation and existing records via the Update operation.
• C. Load all records via the Upsert operation to determine new records vs. existing records.
• D. Load Contact records together using the Streaming API via the Upsert operation.

Answer: B

NEW QUESTION # 97
Universal Containers (UC) uses Salesforce for tracking opportunities (Opportunity). UC uses an internal ERP system for tracking deliveries and invoicing. The ERP system supports SOAP API and OData for bi-directional integration between Salesforce and the ERP system. UC has about one million opportunities. For each opportunity, UC sends 12 invoices, one per month. UC sales reps have requirements to view current invoice status and invoice amount from the opportunity page. When creating an object to model invoices, what should the architect recommend, considering performance and data storage space?

• A. Create a custom object Invoice _c with a Lookup relationship with Opportunity.
• B. Create a custom object Invoice _c with a master -detail relationship with Opportunity.
• C. Use Streaming API to get the current status from the ERP and display on the Opportunity page.
• D. Create an external object Invoice _x with a Lookup relationship with Opportunity.

Answer: D

NEW QUESTION # 98
Universal Containers (UC) wants to ensure their data on 100,000 Accounts pertaining mostly to US-based companies is enriched and cleansed on an ongoing basis. UC is looking for a solution that allows easy monitoring of key data quality metrics. What should be the recommended solution to meet this requirement?

• A. Implement an Apex Trigger on Account that queries a third-party data quality API to monitor Account data quality.
• B. Use declarative approach by installing and configuring Data.com Prospector to monitor Account data quality.
• C. Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality.
• D. Implement Batch Apex that calls out a third-party data quality API in order to monitor Account data quality.

Answer: C

Explanation:
Using a declarative approach by installing and configuring Data.com Clean to monitor Account data quality can help UC meet their requirement. Data.com Clean can enrich and cleanse data on an ongoing basis by comparing Salesforce records with Data.com records and providing suggestions for updates. Data.com Clean can also provide dashboards and reports to monitor key data quality metrics such as match rate, field fill rate, and record completeness

NEW QUESTION # 99
Universal Containers (UC) is building a Service Cloud call center application and has a multisystem support solution. UC would like or ensure that all systems have access to the same customer information.
What solution should a data architect recommend?

• A. Make Salesforce the system of record for all data.
• B. Let each system be an owner of data it generates.
• C. Load customer data in all systems.
• D. Implement a master data management (MDM) strategy for customer data.

Answer: D

Explanation:
A master data management (MDM) strategy for customer data can help UC ensure that all systems have access to the same customer information, without loading or duplicating data in all systems. An MDM strategy can also help UC avoid data conflicts and inconsistencies that may arise from having multiple systems as owners of data.

NEW QUESTION # 100
Universal Containers keeps its Account data in Salesforce and its Invoice data in a third -party ERP system. They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place. What two approaches should an architect suggest for achieving this solution? Choose 2 answers

• A. Create a report in an external system combining Salesforce Account data and Invoice data from the ERP.
• B. Create a separate Salesforce report for Accounts and Invoices and combine them in a dashboard.
• C. Create a report combining data from the Account standard object and the Invoices external object.
• D. Create a Visualforce page combining Salesforce Account data and Invoice external object data.

Answer: A,D

Explanation:
Creating a report in an external system combining Salesforce Account data and Invoice data from the ERP, and creating a Visualforce page combining Salesforce Account data and Invoice external object data are two approaches that an architect can suggest for achieving this solution. Both of these approaches can display data from both Accounts and Invoices in one place, using either an external reporting tool or a custom web page. Creating a report combining data from the Account standard object and the Invoices external object is not possible because Salesforce does not support reporting on external objects. Creating a separate Salesforce report for Accounts and Invoices and combining them in a dashboard is not ideal because it will not show the data in one report, but rather in two separate components.

NEW QUESTION # 101
UC has millions of Cases and are running out of storage. Some user groups need to have access to historical cases for up to 7 years.
Which 2 solutions should a data architect recommend in order to minimize performance and storage issues?
Choose 2 answers:

• A. Leverage on premise data archival and build integration to view archived data.
• B. Create a custom object to store case history and run reports on it.
• C. Export data out of salesforce and store in Flat files on external system.
• D. Leverage big object to archive case data and lightning components to show archived data.

Answer: A,D

Explanation:
The correct answer is C and D. To minimize performance and storage issues, a data architect should recommend leveraging on premise data archival and building integration to view archived data, and leveraging big object to archive case data and lightning components to show archived data. These solutions will allow some user groups to access historical cases for up to 7 years without consuming too much storage space or affecting the performance of queries and reports. Option A is incorrect because exporting data out of salesforce and storing it in flat files on external system will make it difficult to access and query the data.
Option B is incorrect because creating a custom object to store case history and run reports on it will still consume a lot of storage space and impact the performance of queries and reports.

NEW QUESTION # 102
What 2 data management policies does the data classification feature allow customers to classify in salesforce? Choose 2 answers:

• A. Reference data policy.
• B. Data governance policy.
• C. Data sensitivity level
• D. Compliance categorization policy.

Answer: C,D

Explanation:
The data classification feature allows customers to classify their data in Salesforce based on two policies:
Data sensitivity level: This policy defines how sensitive the data is and what level of protection it requires. For example, high sensitivity data may require encryption or masking.
Compliance categorization policy: This policy defines how the data is regulated by various laws and standards. For example, GDPR or PCI DSS.

NEW QUESTION # 103
Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data, Currently, it has data backup processes that runs weekly, which back up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage.
What should a data architect recommend for a daily backup and restore solution?

• A. Use ETL for backup and restore from EDW.
• B. Change weekly backup process to daily backup, and implement a custom restore solution.
• C. Use Bulk API to extract data on daily basis to EDW and REST API for restore.
• D. Use AppExchange package for backup and restore.

Answer: D

NEW QUESTION # 104
A data architect is working with a large B2C retailer and needs to model the consumer account structure in Salesforce.
What standard feature should be selected in this scenario?

• A. Account Contact
• B. Contacts
• C. Person Accounts
• D. Individual Accounts

Answer: C

NEW QUESTION # 105
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. Do not integrate legacy CRM to Salesforce, but integrate salesforce to SAP
• B. Integrate legacy CRM to salesforce and keep data in synch till new functionality is in place
• C. Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce
• D. Suggest MDM solution and link MDM to salesforce and SAP

Answer: C,D

Explanation:
Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce. This is a good recommendation because it allows both Salesforce and the legacy CRM to interact with the ERP system, which can be the source of truth for some data entities. However, it avoids creating a direct connection between Salesforce and the legacy CRM, which can cause data duplication and synchronization issues. Suggest MDM solution and link MDM to salesforce and SAP. This is another good recommendation because it can help manage the data lifecycle and quality across multiple systems, as well as provide a single view of the customer data

NEW QUESTION # 106
Universal Containers (UC) has a multi-level master-detail relationship for opportunities, a custom opportunity line item object, and a custom discount request. UC has opportunity as master and custom line item object as detail in master-detail relationship. UC also has a custom line item object as master and a custom discount request object as detail in another master-detail relationship. UC has a requirement to show all sums of discounts across line items at an opportunity level. What is the recommended solution to address these requirements?

• A. Remove the master-detail relationships and rely completely on workflow/triggers to summarize the discount amount.
• B. Roll-up discount request amount at the line-item-level and line-item-level summary discount at the opportunity level.
• C. Update the master-detail relationships to lookup relationships in order to allow the discount amount to roll up.
• D. Use roll-up for the line-item-level summary and a trigger for the opportunity amount summary, as only one level roll-up is allowed.

Answer: B

Explanation:
The recommended solution to address the requirements of Universal Containers (UC) is to roll-up discount request amount at the line-item-level and line-item-level summary discount at the opportunity level. This solution would allow UC to show all sums of discounts across line items at an opportunity level using standard roll-up summary fields. Since UC has a multi-level master-detail relationship for opportunities, a custom opportunity line item object, and a custom discount request object, they can use two levels of roll-up summary fields to aggregate the discount amounts from the child objects to the parent objects. For example, they can create a roll-up summary field on the custom line item object to sum up the discount request amounts from the custom discount request object. Then, they can create another roll-up summary field on the opportunity object to sum up the line-item-level summary discounts from the custom line item object.

NEW QUESTION # 107
Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics. What solution addresses this requirement?

• A. Generate reports to view the quality of sample data.
• B. Use custom objects and fields to calculate data quality.
• C. Export the data to an enterprise data warehouse and use BI tools for data quality.
• D. Use third-party AppExchange tools to monitor and measure data quality.

Answer: D

Explanation:
Using third-party AppExchange tools to monitor and measure data quality can address the requirement of UC executives by providing features such as data cleansing, deduplication, validation, enrichment, and scoring.
These tools can help improve the accuracy, completeness, and consistency of the data entered by sales reps .

NEW QUESTION # 108
Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of 10 line items. The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year. However, data storage is running low in Salesforce.
Which approach for data archiving is appropriate for this scenario?

• A. 1. Annually export and delete orders and order line items. 2. Store them in a zip file in case the data is needed later.
• B. 1. Annually export and delete order line items. 2. Store them in a zip file in case the data is needed later.
• C. 1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.
• D. 1. Annually delete orders and order line items. 2. Ensure the customer has order information in another system.

Answer: C

Explanation:
Option B is the most appropriate approach for data archiving in this scenario1. By aggregating order amount data at a summary level and storing it in a custom object, you can reduce data storage and still provide visibility to the Sales Reps on how much money each customer generates year-over-year. Option A is not correct because storing data in a zip file does not make it available in Salesforce. Option C is not correct because exporting and deleting orders and order line items may lose important details that are needed for analysis or reporting. Option D is not correct because deleting orders and order line items without exporting them may cause data loss or inconsistency if the customer does not have order information in another system.

NEW QUESTION # 109
Universals Containers' system administrators have been complaining that they are not able to make changes to its users' record, including moving them to new territories without getting "unable to lock row" errors. This is causing the system admins to spend hours updating user records every day.
What should the data architect do to prevent the error?

• A. Analyze Splunk query to spot offending records.
• B. Enable granular locking.
• C. Reduce number of users updated concurrently.
• D. Increase CPU for the Salesforce org.

Answer: B

Explanation:
Enabling granular locking (option B) is the best option to prevent the error, as it allows finer control over how records are locked during automated or manual processes, and reduces the chances of lock contention or deadlock. Reducing number of users updated concurrently (option A) is not a good option, as it may limit the productivity and efficiency of the system admins, and it does not address the root cause of the error. Analyzing Splunk query to spot offending records (option C) is also not a good option, as it may require more time and effort, and it does not provide a permanent solution for the error. Increasing CPU for the Salesforce org (option D) is also not a good option, as it may introduce additional cost and complexity, and it does not solve the root cause of the error.

NEW QUESTION # 110
Universal Containers (UC) has a Salesforce instance with over 10.000 Account records. They have noticed similar, but not identical. Account names and addresses. What should UC do to ensure proper data quality?

• A. Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.
• B. Make the Account Owner clean their Accounts' addresses, then merge Accounts with the same address.
• C. Use a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.
• D. Run a report, find Accounts whose name starts with the same five characters, then merge those Accounts.

Answer: A

Explanation:
Enabling Account de-duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts, is what UC should do to ensure proper data quality for their Account records. Matching rules allow UC to define how Salesforce identifies duplicate Accounts based on various criteria, such as name, address, phone number, etc. Mass merge allows UC to merge up to 200 duplicate Accounts at a time, based on the matching rules. This simplifies and automates the process of de-duplicating Accounts and improves data quality. The other options are either more time-consuming, costly, or error-prone for ensuring proper data quality.

NEW QUESTION # 111
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. Install a third-party AppExchange tool.
• B. Use the Bulk API in parallel mode.
• C. Call the REST API in successive queries.
• D. Utilize PK Chunking with the Bulk API.

Answer: D

Explanation:
According to the Salesforce documentation2, extracting large amounts of data from Salesforce can be challenging and time-consuming, as it can encounter performance issues, API limits, timeouts, etc. To extract 100 million records from Salesforce for migration to an enterprise data warehouse (EDW), a data extraction strategy that can provide maximum performance is:
Utilize PK Chunking with the Bulk API (option C). This means using a feature that allows splitting a large query into smaller batches based on the record IDs (primary keys) of the queried object. This can improve performance and avoid timeouts by processing each batch asynchronously and in parallel using the Bulk API3.
Installing a third-party AppExchange tool (option A) is not a good solution, as it can incur additional costs and dependencies. It may also not be able to handle such a large volume of data efficiently. Calling the REST API in successive queries (option B) is also not a good solution, as it can encounter API limits and performance issues when querying such a large volume of data. Using the Bulk API in parallel mode (option D) is also not a good solution, as it can still cause timeouts and errors when querying such a large volume of data without chunking.

NEW QUESTION # 112
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. Import Account records first followed by order records after sorting orders by AccountID.
• B. Import Account records first followed by order records after sorting order by OrderID.
• C. Import Order records and Account records separately and populate AccountID in orders using batch Apex.
• D. Change the relationship to Lookup and update the relationship to master-detail after import.

Answer: A

NEW QUESTION # 113
UC migrating 100,000 Accounts from an enterprise resource planning (ERP) to salesforce and is concerned about ownership skew and performance.
Which 3 recommendations should a data architect provide to prevent ownership skew?
Choose 3 answers:

• A. Assigned a default user as owner of accounts, and assign role in hierarchy.
• B. Assign "view all" permission on profile to give access to account.
• C. Assign a default user as owner of accounts and assigned top most role in hierarchy.
• D. Assign a default user as owner of account and do not assign any role to default user.
• E. Keep users out of public groups that can be used as the source for sharing rules.

Answer: C,D,E

Explanation:
According to the Salesforce documentation1, ownership skew occurs when a large number of records (more than 10,000) are owned by a single user or queue. This can cause performance issues and lock contention when multiple users try to access or update those records. To prevent ownership skew, some of the recommended practices are:
Assign a default user as the owner of the records and do not assign any role to the default user (option C). This way, the records will not be visible to other users in the role hierarchy and will not cause sharing recalculations.
Keep users out of public groups that can be used as the source for sharing rules (option B). Sharing rules based on public groups can cause excessive sharing calculations and lock contention when many records are owned by a single user or queue.
Assign a default user as the owner of the records and assign the top most role in the hierarchy to the default user (option E). This way, the records will be visible to all users in the role hierarchy, but will not cause sharing recalculations or lock contention.
Assigning a default user as the owner of the records and assigning a role in the hierarchy (option A) is not a good practice, as it can cause sharing recalculations and lock contention when the role is updated or moved.
Assigning "view all" permission on profile to give access to the records (option D) is also not a good practice, as it can bypass the security and sharing model and expose sensitive data to unauthorized users.

NEW QUESTION # 114
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. Create a Workflow to default a value into this field.
• B. Mark the field required in setup at the field level.
• C. Set up a Validation Rule to prevent blank values.
• D. Blame the customer's external system for bad data.

Answer: B,C

NEW QUESTION # 115
As part of a phased Salesforce rollout. there will be 3 deployments spread out over the year. The requirements have been carefully documented. Which two methods should an architect use to trace back configuration changes to the detailed requirements? Choose 2 answers

• A. Review the setup audit trail for configuration changes.
• B. Maintain a data dictionary with the justification for each field.
• C. Put the business purpose in the Description of each field.
• D. Use the Force.com IDE to save the metadata files in source control.

Answer: C,D

Explanation:
Option B is correct because putting the business purpose in the Description of each field is a method that an architect can use to trace back configuration changes to the detailed requirements1. The Description of each field provides a brief explanation of what the field is used for and why it is needed2. Option D is correct because using the Force.com IDE to save the metadata files in source control is another method that an architect can use to trace back configuration changes to the detailed requirements1. The Force.com IDE is an integrated development environment that allows developers to work with Salesforce metadata files and Apex code3. Source control is a system that tracks and manages changes to code and configuration files4. Option A is not correct because reviewing the setup audit trail for configuration changes is not a method to trace back configuration changes to the detailed requirements, but a way to monitor and audit the changes made in the setup area. Option C is not correct because maintaining a data dictionary with the justification for each field is not a method to trace back configuration changes to the detailed requirements, but a document that provides information about the data entities and attributes in a system.

NEW QUESTION # 116
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. Defer roll-up summary fields calculation during data migration.
• D. Perform Batch job in serial mode and reduce batch size

Answer: A

NEW QUESTION # 117
The head of sales at Get Cloudy Consulting wants to understand key relevant performance figures and help managers take corrective actions where appropriate.
What is one reporting option Get Cloudy Consulting should consider?

• A. Lead conversion rate report
• B. Case SLA performance report
• C. Sales KPI Dashboard
• D. Opportunity analytic snapshot

Answer: C

Explanation:
A Sales KPI Dashboard is one reporting option that Get Cloudy Consulting should consider to understand key relevant performance figures and help managers take corrective actions where appropriate. A Sales KPI Dashboard can display various metrics that indicate the health and effectiveness of the sales team, such as quota attainment, pipeline value, win rate, average deal size, sales cycle length, and more. A Sales KPI Dashboard can also help identify trends, patterns, and areas for improvement.

NEW QUESTION # 118
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 object to store archived case data.
• B. Purchase more data storage to support case object
• C. Use a custom Big object to store archived case data.
• D. Archive Case data using Salesforce Archiving process

Answer: C

NEW QUESTION # 119
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. Truncate all 5 objects and hard delete before running the migration test.
• B. Refresh the full copy sandbox and re-run the data migration test.
• C. Hard delete all 5 objects' data and re-run the data migration test.
• D. Truncate all 5 objects quickly and re-run the data migration test.

Answer: B

Explanation:
The recommended approach to re-run the test is to refresh the full copy sandbox and re-run the data migration test. A full copy sandbox is a replica of the production Org, including all data, metadata, and attachments. Refreshing a full copy sandbox means creating a new copy of the production Org and replacing the existing sandbox. This would ensure that the test is run on a clean and up-to-date environment, without any leftover data or configuration from previous tests. Truncating or hard deleting objects would not be sufficient, because they would not remove all the data or metadata from the sandbox, and they could also affect other dependent objects or processes.

NEW QUESTION # 120
......

Updated Nov-2024 Pass Data-Architect Exam - Real Practice Test Questions: https://www.prep4king.com/Data-Architect-exam-prep-material.html

Pass Your Exam With 100% Verified Data-Architect Exam Questions: https://drive.google.com/open?id=1Xvqw_I-3JpMgQ2xJBQwrPYh0POKSJSew