Querying Microsoft SQL Server 70-461Test

Pregunta 1 de 21

1

You administer a Microsoft SQL Server 2012 database named ContosoDB. Tables are defined as
shown in the exhibit.
(Administra una base de datos de Microsoft SQL Server 2012 denominada ContosoDB. Las tablas se definen como
se muestra en al imagen a continuación)

You need to display rows from the Orders table for the Customers row having the CustomerId value
set to 1 in the following XML format:
<row OrderId="1" OrderDate="2000-01-01T00:00:00" Amount="3400.00" Name="Customer A"
Country="Australia" />
<row OrderId="2" OrderDate="2001-01-01T00:00:00" Amount="4300.00" Name="Customer A"
Country="Australia" />
Which Transact-SQL query should you use?

Selecciona una de las siguientes respuestas posibles:

SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML RAW
SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML RAW, ELEMENTS
SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML AUTO
SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML AUTO, ELEMENTS
SELECT Name, Country, OrderId, OrderDate, Amount
FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML AUTO
SELECT Name, Country, Orderld, OrderDate, Amount
FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML AUTO, ELEMENTS
SELECT Name AS '@Name', Country AS '@Country', OrderId, OrderDate, Amount
FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML PATH ('Customers')
SELECT Name AS 'Customers/Name', Country AS 'Customers/Country', OrderId, OrderDate,
Amount
FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML PATH ('Customers')

Explicación

Pregunta 2 de 21

1

You administer a Microsoft SQL Server 2012 database named ContosoDb. Tables are defined as
shown in the exhibit.

You need to display rows from the Orders table for the Customers row having the CustomerIdvalue
set to 1 in the following XML format.

<Orders OrderId="1" OrderDate="2017-01-01" Amount="2.900000000000000e+001">
<Customers Name="Cliente1" Country="Ecuador"/>
</Orders>
<Orders OrderId="2" OrderDate="2017-01-01" Amount="2.400000000000000e+000">
<Customers Name="Cliente1" Country="Ecuador"/>
</Orders>

Which Transact-SQL query should you use?

Selecciona una de las siguientes respuestas posibles:

SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML RAW
SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers=CustomerId = 1
FOR XML RAW, ELEMENTS
SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML AUTO
SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId= 1
FOR XML AUTO, ELEMENTS
SELECT Name, Country, OrderId, OrderDate, Amount
FROM Orders INNER JOIN Customers ON Orders.CustomerId= Customers.CustomerId
WHERE Customers.CustomerId= 1
FOR XML AUTO
SELECT Name, Country, Orderld, OrderDate, Amount
FROM Orders INNER JOIN Customers ON Orders.CustomerId= Customers.CustomerId
WHERE Customers.CustomerId= 1
FOR XML AUTO, ELEMENTS
SELECT Name AS '@Name', Country AS '@Country', OrderId, OrderDate, Amount
FROM Orders INNER JOIN Customers ON Orders.CustomerId= Customers.CustomerId
WHERE Customers.CustomerId= 1
FOR XML PATH ('Customers')
SELECT Name AS 'Customers/Name', Country AS 'Customers/Country', OrderId, OrderDate,
Amount
FROM Orders INNER JOIN Customers ON Orders.CustomerId= Customers.CustomerId
WHERE Customers.CustomerId= 1
FOR XML PATH ('Customers')

Explicación

Pregunta 3 de 21

1

You administer a Microsoft SQL Server 2012 database named ContosoDB. Tables are defined as
shown in the exhibit.

You need to display rows from the Orders table for the Customers row having the CustomerId value
set to 1 in the following XML format.

<CUSTOMERS Name="Customer A" Country="Australia">
<ORDERS OrderID="1" OrderDate="2001-01-01" Amount="3400.00" />
<ORDERS OrderID="2" OrderDate="2002-01-01" Amount="4300.00" />
</CUSTOMERS>

Which Transact-SQL query should you use?

Selecciona una de las siguientes respuestas posibles:

SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML RAW
SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML RAW, ELEMENTS
SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML AUTO
SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders INNER JOIN Customers ON Orders.CustomerId - Customers.CustomerId
WHERE Customers.CustomerId= 1
FOR XML AUTO, ELEMENTS
SELECT Name, Country, OrderId, OrderDate, Amount
FROM Orders INNER JOIN Customers ON Orders.CustomerId= Customers.CustomerId
WHERE Customers.CustomerId= 1
FOR XML AUTO
SELECT Name, Country, Orderld, OrderDate, Amount
FROM Orders INNER JOIN Customers ON Orders.CustomerId= Customers.CustomerId
WHERE Customers.CustomerId= 1
FOR XML AUTO, ELEMENTS
SELECT Name AS '@Name', Country AS '@Country', OrderId, OrderDate, Amount
FROM Orders INNER JOIN Customers ON Orders.CustomerId= Customers.CustomerId
WHERE Customers.CustomerId= 1
FOR XML PATH ('Customers')
SELECT Name AS 'Customers/Name', Country AS 'Customers/Country', OrderId, OrderDate,
Amount
FROM Orders INNER JOIN Customers ON Orders.CustomerId= Customers.CustomerId
WHERE Customers.CustomerId= 1
FOR XML PATH ('Customers')

Explicación

Pregunta 4 de 21

1

You have a database named Sales that contains the tables as shown in the exhibit (Click the Exhibit button)
You need to create a query that meets the followlng requirements:

- References columns by using one-part names only.
- Groups aggregates only by SalesTerritorylD, and then by ProductlD
- Orders the results in descending order by SalesTerritorylD and then by ProductlD in descending order for both

Part of the correct T-SQL statement has been provided in the answer area Provide the complete code

SELECT SalesTerritoryID,
ProductlD
AVG(UnitPrice),
MAX(OrderQty)
MAX(DiscountAmount)
FROM Sales_DetaiIs

Selecciona una o más de las siguientes respuestas posibles:

GROUP By ProductiD
GROUP By SalesTerritoryID
GROUP By SalesTerritoryID, ProductiD
ORDER By ProductiD DESC
ORDER By SalesTerritoryID DESC, ProductiD DESC

Explicación

Pregunta 5 de 21

1

SIMULATION
You have a database named Sales that contains the tables as shown in the exhibit. (Click the Exhibit button)

You need to create a query that retums a list of products from Sales.ProductCatalog. The solution must meet the following requirements:
- UnitPrice must be retumed in descending order.
- The query must use two-part names to reference the table.
- The query must use the RANK function to calculate the results.
- The query must retum the ranking Of rows in a column named PriceRank.
- The list must display the columns in the order that they are defined in the table. PriceRank must appear last.

Part of the correct T-SQL statement has been provided in the answer area. Provide the complete code.

SELECT CatlD, CatName, ProductID, ProdName, UnitPrice,
FROM Sales.ProductCatalog
ORDER BY PriceRank

Selecciona una de las siguientes respuestas posibles:

RANK ORDER BY ProductCatalog.UnitPrice DESC
RANK(ORDER BY ProductCatalog.UnitPrice ASC)) AS PriceRank
RANK() OVER (ORDER BY Details.UnitPrice DESC) AS PriceRank
RANK() OVER (ORDER BY ProductCatalog.UnitPrice DESC) AS PriceRank
RANK() OVER (ORDER BY Orders.UnitPrice DESC) AS PriceRank

Explicación

Pregunta 6 de 21

1

DRAG DROP
You have a SQL Server database named CUSTOMERS.
You need to sign a stored procedure named SelectCustomers in the CUSTOMERS database.
Which four statements should you execute in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.

Arrastra la opción correcta a cada uno de los puntos naranjas

ORD. 4

ORD. 3

ORD. 1

ORD. 2

Incorrecta 1

Incorrecta 2

Explicación

Pregunta 7 de 21

1

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

Selecciona una de las siguientes respuestas posibles:

SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount
FROM (
SELECT SalesOrderId, SalesAmount
FROM DomesticSalesOrders
UNION
SELECT SalesOrderId, SalesAmount
FROM InternacionalSalesOrders
) AS P
SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount
FROM (
SELECT SalesOrderId, SalesAmount
FROM DomesticSalesOrders
UNION ALL
SELECT SalesOrderId, SalesAmount
FROM InternacionalSalesOrders
) AS P
SELECT COUNT(*) AS NumberOfSales, SUM (SalesAmount) AS TotalSalesAmount
FROM DomesticSalesOrders
UNION
SELECT COUNT(*) NumberOfSales, SUM (SalesAmount) AS TotalSalesAmount
FROM InternacionalSalesOrders
SELECT COUNT(*) AS NumberOfSales, SUM (SalesAmount) AS TotalSalesAmount
FROM DomesticSalesOrders
UNION ALL
SELECT COUNT(*) NumberOfSales, SUM (SalesAmount) AS TotalSalesAmount
FROM InternacionalSalesOrders

Explicación

Pregunta 8 de 21

1

You administer a Microsoft SQL Server database that has multiple tables in the Sales schema. Some users must be prevented from deleting records in any of the tables in the Sales schema. You need to manage users who are prevented from deleting records in the Sales schema.
You need to achieve this goal by using the minimum amount of administrative effort. What should you do?

Selecciona una de las siguientes respuestas posibles:

Create a custom database role that includes the users. Deny Delete permissions on the Sales schema for the custom database role.
Include the Sales schema as an owned schema for the db_denydatawriterrole. Add the users to the db_denydatawriter role.
Deny Delete permissions on each table in the Sales schema for each user.
Create a custom database role that includes the users. Deny Delete permissions on each table in the Sales schema for the custom database role.

Explicación

Pregunta 9 de 21

1

DRAG DROP
You develop an SQL Server database. The database contains a table that is defined by the following T-SQL statements:

CREATE TABLE Employees
(employeeNumber INT,
surName VARCHAR(IOO),
givenName VARCHAR(2S),
dateOfBirth DATE,
workPhone VARCHAR(12));

The table contains duplicate records based on the combination of values in the surName, givenName, and dateOBirth fields.
You need to remove the duplicate records.
How should you complete the relevant Transact-SQL statements? To answer, drag the appropriate code segment or segments to the correct location or locations in the answer area. Each code segment may be used once, more than once, or not at all. You may need to drag the Split bar between panes or scroll to view conten

WITH CTE
AS (
SELECT surName,
givenName,
DateOfBirth,
❌
Over (
❌, givenName, DateOfBirth
❌ (SELECT 1)) AS Ct
FROM dbo.Employees)
❌

Arrastra y suelta para completar el texto.

Row_number()

Rank ()

PARTITION BY surName

PARTITION BY employeeNumber

ORDER BY

GROUP BY

DELETE FROM CTE WHERE Ct > 1

DELETE FROM CTE WHERE Ct = 1

Explicación

Pregunta 10 de 21

1

Your database contains a table named Products that has columns named ProductID and Name_
You want to write a query that retrieves data from the Products table sorted by Name listing 15 rows at a time.
You need to view rows 31 through 45.
Which Transact-SQL query should you create?

Selecciona una de las siguientes respuestas posibles:

WITH Data AS (SELECT *,Rn = ROW_NUMBER() OVER(ORDER BY ProductID, Name) FROM Products)
SELECT * FROM Data WHERE Data.Rn BETWEEN 30 45
SELECT TOP 15 * FROM Products ORDER BY Name
SELECT * FROM Products ORDER BY Name OFFSET 30 ROWS FETCH NEXT 15 ROWS ONLY
SELECT * FROM Products ORDER BY Name FETCH ROWS BETWEEN 31 AND 45

Explicación

Pregunta 11 de 21

1

DRAG DROP
You need to create a stored procedure to support the following:

• TRY/CATCH error handling
• Transaction management

Which three statements should you include in the stored procedure in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.

===================== Answer Area =====================
==========Statemenets==============Answers============

SET XACT_ABORT ON;------------|------------1 ❌

BEGIN TRANSACTION;------------|------------2 ❌

SAVE TRANSACTION---------------|------------3 ❌

COMMIT TRANSACTION;---------|

ROLLBACK TRANSACTION;------|

Arrastra y suelta para completar el texto.

BEGIN TRANSACTION;

SAVE TRANSACTION

ROLLBACK TRANSACTION;

SET XACT_ABORT ON;

COMMIT TRANSACTION;

Explicación

Pregunta 12 de 21

1

You use a Microsoft Azure SQL DataBase instance_ The instance contains a table named Customers that has columns named Id, Name, and IsPriority.

You need to create a view named VwPriorityCustomers that:

• retums rows from Customer thathave a value of True in the IsPriority column, and
• does not allow columns to be altered or dropped in the underlying table.

Which Transact-SQL statement shoul you run?

Selecciona una de las siguientes respuestas posibles:

CREATE VIEW Vwprioritycustomers
SELECT Id, Name FROM dbo.Customers WHERE IsPriority=1
WITH CHECK OPTION
CREATE VIEW Vwprioritycustomers
WITH VIEW METADATA
SELECT Id, Narne FROM dbo.Customers WHERE IsPriority=1
CREATE VIEW Vwprioritycustomers
WITH ENCRYPTION
SELECT Id, Narne FROM dbo.Customers WHERE IsPriority=1
CREATE VIEW Vwprioritycustomers
WITH SCHEMABINDING
SELECT Id, Name FROM dbo.Customers WHERE IsPriority=1

Explicación

Pregunta 13 de 21

1

You are developing a database that Will contain price informatiom
You need to store the prices that include a fixed precision and a scale of Six digits.
Which data type should you use?

Selecciona una de las siguientes respuestas posibles:

Float
Money
Small money
Decimal

Explicación

Pregunta 14 de 21

1

A database named AdventureWorks contains two tables named Production.Product and Sales.SaIesOrderDetaiI.
The tables contain data on the available products and a detailed order history.
The Production.Product table contains the following two columns:
• ProductlD
• Name
The Sales. SalesOrderDetail table contains the following three columns:
• SalesOrderlD
• ProductlD

You need to create a query listing all of the products that were never ordered
Which statements should you execute?

Selecciona una de las siguientes respuestas posibles:

SELECT ProductID
FROM Production.Product
EXCEPT
SELECT ProductID
FROM sales.SalesOrderDetail
ORDER BY ProductID
SELECT ProductID
FROM Production.Product
ORDER BY ProductID
EXCEPT
SELECT ProductID
FROM sales.SalesOrderDetail
SELECT ProductID
FROM Production.Product
INTERSECT
SELECT ProductID
FROM sales.SalesOrderDetail
ORDER BY ProductID
SELECT ProductID
FROM Production.Product
ORDER BY ProductID
INTERSECT
SELECT ProductID
FROM sales.SalesOrderDetail

Explicación

Pregunta 15 de 21

1

DRAG DROP
A database contains tables as shown in the exhibit. (Click the Exhibit button.)
Products that are discontinued are moved from the Products table to the DiscontinuedProducts table. Any orders for discontinued products are removed from the Orders table.
You write the following SELECT statement to return all the discontinued products:

SELECT productld FROM

You need to extend the SELECT statement to include products who do not have any orders.
Which four Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list ofTransact-SQL segments to the answer area and arrange them in the correct order
Exhibit

========================================Answer Area======================================
=======================SQL Statemenets========|========Answers===========================

UNION=======================================|===1.❌

EXCEPT======================================|===2.❌

INTERSECT====================================|===3.❌

LEFT JOIN D===================================|===4.❌

INNER JOIN===================================|

SELECT ProductId FROM Orders===================|

SELECT ProductId FROM Products=================|

ON Products.ProductId = Orders.ProductId==========|

Arrastra y suelta para completar el texto.

UNION

INTERSECT

SELECT ProductId FROM Products

ON Products.ProductId = Orders.ProductId

EXCEPT

SELECT ProductId FROM Orders

LEFT JOIN D

INNER JOIN

Explicación

Pregunta 16 de 21

1

Rellena los espacios en blanco para completar el texto.

You have a stored procedure named Procedurel_ Procedurel retrieves all order ids after a specific date. The rows for Procedurel are not sorted. Procedurel has a single parameter named Parameterl_ Parameterl uses the
varchar type and is configured to pass the specific date to Procedurel. A database administrator discovers that OrderDate is not being compared correctly to Parameterl after the data type of the column is changed to datetime.
You need to update the SELECT statement to meet the following requirements:
• Thecode must NOT use aliases_
• The code must NOT use object delimiters_
The objects called in Procedurel must be able to be resolved by all users.
OrderDate must be compared to Parameterl after the data type of Parameterl is changed to datetime.
Which SELECT statement should you use?
You Response : WHERE >

Explicación

Pregunta 17 de 21

1

You use Microsoft SQL Server to create a stored procedure as shown in the following code segment. (Line numbers are included for reference only)

01 CREATE PROCEDURE DeleteCandidate
02 @InputCandidateID INT;
03 AS
04 BEGIN
05 BEGIN TRANSACTION;
06 BEGIN TRY
07 DELETE HumanResources.JobCandidate
08 WHERE JobCandidateID = @ImputCandidateID;
09 INSERT INTO Audit.Log(Operation,OperationDate)
10 VALVES ('Delete',SYSDATETIME());
11 COMMIT TRANSACTION;
12 END TRY
13 BEGIN CATCH
14
15 COMMIT TRANSACTION;
16 ELSE
17 ROLLBACK TRANSACTION;
18 END CATCH
19 END;

The procedure can be caled within Other transactions.

You need to ensure that when the DELETE statement from the HumanResourcesJobCandidate table succeeds, the modification is retained even if the insert into the Audit.Log table fails.

Which code segment should you add to line 14?

Selecciona una de las siguientes respuestas posibles:

IF @@TRANCOUNT = 0
IF (XACT_STATE ()) = 0
IF (XACT_STATE ()) = 1
IF @@TRANCOUNT = 1

Explicación

Pregunta 18 de 21

1

DRAG DROP

You are a Microsoft SQL Server client tools to develop a Microsoft Azure SQL Database database that supports an e-leaming application.
The database consists of a Course table, a Subject table, and a CourseSubject table as
shown in the exhibit. (Click the Exhibit button.)

You need to write a trigger that meets the following requirements:

Subjects are not physically deleted, but are marked as deleted.
When a subject is deleted, the courses that offer that subject are marked as discontinued.

Which four Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list ofTransact-SQL segments to the answer area and arrange them in the correct order.

Arrastra la opción correcta a cada uno de los puntos naranjas

Ord. 1

Ord. 2

Ord 3

Ord. 4

Incorrecto 1

Incorrecto 2

Incorrecto 3

Incorrecto 4

Explicación

Pregunta 19 de 21

1

You are writing a set of queries against a FILESTREAM-enabled database.
You create a stored procedure that Will update multiple tables within a transaction
You need to ensure that if the stored procedure raises a run-time error, the entire transaction is terminated and rolled back-
Which Transact-SQL statement should you include at the beginning of the stored procedure?

Selecciona una de las siguientes respuestas posibles:

SET IMPLICIT TRANSACTIONS ON
SET TRANSACTION ISOLATION LEVEL SNAPSHOT
SET IMPLICIT TRANSACTIONS OFF
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SET XACT ABORT OFF
SET XACT ABORT ON

Explicación

Pregunta 20 de 21

1

You develop a Microsoft SQL Server database that has two tables named SavingAccounts and LoanAccounts. Both tables have a column named AccountNumber of the nvarchar data type
You use a third table named Transactions that has columns named Transactionld AccountNumber, Amount, and TransactionDate.
You need to ensure that when multiple records are inserted in the Transactions table, only the records that have a valid AccountNumber in the SavingAccounts or LoanAccounts are inserted.
Which Transact-SQL statement should you use?

Selecciona una de las siguientes respuestas posibles:

CREATE TRIGGER TrgValidateAccountNumber
ON Transaccions
INSTEAD OF INSERT
BEGIN
INSERT INTO Transactions
SELECT TransactionID,AccountNumber,Amount,TransactionDate FROM inserted
WHERE AccountNumber IN
(SELECT AccountNumber FROM LoanAccounts
UNION SELECT AccountNumber FROM SavingAccounts)
END
CREATE TRIGGER TrgValidateAccountNumber
ON Transaccions
FOR INSERT
BEGIN
INSERT INTO Transactions
SELECT TransactionID,AccountNumber,Amount,TransactionDate FROM inserted
WHERE AccountNumber IN
(SELECT AccountNumber FROM LoanAccounts
UNION SELECT AccountNumber FROM SavingAccounts)
END
CREATE TRIGGER TrgValidateAccountNumber
ON Transaccions
INSTEAD OF INSERT
AS
BEGIN
IF EXIST (
SELECT AccountNumber FROM inserted EXCEPT
(SELECT AccountNumber FROM LoanAccounts
UNION SELECT AccountNumber FROM SavingAccounts)
BEGIN
ROLLBACK TRAN
END
END
CREATE TRIGGER TrgValidateAccountNumber
ON Transaccions
FOR INSERT
AS
BEGIN
IF EXIST (
SELECT AccountNumber FROM inserted EXCEPT
(SELECT AccountNumber FROM LoanAccounts
UNION SELECT AccountNumber FROM SavingAccounts)
BEGIN
ROLLBACK TRAN
END
END

Explicación

Pregunta 21 de 21

1

DRAG DROP
You administer a Microsoft SQL Server database. You use an OrderDetail table that has the following definition.

CREATE TABLE [dbo].[OrderDetail]
([SalesOrderID] [INT] NOT NULL,
[SalesOrderDetailID] [INT] IDENTITY(1,1) NOT NULL,
[CarrierTrackingNumber] [NVARCHAR] (25) NULL,
[OrderQty] [SMALLINT] NOT NULL,
[SpecialOfferID] [INT] NULL,
[UnitPrice] [MONEY] NOT NULL);

You need to create a non-clustered index on the SalesOrderID column in the OrderDetail table to include only rows that contain a value in the SpecialOfferID column.
Which four Transact-SQL statements should you use?

(To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.)

❌
❌
❌
❌
❌

Arrastra y suelta para completar el texto.

CREATE NONCLUSTERED

INDEX FIndx_SpecialOfferID

ON dbo.OrderDetail(SalesOrderID)

WHERE

Special OfferID IS NOT NULL

CREATE CLUSTERED

FILTER ON

AS FILTERED INDEX

	Creado por Cristian A. Castro Campoverde hace más de 7 años