Microsoft
MB7-702 · Question #5
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…
The correct answer is 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. See the full explanation below for the reasoning.
Question
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.)
Options
- AThere is no SumIndexField amount on the Sales Line table for a key that includes the Document No. field.
- BThe MaintainSIFTIndex property is set to FALSE for a key that includes the Document No. field and the
- CAll keys that include the Document No. field and the Amount field set as SumIndexField are disabled.
- DThere is no SumIndexField Technology (SIFT) bucket enabled in the property SIFTLevelsToMaintain for
How the community answered
(22 responses)- A73% (16)
- C9% (2)
- D18% (4)
Community Discussion
No community discussion yet for this question.