ExamDumpster

Free 70-761 sample questions

Here are free 70-761 sample questions on T-SQL, each with an answer and an explanation. They cover joins, window functions and error handling. Use them to practise query skills that still matter in SQL Server today.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 6 of 12 free sample questions.

Question 1Choose one

Your organization’s Sales department has two tables named Clients and Purchases. The Sales department requires an inventory of all client IDs and the date of the last purchase made by each client. This info should be recorded in two columns, named ClientID and LatestPurchaseDate. A specified date has to be returned for clients that have not made any purchases. Your Transact-SQL statement has to include a specific type of JOIN. Solution: You include a LEFT OUTER JOIN. Has the requirement been satisfied?

Question 2Choose one

You are required to substitute three subqueries named SQ1, SQ2, and SQ3 with named result sets or temporary tables. The result set of SQ1 has to make use of the execution scope of a SELECT statement. Other session users have to see the result set of SQ2 prior to it being removed. Other statements in the same session should have access to the result set of SQ3. However, the result set of SQ3 should be invisible to other sessions. You have to make sure that a suitable subquery replacement is used for SQ2. Which of the following is the option you should use?

Question 3Choose one

Your company has a database that includes the Clients, Towns, and Clientclassifications tables. The database monitors purchases and shipping for American clients. All of these tables have system versioning configured. You have been tasked with writing a query that retrieves data for analyzing the effects of discounts on credit limits. The main purpose of the analysis is to ascertain the average credit limit for every standard discount percentage, from 0% to 4%. Which of the following should be included in your Transact-SQL statement?

Question 4Choose one

You are required to generate a table named Expenses that includes an ID, a Motivation, and a Total column. You informed that the ID column should be configured as the table’s primary key, which has to be a value that is globally exclusive. When INSERT procedures are executed, the value must be created automatically. The Motivation column should be configured to allow for values from various languages, with a maximum of 600 characters for explaining why a payment was made. The Total column should be configure to contain monetary values, and should not result in computations generating rounding inaccuracies. You need to use the correct data type for the Motivation column. Solution: You make use of the Nvarchar data type. Has the requirement been satisfied?

Question 5Choose one

You are preparing to create a table using a Transact-SQL statement. You need to assign a property to a column, which prompts the Database Engine to supply a unique, incremental value when a new row is added to the table. Which of the following is property you should assign?

Question 6Choose one

You are tasked with making sure that Users are capable of obtaining data from the tables in a specific database in an informal manner. The data retrieved should be referenced as a single table. You are informed that users must be able to retrieve the necessary information according to the variables stated when the query is made. Solution: Include a TRY_PARSE function in the Transact-SQL query. Has the requirement been satisfied?

6 more free samples are waiting

Create a free account to unlock the whole 70-761 sample bank, or get full access to all 52 practice questions in the simulator.

Create account