You are a professional level SQL Sever 2008 Database Administrator.
A SQL Server 2008 instance at the New York central site is managed by you, and it is called Ins01.
There is a sales team in your company, and their task is to finish purchase orders for customer requests.
The sales team updates data regularly in a local database by utilizing their portable computers.
When the central site is connected by portable computers, a database named Sales will be synchronized
with
the local database. A duplication model will be created to duplicate the local database to the Sales
database.
The requirements listed below should be satisfied by the duplication model:
First, when the same data is updated by multiple users independently, there should be no data conflicts.
Secondly, sensitive data such as product price cannot be updated by the sales team.
Thirdly, the data should be synchronized by the sales team not only at scheduled times but also on demand.
The best model should be identified to have data duplicated, and you should be reduced the development efforts to the least.
Which action will you perform?

• A. You should utilize snapshot duplication along with each portable computer that is set up as a subscriber.
• B. You should utilize transactional duplication along with each portable computer that is set up as a publisher.
• C. You should utilize merge duplication along with each portable computer that is set up as a subscriber.
• D. You should utilize SQL Server Integration Services (SSIS) to promote the date modification and pull updates to the Sales database along with the SSIS packages, on demand.

You are a professional level SQL Sever 2008 Database Administrator.
A database is included by the instance, and a table named EmployeeData is contained by the database.
There is a column named Profile in the EmployeeData table. Microsoft Office Word 2003 documents are stored in the column.
The space utilized by the Profile column should be cut to the least. In addition, a reasonable performance should be maintained to retrieve the content of the column.
Which action will you perform?

• A. PAGE LEVEL compression should be utilized for the EmployeeData table.
• B. The Profile column should be implemented as a CLR user-defined type.
• C. ROW compression should be utilized for the EmployeeData table.
• D. The Profile column should be stored by utilizing filestream storage, and the NTFS file system compression should be utilized.

You are designing a database solution by using SQL Server 2008.
The database has a large number of tables that have columns that contain sensitive data. The sensitive data must be protected.
You need to choose an encryption strategy that has the minimum effect on the performance of the server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Use Transparent Data Encryption (TDE).
• B. Use Encrypting File System.
• C. Use Bitlocker Encryption.
• D. Use Cell-Level Encryption.

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named
Wiikigo.
There is a team of database administrators in your company.
SQL Server 2008 Integration Services (SSIS) packages are created on the test server in a shared
project by a team of application developers. A fixed cache file is required by one of the packages.
The company will deploy the packages to the production server on completion of development.
The production server is available only to the database administrators.
Since you are the technical support, you need to confirm that the project can be deployed
successfully to the production server by the application developers.
Which action will you perform to achieve the goal?

• A. To achieve the goal, a direct package configuration should be created for each package.
• B. To achieve the goal, an indirect package configuration should be created for all packages.
• C. To achieve the goal, the Import and Export Wizard should be utilized to save packages.
• D. To achieve the goal, a deployment utility should be created for the SSIS project.