PrepAway - Latest Free Exam Questions & Answers

Which two statements are true?

In SQL Server Profiler you view the following query from Microsoft Dynamics NAV:
SELECT SUM(“Amount”) FROM “CRONUS International Ltd_$Sales Line” WHERE
“Document No_” = ‘ORD-980001’
Which two statements are true? (Each correct answer presents a complete solution. Choose
two.)

PrepAway - Latest Free Exam Questions & Answers

A.
There is no SumIndexField amount on the Sales Line table for a key that includes the
Document No. field.

B.
The MaintainSIFTIndex property is set to FALSE for a key that includes the Document
No. field and the Amount field set as SumIndexField.

C.
All keys that include the Document No. field and the Amount field set as SumIndexField
are disabled.

D.
There is no SumIndexField Technology (SIFT) bucket enabled in the property
SIFTLevelsToMaintain for the Amount field for a key that includes the Document No. field
and the Amount field set as SumIndexField.

Explanation:
Ref: http://msdn.microsoft.com/en-gb/library/dd301348.aspx


Leave a Reply