Free Preview Premium PassLeader 70-761 Exam Dumps in VCE and PDF (Question 36 – Question 40)

Valid 70-761 Dumps shared by PassLeader for Helping Passing 70-761 Exam! PassLeader now offer the newest 70-761 VCE dumps and 70-761 PDF dumps, the PassLeader 70-761 exam questions have been updated and ANSWERS have been corrected, get the newest PassLeader 70-761 dumps with VCE and PDF here: http://www.passleader.com/70-761.html (74 Q&As Dumps)

BTW, DOWNLOAD part of PassLeader 70-761 dumps from Cloud Storage: https://drive.google.com/open?id=0B-ob6L_QjGLpaEZzRVFnOE9OenM

QUESTION 36
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a table named Products that contains information about the products that your company sells. The table contains many columns that do not always contain values. You need to implement an ANSI standard method to convert the NULL values in the query output to the phrase “Not Applicable”. What should you implement?

A.    the COALESCE function
B.    a view
C.    a table-valued function
D.    the TRY PARSE function
E.    a stored procedure
F.    the ISNULL function
G.    a scalar function
H.    the TRY CONVERT function

Answer: F
Explanation:
The ISNULL function replaces NULL with the specified replacement value.
References: https://msdn.microsoft.com/en-us/library/ms184325.aspx

QUESTION 37
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a database that is denormalized. Users make frequent changes to data in a primary table. You need to ensure that users cannot change the tables directly, and that changes made to the primary table also update any related tables. What should you implement?

A.    the COALESCE function
B.    a view
C.    a table-valued function
D.    the TRY PARSE function
E.    a stored procedure
F.    the ISNULL function
G.    a scalar function
H.    the TRY CONVERT function

Answer: B
Explanation:
Using an Indexed View would allow you to keep your base data in properly normalized tables and maintain data-integrity while giving you the denormalized “view” of that data.
References: http://stackoverflow.com/questions/4789091/updating-redundant-denormalized-data-automatically-in-sql-server

QUESTION 38
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a database that stores sales and order information. Users must be able to extract information from the tables on an ad hoc basis. They must also be able to reference the extracted information as a single table. You need to implement a solution that allows users to retrieve the data required, based on variables defined at the time of the query. What should you implement?

A.    the COALESCE function
B.    a view
C.    a table-valued function
D.    the TRY PARSE function
E.    a stored procedure
F.    the ISNULL function
G.    a scalar function
H.    the TRY CONVERT function

Answer: C
Explanation:
User-defined functions that return a table data type can be powerful alternatives to views. These functions are referred to as table-valued functions. A table-valued user-defined function can be used where table or view expressions are allowed in Transact-SQL queries. While views are limited to a single SELECT statement, user-defined functions can contain additional statements that allow more powerful logic than is possible in views. A table-valued user-defined function can also replace stored procedures that return a single result set.
References: https://technet.microsoft.com/en-us/library/ms191165(v=sql.105).aspx

QUESTION 39
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a table named AuditTrail that tracks modifications to data in other tables. The AuditTrail table is updated by many processes. Data input into AuditTrail may contain improperly formatted date time values. You implement a process that retrieves data from the various columns in AuditTrail, but sometimes the process throws an error when it is unable to convert the data into valid date time values. You need to convert the data into a valid date time value using the en-US format culture code. If the conversion fails, a null value must be returned in the column output. The conversion process must not throw an error. What should you implement?

A.    the COALESCE function
B.    a view
C.    a table-valued function
D.    the TRY PARSE function
E.    a stored procedure
F.    the ISNULL function
G.    a scalar function
H.    the TRY CONVERT function

Answer: H
Explanation:
A TRY_CONVERT function returns a value cast to the specified data type if the cast succeeds; otherwise, returns null.
References: https://msdn.microsoft.com/en-us/library/hh230993.aspx

QUESTION 40
Hotspot Question
You have the following subqueries: Subquery1 , Subquery2, and Subquery3. You need to replace the three subqueries with named result sets or temporary tables. The following requirements must be met:
passleader-70-761-dumps-401
Which replacement techniques should you use? To answer, select the appropriate options in the answer area.
passleader-70-761-dumps-402

Answer:
passleader-70-761-dumps-403
Explanation:
Subquery1: common table expression (CTE)
A common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query. Unlike a derived table, a CTE can be self-referencing and can be referenced multiple times in the same query.
Subquery2: global temporary table
Global temporary tables are visible to any user and any connection after they are created, and are deleted when all users that are referencing the table disconnect from the instance of SQL Server.
Subquery3: local temporary table
Local temporary tables are visible only to their creators during the same connection to an instance of SQL Server as when the tables were first created or referenced. Local temporary tables are deleted after the user disconnects from the instance of SQL Server.
References:
https://technet.microsoft.com/en-us/library/ms190766(v=sql.105).aspx
https://technet.microsoft.com/en-us/library/ms186986.aspx


Get the newest PassLeader 70-761 VCE dumps here: http://www.passleader.com/70-761.html (74 Q&As Dumps)

And, DOWNLOAD the newest PassLeader 70-761 PDF dumps from Cloud Storage for free: https://drive.google.com/open?id=0B-ob6L_QjGLpaEZzRVFnOE9OenM