you need to identify if there is at least another record that match criteria.
The Filter function finds records in a table that satisfy a formula. Use Filter to find a set of records that match one or more criteria and discard those records that don't.
The LookUp function finds the first record in a table that satisfies a formula. Use LookUp to find a single record that matches one or more criteria.
A
---
A custom mobile app must be created to allow salespeople to add or search by pharmacy name. Pharmacy records must be uniquely identified by pharmacy name, address, contact name, and phone number.
as we need to search by pharmacy name but pharmacies are uniquely identified by name, address, contact name and phone number, the results if we are searching by name only may contains more records --> filter
• A custom mobile app must be created to allow salespeople to add or search by pharmacy name.
• Pharmacy records must be uniquely identified by pharmacy name, address, contact name, and phone number.
Correct!
A. Filter
The correct answer is C. LookUp.
The LookUp function is used to retrieve a record from a table based on a unique identifier. In this case, the unique identifier is the pharmacy name.
The Filter and Find functions can also be used to search for pharmacy records. However, they will return all records that match the search criteria, including records that have duplicate pharmacy names. The LookUp function will only return the record with the specified pharmacy name.
pharmacy name that we are searching is told to be uniquely identifiable, due to that they are only looking for one record to return (its not a street name or city theyre using) as they only want one record lookup is correct.
damn annoying though
To create a mobile app that allows salespeople to add or search by pharmacy name and have records uniquely identified by pharmacy name, address, contact name, and phone number, you should use the LookUp function expression. The LookUp function allows you to search for a specific record in a dataset based on one or more specific field values and return the corresponding information. In this case, you can use LookUp function to search for a pharmacy record based on the pharmacy name, address, contact name, and phone number, and return the record that matches those criteria. This will ensure that each pharmacy record is uniquely identified by these four fields and can be easily searched and accessed by salespeople through the mobile app.
A custom mobile app must be created to allow salespeople to add or search by pharmacy name.
Pharmacy records must be uniquely identified by pharmacy name, address, contact name, and phone number.
This section is not available anymore. Please use the main Exam Page.PL-400 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
MarioM
Highly Voted 2 years, 3 months agoosx
5 months, 1 week agoKepty
Highly Voted 2 years, 3 months agoJuan0414
Most Recent 3 months, 3 weeks agoTheRealTrompie99
4 months, 2 weeks agohai297
8 months, 3 weeks agoMikeAWS
1 year, 3 months agouberlord
1 year, 3 months ago7acdde5
1 year, 5 months agonadien
1 year, 6 months agoDimpleG
1 year, 11 months agoosx
5 months, 1 week agochiari_do
1 year, 7 months agoCRMBug
2 years, 1 month ago