70-432 exam questions and answers provided by GreatExam will guarantee you pass 70-432 exam, because GreatExam is the top IT Certification study training materials vendor. Many candidates have passed exam with the help of GreatExam. We offer the latest 70-432 PDF and VCE dumps with new version VCE player for free download, you can pass the exam beyond any doubt.
QUESTION 1
You are the administrator of a SQL Server 2008 instance.
All the instances run on their independent server. The three instances are respectively named InstanceA, InstanceB, and InstanceC. Between InstanceA and InstanceB, you configure a mirroring mission-critcal database. InstanceA currently acts as the Principal and InstanceC acts as the witness.
You intend to apply a patch to both servers as soon as possible, the patch needs to restart the server.
You must make sure that the database is online on the partner that currently does not apply the patch and during this time the database does not failover to the other partner.
Which action should you perform to achieve this goal?
A. First, you should stop the mirroring session.
Second you apply the patch to the server that runs InstanceB.
Third, you should resume the mirroring session.
Fourth, you should manually failover the mirroring session.
At last, you should apply the patch to the server that runs Instance1.
B. First, you should apply the patch to the server that runs InstanceB.
Second you apply the patch to the server that runs InstanceA.
C. First, you should apply the patch to the server that runs InstanceB.
Second you failover the mirroring session manually.
At last apply the patch to the server that runs InstanceA
D. First, you should remove the mirroring session.
Second you apply the patch to the server that runs InstanceB.
Third, you should apply the patch to the server that runs Instance1.
At last re-establish the mirroring session.
Answer: A
QUESTION 2
You are the administrator of a SQL Server 2008 instance with a database named DB1.
In the Services schema there is a table named Service.Table.
The Services.Table has to be moved from the Sales schema to a new schema named Costs.
Which Transact-SQL statement should you execute?
A. ALTER TABLE Service.Table SWITCH TO Costs.Table1;
B. ALTER SCHEMA Costs TRANSFER Service.Table;
C. ALTER USER Service WITH DEFAULT_SCHEMA = Costs;
D. ALTER AUTHORIZATION ON Service.Table1 TO Costs;
Answer: B
QUESTION 3
You are the administrator of a SQL Server 2008 instance with a database named DB1.
which contains the following stored procedure. (Line numbers are useded for reference only.)
01 CREATE PROCEDURE Sales.Procedure1
02 AS
03 IF OBJECT_ID(‘Service.Table’) IS NOT NULL
04 DROP TABLE Service.Table;
05
06 CREATE TABLE Service.Table (
07 Id int PRIMARY KEY CLUSTERED,
08 Name varchar(100);
09 );
10
11 …
12 GO
The following exception is raised when a user tries to invoke Procedure1,
“Msg 262, Level 14, State 1, Procedure Procedure1, Line 5
CREATE TABLE permission denied in database ‘DB1’.”
You should grant the user access to execute Procedure1, you must assign only the required permissions.
Which action should you perform?
A. Between lines 01 and 02, you should insert the WITH EXECUTE AS ‘dbo’ clause.
B. Between lines 01 and 02, you should insert the EXECUTE AS USER = ‘dbo’ statement.
C. You should give the user the ALTER permission on the Service schema
D. You should give the CREATE TABLE permission and permit the user to drop the Service.Table table.
Answer: A
QUESTION 4
You are the administrator of a SQL Server 2008 instance with a database named Dworks.
The table below shows the two tables of the Dworks database:
There are two partitions in the BillHistory table.
Partition1 is empty while partition2 contains all data.
You intend to move data from partition2 to the appropriate partition of the BillHistory table.
Partions2 contains data for the oldest month of the Bills table.
You are going to develop a process to achieve this.
You have to make sure that at the end of every month the process can be repeated.
A. Alter the partition function of the BillHistory table by using the split option.
Switch the appropriate partition of the Bills table to the appropriate partition of the BillHistory table. Alter the BillHistory table by using the split option.
B. Alter the partition function of the Bills table by using the split option.
Alter the Billstable by using the merge option.
C. Alter the partition function of the BillHistory table by using the split option.
Switch the appropriate partition of the Bills table to the appropriate partition of the BillHistory table. Alter the BillHistory table by using the merge option.
Alter the Bills table by using the merge option.
D. Alter the partition function of the Bills table by using the split option.
Alter the BillHistory table by using the split option.
Alter the partition function of the BillHistory table by using the merge option.
Alter the Bill stable by using the merge option.
Answer: C
QUESTION 5
You are the administrator of a SQL Server 2008 instance.
You notice that the application has a poor performance.
On the remote SQL Server instance, you capture a workload of the remote instance to a trace table by using SQL Profiler.
You use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance.
Which action should you perform to achieve this goal?
A. You should recapture the workload by using the data collector.
B. You should enable the XP_MSVER stored procedure on the local server.
C. You should enable the XP_MSVER stored procedure on the remote server
D. You should recapture the workload to a trace file by using SQL Profiler.
Answer: D
QUESTION 6
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.
You have to 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 7
You are the administrator of a SQL Server 2008 instance.
There is a n On-Line Analytical Processing (OLAP) database named in the instance.
The database contains a dimension table named Clients.
Ever hour backup of data of the Clients table is performed.
But the Clinets table contains redundant data.
You must keep the disk space used to store the Clients table.
Which compression technology should you use?
A. You should use row compression
B. You should use page compression
C. You should use backup compression
D. You should use windows NTFS file system compression
Answer: B
QUESTION 8
You are the administrator of a SQL Server 2008 instance.
There is a text file which is named SQL01.log on the E: drive.
A SQL Server Agent job executes every 2 minutes and logs information to the text file.
You get a report from users saying that the sever doesn’t make response.
As the technical support, you check and find that the SQL Server Agent service does not run and the SQL Server Agent job no longer functions.
You have to identify the reason why the SQL Server Agent service is unresponsive.
Which log should you check?
A. You should check SQL1.log
B. You should check SQLAGENT.OUT
C. You should check log_xx.trc
D. You should check ERRORLOG
Answer: B
QUESTION 9
You are the administrator of a SQL Server 2008 instance.
A SQL Server Agent job is failing.
You find that the job history information is incomplete and seems to be truncated after you review it.
All information produced by a job must be available for viewing.
Which action should you perform to achieve this goal?
A. You should enable notifications to the Windows application event log when the job completes.
B. You should enable write OEM file
C. You should enable all job steps, making them send the output to a file
D. You should include execution trace messages in the SQL Agent Error log
Answer: C
QUESTION 10
You are the administrator of a SQL Server 2008 instance.
There is a database named DB1 in the instance.
On DB1, quite few logged operations are performed.
Now according to the requirement of the company CIO, you must validate that the database can be restored to a specific point in time.
Which action should you perform to achieve this goal?
A. You should verify that the simple recovery model is used by the database
B. You should verify that the full recovery model is used by the database.
C. You should verify that the checksum page verify option is used by the database
D. You should verify that the bulk-logged recovery model is used by the database
Answer: B
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
GreatExam is the leader in supplying candidates with current and up-to-date training materials for Microsoft certification and exam preparation. Comparing with others, our 70-432 exam questions are more authoritative and complete. We offer the latest 70-432 PDF and VCE dumps with new version VCE player for free download, and the new 70-432 practice test ensures your exam 100% pass.