Hello,
I got a question in my last exam, do you know the reply please ?Thanks.
You are designing a SQL Server Analysis Services cube un SQL Server for a company that sells insurance plans.
The insurance plan data is stored in a SQL Server data warehouse. Billing data for the insurance plan is extracted from an Oracle database. You need to recommend a solution to merge the insurance plan data and the billing data into a single cube. What should
you include in the recommendation ?
Answer area :
Number of data source views : ?
Minimum number of measure groups : ?
Minimum number of partitions in the cube : ?