This page was exported from Offering New Exam PDF And Exam VCE Dumps For Free Downloading [ ] Export date:Sat Aug 17 17:16:16 2019 / +0000 GMT ___________________________________________________ Title: [Q61-Q68] Lead2pass 2018 100% Valid 70-761 Dumps Guarantee 100% Pass 70-761 Certification Exam --------------------------------------------------- 2018 Exam 70-761 Dumps From Lead2pass Cover All New 70-761 New Questions: QUESTION 61As 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.    tinyintB.    bitC.    floatD.    numericAnswer: BExplanation:bit is an integer data type that can take a value of 1, 0, or NULL. QUESTION 62You'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 BYB.    HAVING, GROUP BY, ORDER BYC.    ORDER BY, GROUP BY, HAVINGD.    GROUP BY, ORDER BY, HAVING Answer: A QUESTION 63You 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 SERIALIZABLEB.    SET XACT_ABORT ONC.    SET IMPLICIT TRANSACTIONS OFFD.    SET XACT_ABORT OFF Answer: BExplanation:SET XACT_ABORT - Specifies whether SQL Server automatically rolls back the current transaction when a Transact-SQL statement raises a run-time error. QUESTION 64Which index type gives high performance gains for analytic queries that scan large amounts of data, especially on large tables? A.    RowstoreB.    Columnstore Answer: BExplanation: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 65You 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.    PIVOTB.    UNPIVOT Answer: A QUESTION 66A 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 theseB.    INSTEAD OF triggers fire in place of the triggering action and before constraints are processedC.    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 67Which 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.    AVGB.    COMPUTEC.    None of theseD.    SUM Answer: C QUESTION 68The 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 COMMITTEDB.    READ UNCOMMITTEDC.    REPEATABLE READD.    SERIALIZABLE Answer: A 70-761 dumps full version (PDF&VCE): Large amount of free 70-761 exam questions on Google Drive: You may also need: 70-762 exam dumps: 70-764 exam dumps: 70-765 exam dumps: 70-767 exam dumps: 70-768 exam dumps: --------------------------------------------------- Images: --------------------------------------------------- --------------------------------------------------- Post date: 2018-01-03 06:49:25 Post date GMT: 2018-01-03 06:49:25 Post modified date: 2018-01-03 06:49:25 Post modified date GMT: 2018-01-03 06:49:25 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from