[Q61-Q68] Official 70-761 Exam Preparation Download From Lead2pass

Pass 70-761 Exam By Exercising Lead2pass Latest 70-761 VCE And PDF Dumps:

https://www.lead2pass.com/70-761.html

QUESTION 61
As part of a new enterprise project, you’re designing a new table to store financial transactions.
This table could eventually store millions of rows and so storage space is very important.
One of the columns in the table will store either a 1 or 0 value. Which data type would be most appropriate?

A.    tinyint
B.    bit
C.    float
D.    numeric

Answer: B
Explanation:
bit is an integer data type that can take a value of 1, 0, or NULL.

QUESTION 62
You’re creating a new query that will select rows from a products tables.
The query works out the count of products within each category by grouping on the category, filtering by categories that contain more than one product and then sorting the results in category order.
In which order should these clauses be used in the query?

A.    GROUP BY, HAVING, ORDER BY
B.    HAVING, GROUP BY, ORDER BY
C.    ORDER BY, GROUP BY, HAVING
D.    GROUP BY, ORDER BY, HAVING

Answer: A

QUESTION 63
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?

A.    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
B.    SET XACT_ABORT ON
C.    SET IMPLICIT TRANSACTIONS OFF
D.    SET XACT_ABORT OFF

Answer: B
Explanation:
SET XACT_ABORT – Specifies whether SQL Server automatically rolls back the current transaction when a Transact-SQL statement raises a run-time error.

QUESTION 64
Which index type gives high performance gains for analytic queries that scan large amounts of data, especially on large tables?

A.    Rowstore
B.    Columnstore

Answer: B
Explanation:
Use columnstore indexes on data warehousing and analytics workloads, especially on fact tables, since they tend to require full table scans rather than table seeks.

QUESTION 65
You can use the PIVOT and UNPIVOT relational operators to change a table-valued expression into another table.
Which clause rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, and performs aggregations where they are required on any remaining column values that are wanted in the final output?

A.    PIVOT
B.    UNPIVOT

Answer: A

QUESTION 66
A DML trigger is an action programmed to execute when a data manipulation language (DML) event occurs in the database server.
DML events include UPDATE, INSERT, or DELETE statements issued against a table or view.
Which of the following is TRUE regarding INSTEAD OF triggers?

A.    All of these
B.    INSTEAD OF triggers fire in place of the triggering action and before constraints are processed
C.    If there are AFTER triggers on the table, they will fire after constraint processing.
D.    If the constraints are violated, the AFTER trigger is not executed.

Answer: A

QUESTION 67
Which Transact-SQL clause is described below?
Generates totals that appear as additional summary columns at the end of the result set.
When used with BY, the ___ clause generates control-breaks and subtotals in the result set.

A.    AVG
B.    COMPUTE
C.    None of these
D.    SUM

Answer: C

QUESTION 68
The transaction isolation level controls the locking and row versioning behavior of Transact-SQL statements issued by a connection to SQL Server.
Which of the following transaction isolation levels is the default in SQL Server 2016?

A.    READ COMMITTED
B.    READ UNCOMMITTED
C.    REPEATABLE READ
D.    SERIALIZABLE

Answer: A

70-761 dumps full version (PDF&VCE): https://www.lead2pass.com/70-761.html

Large amount of free 70-761 exam questions on Google Drive: https://drive.google.com/open?id=0B3Syig5i8gpDU2RSQnhzX2pIZVE

You may also need:

70-762 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDMW9NcjJrQXlsMGs

70-764 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDUjBoM0pVQnlUTlU

70-765 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDejczeWp0aURaSnM

70-767 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDdTF0R0taLWgxSmc

70-768 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDZ2pRQkV6Vnc4dHc