Exam (elaborations)
Data Architecture Practice Exam 1 Questions With Complete Solutions
- Course
- Institution
Data Architecture Practice Exam 1 Questions With Complete Solutions
[Show more]
Content preview
Data Architecture Practice Exam 1 Questions WithComplete Solutions
A developer of Cosmic Solutions is using SOSL in an Apex
class to search multiple objects and fields for a specific term and
return the result. Which of the following are best practices that
should be recommended by a data architect when using SOSL
for searches in Salesforce? Choose 3 answers.
A. Records that are owned by other users should be targeted for
faster searches.
B. Search terms should use exact phrases and be as selective as
possible.
C. Search scope should be limited by targeting specific objects.
D. Records within a division should be excluded in SOSL
searches.
E. Searches should be performed in specific fields, such as name
fields, instead of all fields. Correct Answer B, C, & E
In order to ensure faster SOSL searches, exact phrases should be
used, and the search terms should be as selective as possible.
The search scope can be limited by targeting specific objects,
records owned by the searcher, and records within a division,
whenever applicable.
http://resources.docs.salesforce.com/rel1/doc/en-us/static/pdf/
salesforce_query_search_optimization_developer_cheatsheet.pd
f
A developer would like to make SOQL queries used in certain
Apex classes selective to improve their performance due to a
,large number of records retrieved by them. Which of the
following would make a SOQL query non-selective? Choose 3
answers.
A. Filter condition with a non-deterministic formula field
B. Filter condition with leading "%" wildcards
C. Filter condition with a composite index
D. Negative filter operators such as NOT LIKE and
EXCLUDES
E. Comparison operators paired with a number or percent field
Correct Answer A, B, & D
The following can make a SOQL query non-selective:
1) Negative filter operators used in filter conditions (!=, NOT
LIKE, and EXCLUDES)
2) Comparison operators paired with text fields (<, >, <=, and
>=)
3) Leading "%" wildcards (LIKE '%string%')
4) References to non-deterministic formula fields, such as cross-
object formula fields
Comparison operators paired with a number or percent field do
not make a query non-selective. A filter condition with a
composite index that uses the AND operator does not
necessarily make a SOQL query non-selective. To ensure
selectivity, the filter condition should target less than twice the
index selectivity thresholds for each filter and the index
selectivity thresholds for the intersection of the fields.
,https://help.salesforce.com/articleView?
id=000325257&language=en_US&type=1&mode=1
http://resources.docs.salesforce.com/rel1/doc/en-us/static/pdf/
salesforce_query_search_optimization_developer_cheatsheet.pd
f
An administrator of Cosmic Solutions is trying to extract more
than 10 million account records from Salesforce using a third-
party tool that supports Bulk API. However, the Bulk API query
fails to complete. What should a data architect recommend to
ensure that the query does not fail? Choose 1 answer.
A. Manually export the records in multiple batches of 250,000
records.
B. Use Bulk API in serial mode to extract the records.
C. Look for an AppExchange application to extract the records.
D. Use PK Chunking to split the query into chunks. Correct
Answer D. Use PK Chunking to split the query into chunks.
PK Chunking can be used to ensure that the Bulk API query
does not fail due to the large number of records. To enable the
feature, one can specify the header 'Sforce-Enable-PKChunking'
on the job request for the Bulk API query. It automatically splits
the query into separate chunks, executes a query for each chunk,
and returns the data. This approach is better than manually
exporting the records in batches or looking for an AppExchange
application. Using Bulk API in serial mode is not likely to
ensure that the query does not fail. Serial mode is typically used
to prevent lock contention on records.
, https://developer.salesforce.com/blogs/engineering/2015/03/use-
pk-chunking-extract-large-data-sets-salesforce.html
https://developer.salesforce.com/docs/atlas.en-
us.api_asynch.meta/api_asynch/
async_api_headers_enable_pk_chunking.htm
Cosmic Circle Goods uses a Salesforce org with two custom
objects called 'Sold Product' and 'Product Part'. The 'Sold
Product' object stores information about each product sold to a
customer and is related to the 'Account' object through a master-
detail relationship. The 'Product Part' object stores information
about the details of each part associated with a particular
product, such as the name of the part and the cost of producing
the part. The 'Product Part' object is the child of the 'Sold
Product' object in a master-detail relationship. The sales director
of the company would like to view the total cost of producing all
the products that are sold to a customer on the customer's
account record. What solution should a Data Architect
recommend for this requirement?Choose 1 answer.
A. Create a flow to calculate the total cost, and add a button to
the Account detail page to allow users to trigger the flow.
B. Create Correct Answer C. Create one roll-up summary field
on the 'Account' object and another one on the 'Sold Product'
object to calculate the total cost.
The simplest way to meet this requirement is to create two roll-
up summary fields. A roll-up summary field on the 'Sold
Product' object can calculate the total cost of all the parts
associated with a particular product. Another roll-up summary
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Classroom. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75323 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now