You need to create a database object that meets the following requirements: ✑ accepts a product identified as input ✑ calculates the total quantity of a specific product, including quantity on hand and quantity on order ✑ caches and reuses execution plan ✑ returns a value ✑ can be called from within a SELECT statement ✑ can be used in a JOIN clause What should you create?

Correct Answer: a temporary table that has a columnstore index

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?

Correct Answer: the COALESCE function

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?

Correct Answer: the TRY_PARSE function

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?

Correct Answer: a table-valued function

You have a database that contains the following tables: You need to write a query that returns a list of all customers who have not placed orders. Which Transact-SQL statement should you run?

Correct Answer: SELECT custid FROM Sales.Customers INTERSECT SELECT custid FROM Sales.Orders

Welcome to awslagi.com – Sharing AWS, Google Cloud, Microsoft Azure IT Exams. It's free for all!

Querying Data with Transact-SQL

Query data with Transact-SQL accurately and efficiently.

4.8★★★★★(270 ratings)

19,486 studentsIntermediate

Build strong SQL querying skills using Transact-SQL for data retrieval, filtering, grouping, and analysis. The exam provides a practical foundation for anyone working with SQL Server data. This certification is valuable for analysts, developers, and database learners who need reliable query skills. It supports better data understanding and stronger technical performance in data-centric roles.

What you'll learn

Write T-SQL queries- Join and filter data- Aggregate results- Use functions and expressions- Work with query logic

70-761

Lectures2

Quizzes0

Duration30 week

Students19,486

$20.00

📢 Unlock Full Access to Success!

"The content displayed here is a promotional preview and contains only 50% of the actual exam database. To access the complete set of updated questions, please upgrade to the Full Version."

👉 Click the button and follow the instructions to secure your full access immediately!