Microsoft SQL Server 2008, Implementation and Maintenance

MCSA : SQL Server 2008 70-432 TSQL Exam Paper with Solution

You work as a database administrator at ABC.com. ABC.com is planning to migrate a SQL Server 2000 application to SQL Server 2008 R2.After the migration, you want to keep an eye on the performance of the SQL Server 2008 R2 instance.   You then configure a SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes.

Which two of the following best describes these two event classes respectively? (Choose two.)

A. The Deprecation Final Support event class reveals that a feature will be removed in the next important

release of SQL Server.

B. The Deprecation Announcement event class reveals that a feature will be removed in the next important

release of SQL Server.

C. The Deprecation Announcement event class reveals that a feature will be removed in an upcoming edition

of SQL Server.

D. The Deprecation Final Support event class reveals that a feature will be removed in an upcoming edition of SQL Server.

Correct Answer: AC

You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008 R2 instance that includes an On-Line Analytical Processing (OLAP) database.
The OLAP database hosts a dimension table, named ABCClients, which has hourly information updates configured. As a result, ABCClients has a large quantity of information that is no longer used. You have been instructed to make sure that the amount of space used by the ABCClients table is reduced with as little administrative effort as possible.
Which of the following actions should you take?
A. You should consider manually deleting the information that is no longer used.
B. You should consider making use of page compression.
C. You should consider making use of the Disk Cleanup Wizard.
D. You should consider making use of folder compression.


Correct Answer: B

How to move Application to Cloud

Move Application to Cloud

Application belongs to Adatum to keep a track, Submit and also the business process expenses. A datum’s policy is to submit their monthly Expenses to the Company for Reimbursement.

                                                             

Download the Sample Code from http://msdn.microsoft.com/en-us/library/ff728592.aspx

Install the setup, open DependencyChecker.exe

When DependencyChecker.exe is clicked, it displays the list of pre requisites to be installed. Install all the Prerequisites

Now open the desired project

File -> Open -> Project/solution -> aExpense.sln

Now debug the project

After the Debug is started the output is then ready to appear in a browser

It now shows the site’s security certificate is not trusted!

Click Proceed anyway

Click on ADATUM\johndoe(Group: ‘Employee’)

Continue with login should be clicked

Enter DATE: TITLE:

Description,

 Amount,

In drop down select REIMB.METHOD as Cash and APPROVER ADATUM\mary

Add receipt by clicking browse

Adding Lunch and Dinner

 

OUTPUT:

Logging into manager’s role:

Manager can now login and review the reimbursements

He now has the authority to approve it

 

Worker can cross check it by logging into his account again