You need to develop a BISM that meets the business requirements for ad-hoc and daily operational analysis.
You must minimize development effort.
Which development approach and mode should you use?

You are designing a fact table in a SQL Server database.The fact table must meet the following requirements:
Include a columnstore index.
Allow users to choose up to 10 dimension tables andup to five facts at one time.
Maximize performance of queries that aggregate measures by using any of the 10 dimensions.
Support billions of rows.
Use the most efficient design strategy.You need to design the fact table to meet the requirements.Whatshould
you do?
(More than one answer choice may achieve the goal.Select the BEST answer.)

You are designing a subscription strategy for a SQLServer Reporting Services (SSRS) report.
You have an application that populates a table withuser-specific subscription schedules and report formats.
You need to ensure that users can receive reports by email according to their preferences.
Email messages will be sent via an internal mail server.
What should you do? (More than one answer choice may achieve the goal.Select the BEST answer.)

You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube.
For Customer A, Projected Revenue is defined as 150percent of the Total Sales for the customer.
For all other customers, Projected Revenue is defined as 110 percent of the Total Sales for the customer.
You need to calculate the Projected Revenue as efficiently as possible.Which calculation should you use?
(More than one answer choice may achieve the goal.Select the BEST answer.)

You need to re-establish subscriptions on SSRS01.
What should you do?

You are designing a partitioning strategy for a large fact table in a Manufacturing data warehouse.
Tens of millions of new inventory fact records are loaded into the data warehouse weekly, outside of business
hours.
Most queries against the database are generated by reports and by cube processing.
Data is frequently queried at the day level and occasionally at the month level.
You need to partition the table to maximize the performance of queries.
What should you do? (More than one answer choice may achieve the goal.Select the BEST answer.)

You need to implement security in the cube to limitthe sites visible to each user.
What should you do?

You need to define the trend calculation for the sales performance KPI.
Which KPI trend MDX expression should you use?

You are designing a subscription strategy for a SQLServer Reporting Services (SSRS) report.
You have an application that populates a table withuser-specific subscription schedules and report formats.
You need to ensure that users can receive reports by email according to their preferences.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

DRAG DROP You are designing a SQL Server Reporting Services (SSRS) solution. A report project must
access multiple SQL Azure databases.
Each database is on a different host. The databases have identical schema and security configurations. You
have the following requirements:
The report must support subscriptions.
Users must be able to select the host when runningthe report. What should you do?
To answer, drag the appropriate phrase or phrases from the list to the correct location or locations in the
answer area.
(Answer choices may be used once, more than once, or not all.)

Exhibit: