Online Access Free 070-432 Practice Test

You administer a Microsoft SQL Server 2008 R2 instance.
You need to attach a database named Northwind to the server.
Which Transact-SQL command should you use?

• A.Option D
• B.Option A
• C.Option C
• D.Option B

You maintain a SQL Server 2008 Enterprise Edition instance that contains a database named Finance. You need to reduce the size of the full database backup files of the Finance database. Which Transact-SQL statement should you use?

• A.BACKUP DATABASE FINANCE TO DISK = ,t:\backups\finance.bak' WITH DIFFERENTIAL:
• B.BACKUP DATABASE FINANCE TO DISK = ,t:\backups\finance.bak' WITH COMPRESSION:
• C.BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak' WITH COMPRESSION- DIFFERENTIAL;
• D.BACKUP DATABASE FINANCE TO DISK = t:\backups\finance.bak*;

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

You are mastering the company database, with a SQL Server 2008 computer called SQLTEST1.There are three examples of SQL Server in the SQLTEST1.The ability to connect to the dedicated administrative connection on every example of SQL Server should be included in the disaster recovery plan of the company. You find that you could connect to the connection on SQLTEST1 default example while testing this ability; you could not connect to the dedicated connection on the two other examples on SQLTEST1. You should clarify that the examples are implementing and that client applications should be able to approach them. You should make sure that no other administrators are attempting to connect to any dedicated connections on SQLTEST1. You should also make sure that you could connect to the dedicated connection on all three examples. Which is the correct answer?

• A.You should utilize the IIS tool to make the dedicated administrative connection.
• B.You should reset the default example to utilize a default port amount other than 1434.
• C.You should stop and restart the default examples of SQL Server.
• D.You should begin the SQL Server Browser service. Set the service to run automatically.

You administer a Microsoft SQL Server 2008 R2 instance.
Mirroring has been configured between two servers.
You need to ensure that automatic failover will occur when the principal server fails
What should you do?

• A.Create a witness server to monitor the mirroring session.
  On the principal server, use the ALTER DATABASE statement along with the SET WITNESS clause.
• B.Create a witness server to monitor the mirroring session.
  On both partner servers, use the ALTER DATABASE statement along with the SET WITNESS clause.
• C.Create a Microsoft SQL Server Integration Services package on the partner server to monitor the principal server.
• D.Implement Policy Based Management.
  Enable the Server Performance management facet.