Pass with professional 70-432 actual quiz materials

You administer a SQL Server 2008 instance that has TCP/IP enabled.
You need to verify the port that the SQL Server instance listens on.
What should you do?

• A. Open SQL Server Configuration Manager
  Select the SQL Server Services service.
  In the right panel, right-click SQL Server Browser, right-click Properties, and then select the Advanced tab.
• B. Open SQL Server Configuration Manager
  Expand the SQL Native Client 10.0 Configuration service.
  Select the Client Protocols service. Select the Properties option.
• C. Open SQL Server Configuration Manager
  Select the SQL Server Services service.
  In the right panel, right-click SQL Server (InstanceName), right-click Properties, and then select the Advanced tab.
• D. Open SQL Server Configuration Manager
  Expand the SQL Server Network Configuration service. Select the Protocols for (InstanceName) service.
  In the right panel, right-click TCP/IP, select the Properties option, and then select the IP Addresses tab.

You administer a SQL Server 2008 instance that contains a database named DB1.
A table named Sales.Table1 exists in the Sales schema.
You need to move the Sales.Table1 table to a new schema named Billing.
Which Transact-SQL statement should you execute?

• A. ALTER AUTHORIZATION ON Sales.Table1 TO Billing:
• B. ALTER TABLE Sales.Table1 SWITCH TO Billing.Table1;
• C. ALTER USER Sales WITH DEFAULT_SCHEMA = Billing;
• D. ALTER SCHEMA Billing TRANSFER Sales.Table1;

You maintain an instance of Microsoft SQL Server 2008. The instance contains a database named Finance.
The recovery model of the Finance database is set to Full. A full database backup of all the user databases is performed at 02:00 hours daily. The transaction log backup occurs every 15 minutes. A differential backup is performed every 4 hours.
You plan to perform a full backup of the Finance database at 11:00 hours.
You need to ensure that the backup is performed without affecting the overall backup and restore procedures for the Finance database. You also need to ensure that the backup files are restored in proper sequence.
Which Transact-SQL statement should you use?

• A. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak' WITH NOUNLOAD;
• B. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak` WITH COPY_ONLY:
• C. BACKUP LOG FINANCE TO DISK = 't:\backups\finance.trn';
• D. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak` WITH
  DIFFERENTIAL;

You plan to install a SQL Server 2008 instance for a new application on an existing server that contains a default SQL Server 2005 instance.
You need to ensure that both database instances are available for their applications. Your solution must meet the following requirements:
- Minimize administrative effort.
- Prevent changes to the existing application environments.
What should you do?

• A. Configure both applications to use SQL Server 2008.
• B. Configure the new application to use a SQL Server 2008 named instance.
• C. Configure the new application to use the SQL Server 2008 default instance.
• D. Configure both instances to use SQL Server 2008.

You administer a SQL Server 2008 instance that contains a database named AdventureWorks.
The AdventureWorks database contains a table named OrderDetail. You plan to export all data from this table to a file.
You need to ensure that the following data export requirements are met: A Microsoft Office Open XML document format is used The data export process is saved for reuse.
What should you do?

• A. Run the SQL Import and Export Data Wizard and save the output to a file.
• B. Run the bulk copy program utility along with an output file and no format file.
• C. Run the SQLCmd utility and save the output to a file.
• D. Run the bulk copy program utility along with a format file and an output file.