nerdexam
Access_Data

A30-327 · Question #26

You need to search for specific data that are located in a Microsoft Word document. You do not know the exact spelling of this data. Using the Index Search Options as displayed in the exhibit, which…

The correct answer is A. check the Fuzzy box; check the File Name Pattern box; type *.doc in the pattern container. Option A is correct because "Fuzzy" search is specifically designed to find approximate matches when you don't know the exact spelling of a term - it broadens results to include similarly spelled words. Pairing it with the File Name Pattern .doc correctly limits the search to…

Keyword Searching and Filtering

Question

You need to search for specific data that are located in a Microsoft Word document. You do not know the exact spelling of this data. Using the Index Search Options as displayed in the exhibit, which changes do you make in the Broadening Options and Search Limiting Options containers?

Options

  • Acheck the Fuzzy box; check the File Name Pattern box; type *.doc in the pattern container
  • Bcheck the Stemming box; check the File Name Pattern box; type *.doc in the pattern container
  • Ccheck the Synonym box; check the File Name Pattern box; type *.doc in the pattern container
  • Dcheck the Stemming box; check the File Name Pattern box; type %.doc in the pattern container

How the community answered

(13 responses)
  • A
    69% (9)
  • B
    23% (3)
  • D
    8% (1)

Explanation

Option A is correct because "Fuzzy" search is specifically designed to find approximate matches when you don't know the exact spelling of a term - it broadens results to include similarly spelled words. Pairing it with the File Name Pattern *.doc correctly limits the search to Microsoft Word documents, where * is the standard wildcard character for file system patterns.

Why the distractors are wrong:

  • B (Stemming) finds variations of a word by its root (e.g., "run" → "running", "ran"), which addresses word forms - not spelling uncertainty.
  • C (Synonym) expands results to include words with similar meanings, which is irrelevant when your problem is not knowing how a word is spelled.
  • D (Stemming + %.doc) fails on two counts: Stemming is the wrong broadening option, and % is a SQL wildcard (used in database LIKE queries), not a file system wildcard - * is correct for file patterns.

Memory tip: Think F for Fuzzy = F for Fuzzily-spelled - when spelling is uncertain, Fuzzy is your friend. And remember that file patterns use * (like *.doc), not %, which belongs in SQL databases.

Topics

#Fuzzy matching#File pattern filtering#Index search options#Keyword searching

Community Discussion

No community discussion yet for this question.

Full A30-327 Practice