Nov-2024 Data-Architect Study Material, Preparation Guide and PDF Download
Free Data-Architect Certification Sample Questions with Online Practice Test
NEW QUESTION # 59
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. Add custom indexes on frequently searched account and contact objects fields
- B. Load only the data that the users is permitted to access
- C. Create a skinny table to represent account and contact objects.
- D. Limit data loading to the 2000 most recently created records.
Answer: A
Explanation:
The correct answer is B, add custom indexes on frequently searched account and contact object fields. Custom indexes are a way to improve the performance of your queries and reports by creating indexes on specific fields that are often used in filters or joins. By adding custom indexes on frequently searched account and contact object fields, you can speed up the response time for reports and list views. Loading only the data that users are permitted to access, limiting data loading to the 2000 most recent records, or creating a skinny table are also possible solutions, but they are either not feasible, not scalable, or not supported by Salesforce.
NEW QUESTION # 60
Northern Trail Outfitters (NTO) has multiple Salesforce orgs based on regions. Users need read-only access to customers across all Salesforce orgs.
Which feature in Salesforce can be used to provide access to customer records across all NTO orgs?
- A. External APIs
- B. Federated Search
- C. Salesforce Connect
- D. Salesforce 2 Salesforce
Answer: C
Explanation:
Salesforce Connect is a feature that allows users to access data from external sources and multiple Salesforce orgs, using either clicks or code. Salesforce Connect can provide read-only access to customer records across all NTO orgs, without replicating or storing the data in Salesforce.
NEW QUESTION # 61
Which API should a data architect use if exporting 1million records from Salesforce?
- A. SOAP API
- B. Bulk API
- C. REST API
- D. Streaming API
Answer: B
Explanation:
Using Bulk API to export 1 million records from Salesforce is the best option. Bulk API is a RESTful API that allows you to perform asynchronous operations on large sets of data. You can use Bulk API to create, update, delete, or query millions of records in batches. Bulk API is optimized for performance and scalability, and it can handle complex data loading scenarios.
NEW QUESTION # 62
A national nonprofit organization is using Salesforce to recruit members. The recruitment process requires a member to be matched with a volunteer opportunity. Given the following:
1. A record is created in Project__ c and used to track the project through completion.
2. The member may then start volunteering and is required to track their volunteer hours, which is stored in VTOTime_c object related to the project.
3. Ability to view or edit the VTOTime__c object needs to be the same as the Project__ c record.
4. Managers must see total hours volunteered while viewing the Project__ c record.
Which data relationship should the data architect use to support this requirement when creating the custom VTOTime__c object?
- A. Master Detail field on Project _c to VTOTime _c showing a list of VTOTime_c Records in a related list.
- B. Lookup field on VTOTime_c to Project_c with formula filed on Project__ c showing Sum of hours from VTOTime__c records.
- C. Master Detail Field on VTOTime_ c to Project_c with rollup summary field on Project __c showing sum of hours from VTOTime_c records.
- D. Lookup Field on Project_c to VTOTime_c displaying a list of VTOTime__c in a related list.
Answer: C
Explanation:
A master-detail field on VTOTime__c to Project__c is the data relationship that the data architect should use to support the requirement when creating the custom VTOTime__c object. A master-detail relationship creates a parent-child relationship between two objects, where the master record controls certain behaviors of the detail record, such as security, ownership, deletion, and roll-up summary fields. By using a master-detail field on VTOTime__c to Project__c, you can ensure that the ability to view or edit the VTOTime__c object is the same as the Project__c record, and that managers can see the total hours volunteered while viewing the Project__c record using a roll-up summary field.
NEW QUESTION # 63
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. Explore external data sources in salesforce to build 360 view of customer.
- B. Use a customer data mart to view the 360 view of customer.
- C. Periodically upload summary information in salesforce to build 360 view.
- D. Migrate customer activities from all 4 systems into salesforce.
Answer: A
Explanation:
Exploring external data sources in Salesforce to build 360 view of customer is the best strategy to satisfy the requirement, as it allows real-time access to data from other systems without storing it in Salesforce3. Using a customer data mart may not provide real-time information or may require additional integration efforts.
Migrating customer activities from all 4 systems into Salesforce may exceed the storage limits or cause data quality issues. Periodically uploading summary information in Salesforce may not provide current or detailed information.
NEW QUESTION # 64
Universal Container require all customers to provide either a phone number of an email address when registering for an account.
What should the data architect use to ensure this requirement is met?
- A. Apex Class
- B. validation Rule
- C. Process Builder
- D. required Fields
Answer: B
Explanation:
Using a validation rule is the best way to ensure that all customers provide either a phone number or an email address when registering for an account, as it allows defining a formula that evaluates whether a record meets certain criteria. Using required fields may not work if both phone number and email address are required.
Using an Apex class or a Process Builder may be more complex or cumbersome than using a validation rule.
NEW QUESTION # 65
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. Salesforce Administrators
- B. Analytics/BI Owners
- C. Data Domain Stewards
- D. Operational Data Users
Answer: B,C
NEW QUESTION # 66
Universal Containers uses Apex jobs to create leads in Salesforce. The business team has requested that lead creation failures should be reported to them.
Which option does Apex provide to report errors from this Apex job?
- A. Use Apex services to email failures to business when error occurs.
- B. Save Apex errors in a custom object, and allow access to this object for reporting.
- C. Use Custom Object to store leads, and allow unprocessed leads to be reported.
- D. Use AppExchange package to clean lead information before Apex job processes them.
Answer: A
NEW QUESTION # 67
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. Change PPS integration to update only opportunity amount fields when values is NULL.
- B. Create a custom field for opportunity amount that sales users update separating the fields that PPS updates.
- 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
Explanation:
Changing the opportunity amount field access to read only for sales users using field level security is the best way to address the overriding issue. This way, the sales users can still view the opportunity amount field but cannot edit it, and PPS can update it as the trusted source
NEW QUESTION # 68
Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement?
Choose 2 answers
- A. Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
- B. Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.
- C. Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.
- D. Turn on field Contact object history tracking for these ten fields, then create reports on contact history.
Answer: A,D
Explanation:
To capture and report on any changes made to ten text fields on the Contact object for the past 3 months, the data architect should write an Apex trigger on Contact after insert and after update events and store the old values in another custom object, or turn on field Contact object history tracking for these ten fields and create reports on contact history. An Apex trigger can capture the old and new values of the fields, as well as the user and time of the change, and store them in a custom object that can be used for reporting. Field history tracking can also track the changes to the fields and store them in a history table that can be used for reporting.
However, field history tracking only retains data for up to 18 months or 24 months with an extension, so it may not be suitable for longer-term reporting needs. The other options are not feasible or effective for capturing and reporting on field data changes.
NEW QUESTION # 69
(NTO) has multiple salesforce orgs based on geographical reports (AMER, EMEA, APAC). NTO products are in the AMER org and need to be created in the EMEA and APAC after the products are approved.
Which two features should a data architect recommend to share records between salesforce orgs? Choose 2.
- A. Change data capture (CDC)
- B. Federation search
- C. Salesforce connect.
- D. Salesforce 2 Salesforce
Answer: A,D
NEW QUESTION # 70
Universal Containers has deployed Salesforce for case management The company is having difficulty understanding what percentage of cases are resolved from the initial call to their support organization. What first step is recommended to implement a reporting solution to measure the support reps case closure rates?
- A. Install AppExchange packages for available reports.
- B. Enable field history tracking on the Case object.
- C. Create a report on Case analytic snapshots.
- D. Create Contact and Opportunity Reports and Dashboards.
Answer: B
NEW QUESTION # 71
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. Make the queries more selective using indexed fields.
- B. Use SOQL queries without WHERE conditions.
- C. Work with Salesforce Support to enable Skinny Tables.
- D. Reduce the number of triggers on Order _c object.
Answer: A,C
Explanation:
To improve the performance of SOQL queries that retrieve data from the Order_c object, the data architect should work with Salesforce Support to enable Skinny Tables and make the queries more selective using indexed fields. Skinny Tables are custom tables that contain frequently used fields and are kept in sync with the base tables3. They can improve performance by reducing the number of table joins and using indexes. Making the queries more selective using indexed fields can also improve performance by reducing the query execution time and avoiding query timeouts4. The other options are not effective or recommended for improving SOQL performance.
NEW QUESTION # 72
UC is planning a massive SF implementation with large volumes of dat
a. As part of the org's implementation, several roles, territories, groups, and sharing rules have been configured. The data architect has been tasked with loading all of the required data, including user data, in a timely manner.
What should a data architect do to minimize data load times due to system calculations?
- A. Load the data through data loader, and turn on parallel processing.
- B. Enable granular locking to avoid "UNABLE _TO_LOCK_ROW" error.
- C. Enable defer sharing calculations, and suspend sharing rule calculations
- D. Leverage the Bulk API and concurrent processing with multiple batches
Answer: C
Explanation:
The correct answer is A, enable defer sharing calculations, and suspend sharing rule calculations. Defer sharing calculations and suspend sharing rule calculations are features that allow you to temporarily disable the automatic recalculation of sharing rules when you load large volumes of data. This can improve the performance and speed of your data load process by avoiding unnecessary system calculations. Loading the data through data loader, leveraging the bulk API, or enabling granular locking are also options that can help with data load times, but they do not directly address the system calculations issue.
NEW QUESTION # 73
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. Select Clear the value of this field option while configuring the lookup relationship.
- B. Create multiple similar products and distribute the skew across those products.
- C. Change the lookup relationship to master-detail relationship.
- D. Create a custom object to maintain the relationship between products and customers.
Answer: B
NEW QUESTION # 74
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 need to small amounts of external data at any one time.
- B. You need to expose data via a virtual private connection.
- 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 have a large amount of data that you don't want to copy into your Salesforce org.
Answer: A,D,E
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 # 75
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. Sales KPI Dashboard
- B. Opportunity analytic snapshot
- C. Lead conversion rate report
- D. Case SLA performance report
Answer: A
NEW QUESTION # 76
Get Cloudy Consulting monitors 15,000 servers, and these servers automatically record their status every 10 minutes. Because of company policy, these status reports must be maintained for 5 years. Managers at Get Cloudy Consulting need access to up to one week's worth of these status reports with all of their details.
An Architect is recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce.
Which two limits should the Architect be aware of? (Choose two.)
- A. API Request limits
- B. Webservice callout limits
- C. Workflow rule limits
- D. Data storage limits
Answer: A,D
Explanation:
Data storage limits and API request limits are two important factors that affect the data integration and storage in Salesforce. Data storage limits determine how much data can be stored in Salesforce, and API request limits determine how many API calls can be made to Salesforce in a 24-hour period. Both of these limits depend on the edition and license type of the Salesforce org. Workflow rule limits and webservice callout limits are not directly related to data integration and storage, but rather to business logic and external services.
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 lookup relationship field on contact object.
- B. Implement a Contact Conference junction object with master detail relationship to both contact and conference_c
- C. Create a master detail relationship field on the Conference object.
- D. Create a master detail relationship field on the Contact object.
Answer: B
Explanation:
Implementing a Contact Conference junction object with master detail relationship to both contact and conference_c is the correct way to model the relationship between the contact and conference objects, as it allows a many-to-many relationship between them. This means that each contact can attend multiple conferences, and each conference can be related to multiple contacts. Creating a master detail relationship field on either the contact or the conference object would create a one-to-many relationship, which does not meet the requirements. Creating a lookup relationship field on contact object would also create a one-to-many relationship, and would not enforce referential integrity.
NEW QUESTION # 78
A large automobile company has implemented Salesforce for its sales associates. Leads flow from its website to Salesforce using a batch integration in Salesforce. The batch job converts the leads to Accounts in Salesforce. Customers visiting their retail stores are also created in Salesforce as Accounts.
The company has noticed a large number of duplicate Accounts in Salesforce. On analysis, it was found that certain customers could interact with its website and also visit the store. The sales associates use Global Search to search for customers in Salesforce before they create the customers.
Which option should a data architect choose to implement to avoid duplicates?
- A. Develop an Apex class that searches for duplicates and removes them nightly.
- B. Implement an MDM solution to validate the customer information before creating Salesforce.
- C. Build a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.
- D. leverage duplicate rules in Salesforce to validate duplicates during the account creation process.
Answer: D
Explanation:
Leveraging duplicate rules in Salesforce to validate duplicates during the account creation process (option A) is the best option to implement to avoid duplicates, as it allows the sales associates to identify and merge duplicate accounts before they are saved. Developing an Apex class that searches for duplicates and removes them nightly (option B) is not a good option, as it may cause data loss or conflicts, and it does not prevent duplicates from being created in the first place. Implementing an MDM solution to validate the customer information before creating Salesforce (option C) is also not a good option, as it may introduce additional complexity and cost, and it does not address the issue of customers interacting with both the website and the store. Building a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores (option D) is also not a good option, as it may not be reliable or user-friendly, and it does not leverage the existing Global Search feature.
NEW QUESTION # 79
......
Data-Architect Certification Study Guide Pass Data-Architect Fast: https://www.surepassexams.com/Data-Architect-exam-bootcamp.html
Data-Architect Dumps PDF 2024 Program Your Preparation EXAM SUCCESS: https://drive.google.com/open?id=1yLQf9KseJwmbUyyg-NDOVztYyZd-SaF5