PrepAway - Latest Free Exam Questions & Answers

Category: 70-432 (v.1)

Exam 70-432: TS: Microsoft SQL Server 2008,
Version: TS: Microsoft SQL Server 2008, Implementation and Maintenance (update January 2014)

What utility should you run to create the requested package?

You work as a database administrator at ABC.com. You have just installed Microsoft SQL Server
Management Studio on one of ABC.com’s workstations and the Microsoft Business Intelligence
Development Studio. You have been requested to design a 12 table transactional package to be
stored on an offsite server’s msdb data store.
You decide that BIDS in this scenario is an overkill and you decide to uninstall it. What utility
should you run to create the requested package?

What steps should you take?

DRAG DROP
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_DB1. As part of your backup method of ABC_DB1,
you do a Full backup every Sunday at 01:00, you do a differential backup weekdays at 22:00, and
you do transactional log backup weekdays at 08:00; 12:00 and 16:00.
You have received notification that the user database data files have failed on Thursday at 15:00.
You need to ensure that ABC_DB1 are retrieve as quickly as possible with as small as possible
amount of data loss.
What steps should you take? Use only steps that apply.

How can you meet her request while keeping the database backup files in order for future backups and restores?

DRAG DROP
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_Prod. During the night a daily full backup of
ABC_Prod is started at 03:15, a differential backup is performed every 90 days minutes and a
transaction log backup is performed every 20 minutes.

This particular day your CEO has requested that you make an extra full backup during the lunch
break starting at 11.30. How can you meet her request while keeping the database backup files in
order for future backups and restores?

How should you remedy the situation?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. The SQL Server 2008 instance hosts quite a few applications. ABC also has a server
named ABC-SR43 that is used to store log files.
You have to set up a new job that stores log files on ABC-SR43. You create a new account
ABC\Log_Account. You set it up to be run by the SQL Server Agent Services.
However, your job fails to store any log files on ABC-SR43. After some investigation you notice
that the job does not have permissions to store files on ABC-SR43.
How should you remedy the situation? Select the best option.

How should you implement the ABC Training Policy?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that has a table named ABC_Training. ABC_ Training contains a column named
ABC_Distance. A new ABC.com training policy states that the training (ie. The ABC_Distance
column in the ABC_Training table) cannot be increased or decreased by more than 3%.

How should you implement the ABC Training Policy?

How can this be achieved and still keep the performance and functionality of the web application?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_DB. ABC.com contains a lot of customer data
which is processed by the Web application. You need to keep the customer information safe since
it is confidential. This information includes files of data, backups, and log files.
How can this be achieved and still keep the performance and functionality of the web application?
Select one or two.

What T-SQL code should you use?

You work as a database administrator at ABC.com. ABC.com is using two SQL Server 2008
sample named ABCSmp1 and ABCSmp2. Furthermore, ABCSmp1 contains a database named
ABC_DB. A ABC.com user named Mia Hamm uses her logon MiaHamm to log on to the database
on ABCSmp1. During the week you have transferred ABC_DB to ABCSmp2. You manually
recreate the Mia Hamm login on ABCSmp2. However, when she tries to login on ABC_DB at
ABCSmp2, she received an error message stating that she is not allowed access. Mia Hamm
needs to access ABC_DB and you need to make it happen.
What T-SQL code should you use? (Each correct option is part of the answer. Choose TWO)

Which T-SQL statement should you insert at line 03 to make the batch meet the requirement in this scenario?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. You have received instructions from management to allow the users at ABC.com on the
SQL Server sample to use the OPENROWSET() function to search remote information sources.
You study incomplete code in the exhibit carefully. (Line numbers are used for reference purposes
only)
Exhibit:
01. sp_configure ‘show advanced options’, 1
02. RECONFIGURE
03.
04. RECONFIGURE
05. GO
06.

07. SELECT a.*
08. FROM OPENROWSET(‘SQLNCLI’, ‘Server=Madrid;Trusted_Connection=yes;’,
09. ‘SELECT GroupName, Name, DepartmentID
10. FROM AdventureWorks.HumanResources.Department
11. ORDER BY GroupName, Name’) AS a;
12. GO
Which T-SQL statement should you insert at line 03 to make the batch meet the requirement in
this scenario?

What actions should you take??

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. The a SQL Server 2008 instance is used on a Windows Server 2000 server and uses
the mixed authentication mode. Management wants you to ensure the following:
•SQL Server 2008 logins must have the same password complexity rules which are enforced by
Windows Server 2000 for authentication.

•Full compliance of all users with regarding to adhering to the password complexity rules.
What actions should you take?? (Each correct option is part of the answer. Choose TWO)


Page 1 of 1312345...10...Last »