IT認証試験問題集
毎月、ITshikenは1500人以上の受験者が試験準備を助けて、試験に合格するために受験者にご協力します
 ホームページ / 70-761 問題集  / 70-761 問題練習

Microsoft 70-761 問題練習

Querying Data with Transact-SQL 試験

最新更新時間: 2019/05/10,合計59問。

平成から令和へ:70-761 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。

実際の問題集を練習し、試験のポイントを了解し、テストに申し込むするかどうかを決めることができます。

さらに試験準備時間の35%を節約するには、70-761 問題集を使用してください。

 / 4

Question No : 1
You create a table by running the following Transact-SQL statement:



You need to develop a query that meets the following requirements:
- Output data by using a tree-like structure.
- Allow mixed content types.
- Use custom metadata attributes.
Which Transact-SQL statement should you run?

正解:

Question No : 2
You create a table by running the following Transact-SQL statement:



You are developing a report that aggregates customer data only for the year 2014. The report requires that the data be denormalized.
You need to return the data for the report.
Which Transact-SQL statement should you run?

正解:

Question No : 3
You create a table named Customers. Data stored in the table must be exchanged between web pages and web servers by using AJAX calls that use REST endpoint.
You need to return all customer information by using a data exchange format that is textbased and lightweight.
Which Transact-SQL statement should you run?

正解:

Question No : 4
You create a table by running the following Transact-SQL statement:



You are developing a report that displays customer information. The report must contain a grand total column.
You need to write a query that returns the data for the report.
Which Transact-SQL statement should you run?

正解:

Question No : 5
You create a table by running the following Transact-SQL statement:



You need to return normalized data for all customers that were added in the year 2014.
Which Transact-SQL statement should you run?

正解:

Question No : 6
You create a table by running the following Transact-SQL statement:



You need to audit all customer data.
Which Transact-SQL statement should you run?

正解:

Question No : 7
DRAG DROP
You are developing a database to track customer orders. The database contains the following tables: Sales.Customers, Sales.Orders, and Sales.OrderLines. The following table describes the columns in Sales.Customers.



The following table describes the columns in Sales.Orders.



The following table describes the columns in Sales.OrderLines.



You need to create a function that calculates the highest tax rate charged for an item in a specific order.
Which five Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.



正解:

Question No : 8
DRAG DROP
You are developing a database to track customer orders. The database contains the following tables: Sales.Customers, Sales.Orders, and Sales.OrderLines.
The following table describes the columns in Sales.Customers.



The following table describes the columns in Sales.Orders.



The following table describes the columns in Sales.OrderLines.



You need to create a stored procedure that inserts data into the Customers table.
The stored procedure must meet the following requirements:
- Data changes occur as a single unit of work.
- Data modifications that are successful are committed and a value of O is returned.
- Data modifications that are unsuccessful are rolled back. The exception severity level is set to 16 and a value of -1 is returned.
- The stored procedure uses a built-it scalar function to evaluate the current condition of data modifications.
- The entire unit of work is terminated and rolled back if a run-time error occurs during execution of the stored procedure.
How should complete the stored procedure definition? To answer, drag the appropriate Transact-SQL segments to the correct targets. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.



正解:

Question No : 9
HOTSPOT
You are developing a database to track customer orders. The database contains the following tables: Sales.Customers, Sales.Orders, and Sales.OrderLines.
The following table describes the columns in Sales.Customers.



The following table describes the columns in Sales.Orders.



The following table describes the columns in Sales.OrderLines.



You need to create a database object that calculates the total price of an order including the sales tax.
The database object must meet the following requirements:
- Reduce the compilation cost of Transact-SQL code by caching the plans and reusing them for repeated execution.
- Return a value.
- Be callable from a SELECT statement.
How should you complete the Transact-SQL statements? To answer, select the appropriate Transact-SQL segments in the answer area.



正解:

Question No : 10
DRAG DROP
You are developing a database to track customer orders. The database contains the following tables: Sales.Customers, Sales.Orders, and Sales.OrderLines.
The following table describes the columns in Sales.Customers.



The following table describes the columns in Sales.Orders.



The following table describes the columns in Sales.OrderLines.



You need to create a function that accepts a CustomerID as a parameter and returns the following information:
- all customer information for the customer
- the total number of orders for the customer
- the total price of all orders for the customer
- the average quantity of items per order
How should you complete the function definition? To answer, drag the appropriate TransactSQL segment to the correct locations. Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.



正解:

Question No : 11
You have a database that contains tables named Customer_CRMSystem and Customer_ HRSystem.
Both tables use the following structure:



The tables include the following records:
Customer_ CRMSystem



Customer_ HRSystem



Records that contain null values for CustomerCode can be uniquely identified by Customer Name.
You need to create a list of all unique customers that appear in either table.
Which Transact-SQL statement should you run?

正解:

Question No : 12
You have a database that contains tables named Customer_CRMSystem and Customer_ HRSystem.
Both tables use the following structure:



The tables include the following records:
Customer_ CRMSystem



Customer_ HRSystem



Records that contain null values for CustomerCode can be uniquely identified by Customer Name.
You need to display a Cartesian product, combining both tables.
Which Transact-SQL statement should you run?

正解:

Question No : 13
You have a database that contains tables named Customer_CRMSystem and Customer_ HRSystem.
Both tables use the following structure:



The tables include the following records:
Customer_ CRMSystem



Customer_ HRSystem



Records that contain null values for CustomerCode can be uniquely identified by Customer Name.
You need to display customers who appear in both tables and have a proper CustomerCode.
Which Transact-SQL statement should you run?

正解:

Question No : 14
You have a database that contains tables named Customer_CRMSystem and Customer_ HRSystem.
Both tables use the following structure:



The tables include the following records:
Customer_ CRMSystem



Customer_ HRSystem



Records that contain null values for CustomerCode can be uniquely identified by Customer Name.
You need to display a list of customers that do not appear in the Customer_HRSystem table.
Which Transact-SQL statement should you run?

正解:

Question No : 15
DRAG DROP
You create three tables by running the following Transact-SQL statements:



For reporting purposes, you need to find the active user count for each role, and the total active user count. The result must be ordered by active user count of each role. You must use common table expressions (CTEs).
Which four Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.



正解:

 / 4