70-761

DRAG DROP You query a database that includes two tables: Project and Task. The Project table includes the following columns: Task level is defined using the following rules: You need to determine the task level for each task in the hierarchy. Which five Transact-SQL segments should you use to develop...

You have a database that stores sales and order information. Users must be able to extract information from the tables on an ad hoc basis. They must also be able to reference the extracted information as a single table. You need to implement a solution that allows users to retrieve...

DRAG DROP You query a database that includes two tables: Project and Task. The Project table includes the following columns: Task level is defined using the following rules: You need to determine the task level for each task in the hierarchy. Which five Transact-SQL segments should you use to develop...

DRAG DROP You need to create a stored procedure that meets the following requirements: - Produces a warning if the credit limit parameter is greater than 7,000 - Propagates all unexpected errors to the calling process How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQP segments...

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...

DRAG DROP You need to create a stored procedure to update a table named Sales.Customers. The structure of the table is shown in the exhibit. (Click the exhibit button.) The stored procedure must meet the following requirements: - Accept two input parameters. - Update the company name if the customer...

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?A . B . C . D . E . View AnswerAnswer: E

HOTSPOT You run the following Transact-SQL statement: You need to ensure that you can insert data into the table. What are the characteristics of the data? To answer, select the appropriate options in the answer area. View AnswerAnswer:

CORRECT TEXT You work for an organization that monitors seismic activity around volcanos. You have a table named GroundSensors. The table stored data collected from seismic sensors. It includes the columns describes in the following table: The database also contains a scalar value function named NearestMountain that returns the name...

DRAG DROP You have a database that includes the following tables: You need to create a list of all customer IDs and the date of the last order that each customer placed. If the customer has not placed any orders, you must return the date January 1, 1900. The column...