Microsoft
MB7-702 · Question #5
MB7-702 Question #5: Real Exam Question with Answer & Explanation
Sign in or unlock MB7-702 to reveal the answer and full explanation for question #5. The question stem and answer options stay visible for context.
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
Unlock MB7-702 to see the answer
You've previewed enough free MB7-702 questions. Unlock MB7-702 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.