Which configuration type should you use?
You are designing a SQL Server Integration Services(SSIS) package configuration strategy.
The package configuration must meet the following requirements:
Include multiple properties in a configuration.
Support several packages with different configuration settings.You need to select the appropriate configuration.
Which configuration type should you use? To answer,select the appropriate option from the drop-down list in
the dialog box.
You need to roll back the compatibility level of the Research database.What should you do?
You need to roll back the compatibility level of the Research database.What should you do?
Which development approach and mode should you use?
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 need to design the fact table to meet the requirements.Whatshould you do? (More than one answer choice may
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 need to ensure that users can receive reports by email according to their preferences
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 need to calculate the Projected Revenue as efficiently as possible.Which calculation should you use? (Mor
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
You need to re-establish subscriptions on SSRS01.
What should you do?
You need to partition the table to maximize the performance of queries
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
You need to implement security in the cube to limitthe sites visible to each user.
What should you do?
Which KPI trend MDX expression should you use?
You need to define the trend calculation for the sales performance KPI.
Which KPI trend MDX expression should you use?