There are many companies that provide 70-432 braindumps but those are not accurate and latest ones. Preparation with GreatExam 70-432 practice test study guide is a best way to pass this certification exam in easy way.
QUESTION 201
Drag and Drop Question
You administer a Microsoft SQL Server 2008 R2 database instance.
Occasionally, the following problems occur:
– The SQL Server service fails to start.
– A query from the application runs slower than expected.
You need to be able to diagnose each of these problems.
Which tool or tools should you use? (To answer, drag the appropriate problem to the correct tool in the answer area. Each problem may be used once, more than once, or not at all. Each tool may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)
QUESTION 202
Drag and Drop Question
You administer a Microsoft SQL Server 2008 R2 database instance that supports a sales management application.
Occasionally, users of the application report that they receive a deadlock error.
You plan to troubleshoot this error.
You need to ensure that the instance is configured to capture troubleshooting information that will create an XML document detailing the deadlock condition.
Which two actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Answer:
QUESTION 203
You administer a Microsoft SQL Server 2008 R2 database instance.
You need to identify queries or stored procedures that are consuming server resources.
You also need to view the query plan that is being used by each of these queries or procedures.
Which Dynamic Management Views (DMVs) should you use to find details about specific queries? (Choose all that apply.)
A. dm_io_virtual_file_stats
B. dm_exec_sql_text
C. dm_exec_query_stats
D. dm_exec_connections
E. dm_exec_query_plan
Answer: ABD
QUESTION 204
You administer a Microsoft SQL Server database.
You plan to deploy a new database application.
You want to use SQL Server common language runtime (CLR) integration.
You need to ensure that CLR assemblies can be used.
What should you do?
A. Run the following statement:
EXEC sp_configure ‘show advanced options’, 1
RECONFIGURE
GO
EXEC sp_configure ‘clr enabled’, 1
RECONFIGURE
GO
B. Open Microsoft SQL Server Management Studio and connect to the server.
Right-click the server and select Properties.
Browse to the Advanced tab.
Configure the CLRIntegration property to True.
C. Open Microsoft SQL Server Management Studio and connect to the server.
Right-click the server and select Facets.
Choose the Server Configuration facet.
Configure the AweEnabled property to True.
D. open Microsoft SQL Server Management Studio and connect to the server.
Right-click the server and select Properties.
Browse to the Advanced tab.
Configure the Filestream Access Level option to Full access enabled.
Answer: D
QUESTION 205
Drag and Drop Question
You install a Microsoft SQL Server 2008 R2 instance that uses default settings.
You want to add a storage area network (SAN) array.
The SAN has two mapped drives: D and L.
You need to ensure that all new databases meet the following requirements:
– Data files are stored on drive D in the SQLData folder.
– Log Files are stored on drive L in the SQLLogs folder.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Answer:
QUESTION 206
You administer a Microsoft SQL Server database that hosts an order-processing application.
Employees in the order entry group perform real-time data entry for customers.
Employees in the reporting group run historical reports.
Employees in the order entry group report of poor performance when the reporting group runs reports.
You need to limit the amount of CPU and RAM used by the reporting group.
What should you do?
A. Implement Resource Governor by using a Resource Pool assigned to the users of the reporting group to limit the amount of CPU/RAM they can use.
B. Use sp_dbmmonitoraddmonitoring to set up a monitoring process to kill the reporting group’s queries that pass a given threshold.
C. Create a set of views in a new schema, and then alter the queries of the reporting group to use these views.
D. Implement Policy Based Management by using the Server Performance facet.
Answer: C
QUESTION 207
You administer a SQL Server 2008 instance.
A database developer named User1 needs to view the definitions of all database objects in a database and read data from all user-defined tables, views, and table-valued functions.
You need to set the required permissions for User1.
Which Transact-SQL statements should you execute?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: B
QUESTION 208
Drag and Drop Question
You administer a Microsoft SQL Server 2008 R2 database named
AdventureWorks2008R2 that hosts a credit card-processing application.
You need to implement transparent data encryption.
Which four Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)
Answer:
QUESTION 209
Drag and Drop Question
You administer a Microsoft SQL Server 2008 R2 database installed along with the default settings.
You want to migrate a database from a SQL Server 2000 server that is being decommissioned. The application instantiates ActiveX objects from stored procedures in the database by using sp_OACreate.
You need to configure SQL Server 2008 R2 to allow command-line calls from this database.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Answer:
QUESTION 210
Drag and Drop Question
You administer a Microsoft SQL Server 2008 R2 database instance.
You need to identify the purpose of each Dynamic Management Views (DMVs).
What should you do? (To answer, drag the appropriate purpose to the correct DMV in the answer area. Each purpose may be used once, more than once, or not at all. Each DMV may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)
Answer:
QUESTION 211
You administer a database for an online ordering system.
You plan to create a disaster recovery plan that uses transaction log backups by using only Microsoft SQL Server native tools.
You need to ensure that the transaction log backup schedule meets the following requirements:
– Log backups occur every 15 minutes between 09:00 hours and 17:00 hours.
– Log backups occur every hour between 17:00 hours and 09:00 hours.
What should you do?
A. Create two SQL Server Integration Services (SSIS) packages by using a single schedule.
B. Insert a new row to dm_os_schedulers.
C. Create a database maintenance plan by using the Database Maintenance Wizard.
D. Create two SQL Agent jobs by using a single schedule.
Answer: B
QUESTION 212
You administer a Microsoft SQL Server 2008 R2 instance.
The database has been marked as suspect.
You need to place the database into an EMERGENCY state for troubleshooting.
What should you do?
A. Execute sp_helpfile.
B. Execute DBCC CHECKDB.
C. Examine the msdb..suspect_pagestable.
D. Execute DBCC CHECKDBalong with the REPAIR_FASTclause.
E. Execute DBCC CHECKDBalong with the REPAIR_REBUILDclause.
F. Restore the database from the most recent full backup. Apply any differential and log backups.
G. Use the ALTER DATABASEstatement along with the SET EMERGENCYclause.
H. Use the RESTORE DATABASEstatement along with the PAGESclause.
Create a new log backup.
Apply all differential and log backups, including the most recent backup.
I. Use the RESTORE DATABASEstatement along with the PAGESclause.
Apply any differential and log backups.
Create a new log backup and then restore the new log backup.
Answer: G
QUESTION 213
You administer a Microsoft SQL Server 2008 R2 instance.
A disk drive that contains the files for the database is lost.
The drive has been replaced, but the data files have been irrevocably lost.
You need to restore the database.
What should you do?
A. Execute sp_helpfile.
B. Execute DBCC CHECKDB.
C. Examine the msdb..suspect_pagestable.
D. Execute DBCC CHECKDBalong with the REPAIR_FASTclause.
E. Execute DBCC CHECKDBalong with the REPAIR_REBUILDclause.
F. Restore the database from the most recent full backup. Apply any differential and log backups.
G. Use the ALTER DATABASEstatement along with the SET EMERGENCYclause.
H. Use the RESTORE DATABASEstatement along with the PAGESclause.
Create a new log backup.
Apply all differential and log backups, including the most recent backup.
I. Use the RESTORE DATABASEstatement along with the PAGESclause.
Apply any differential and log backups.
Create a new log backup and then restore the new log backup.
Answer: F
QUESTION 214
You administer a Microsoft SQL Server 2008 R2 instance.
You need to ensure that no suspect pages have been detected in your database.
What should you do?
A. Execute sp_helpfile.
B. Execute DBCC CHECKDB.
C. Examine the msdb..suspect_pagestable.
D. Execute DBCC CHECKDBalong with the REPAIR_FASTclause.
E. Execute DBCC CHECKDBalong with the REPAIR_REBUILDclause.
F. Restore the database from the most recent full backup.
Apply any differential and log backups.
G. Use the ALTER DATABASEstatement along with the SET EMERGENCYclause.
H. Use the RESTORE DATABASEstatement along with the PAGESclause.
Create a new log backup.
Apply all differential and log backups, including the most recent backup.
I. Use the RESTORE DATABASEstatement along with the PAGESclause.
Apply any differential and log backups.
Create a new log backup and then restore the new log backup.
Answer: C
QUESTION 215
You maintain a SQL Server 2008 instance that contains a database named Finance.
You suspect that three large tables in the Finance database are corrupt.
You plan to execute the DBCC CHECKTABLE statement concurrently on the three tables to minimize downtime.
You need to set the database option to prevent users from accessing the database during the execution of the statement.
Which database option should you turn on?
A. OFFLINE
B. READ_ONLY
C. RESTRICTED_USER
D. SINGLE_USER
Answer: D
We give you the proper and complete training with free 70-432 GreatExam updates. Our braindumps will defiantly make you perfect to that level you can easily pass the exam in first attempt.
Comments are closed.