70-461 試験問題を無料オンラインアクセス

You use Microsoft SQL Server 2012 to develop a database application.
Your application sends data to an NVARCHAR(MAX) variable named @var.
You need to write a Transact-SQL statement that will find out the success of a cast to a decimal (36,9).
Which code segment should you use?

• A.SELECT
  IF(TRY_PARSE(@var AS decimal(36,9)) IS NULL,
  'True',
  'False'
  )
  AS BadCast
• B.BEGIN TRY
  SELECT
  convert (decimal(36,9), @var) as Value,
  'True' As BadCast
  END TRY
  BEGIN CATCH
  SELECT
  convert (decimal(36,9), @var) as Value,
  'False' As BadCast
  END CATCH
• C.SELECT
  CASE
  WHEN convert (decimal(36,9), @var) IS NULL
  THEN 'True'
  ELSE 'False'
  END
  AS BadCast
• D.TRY(
  SELECT convert (decimal(36,9), @var)
  SELECT 'True' As BadCast
  )
  CATCH(
  SELECT 'False' As BadCast
  )

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

You need to create a view named uv_CustomerFullName to meet the following requirements:
* The code must NOT include object delimiters.
* The view must be created in the Sales schema.
* Columns must only be referenced by using one-part names.
* The view must return the first name and the last name of all customers.
* The view must prevent the underlying structure of the customer table from being changed.
* The view must be able to resolve all referenced objects, regardless of the user's default schema.
Which code segment should you use?
To answer, type the correct code in the answer area.

• A.CREATE VIEW Sales.uv_CustomerFullName
  WITH SCHEMABINDING
  AS
  SELECT FirstName, LastName
• B.CREATE VIEW Sales.uv_CustomerFullName
  WITH SCHEMABINDING
  AS
  SELECT FirstName, LastName
  FROM Sales.Customers

A database contains tables as shown in the exhibit. (Click the Exhibit button.) Customer who are inactive are moved from the Customers table to the InactiveCustomers table. Any orders for inactive customers are removed from the Orders table.
You write the following SELECT statement to return all the inactive customers:
SELECT CustomerId FROM InactiveCustomers
You need to extend the SELECT statement to include customers who do not have any orders.
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.
Exhibit

正解：

Explanation:
EXCEPT returns distinct rows from the left input query that aren't output by the right input query.
References: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-except-and-intersect-transact-sql?view=sql-server-2017

You develop a SQL Server database for a large multinational company.
You must develop a stored procedure to loop through employee information and return data for one employee at a time.
How should you complete the stored procedure? To answer, drag the appropriate Transact-SQL segment to the correct locations in the answer area. 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.

正解：

Explanation:
Box 1: CURSOR VARYING OUTPUT
Transact-SQL stored procedures can use the cursor data type only forOUTPUT parameters. If the cursor data type is specified for a parameter, both the VARYING and OUTPUT parameters are required. If the VARYING keyword is specified for a parameter, the data type must be cursor and the OUTPUT keyword must be specified.
Box2: FORWARD_ONLY STATIC
Box 3: CLOSE
Box 4: DEALLOCATE
References:https://technet.microsoft.com/en-us/library/ms175498(v=sql.105).aspx

You use a contained database named ContosoDb within a domain. You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations.
Which type of user should you create?

• A.SQL user with a custom SID
• B.Domain user
• C.SQL user without login
• D.SQL user with login