Home » Microsoft » 70-517 » Which FQL statements should you use?
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: BDF
Explanation/Reference:
B (not E):
* The ordered variant of NEAR, and requires an ordered match of the terms. The ONEAR N terms within a certain operator can be used to restrict the result set to items that have 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
