DRAG DROP
You install SQL Server Integration Services (SSIS) and develop an SSIS project to load a
data warehouse. The project defines 10 parameters that have different values for the
development, test and production environments. Some packages have additional
parameters defined.
You plan to deploy the SSIS packages to one server. The server will also host the
production data warehouse.
You need to deploy and configure the packages.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.

DRAG DROP
You develop a SQL Server Integration Services (SSIS) project named Project1 by using
SQL Server Data Tools (SSDT). Project1 contains a package named Package1.
You add a project parameter named EnvironmentText to Project1.
In SQL Server Management Studio (SSMS), you create the SSIS catalog.
You have the following requirements:

Configure Package1 so it can run within either a development environment or a test
environment.
Pass the value of an SSIS environment variable to the EnvironmentText project parameter.
The value of the environment variable must be different for each SSIS environment.
You need to deploy the SSIS project and configure the SSIS environment.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)

HOTSPOT
A company maintains separate environments for test, production, and quality assurance.
The company uses the project deployment model for SQL Server Integration Services
(SSIS) deployments.
You create an SSIS project to perform a weekly refresh of the company’s data warehouse
and cubes. The project has three packages.
You need to configure the project to ensure so that the test and production teams can run
each package without manually adding server-specific information.

Which program should you use?
To answer, select the appropriate program in the answer area.

You are creating a calculated measure in a sales cube by using a Multidimensional
Expressions (MDX) calculation. The cube includes a date dimension. The date dimension
has a hierarchy named Calendar that includes Calendar Year, Month, and Day attributes.
The calculated measure must calculate the year-to-date sales for the current slicer. The
MDX calculation must work for as many hierarchy levels as possible.
You need to create a calculated measure for the cube that meets the requirements.
Which expression should you use in the calculation designer? (More than one answer choice
may achieve the goal. Select the BEST answer.)

DRAG DROP
You have a business intelligence (BI) infrastructure.
You create a SQL Server Integration Services (SSIS) project that contains the packages for
the BI infrastructure.
You need to automate the deployment of the SSIS project. The solution must ensure that the
deployment can occur as part of an unattended Transact-SQL script.
Which three actions should you perform in sequence? To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.

You are designing a customer dimension for a multidimensional OLAP (MOLAP) database.
The dimension table will contain millions of rows of data.
Customer dimension attributes will come from the following two sources:
An enterprise resource planning (ERP) system that contains millions of rows of dat
a. Attributes from this source will be updated daily.
A marketing database that contains thousands of rows of data representing customers’
geographic information. Attributes from this source will be updated monthly.
Most report queries against the cube use attributes from both sources. Customers in the
cube dimension will frequently be filtered by the geographic attributes.
You need to design the dimension table and cube dimension to ensure that report queries
perform well, and minimize the time required to reprocess cube attributes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

You have two servers named Served and Server2. Both servers have SQL Server 2012
installed. Both servers have a SQL Server Integration Services (SSIS) catalog.
You are preparing a disaster recovery plan for a business intelligence (BI) solution.
You need to ensure that the SSIS catalog from Server1 can be restored to Server2.
Which two actions should you perform on Server1? Each correct answer presents part of the
solution.

DRAG DROP
You have a business intelligence (BI) infrastructure that contains three servers. The servers
are configured as shown in the following table.

You need to recommend a health monitoring solution for the BI infrastructure.
The solution must meet the following requirements:
Monitor the status of the Usage Data Collection feature.
Monitor the number of end-users accessing the solution.
Monitor the amount of cache used when the users query data.
Which health monitoring solution should you recommend using on each server? To answer,
drag the appropriate monitoring solutions to the correct servers. Each monitoring solution
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.

A company has a relational data warehouse, a SQL Server Analysis Services (SSAS)
database, and a SQL Server Reporting Services (SSRS) instance. The SSAS database
contains a cube named Sales. Shared data sources exist in SSRS for the relational and
SSAS databases. Each company department has its own report writers.
Report writers in the Marketing department want to create new reports by using Report
Builder. Many reports will include data generated by a custom formula that references data
stored either in a data warehouse table or in the Sales cube. The custom formula will
compare time periods across multiple products, categories, and regions.
You have the following requirements:
Ensure that only Marketing department report writers can access the custom formula.
Implement only one dataset.
Ensure that the dataset references the data source that will provide the fastest data retrieval.
You need to meet the requirements to support the Marketing department report writers.

What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

DRAG DROP
Your network contains a development environment, a staging environment, and a production
environment.
You have a SQL Server Integration Services (SSIS) project. All of the packages in the
project load data from files in a shared network folder. The packages use indirect XML
configurations to set the location of the network folder.
The project is deployed to the three environments. Each environment has a different set of
source files and a different network folder for the source files.
Currently, if an environment variable is missing, the package will use the network folder
specified in the package, not the folder specified in the XML configuration file.
You need to ensure that each time a package is executed, the network folder location
specified in the package is NOT used.
Which three actions should you perform in sequence? To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.