|
Braindumps of 70-447
MCDBA
Skills to MCITP Database Administrator by Using
Microsoft SQL Server 2005
Exam Questions, Answers,
Braindumps (70-447)
Hi
all.
I think
it was tough but thanks to
www.examcheets.com . I purchased their study
material and got through. The stuff had drag and drops,
exhibits and all that is required for the exam.
Question: 1
You work
as DBA at Company .com. You administer two Windows
Server 2003 computers named Company A and Company B. You
install SQL Server 2005 on both Company A and Company B
to host a new company database. Company A hosts a
read-write copy of the company database in which all
changes are made. Company B subscribes to a publication
on Company A and is only used for reporting. A Windows
domain administrator provides you with a domain user
account named SQL SRV to use as the security context for
the SQL Server services. A password policy of 42 days
exists in the Default Domain Group Policy object (GPO).
You
install the database on Company A and Company B and
configure replication. Everything works fine for six
weeks, but then all SQL Server services fail. You need
to correct the problem. What should you do?
A. Ask
the Windows domain administrator to grant the Log on as
service right to the SQL SRV domain user account.
B.
Configure the SQL SRV domain user account with a new
strong password. Configure the new password in the
properties of each SQL Server service that failed.
C. Create
a local user account on Company A named Company A and a
local user account on Company B named Company B.
Configure Company A and Company B to run under the
context of the appropriate local user account.
D. Ask
the Windows domain administrator to grant the SQL SRV
domain user account membership in the Domain Admin
group.
Answer: B
Question: 2
You are a
database administrator of two SQL Server 2005 computers
named Company A and Company B. You have a Microsoft .NET
application that has been modified so that it now
accesses a database on Company B in addition to Company
A. You do not want the user application to connect
directly to Company B. You need to enable the data
retrieval from Company B while maintaining the ability
to assign different permissions to different users who
use the .NET application. What should you do?
A. Change
the .NET application to define a new Server connection
to Company B.
B.
Configure a linked Server on Company A to point to
Company B.
C. Change
the stored procedures called by the .NET application to
include the OPENXML command.
D.
Configure a linked Server on Company B to point to
Company A.
Answer: B
Question: 3
You are a
database administrator for Company .com. Your company
uses a different company's application that is based on
SQL Server 2005 Standard Edition. The application
executes a query that uses an index query hint. The
index query hint is not suitable for your environment,
but you cannot modify the query. You need to force the
application to use a different query execution plan.
What should you do?
A. Create
a plan guide for the query.
B. Clear
the procedure cache.
C. Create
a new covering index on the columns that the query uses.
D. Update
the statistics for all of the indexes that the query
uses.
Answer: A
Question: 4
You are a
database administrator for Company .com. Your SQL Server
2005 computer contains one user database that holds
sales transaction information. Users report that the
queries and stored procedures that they use every day
are taking progressively longer to execute. You also
notice that the amount of free disk space on the SQL
Server computer is decreasing. You need to create a
maintenance plan to correct the performance and storage
problems. What are two possible ways to achieve this
Goal t? (Each correct answer presents a complete
solution. Choose two.)
A. In the
SQL Server Maintenance Plan Wizard, use the Check
Database Integrity option.
B. In the
SQL Server Maintenance Plan Wizard, use the Reorganize
Index option.
C. In the
SQL Server Maintenance Plan Wizard, use the Shrink
Database option.
D. In the
SQL Server Maintenance Plan Wizard, use the Clean Up
History option.
E. In the
SQL Server Maintenance Plan Wizard, use the Execute SQL
Server Agent Job option.
Answer: B, C
Question: 5
You are a
database administrator for Company .com. You are
responsible for a SQL Server 2005 database that has
several indexes. You need to write a stored procedure
that checks the indexes for fragmentation. Which
Transact-SQL statement should you use?
A. DBCC
INDEXDEFRAG
B. SELECT
* FROM sys.dm_db_index_physical_stats
C. SELECT
* FROM sys.indexes
D. DBCC
DBREINDEX
Answer: B
Question: 6
You work
as DBA at Company .com. You administer two SQL Server
2005 computers named Company A and Company B. Company A
and Company B contain a copy of a database named Sales.
The database is replicated between Company A and Company
B by using transactional replication. A full backup of
each database is performed every night. Transaction log
backups are performed every hour. Replication latency is
typically less than two minutes. One afternoon, the
Sales database on Company A becomes corrupted. You are
unable to repair the database. The Sales database on
Company B is unaffected. You need to return the Sales
database on Company A to normal operation as quickly as
possible. You must ensure a minimum loss of data and
minimal impact to users of either Server . What should
you do?
A.
Perform a full database backup on Company B. Restore the
backup to Company A.
B.
Restore the most recent full database backup and all
transaction logs made since the full backup was made.
C.
Restore only the most recent transaction log backup.
D. Detach
the Sales database on Company B. Copy the database file
to Company A, and attach the database on both Server s.
Answer: A
Question: 7
You are a
database administrator for Company .com. The company
runs a popular databasedriven Web site against a SQL
Server 2005 computer named Company B. You need to ensure
a quick response time and appropriate audit trail in the
event that Company B experiences excessive traffic due
to denial-of-service (DoS) attacks. Which two actions
should you perform?
(Each
correct answer presents part of the solution. Choose
two.)
A.
Configure the new performance alert to start a SQL
Server Profiler trace.
B. Create
a new performance alert to monitor the Current Bandwidth
counter.
C.
Configure the new performance alert to start a Network
Monitor capture.
D. Create
a new performance alert to monitor the Bytes Total/sec
counter.
Answer: C, D
Question: 8
You are a
database administrator for Company .com. One of the
databases on a SQL Server 2005 computer contains a
stored procedure. Users run this stored procedure to
import data into a table. The stored procedure needs to
use the TRUNCATE TABLE command before importing new data
into the table. However, the users who run the stored
procedure do not have permission to truncate the table.
You need to provide a way for the stored procedure to
truncate the table before it imports new data. What
should you do?
A.
Configure the stored procedure to use the EXECUTE AS
command.
B.
Configure the stored procedure to be owned by the same
database user as the table.
C. Assign
the users DELETE permission in the table.
D. Add
the users to the db_datawriter fixed database role.
Answer: A
Question: 9
You are a
database administrator for Company .com. You have
separate SQL Server 2005 development and production
environments. You use the Business Intelligence
Development Studio to create a SQL Server Integration
Services (SSIS) package in your development environment.
Then, you use the SSIS package to import data into your
development environment from one of your company's
trading partners. You need to deploy the SSIS package to
your production environment. Your production environment
uses different table names than your development
environment. What should you do?
A. Save
the SQL Server Integration Services (SSIS) package to a
file. Copy the file to the production Server . Configure
the SSIS package on the production Server to use the new
file.
B. Back
up the master database and restore it to the production
Server . Rename the appropriate tables inside the master
database.
C. Create
a SQL Server Integration Services (SSIS) package
configuration. Build a deployment utility. Copy the
deployment folder for your SSIS project to your
production Server . Execute the manifest file.
D. Back
up the msdb database and restore it to the production
Server . Rename the appropriate tables inside the msdb
database.
Answer: C
Question: 10
You are a
database administrator for Company .com. You notice that
one of the data files on a SQL Server 2005 computer is
corrupted. You need to restore the database from the
most recent set of backups. You want to perform this
task as quickly as possible, with a minimum loss of
data. What should you do first?
A.
Restore the most recent transaction log backup.
B.
Restore the most recent full database backup.
C.
Perform a full database backup.
D.
Perform a transaction log backup.
Answer: D
|
