New Braindump2go 70-432 Exam Questions Updated Today! Want to know New Questions in 2015 70-432 Exam? Download Free Braindump2go 70-432 Exam Preparation Materials Now!
Vendor: Microsoft
Exam Code: 70-432
Exam Name: TS: Microsoft SQL Server 2008, Implementation and Maintenance
Keywords: 70-432 Exam Dumps,70-432 Practice Tests,70-432 Practice Exams,70-432 Exam Questions,70-432 PDF,70-432 VCE Free,70-432 Book,70-432 E-Book,70-432 Study Guide,70-432 Braindump,70-432 Prep Guide
QUESTION 11
You are the administrator of a SQL Server 2008 instance.
According to the company requirement, the names of all user-defined stored procedures
must contain the prefix usp_ on all instances. Besides this, you must make sure that stored procedures that do not contain this prefix cannot be created by you.
What should you do?
A. A policy should be created.
The policy targets the name of the stored procedure that is evaluated on demand.
B. A policy should be created.
The policy targets the name of the stored procedure that is evaluated on change.
C. A condition should be created.
The condition targets the name of the stored procedure that is evaluated on change
D. A condition should be created.
The condition targets the name of stored procedure that is evaluated on demand.
Answer: B
QUESTION 12
You are the administrator of a SQL Server 2008 instance.
The company CIO wants you to configure FILESTREAM data and the two requirements below must be met: you must enable FILESTREAM for file I/O streaming access; remote client computers must be able to have streaming access to FILESTREAM data.
You have to make sure that FILESTREAM data is enabled.
Which service should you configure?
A. You should configure SQL Server VSS Writer
B. You should configure Distributed File System
C. You should configure SQL Server
D. You should configure SQL Server Full Text
Answer: C
QUESTION 13
You are the administrator of a SQL 2008 instance.
There is an Internet Information Services application.
This application will use anonymous access to access the SSAS instance.
You must make sure that the application can access the SSAS instance.
What should you do?
A. The ure the SQL Server service torun un server configuration should be set to False
B. The Security\RequireClientAuthentication server configuration should be set to True.
C. The NTLM Security Support Provider Interface (SSPI) provider should be added to the Security\SecurityPackageList server configuration.
D. The Kerberos Security Support Provider Interface (SSPI) provider should be added to the Security\SecurityPackageList server configuration
Answer: A
QUESTION 14
You are the administrator of a SQL Server 2008 with a named Instance01.
Instance01 contains a database which is named Dworks.
The bulk-logged recovery mode is used by the Dworks database.
You logship the Dworks database through a WAN link.
A scheduled job rebuilds the indexes of the Dworks database.
You find that the size of the log backups for log shipping has been enlarged by the job.
You have to reduce the size of the log backup.
Which action should you perform to achieve this goal?
A. You should recreate the indexes.
B. You should compress the log file backups
C. You should make the Dworks database use the Full recovery mode
D. You should make the Dworks database use the Simple recovery mode.
Answer: B
QUESTION 15
You are the administrator of a SQL Server 2008 cluster.
According to the company requirement, the failover response of the cluster has to be tested.
The company assigns this task to you.
On the cluster, you have to implement a manual failover.
Which actions should you take? (choose more than one)
A. The contents of a shared folder on the active node should be encrypted by using Encrypting
File System (EFS)
B. You should restore a backup to the active node
C. You should get rid of the shared array from the active node
D. From the active node, you have to uplug the network cable(s)
Answer: CD
QUESTION 16
You are a database developer for your company.
You are creating a parameterized stored procedure that will query the data and return rows that include any verb tense of the verbs supplied as input to the stored procedure.
The query should also return rows that contain both plural and singular forms of nouns.
The data is included in several varchar(max) and varbinary(max)columns.
You need to create the stored procedure to fulfill these requirements.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Use the LIKE operator.
B. Use the CONTAINS predicate.
C. Create a full-text index on the appropriate column or columns.
D. Create a nonclustered index on the appropriate column or columns.
Answer: BD
QUESTION 17
You are the administrator of a SQL Server 2008 instance with a database named DB01.
The company CIO wants all the application developers can capture traces to troubleshoot the application that uses the database DB1, and they can perform this by using SQL Server Profiler.
But they must have given little permission as possible.
The company CIO assigns this task to you.
Which action should you perform to achieve this goal?
A. All the SQL Server logins of the application developers have to be added to a fixed server role.
B. All the database users of the application developers have to be added to a fixed database role
C. All SQL Server logins of the application developers should be given the appropriate
server-level permissions.
D. All database users of the application developers should be given the appropriate
database-level permissions.
Answer: C
QUESTION 18
You are the administrator of a SQL Server 2008 instance.
You have to perform the backup of the default trace according to the requirement of your failure recovery plan.
The default trace is contained in the subdirectory.
You have to backup the subdirectory.
Which SQL Server database engine subdirectory should be backed up?
A. DATA
B. INSTALL
C. LOG
D. BINN
Answer: C
QUESTION 19
You are the administrator of a SQL Server 2008 instance.
There is a database named DB1 in the instance.
The backup strategy for DB1 has the following requirements:
every day at 9:00 full database backup to a file named cash.bak is performed;
At 9:15 a transaction log backup to a file named cash_HHMM.trn is performed every 15 minutes.
DB1 is being used in single-user mode.
Today a user reports that a query deleted some data by accident, the query was executed at 9: 25.
Since the deleted data is quite important, the data has to be restored to its original state.
You must achieve this goal.
Which action should you perform to achieve this goal?
A. RESTORE DATABASE Cash
FROM DISK = ‘t:\backups\cash.bak’
WITH NORECOVERY;
RESTORE LOG Cash
FROM ‘t:\backups\cash_0930.trn’
WITH RECOVERY,
STOPAT = ‘Mar 17, 2008 9:25AM’;
B. RESTORE DATABASE Cash
FROM DISK = ‘t:\backups\cash.bak’;
RESTORE LOG Cash
FROM ‘t:\backups\cash_0915.trn’
WITH NORECOVERY;
RESTORE LOG Cash
FROM ‘t:\backups\cash_0930.trn’
WITH RECOVERY,
STOPAT = ‘Mar 17, 2008 9:25AM’;
C. RESTORE DATABASE Cash
FROM DISK = ‘t:\backups\cash.bak’;
RESTORE LOG Cash
FROM ‘t:\backups\cash_0915.trn’
WITH NORECOVERY;
RESTORE LOG Cash
FROM ‘t:\backups\cash_0930.trn’
WITH RECOVERY;
D. RESTORE DATABASE Cash
FROM DISK = ‘t:\backups\cash.bak’
WITH NORECOVERY;
RESTORE LOG Cash
FROM ‘t:\backups\cash_0915.trn’
WITH NORECOVERY;
RESTORE LOG Cash
FROM ‘t:\backups\cash_0930.trn’
WITH RECOVERY,
STOPAT = ‘Mar 17, 2008 9:25AM’;
Answer: D
QUESTION 20
You are the administrator of a SQL Server 2008 instance with a database named DB1 in the instance.
At present about 90 GB of data is stored in DB1.
You made some rough calculations that every day about 1 GB of data is modified or inserted.
You set the recovery model of DB1 to Simple.
According to the company requirements, during business hours, data loss of more than 120 minutes worth of transactions is unacceptable.
You have to choose a backup strategy which must comply with the following two requirements:
– Using as little disk space as possible
– Complying with the company requirements.
Which action should you perform to achieve this goal?
A. A full database backup should be performed once daily.
During business hour, a transaction log backup should be performed every two hours.
B. A full database backup should be performed once daily
C. A full database backup should be performed once daily.
During business hours, a differential backup should be performed every two hours
D. Perform a full database backup should be performed once every week.
A differential backup should be performed once daily.
During business hours a transaction log backup should be performed every two hours.
Answer: C
Braindump2go Offers PDF & VCE Dumps Download for New Released Microsoft 70-432 Exam! 100% Exam Success Guaranteed OR Full Money Back Instantly!