You need to perform the following maintenance tasks: Identify unused indexes
DRAG DROP
You have a database named database1. Each table in database1 has one index per column.
Users often report that creating items takes a long time.
You need to perform the following maintenance tasks:
Identify unused indexes.
Identify indexes that need to be defragmented.
What should you use?
To answer, drag the appropriate function to the correct management task in the answer
area. (Answer choices may be used once, more than once, or not at all.)
You need to design a solution that meets the requirements
You are designing a SQL Server Integration Services (SSIS) solution. The solution will
contain an SSIS project that includes several SSIS packages. Each SSIS package will
define the same connection managers and variables.
You have the following requirements:
The deployment model must support changing the content of connection strings by using
parameters at execution time.
The deployment model must automatically log events to the SSISDB database.
Maximize performance at execution time.
You need to design a solution that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable
You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains
several dimensions, a local measure group, and a linked measure group. Both measure
groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft
Excel 2010 PivotTable What-If Analysis.
What should you do before the partition can be write-enabled?
You need to reduce the amount of time it takes to execute the query
You execute the following code.
After populating the Employees table with 10,000 rows, you execute the following query:
You need to reduce the amount of time it takes to execute the query.
What should you do?
which tab should you enter the MDX expression?
HOTSPOT
You are setting role permissions for a SQL Server Analysis Service (SSAS) cube.
You plan to grant Read access for specific attribute members only to specific Active
Directory security groups.
You need to enter a Multidimensional Expressions (MDX) expression to configure the
attribute member access.
On which tab should you enter the MDX expression? To answer, select the appropriate tab
in the answer area.
Which expression should you use?
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to add a calculated member to the Customer dimension to evaluate the sum of
values for the United Kingdom and the United States.
Which expression should you use? (To answer, drag the appropriate expression to the
answer area.)
Which type of dimension should you create for each table?
DRAG DROP
You have a database named DB1. DB1 contains four tables named FactSales, DimTime,
DimCustomer, and DimEmployee. A sample from DimEmployee is shown in the following table.
A sample from DimCustomer is shown in the following table.
A sample from FactSales is shown in the following table.
You need to identify which type of dimension must be created for each table.
Which type of dimension should you create for each table? To answer, drag the appropriate
dimensions to the correct tables. Each dimension may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
Which tool should you use?
You have a server that has SQL Server 2012 installed.
You need to identify which parallel execution plans are running in serial.
Which tool should you use?
You need to upgrade to SSRS 2012 with the minimum downtime and hardware requirements
You have a SQL Server Reporting Services (SSRS) 2008 instance integrated with an
Internet-facing Microsoft SharePoint 2010 farm. PerformancePoint Services and Excel
Services are installed and configured.
You need to upgrade to SSRS 2012 with the minimum downtime and hardware
requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
You need to ascertain the memory consumed by each object in the SSAS instance
You are working with multiple tabular models deployed on a single SQL Server Analysis
Services (SSAS) instance.
You need to ascertain the memory consumed by each object in the SSAS instance.
What should you do?