Examen 70-461 V001

16 octubre, 201818 octubre, 2018 JuanCastillo 0 comentarios

Username *

User Password *

User Email *

Confirm Password *

Results

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

SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount FROM DomesticSalesOrdersUNIONSELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmountFROM InternationalSalesOrders

SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount FROM (SELECT SalesOrderId, SalesAmountFROM DomesticSalesOrdersUNION ALLSELECT SalesOrderId, SalesAmountFROM InternationalSalesOrders) AS p

ELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount FROM DomesticSalesOrdersUNION ALLSELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmountFROM InternationalSalesOrders

SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount FROM (SELECT SalesOrderId, SalesAmountFROM DomesticSalesOrdersUNIONSELECT SalesOrderId, SalesAmountFROM InternationalSalesOrders) AS p

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/

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

CROSS APPLY

CROSS JOIN

UNPIVOT

PIVOT

Explanation:

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

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

SET XACT_ABORT ON

BEGIN

SET XACT_ABORT OFF

TRY

SET ARITHABORT OFF

SET ARITHABORT ON

Explanation:

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

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

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

Use the DATETIMEOFFSET data type.

Use the FORMAT function.

Use the VARBINARY data type

Use an appropriate collation.

Use the TODATETIMEOFFSET function

Use the DATE data type

Use the CAST function.

Use the DATETIME data type.

Use a user-defined table type.

Use the DATETIME2 data type.

Explanation:

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

#5. You develop a Microsoft SQL Server 2012 database. You need to create a batch process that meets the following requirements: Returns a result set based on supplied parameters. Enables the returned result set to perform a join with a table. Which object should you use?

Table-valued user-defined function

Scalar user-defined function

Inline user-defined function

Stored procedure

← Agregar ayudas visuales a reportes de reporting services
Curso de SQL Server Integration Services →

También te puede gustar

Deja una respuesta Cancelar la respuesta

Lo siento, debes estar conectado para publicar un comentario.

Mi Canal

Sitio patrocinado por

Google Plus

Libros recomendados

News

SSRS Uncategorized

alternar colores de las filas de un reporte en SSRS: Agregar ayudas visuales a reportes de reporting services

10 octubre, 2018 JuanCastillo 0

Dar formato como tabla SSRS en SQL Server Reporting Services En muchas ocasiones escuchamos que queremos tener una ayuda visual

SSRS

Configuración para acceder de forma anonima a Reporting Services

11 mayo, 2018 JuanCastillo 8

SSRS

Como crear un reporte en SSRS para compresion datos: Compresion sql con reporting services SQL Server

24 febrero, 2017 JuanCastillo 6

SSRS

Como añadir un reporte personalizado a SQL Server Management Studio: Reporte personalizado en SQL Server Management Studio

21 febrero, 2017 JuanCastillo 2