Online Access Free 070-461 Exam Questions

You are developing a database that will contain price information.
You need to store the prices that include a fixed precision and a scale of six digits.
Which data type should you use?

• A.Smallmoney
• B.Money
• C.Numeric
• D.Varchar

You need to create a view named uv_CustomerFullNames. The view must prevent the underlying structure of the customer table from being changed.
Part of the correct T-SQL statement has been provided in the answer area. Provide the complete code.

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

Your database contains a table named Customer that has columns named CustomerID and Name.
You want to write a query that retrieves data from the Customer table sorted by Name listing 20 rows at a time.
You need to view rows 41 through 60.
Which Transact-SQL query should you create?

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

You create a view based on the following statement:

You grant the Select permission to User1.
You need to change the view so that it displays only the records that were processed in the month prior to the current month. You need to ensure that after the changes, the view functions correctly for User1.
Which Transact-SQL statement should you use?

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

You use a Microsoft SQL Server 2012 database.
You want to create a table to store Microsoft Word documents.
You need to ensure that the documents must only be accessible via Transact-SQL queries.
Which Transact-SQL statement should you use?

• A.CREATE TABLE DocumentStore AS FileTable
• B.CREATE TABLE DocumentStore
  (
  [Id] hierarchyid,
  [Document] NVARCHAR NOT NULL
  )
  GO
• C.CREATE TABLE DocumentStore
  (
  [Id] INT NOT NULL PRIMARY KEY,
  [Document] VARBINARY(MAX) NULL
  )
  GO
• D.CREATE TABLE DocumentStore
  (
  [Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE,
  [Document] VARBINARY(MAX) FILESTREAM NULL
  )
  GO