The Microsoft MB6-704 PDF, MB6-704 practice exam and MB6-704 questions and answers at Lead2pass are written and prepared by Microsoft affiliated trainers and lecturers with decades of experience in the IT field. This ensures that you are equipped with the latest and most current information to give you a better chance of passing the Microsoft MB6-704 exam.
You are developing queries to fetch data from the CustTable table. CustTable contains a field named City. There is a non-unique cluster index named city Idx in the City field.
You need to fetch data from CustTable in ascending order based on City.
What are three possible SQL statements that achieve this goal? Each correct answer presents a complete solution.
A. Select CustTable order by city ASC;
B. Select CustTable index city;