You are designing a data warehouse hosted on SQL Azure. The data warehouse currently includes the
dimUser and dimDistrict dimension tables and the factSales fact table. The dimUser table contains records for
each user permitted to run reports against the warehouse, and the dimDistrict table contains information about
sales districts. The system is accessed by users from certain districts, as well as by area supervisors and users
from the corporate headquarters. You need to designa table structure to ensure that certain users cansee
sales data for only certain districts. Some users must be permitted to see sales data from multiple districts.
What should you do?

You are developing a project that contains multipleSQL Server Integration Services (SSIS) packages. The
packages will be deployed to the SSIS catalog. One of the steps in each package accesses an FTP site to
download sales transaction data. You create projectparameters to store the username and password thatare
used to access the FTP site. You need to ensure that the username and password values are encrypted when
they are deployed. What should you do?

You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasksand
no other tasks. The package and all three Execute SQL tasks have their TransactionOption property set to
Supported. You need to ensure that if any of the Execute SQL tasks fail, all three tasks will roll back their
changes. What should you do?

You are designing a SQL Server Integration Services(SSIS) package that uploads a file to a table named
Orders in a SQL Azure database. The company’s auditing policies have the following requirements:
An entry must be written to a dedicated SQL Server log table named OrderLog.
The entry must be written as soon as the file upload task completes.
You need to meet the company’s policy requirements.Which event handler should you use?

You are designing a data warehouse with two fact tables. The first table contains sales per month and the
second table contains orders per day. Referential integrity must be enforced declaratively. You need to design a
solution that can join a single time dimension to both fact tables. What should you do?

You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services
(DQS). You need to complete the post-installation configuration. What should you do?

You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services
(DQS). You need to complete the post-installation configuration. What should you do?

You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application tomodify
an existing knowledge base. In the mapping configuration, two of the three columns are mapped to existing
domains in the knowledge base. The third column, named Team Type, does not yet have a domain. You need
to complete the mapping of the Team Type column. What should you do?

You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rowsfrom a
SQL Azure database. The project uses the Package Deployment Model. This project is deployed to SQL Server
on a test server. You need to ensure that the project is deployed to the SSIS catalog on the production server.
What should you do?

You are developing a SQL Server Integration Services (SSIS) package. To process complex scientific data
originating from a SQL Azure database, a custom task component is added to the project. You need to ensure
that the custom component is deployed on a test environment correctly. What should you do?