070-461 무료 덤프문제 온라인 액세스

You use Microsoft SQL Server 2012 database to develop a shopping cart application.
You need to rotate the unique values of the ProductName field of a table-valued expression into multiple columns in the output.
Which Transact-SQL operator should you use?

• A.UNPIVOT
• B.CROSS JOIN
• C.PIVOT
• D.CROSS APPLY

You are developing an employee management database in Microsoft SQL Server. The database contains two tables that are defined with the following Transact-SQL statements:

If the employee qualify for a bonus level they must receive a percentage of any sales.
Select the appropriate from below:

정답:

You use Microsoft SQL Server 2012 to write code for a transaction that contains several statements.
There is high contention between readers and writers on several tables used by your transaction.
You need to minimize the use of the tempdb space. You also need to prevent reading queries from blocking writing queries.
Which isolation level should you use?

• A.SNAPSHOT
• B.REPEATABLE READ
• C.SERIALIZABLE
• D.READ COMMITTED SNAPSHOT

You are a database developer at an independent software vendor. You create stored procedures that contain proprietary code.
You need to protect the code from being viewed by your customers.
Which stored procedure option should you use?

• A.ENCRYPTBYPASSPHRASE
• B.ENCRYPTION
• C.ENCRYPTBYCERT
• D.ENCRYPTBYKEY

You have a vendor application that uses a scalar function.
You discover that the queries for the application run slower than expected.
You need to gather the runtime information of the scalar function.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.

• A.Create and then enable a profiler trace.
• B.Enable the Include Actual Execution Plan option.
• C.Enable the Display Estimated Execution Planoption.
• D.Create and then enable an extended events trace.
• E.Run the Database Engine Tuning Advisor.