nerdexam
Microsoft

70-448 · Question #285

70-448 Question #285: Real Exam Question with Answer & Explanation

Sign in or unlock 70-448 to reveal the answer and full explanation for question #285. The question stem and answer options stay visible for context.

Question

You create a SQL Server 2008 Reporting Services (SSRS) report. You plan to create a list of customers by using a List control. For each customer in the List control, you plan to include a table that contains the orders for that customer. T he customer data is stored in the Customers table in the data source, and the order data is stored in the Orders table. You need to define the required dataset or datasets for this report. What should you do?

Options

  • ACreate a query that joins the two tables in the data source by using the JOIN clause.
  • BCreate a query that combines the two tables in the data source by using the UNION operator.
  • CCreate a query for each table. Group both tables on the column that is used to join the tables.
  • DCreate a query for each table. Sort both tables on the column that is used to join the tables.

Unlock 70-448 to see the answer

You've previewed enough free 70-448 questions. Unlock 70-448 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.

Full 70-448 Practice