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? (Exhibit)
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