Examen 70-461 V001

Results

#1. You are developing a database that will contain price information. You need to store the prices that include a fixed precision and a scale of six digits. Which data type should you use?

Explanation: Numeric is the only one in the list that can give a fixed precision and scale. http://msdn.microsoft.com/en-us/library/ms179882.aspx

#2. Your database contains two tables named DomesticSalesOrders and InternationalSalesOrders. Both tablescontain more than 100 million rows. Each table has a Primary Key column named SalesOrderId. The datain the two tables is distinct from one another. Business users want a report that includes aggregateinformation about the total number of global sales and total sales amounts. You need to ensure that yourquery executes in the minimum possible time. Which query should you use?

Explanation:
http://msdn.microsoft.com/en-us/library/ms180026.aspx
http://blog.sqlauthority.com/2009/03/11/sql-server-difference-between-union-vs-union-alloptimalperformance-comparison/

 

http://blog.sqlauthority.com/2009/03/11/sql-server-difference-between-union-vs-union-all-optimalperformance-comparison/

#3. 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?

Explanation:

http://technet.microsoft.com/en-us/library/ms177634.aspx

#4. You create a stored procedure that will update multiple tables within a transaction. You need to ensure thatif the stored procedure raises a run-time error, the entire transaction is terminated and rolled back. WhichTransact-SQL statement should you include at the beginning of the stored procedure

Explanation:

http://msdn.microsoft.com/en-us/library/ms190306.aspx

http://msdn.microsoft.com/en-us/library/ms188792.aspx 

#5. You develop a database for a travel application. You need to design tables and other database objects. You create a view that displays the dates and times of the airline schedules on a report. You need to display dates and times in several international formats. What should you do?

Explanation:

http://msdn.microsoft.com/en-us/library/hh213505.aspx

 

Deja una respuesta

WP to LinkedIn Auto Publish Powered By : XYZScripts.com