70-432 무료 덤프문제 온라인 액세스

You administer a SQL Server 2008 instance that contains a database named AdventureWorks. The AdventureWorks database contains the OrderHistory table. The OrderHistory table is partitioned on the OrderId column. The first partition contains integer values between 1 and 100.000. The second partition contains integer values greater than
100.000. You need to add a new partition that contains integer values greater than
200.000. What should you do?

• A.Alter the existing partition function by using a Merge clause.
• B.Alter the existing partition function by using a Split clause.
• C.Create a new partition function.
• D.Alter the existing partition scheme.

You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database named CustomerOrders.
The database is backed up by using the weekly scheduled SQL Server Agent jobs. The backup schedule is shown in the following table:

A drive fails and the CustomerOrders database goes into suspect mode on Tuesday at
09:00 hours.
You need to restore the backup.
What should you do?

• A.Restore the backup taken on Sunday only.
• B.Restore the backup taken on Wednesday only.
• C.Restore the backups taken on Wednesday, Thursday, and Friday.
• D.Restore the backups taken Wednesday, Friday, and Saturday.
• E.Restore the backups taken on Wednesday, Thursday at 09:00 hours, and Thursday at
  18:00
  hours.
• F.Restore the backups taken on Sunday and Monday.
• G.Restore the backups taken on Wednesday and Thursday at 09:00 hours.
• H.Restore the backups taken on Wednesday and Friday.

You administer a SQL Server 2008 instance that contains a database named DB1.
The DB1 database contains the following stored procedure. (Line numbers are included for reference only.)

When a user named User1 attempts to invoke Procedure1, the following exception is raised:
"Msg 262, Level 14, State 1, Procedure Procedure1, Line 5 CREATE TABLE permission denied in database 'DB1'."
You need to provide User1 access to execute Procedure1 by allocating only the required permissions.
What should you do?

• A.Grant the CREATE TABLE permission and allow User1 to drop the Sales.Table1 table.
• B.Grant the ALTER permission on the Sales schema to User1.
• C.Insert the EXECUTE AS USER = 'dbo' statement between lines 02 and 03.
• D.Insert the WITH EXECUTE AS 'dbo' clause between lines 01 and 02.

You are managing a SQL Server 2000 instance which includes a database called Products for Home.com. You decide to install a SQL Server 2008 instance for business. You should
make sure that third-party applications could run normally on both database instances, you could get the results by conforming to the listed conditions:1. The existed application environments keep common. 2. Minimal database administrative effort.Which is the correct answer?

• A.Before setting the new application to utilize the default instance. You could install SQL Server 2008 as a named instance
• B.You should update the SQL Server 2000 instance application to utilize SQL Server 2008 instance.
• C.You should update the SQL Server 2000 application to utilize SQL Server 2008.
• D.Before setting the new application to utilize the new instance. You could install SQL Server 2008 as a named instance

You troubleshoot a SQL Server 2008 instance.
You suspect that an application uses an inefficient locking strategy and causes
concurrency problems.
You need to identify the following:
---
The sessions that wait for a resource The resource needed The sessions that block the resource
Which dynamic management view should you use?

• A.sys.dm_os_waiting_tasks
• B.sys.dm_os_wait_stats
• C.sys.dm_exec_requests
• D.sys.dm_tran_active_transactions