You are designing a data warehouse that uses SQL Server 2012. You are preparing to update the
contents of a fact table that contains a non-clustered columnstore index.
You need to run an update statement against the table.
What should you do first?

You are using SQL Server Data Tools to develop a SQL Server Integration Services (SSIS) project.
The first package that you create in this project contains a package connection that accesses a Microsoft
Excel file. Additional packages in the project must also access this file.You need to define and reuse the Excel file connection in all project packages.
What should you do?

Your company uses a proprietary encryption algorithm to secure sensitive data. A custom cryptographic
assembly was developed in Microsoft .NET and is used in several applications.A SQL Server Integration Services (SSIS) package is importing data into a Windows Azure SQL Database
database. Some of the data must be encrypted with the proprietary encryption algorithm.
You need to design the implementation strategy to meet the requirements while minimizing
development and deployment effort and maximizing data flow performance.
What should you do?

You have Master Data Services (MDS) in a SQL Server deployment. You need to deploy a model that
contains data to the MDS repository. What should you use?

Your company has several line-of-business applications. The applications use a server that has SQL
Server installed and contains several databases.You need that the business applications can access curated and validated data from the databases.
Which features should you deploy to the server?

HOTSPOT
You have a data warehouse that is hosted in a SQL Server instance. The data in the data warehouse is
loaded by running bcp.exe You discover that the transaction logs regularly fill up the local hard disk on
the server and that a WRITELOG wait is present. You need to reduce the amount of disk space used to
store the transaction logs and to remove the WRI7TLOG wait.
Which two database property settings should you modify? To answer, select the appropriate settings in
the answer area.

DRAG DROP
You need to design a data load strategy for a data warehouse fact table. The solution must use an
ordered data load.
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 have a secured database that contains all of the customer data for your company. You plan to use
a project deployment model.
You need to create a SQL Server Integration Services (SSIS) package that connects to the database by
using a dedicated username and password. The solution must ensure that the password used for the
connection string is encrypted.
Which two actions should you perform? (Select Two)

You have a server named SQL1 that has SQL Server Integration Services (SSIS) installed. SQL1 has eight
CPUs, 8 GB of RAM, RAID-1 storage, and a 10-gigabit Ethernet connection.
A package named Package1 runs on SQL1. Package1 contains 10 data tasks. Package1 queries 3 GB of
data from the source system.You review the performance statistics on SQL1 and discover that Package1 executes slower than
expected.
You need to identify the problem that is causing package1 to execute slowly.
Which performance monitor counter data should you review?

You are developing a SQL Server Integration Services (SSIS) package that loads data from a source
transactional tables in a data warehouse.
You discover that one of the data flows loads incorrect data to one of the destination tables.
You need to identify the cause of the incorrect data flow. Which tool should you use?