Free Microsoft 70-432 Exam Dumps Questions & Answers

DRAG DROP
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.)

Correct Answer:

You administer a SQL Server 2008 instance that contains a database named InsightDB.
The InsightDB database is used by an application that is continuously connected.
The application uses the INSERT command extensively. The application uses triggers to populate multiple tables.
You need to ensure that the reports generated by the application using the InsightDB database return current information with minimal negative effects on the application inserts.
What should you do?

• A.Use the database snapshot feature and configure the application to use the snapshot database.
• B.Set the isolation level to Read Committed Snapshot for the InsightDB database.
• C.Use the database replication feature and configure the application to use the replicated database.
• D.Set the isolation level to Read Uncommitted for the InsightDB database.

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
  Expand the SQL Native Client 10.0 Configuration service.
  Select the Client Protocols service. Select the Properties option.
• B.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.
• 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
  Select the SQL Server Services service.
  In the right panel, right-click SQL Server Browser, right-click Properties, and then select the Advanced tab.

You administer two SQL Server 2008 instances named Instance1 and Instance2.
A database named Customers resides on Instance1. You move the Customers database from Instance1 to Instance2.
A SQL Server login named User1 that has the password "111999" is used by a user to access the database on Instance1. You create the same SQL Server login on Instance2.
The user attempts to access the Customers database on Instance2 by using the SQL Server login User1. However, the user receives an error message which indicates that the access to the Customers database is denied.
You need to ensure that User1 can access the Customers database.
Which Transact-SQL statements should you execute on Instance2?

• A.USE Customers; ALTER LOGIN User1 WITH PASSWORD = '111999' UNLOCK;
• B.USE Customers; ALTER USER User1 ENABLE;
• C.USE Customers; ALTER USER User1 WITH LOGIN = User1;
• D.USE Customers; ALTER LOGIN User1 WITH DEFAULT_DATABASE = Customers;

You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition:

Data is grouped into quarterly partitions.
You need to configure the groupings into 12 monthly partitions.
What should you do?

• A.Create a new Filegroup.
  Create a new database File.
  Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause.
  Use the ALTER PARTITION FUNCTION statement along with the SPLIT RANGE clause.
• B.Create a new partition function.
  Create a new partition scheme.
  Add a clustered index to place the data onto the partition scheme.
• C.Run the following statement:
  EXECUTE sp_tableoption
  @TableNamePattern ='OrderItem3',
  @OptionName= 'PartltionByYear';
  @OptionValue= 'true';
• D.Use the ALTER TABLEstatement to remove the COLLATEoption.
• E.Create a new table.
  Use the ALTER TABLE statement along with the SWITCH PARTITION clause.
  Use the ALTER PARTITION FUNCTION statement along with the MERGE RANGE
  clause.
• F.Use the ALTER PARTITION FUNCTION ... SPLIT RANGE statement.
• G.Create a new filegroup.
  Create a new database file.
  Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause.
  Use ALTER INDEX REORGANIZE statement.
• H.Execute the DBCC CLEANTABLEcommand on the OrderItems table.
• I.Remove the clustered index from the table.
• J.Run the following statement:
  CREATE PARTITION SCHEME SEC_FG
  AS PARTITION FUNC_FG
  ALL TO (SECONDARY);