[2023] Data-Architect PDF Questions - Perfect Prospect To Go With RealValidExam Practice Exam
Salesforce Data-Architect Pdf Questions - Outstanding Practice To your Exam
NEW QUESTION # 59
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 order line items. 2. Store them in a zip file in case the data is needed later.
- B. 1. Annually delete orders and order line items. 2. Ensure the customer has order information in another system.
- C. 1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.
- D. 1. Annually export and delete orders and order line items. 2. Store them in a zip file in case the data is needed later.
Answer: C
NEW QUESTION # 60
Northern Trail Outfitters has these simple requirements for a data export process:
File format should be in CSV.
Process should be scheduled and run once per week.
The expert should be configurable through the Salesforce UI.
Which tool should a data architect leverage to accomplish these requirements?
- A. Third-party ETL tool
- B. Data loader
- C. Data export wizard
- D. Bulk API
Answer: C
NEW QUESTION # 61
NTO has 1 million customer records spanning 25 years. As part of its new SF project, NTO would like to create a master data management strategy to help preserve the history and relevance of its customer data.
Which 3 activities will be required to identify a successful master data management strategy? Choose 3 answers:
- A. Create a data archive strategy
- B. Install a data warehouse
- C. Identify data to be replicated
- D. Choose a Business Intelligence tool.
- E. Define the systems of record for critical data
Answer: A,C,E
NEW QUESTION # 62
Cloud Kicks needs to purge detailed transactional records from Salesforce. The data should be aggregated at a summary level and available in Salesforce.
What are two automated approaches to fulfill this goal? (Choose two.)
- A. Third-party Integration Tool (ETL)
- B. Schedulable Batch Apex
- C. Third-party Business Intelligence system
- D. Apex Triggers
Answer: A,B
NEW QUESTION # 63
NTO has implemented salesforce for its sales users. The opportunity management in salesforce is implemented as follows:
1. Sales users enter their opportunities in salesforce for forecasting and reporting purposes.
2. NTO has a product pricing system (PPS) that is used to update opportunity amount field on opportunities on a daily basis.
3. PPS is the trusted source within the NTO for opportunity amount.
4. NTO uses opportunity forecast for its sales planning and management.
Sales users have noticed that their updates to the opportunity amount field are overwritten when PPS updates their opportunities.
How should a data architect address this overriding issue?
- A. Create a custom field for opportunity amount that sales users update separating the fields that PPS updates.
- B. Change PPS integration to update only opportunity amount fields when values is NULL.
- C. Change opportunity amount field access to read only for sales users using field level security.
- D. Create a custom field for opportunity amount that PPS updates separating the field that sales user updates.
Answer: C
NEW QUESTION # 64
UC has large amount of orders coming in from its online portal. Historically all order are assigned to a generic user.
Which 2 measures should data architect recommend to avoid any performance issues while working with large number of order records? Choose 2 answers:
- A. Salesforce handles the assignment of orders automatically and there is no performance impact.
- B. Create a pool of generic users and distribute the assignment of memory to the pool of users.
- C. Create a role at top of role hierarchy and assign the role to the generic user.
- D. Clear the role field in the generic user record.
Answer: C,D
NEW QUESTION # 65
Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect
1. The data model for Org B will drastically change with different objects, fields, and picklist values.
2. Three million records will need to be migrated from org A to org B for compliance reasons.
3. The migrate will need occur within the next two month, prior to be split.
Which migrate strategy should a data architect use to successfully migrate the date?
- A. Write a script to use the Bulk API
- B. use as ETL tool to orchestrate the migration.
- C. Use the Salesforces CLI to query, export, and import
- D. Use Data Loader for export and Data Import Wizard for import
Answer: A
NEW QUESTION # 66
NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part of this process NTO will be migrating all of its metadata and dat a. 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 target org.
What 3 things should a data architect do to maintain the relationship hierarchy during migration?
Choose 3 answers:
- A. Redefine the master detail relationship fields to lookup relationship fields in the target org.
- B. Create a external id field for each object in the target org and map source record ID's to this field.
- C. Replace source record ID's with new record ID's from the target org in the import file.
- D. Keep the relationship fields populated with the source record ID's in the import file.
- E. Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.
Answer: B,C,E
NEW QUESTION # 67
US is implementing salesforce and will be using salesforce to track customer complaints, provide white papers on products and provide subscription (Fee) - based support.
Which license type will US users need to fulfil US's requirements?
- A. Sales cloud license
- B. Service cloud license.
- C. Salesforce license.
- D. Lightning platform starter license.
Answer: B
NEW QUESTION # 68
Universal Containers (UC) has adopted Salesforce as its primary sales automated tool. UC has 100,00 customers with a growth rate of 10% a year, UC uses an on-premise web-based billing and invoice system that generates over 1 million invoices a year supporting a monthly billing cycle.
The UC sales team needs to be able to pull a customer record and view their account status, Invoice history, and opportunities without navigating outside of Salesforce.
What should a data architect use to provide the sales team with the required functionality?
- A. Create a mashup page that will present the billing system records within Salesforce.
- B. Create a visual force tab with the billing system encapsulated within an iframe.
- C. Create a custom object and migrate the last 12 months of Invoice data into Salesforce so it can be displayed on the Account layout.
- D. Write an Apex callout and populate a related list to display on the account record.
Answer: A
NEW QUESTION # 69
Universal Containers has a public website with several forms that create Lead records in Salesforce using the REST API. When designing these forms, which two techniques will help maintain a high level of data quality?
- A. Do client-side validation of phone number and email field formats.
- B. Prefer picklist form fields over free text fields, where possible.
- C. Use cookies to track when visitors submit multiple forms.
- D. Ensure the website visitor is browsing using an HTTPS connection.
Answer: A,B
NEW QUESTION # 70
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 how the archive data will be accessed and used.
- B. Identify the recovery time objective.
- C. Identify the data retention requirements
- D. Identify the recovery point objective.
Answer: A,C
NEW QUESTION # 71
A large retail B2C customer wants to build a 360 view of its customer for its call center agents. The customer interaction is currently maintained in the following system: 1. Salesforce CRM
2. Custom billing solution
3. Customer Master Data management (MDM)
4. Contract Management system
5. Marketing solution
What should a data architect recommend that would help upgrade uniquely identify customer across multiple systems:
- A. Create a custom object that will serve as a cross reference for the customer id.
- B. Store the salesforce id in all the solutions to identify the customer.
- C. Create a custom field as external id to maintain the customer Id from the MDM solution.
- D. Create a customer data base and use this id in all systems.
Answer: C
NEW QUESTION # 72
Universal Containers (UC) plans to implement consent management for its customers to be compliant with General Data Protection Regulation (GDPR). UC has the following requirements:
UC uses Person Accounts and Contacts in Salesforce for its customers.
Data Protection and Privacy is enabled in Salesforce.
Consent should be maintained in both these objects.
UC plans to verify the consent provided by customers before contacting them through email or phone.
Which option should the data architect recommend to implement these requirements?
- A. Delete contact information from customers who have declined consent to be contacted.
- B. Build Custom object to store consent information in Person Account and Contact, validate against this object before contacting customers.
- C. Use the Consent Management Feature to validate consent provide under the person Account and Contact that is provided by the customer.
- D. Configure custom fields in Person Account and Contact to store consent provided by customers, and validate consent against the fields.
Answer: C
NEW QUESTION # 73
A casino is implementing salesforce and is planning to build a customer 360 view for a customer who visits its resorts. The casino currently maintained the following systems that records customer activity:
1. Point of sales system: All purchases for a customer.
2. Salesforce: All customer service activity and sales activity for a customer.
3. Mobile app: All bookings, preferences and browser activity for a customer.
4. Marketing: All email, SMS and social campaigns for a customer.
Customer service agents using salesforce would like to view the activities from all system to provide supports to customers. The information has to be current and real time.
What strategy should the data architect implement to satisfy this requirement?
- A. Migrate customer activities from all 4 systems into salesforce.
- B. Explore external data sources in salesforce to build 360 view of customer.
- C. Periodically upload summary information in salesforce to build 360 view.
- D. Use a customer data mart to view the 360 view of customer.
Answer: B
NEW QUESTION # 74
Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers
- A. Reduce the number of triggers on Order _c object.
- B. Make the queries more selective using indexed fields.
- C. Work with Salesforce Support to enable Skinny Tables.
- D. Use SOQL queries without WHERE conditions.
Answer: B,C
NEW QUESTION # 75
Which two best practices should be followed when using SOSL for searching?
- A. Use SOSL option to ignore custom indexes as search fields are pre-indexed.
- B. Keep searches specific and avoid wildcards where possible.
- C. Use searches against single Objects for greater speed and accuracy.
- D. Use Find in "ALL FIELDS" for faster searches.
Answer: B,D
NEW QUESTION # 76
Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting reports in the Salesforce org.
Which solution should a data architect recommend to improve reporting performance?
- A. Build reports using custom Lightning components.
- B. Move data off of the platform and run reporting outside Salesforce, and give access to reports.
- C. Contact Salesforce support to enable skinny table for cases.
- D. Create a custom object to store aggregate data and run reports.
Answer: B
NEW QUESTION # 77
UC is building a salesforce application to track contacts and their respective conferences that they have attended with the following requirements:
1. Contacts will be stored in the standard contact object.
2. Conferences will be stored in a custom conference__c object.
3. Each contact may attend multiple conferences and each conference may be related to multiple contacts.
How should a data architect model the relationship between the contact and conference objects?
- A. Create a master detail relationship field on the Conference object.
- B. Create a lookup relationship field on contact object.
- C. Create a master detail relationship field on the Contact object.
- D. Implement a Contact Conference junction object with master detail relationship to both contact and conference__c.
Answer: D
NEW QUESTION # 78
A manager at Cloud Kicks is importing Leads into Salesforce and needs to avoid creating duplicate records.
Which two approaches should the manager take to achieve this goal? (Choose two.)
- A. Implement Salesforce Matching and Duplicate Rules.
- B. Run the Salesforce Lead Mass de-duplication tool.
- C. Acquire an AppExchange Lead de-duplication application.
- D. Create a Workflow Rule to check for duplicate records.
Answer: A,C
NEW QUESTION # 79
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. Recommend app exchange packages to support this requirement.
- D. Create a geolocation custom field to maintain this requirement
Answer: B
NEW QUESTION # 80
Northern Trail Outfitters (NTO) wants to capture a list of customers that have bought a particular product. The solution architect has recommended to create a custom object for product, and to create a lookup relationship between its customers and its products.
Products will be modeled as a custom object (NTO_ Product__ c) and customers are modeled as person accounts. Every NTO product may have millions of customers looking up a single product, resulting in a lookup skew.
What should a data architect suggest to mitigate Issues related to lookup skew?
- A. Create a custom object to maintain the relationship between products and customers.
- B. Create multiple similar products and distribute the skew across those products.
- C. Select Clear the value of this field option while configuring the lookup relationship.
- D. Change the lookup relationship to master-detail relationship.
Answer: B
NEW QUESTION # 81
......
Salesforce Certified Data Architect certification is a valuable asset for professionals who are seeking to advance their careers in the Salesforce ecosystem. It demonstrates a high level of proficiency in designing and implementing complex data architecture solutions that meet the unique needs of organizations. Salesforce Certified Data Architect certification also provides access to a network of like-minded professionals who share best practices, tips, and insights on the latest trends and developments in data architecture.
Online Questions - Outstanding Practice To your Data-Architect Exam: https://officialdumps.realvalidexam.com/Data-Architect-real-exam-dumps.html
