QUESTION 1
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?
A. Use the bulk copy program.
B. Use the DTS Designer.
C. Use the Microsoft SQL Server Import and Export Wizard.
D. Use Process Control Tool.
E. Use the Package Migration Wizard.
F. Use the Process Control Tool
G. Use the ISIS.
Answer: C
Explanation:
QUESTION 2
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.
Answer:
QUESTION 3
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?
Answer:
QUESTION 4
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.
A. You should set up ABC\Log_Accoun as a Remote Service account.
B. You should set up ABC\Log_Accoun as a Domain service account.
C. You should set up ABC\Log_Accoun as a Local Service account.
D. You should set up ABC\Log_Accoun as a Local System account.
E. You should set up ABC\Log_Accoun as a Network Service account.
F. You should set up ABC\Log_Account as a Domain account.
Answer: F
Explanation:
The service startup account defines the Microsoft Windows account in which SQL Server Agent
runs and its network permissions. SQL Server Agent runs as a specified user account. For
compatibility with earlier versions of SQL Server, SQL Server Agent can also run as the Local
System account.
In this scenario you should select a Domain account, which allows sufficient permissions and
improved security.
QUESTION 5
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?
A. You should consider developing a view which rolls back non-compliant ABC.com policy
changes to ABC_Distance.
B. You should consider developing a stored procedure which rolls back non-compliant ABC.com
policy compliant changes to the ABC_Distance column.
C. You should consider developing a primary key constraint to the ABC_training table which only
contains valid values on ABC_Distance.
D. You should consider developing a create trigger which rolls back non-compliant ABC.com
policy changes to the ABC_Distance column.
E. You should consider developing an update trigger which rolls back non-compliant ABC.com
policy changes to the ABC_Distance column.
F. You should consider developing a delete trigger which rolls back non-compliant ABC.com policy
changes to the ABC_Distance column.
Answer: E
Explanation:
