70-761 認証試験、Querying Data With Transact-SQL
NO.1 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 tracks orders and deliveries for customers in North America. The database
contains the following tables:
Sales.Customers
Application.Cities
Sales.CustomerCategories
The company's development team is designing a customer directory application. The application
must list customers by the area code of their phone number. The area code is defined as the first
three characters of the phone number.
The main page of the application will be based on an indexed view that contains the area and phone
number for all customers.
You need to return the area code from the PhoneNumber field.
Solution: You run the following Transact-SQL statement:
Does the solution meet the goal?
A. No
B. Yes
Answer: B
70-761 開発 70-761 出題
Explanation:
The following indicates a correct solution:
* The function returns a nvarchar(10) value.
* Schemabinding is used.
* SELECT TOP 1 ... gives a single value
Note: nvarchar(max) is correct statement.
nvarchar [ ( n | max ) ]
Variable-length Unicode string data. n defines the string length and can be a value from 1 through
4,000. max indicates that the maximum storage size is 231-1 bytes (2 GB).
References:
https://docs.microsoft.com/en-us/sql/t-sql/data-types/nchar-and-nvarchar-transact-sql
https://sqlstudies.com/2014/08/06/schemabinding-what-why/
NO.2 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 TRY_CONVERT function
B. a view
C. a scalar function
D. the COALESCE function
E. the ISNULL function
F. a stored procedure
G. a table-valued function
H. the TRY_PARSE function
Answer: B
70-761 ウェブ
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
NO.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 includes the tables shown in the exhibit (Click the Exhibit button.)
You need to create a Transact-SQL query that returns the following information:
- the customer number
- the customer contact name
- the date the order was placed, with a name of DateofOrder
- a column named Salesperson, formatted with the employee first name, a space, and the employee
last name
- orders for customers where the employee identifier equals 4
The output must be sorted by order date, with the newest orders first.
The solution must return only the most recent order for each customer.
Solution: You run the following Transact-SQL statement:
Does the solution meet the goal?
A. Yes
B. No
Answer: A
70-761 認定デベロッパー
Explanation:
The MAX(orderdate) in the SELECT statement makes sure we return only the most recent order.
A WHERE o.empiD =4 clause is correctly used.
GROUP BY is also required.
NO.4 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. a stored procedure
B. the TRY_PARSE function
C. the COALESCE function
D. a table-valued function
E. the TRY_CONVERT function
F. a scalar function
G. a view
H. the ISNULL function
Answer: H
70-761 資料
Explanation:
The ISNULL function replaces NULL with the specified replacement value.
References: https://msdn.microsoft.com/en-us/library/ms184325.aspx
Microsoft 70-761 認証試験認定試験の難しさで近年にほとんどの受験生は資格認定試験に合格しなっかたと良く知られます。だから、我々社の有効な試験問題集は長年にわたりMicrosoft 70-761 認証試験認定資格試験問題集作成に取り組んだIT専門家によって書いてます。実際の試験に表示される質問と正確な解答はあなたのMicrosoft 70-761 認証試験認定資格試験合格を手伝ってあげます。
短時間で一番質高いMicrosoftの70-761 認証試験練習問題を探すことができますか？もしできなかったら、我々の70-761 認証試験試験資料を試していいですか？我が社の70-761 認証試験問題集は多くの専門家が数年間で努力している成果ですから、短い時間をかかってMicrosoftの70-761 認証試験試験に参加できて、予想以外の成功を得られます。それで、Microsoftの70-761 認証試験に参加する予定がある人々は速く行動しましょう。
TopExamの問題集はIT専門家がMicrosoftの70-761 認証試験認証試験について自分の知識と経験を利用して研究したものでございます。TopExamの問題集は真実試験の問題にとても似ていて、弊社のチームは自分の商品が自信を持っています。TopExamが提供した商品をご利用してください。もし失敗したら、全額で返金を保証いたします。
試験番号：70-761問題集試験科目：Querying Data with Transact-SQL
最近更新時間：2017-09-28
問題と解答：全82問 70-761 資格復習テキスト
100％の返金保証。1年間の無料アップデート。
TopExamは最新の070-698問題集と高品質のJN0-680問題と回答を提供します。TopExamの1Y0-230 VCEテストエンジンと1z1-960試験ガイドはあなたが一回で試験に合格するのを助けることができます。高品質の070-740 PDFトレーニング教材は、あなたがより迅速かつ簡単に試験に合格することを100％保証します。試験に合格して認証資格を取るのはそのような簡単なことです。
