70-761最も有効な質問と解答で勉強

Microsoft Querying Data with Transact-SQLは業界で広く認知された資格であり、取得はキャリアの信頼性を高める確かな一歩となります。Tech4Examの70-761問題集は205問を収録し、公式の出題範囲に沿って学習を組み立てられます。

Microsoft 70-761 試験概要:

Microsoft 70-761 試験シラバストピック:

70-761に挑戦する方へ – よくある質問まとめ

Microsoft Querying Data with Transact-SQL 認定 70-761 試験問題：

問題 #1

You have a database that stores information about server and application errors. The database contains the following table:
Servers

Errors

You need to return all unique error log messages and the server where the error occurs most often.
Which Transact-SQL statement should you run?

A. Option B
B. Option D
C. Option C
D. Option A

問題 #2

You have a database that includes the tables shown in the exhibit. (Click the exhibit button.)

You need to create a list of all customers and the date that the customer placed their last order. For customers who have not placed orders, you must substitute a zero for the order ID and 01/01/1990 for the date.
Which Transact-SQL statement should you run?

A. Option B
B. Option D
C. Option C
D. Option A

問題 #3

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section. You will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a database that contains a single table named tblVehicleRegistration. The table is defined as follows:

You run the following query:

The query output window displays the following error message: "Conversion failed when converting the varchar value 'AB012' to data type int." You need to resolve the error.
Solution: You modify the Transact-SQL statement as follows:

Does the solution meet the goal?

A. Yes
B. No

問題 #4

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section. you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You create a table named Customer by running the following Transact-SQL statement:

You must insert the following data into the Customer table:

You need to ensure that both records are inserted or neither record is inserted.
Solution: You run the following Transact-SQL statement:

Does the solution meet the goal?

A. Yes
B. No

問題 #5

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 ISNULL function
B. a view
C. the TRY_CONVERT function
D. a table-valued function
E. the COALESCE function
F. the TRY_PARSE function
G. a scalar function
H. a stored procedure

解説：