You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company
named NaproStar which uses SQL Server2008. You work as the technical support. Now you
receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to you. You
use SQL Server 2008 Reporting Services (SSRS) to create a solution. There is a table in the
solution. The table is named FinishedBills. The table contains two columns respectively
named BillKey and ClientKey. You have to create a measure, the number of customers who
have placed bills is returned by the measure. So what action should you perform?
A.
The Usage property should be set to Count of rows and the Source Column property
should be set to OrderKey.
B.
The Usage property should be set to Count of rows and the Source Column property
should be set to CustomerKey.
C.
The Usage property should be set to Distinct count and the Source Column property
should be set to OrderKey.
D.
The Usage property should be set to Distinct count and the Source Column property
should be set to CustomerKey