You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSRS01 runs SQL Server 2012 Reporting
Services (SSRS). SSRS is configured to run in native mode.
You are evaluating the SSRS predefined roles to determine which users should be
assigned to the roles.
Company security policy states that all users must be assigned the minimum permissions
to perform their required tasks.
Which role should users be assigned to enable them to view basic information about the
report server such as the schedule information in a shared schedule?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft
SQL Server 2012 environment and has recently deployed SQL Server 2012 Reporting
Services (SSRS).
The company will eventually use hundreds of SSRS reports. All the reports will use the
standard corporate branding, fonts and text styles. Many of the reports will also use
common functions that will be coded by developers.
You need to recommend a reporting strategy that enables all reports to use the corporate
branding and fonts and the function code. You need to be able to modify the corporate
branding and function code if required without recreating all the reports.
Where should the corporate branding, fonts and text styles and the function code should
be stored?

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSIS01 runs SQL Server 2012 Integration
Services (SSIS).
You need to determine which package configuration to use for SSIS packages. You need
to select a package configuration option that will allow you to store multiple configuration

properties and values and will enable multiple packages to use the configuration.
Which of the five package configuration options should you use?

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSIS01 runs SQL Server 2012 Integration
Services (SSIS).
You need to determine which package configuration to use for SSIS packages.
Which of the five package configuration options are always applied last, regardless of
where you place them in the configurations organizer?

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure which includes SQL Server
Integration Services (SSIS).
You need to create a project in SSIS that will contain multiple SSIS packages.
The variables and connection managers will be the same for all SSIS packages within the
project. You need to parameterize the connection manager strings to enable the properties
to be updated for subsequent package runs.
You need to ensure that calls to the catalog.start_execution stored procedure in the
Analysis Services database start your deployment model and that performance is
maximized.
Which two of the following options describe the solution that meets the requirements and
minimizes development effort? (Choose two).

You work as a Database Administrator (DBA) for a company named ABC.com. The
company has a Windows Azure subscription. The company uses a cloud-based SQL
Server environment hosted on SQL Azure.
You are using SQL Server Data Tools to create a SQL Server Integration Services (SSIS)
package. The package will use data from a source table to populate a fact table. You have
configured Table as the data access mode for the OLE DB source.

The fact table has a column named TotalSales. The source table has two columns named
CompletedSales and ConfirmedOrders.
You need to configure the SSIS package to discard any records with zero values in the
CompletedSales and ConfirmedOrders columns then populate the TotalSales column in the
fact table with the sum values of the CompletedSales and ConfirmedOrders columns.
How should you configure the data flow task?

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis
Services (SSAS). You have an SSAS cube named ABC-Cube1.
You need to configure ABC-Cube1 to use proactive caching and ensure the cache is
updated when the data changes after waiting for the default 10 second silence interval.
Data that has been cached for more than 30 minutes should be dropped and the storage of
the data and aggregations in the cube must be optimized.
What should you do?

You work as a Database Administrator (DBA) at a company named ABC.com.
A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis
Services (SSAS).
You have a large cube on ABC-SSAS01. The cube contains a single partition and a single
measure group. The cube contains many millions of rows of data.
You need to modify the cube to cope with the rapidly increasing amount of data.
You plan to configure a staging table that will be used to store only the data that has been
added since the last processing of the cube. The measure group will be partitioned by
month and records from the staging table will be inserted into the relevant partition. Record
deletions or updates will not be included in the staging table.
How should you modify the cube?

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A server named ABC-SSAS1 runs SQL Server Analysis Services (SSAS).
You are in the process of designing a monitoring strategy for the ABC-SSAS1. You want to
monitor custom trace events and detailed event durations for queries executed on the
server.
You connect to ABC-SSAS1 using SQL Server Management Studio.
Which two of the following actions should you perform next? (Choose two)

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
The company has a data warehouse named CorpDW. CorpDW is updated with
approximately 100 million new records every week outside business hours.
Data is sometimes queried at month level but more often is queried at day level using cube
processing and reports.

CorpDW contains a large fact table. You need to configure the table partitioning to ensure
that the performance of the queries is maximized.
Which two of the following options describe how you should you partition the table?
(Choose two).