070-489 Free Dumps Study Materials
Question 17: A legal company uses SharePoint for document and records management. You search all
documents by using extractors and managed properties. FAST Query Language (FQL) is enabled for
the result sources, and the content of the document is indexed as full text. All documents are named
by using the following pattern: "AAA-Axxxx-AA".
You must find documents that were created in May 2012 and contain the ordered keywords "liable",
"advocate", and "adjudication". Results that are returned must include only document names that
begin with "HCT-Q" and end only with "AB".
You need to create the FQL query that returns the required results.
Which FQL statements should you use? (Each correct answer presents part of the solution. Choose all
that apply.)
A. Write> =05/01/2012 and write<=05/31/2012
B. string('liable advocate adjudication", mode="onear")
C. title:HCT-Q*
D. title:HCT-Q????-AB
E. NEAR (liable, advocate, adjudication)
F. write:range (2012-05-01, 2012-05-31)
Correct Answer: B,D,F
Explanation:
B (not E):
The ordered variant ofNEAR, and requires an ordered match of the terms.
TheONEARoperator can be used to restrict the result set to items that haveNterms within a certain
distance of Returns only items that don't match the operand. The operand may be any valid FQL
expression.one another.
D (not C):
*All documents are named by using the following pattern: "AAA-Axxxx-AA".
*Results that are returned must include only document names that begin with "HCT-Q" and end only
with "AB".
F (not A):
*Range. Enables range matching expressions. The RANGE operator is used for numeric and date/time
managed properties.
*FQL provides the datetime data type for date and time. The following ISO 8601-compatible datetime
formats are supported in queries: YYYY-MM-DD YYYY-MM-DDThh:mm:ss YYYY-MM-DDThh:mm:ssZ
YYYY-MM-DDThh:mm:ssfrZ
Reference: FAST Query Language (FQL) syntax reference