Try Microsoft : 70-432 valid & accurate questions and answers

You administer a SQL Server 2008 instance that runs on a Windows Server 2003 computer. The instance uses mixed authentication mode.
You need to ensure that the SQL Server 2008 authenticated logins follow the same password complexity rules that are enforced by Windows Server 2003. You also need to ensure that the password complexity rules continue to be enforced.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Use Policy-Based Management to create a policy that prevents any violation of these rules.
• B. Use the ALTER LOGIN ... HASHED statement to modify all logins.
• C. Use the ALTER LOGIN ... CHECK_EXPIRATION = ON statement to modify all logins.
• D. Create an SQL Server Agent job that runs periodically to raise an alert if a rule violation is detected.
• E. Use the ALTER LOGIN ... CHECK_POLICY = ON statement to modify all logins.

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 replication feature and configure the application to use the replicated database.
• B. Use the database snapshot feature and configure the application to use the snapshot database.
• C. Set the isolation level to Read Uncommitted for the InsightDB database.
• D. Set the isolation level to Read Committed Snapshot for the InsightDB database.

You administer a SQL Server 2008 instance.
You use the SQL Server Import and Export Wizard to export data from SQL Server to a
Microsoft Excel file.
You save the package definition to a file.
You need to reexecute the package from the command line.
Which utility should you use?

• A. sqlmaint.exe
• B. dtexec.exe
• C. dta.exe
• D. bcp.exe

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 SQLCmd utility and save the output to a file.
• B. Run the bulk copy program utility along with a format file and an output file.
• C. Run the SQL Import and Export Data Wizard and save the output to a file.
• D. Run the bulk copy program utility along with an output file and no format file.

You administer a SQL Server 2008 instance.
You join two tables on a column named CompanyName by using the following query:
SELECT s.*,i.*
FROM SensitiveTb1 AS s
INNER JOIN Insensitive Tb1 AS iON i. CompanyName = s.CompanyName
When you execute the query, the following error is returned: "Msg 468, Level 16, State 9, Line 17 Cannot resolve the collation conflict between ,SQL_Latinl_General_CPl_CS_AS' and
'SQL_Latin1_General_CP1_CI_AS' in the equal to operation."
You need to modify the ON clause of the query to successfully perform a case-sensitive
join.
What should you do?

• A. ON LOWER(i.CompanyName) = LOWER(s.CompanyName)
• B. ON UPPER(i.CompanyName) = UPPER(s.CompanyName)
• C. ON i.CompanyName = s.CompanyName COLLATE SQL_Latin1_General_CP1_CI_AS
• D. ON i.CompanyName = s.CompanyName COLLATE SQL_Latin1_General_CP1_CS_AS