REAL QUESTIONS SUBMIT MATERIAL ADVERTISE
Braindumps

Microsoft

Cisco

Citrix

CIW

CompTia

CWNA

Apple

Adobe

HP

Legato

Exin

Filemaker

Brocade

Ericsson

TIA

Veritas

ISEB

SCP

IISFA

ISM

OMG

Apc

Mile2

Foundry

Huawei

McData

Symantec

TeraData

RedHat

Solar Winds

Blue Coat

Riverbed

 

 
 
Click on name of dumper to view the dump
 

Pauletta

John Luis

 
 

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.examcheats.net . 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

 

 

Braindumps Real exam questions and verified answers - 100% passing guarantee - cheap prices.

 

Free brain dumps Braindumps, notes, books for free

 

Braindumps and Exams - Instant download real exam questions - Passing guarantee.

Follow us on FaceBook
Braindumps on Facebook
 
 
 
 
 

CheckPoint

Linux

Novell

DB/2

Network Appliance

EC-Council

Nortel

McAfee

Juniper

ISACA

PMI

Sybase

EMC

HDI

SNIA

ISC

Sair

IBM

Lotus

Exam Express

3COM

BICSI

DeLL

Enterasys

Extreme Networks

Guidance Software

Computer Associates

Network General

SAS Institute

Alcatel Lucent

SeeBeyond

TruSecure

Polycom

Hyperion

Hitachi

Nokia

Fortinet

Vmware

Fujitsu

Tibco

Intel

PostgreSQLCE

BusinessObjects

RESSoftware

BlackBerry

AccessData

ICDL

Isilon

SAP

The Open Group

ACSM

Altiris

Avaya

Cognos

F5

Genesys

SDI

ACI

ASQ

Google

H3C

HIPAA

HRCI

SOA

IIBA

Zend