Here are some sample 70-461 exam questions. 70-461 dumps is really great to pass exam. It contains 70-461 practice test braindumps Q&A.

An effective 70-461 exam questions preparation and grip over the entire course contents are definitely required to pass out your Microsoft Certification exam. 70-461 dumps here are reliable, comprehensive and up to the standards having 70-461 exam questions verified by Professional Experts. Our 70-461 dumps compose of 70-461 exam questions and 70-461 practice test, come in two formats i.e. in PDF file format and Online practice test software.

By using this online test engine mode you can practice 70-461 questions answers easily for the actual Microsoft 70-461 exam. You can download and try the free 70-461 dumps demo before buying exam 70-461 PDF file from Testmayor. Our excellent 70-461 exam questions dumps is a guarantee to your success in Microsoft certification exam.

Get 70-461 exam questions dumps and pass exam in first attempt.


70-461 | You develop a Microsoft SQL Server 2012 database…

Question: 12

You develop a Microsoft SQL Server 2012 database. You need to create a batch process that meets the following requirements:
Returns a result set based on supplied parameters.
Enables the returned result set to perform a join with a table.
Which object should you use?

A. Inline user-defined function
B. Stored procedure
C. Table-valued user-defined function
D. Scalar user-defined function

Answer: C

70-461 | You are developing a database that will contain…

Question: 11

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. Float
B. Money
C. Smallmoney
D. Numeric

Answer: D

70-461 | You administer a Microsoft SQL Server…

Question: 10

You administer a Microsoft SQL Server 2012 database that contains a table named OrderDetail. You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You need to reduce fragmentation. You need to achieve this goal without taking the index offline. Which Transact-SQL batch should you use?

A. CREATE INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID WITH DROP EXISTING
B. ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REORGANIZE
C. ALTER INDEX ALL ON OrderDetail REBUILD
D. ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REBUILD

Answer: B

70-461 | You use a Microsoft SQL Server 2012…

Question: 9

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
(
[Id] INT NOT NULL PRIMARY KEY,
[Document] VARBINARY(MAX) NULL
)
GO

B. CREATE TABLE DocumentStore
(
[Id] hierarchyid,
[Document] NVARCHAR NOT NULL
)
GO

C. CREATE TABLE DocumentStore AS FileTable

D. CREATE TABLE DocumentStore
(
[Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE, [Document] VARBINARY(MAX)
FILESTREAM NULL
)
GO

Answer: A

70-461 | You are developing a database application….

Question: 8

You are developing a database application by using Microsoft SQL Server 2012. An application that uses a database begins to run slowly. You discover that during reads, the transaction experiences blocking from concurrent updates. You need to ensure that throughout the transaction the data maintains the original version. What should you do?

A. Add a HASH hint to the query.
B. Add a LOOP hint to the query.
C. Add a FORCESEEK hint to the query.
D. Add an INCLUDE clause to the index.
E. Add a FORCESCAN hint to the Attach query.
F. Add a columnstore index to cover the query.
G. Enable the optimize for ad hoc workloads option.
H. Cover the unique clustered index with a columnstore index.
I. Include a SET FORCEPLAN ON statement before you run the query.
J. Include a SET STATISTICS PROFILE ON statement before you run the query.
K. Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query.
L. Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query.
M. Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query.
N. Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query.

Answer: M

70-461|You administer a Microsoft SQL Server 2012 database

Question: 7

You administer a Microsoft SQL Server 2012 database. The database contains a table named Employee.
Part of the Employee table is shown in the exhibit. (Click the Exhibit button.)
Unless stated above, no columns in the Employee table reference other tables.
Confidential information about the employees is stored in a separate table named EmployeeData. One record exists within EmployeeData for each record in the Employee table.
You need to assign the appropriate constraints and table properties to ensure data integrity and visibility. On which column in the Employee table should you use an identity specification to include a seed of 1,000 and an increment of 1?

A. DateHired
B. DepartmentID
C. EmployeeID
D. EmployeeNum
E. FirstName
F. JobTitle
G. LastName
H. MiddleName
I. ReportsToID

Answer: C

70-461|You develop a database for a travel application. You need to design tables

Question: 6

You develop a database for a travel application. You need to design tables and other database objects. You need to store media files in several tables. Each media file is less than 1 MB in size. The media files will require fast access and will be retrieved frequently. What should you do?

A. Use the CAST function.
B. Use the DATE data type.
C. Use the FORMAT function.
D. Use an appropriate collation.
E. Use a user-defined table type.
F. Use the VARBINARY data type.
G. Use the DATETIME data type.
H. Use the DATETIME2 data type.
I. Use the DATETIMEOFFSET data type.
J. Use the TODATETIMEOFFSET function.

Answer: F

Which Transact- SQL query or queries should you use?

Question: 5

You administer a Microsoft SQL Server database that supports a shopping application.
You need to retrieve a list of customers who live in territories that do not have a sales person.
Which Transact- SQL query or queries should you use? (Each correct answer presents a complete solution. Choose all that apply.)

A. SELECT CustomerID FROM Customer
WHERE TerritoryID <> SOME(SELECT TerritoryID FROM Salesperson)
B. SELECT CustomerID FROM Customer
WHERE TerritoryID <> ALL(SELECT TerritoryID FROM Salesperson)
C. SELECT CustomerID FROM Customer
WHERE TerritoryID <> ANY(SELECT TerritoryID FROM Salesperson)
D. SELECT CustomerID FROM Customer
WHERE TerritoryID NOT IN(SELECT TerritoryID FROM Salesperson)

Answer: BD

You develop a Microsoft SQL Server 2012 database

Free 70-461 Questions Answers

Question: 4

You develop a Microsoft SQL Server 2012 database.
You need to create a batch process that meets the following requirements:
– Returns a result set based on supplied parameters.
– Enables the returned result set to perform a join with a table.
Which object should you use?

A. Inline user-defined function
B. Stored procedure
C. Table-valued user-defined function
D. Scalar user-defined function

Answer: C

You develop a Microsoft SQL Server 2012 database that contains tables named Customers and Orders. The tables are related by a column named CustomerId.

Free 70-461 Questions Answers

Question No : 3

You develop a Microsoft SQL Server 2012 database that contains tables named
Customers and Orders. The tables are related by a column named Customer Id.You need to create a query that meets the following requirements:Returns the Customer Name for all customers and the Order Date for any or ders that they have placed.Results must not include customers who have not placed any orders.Which Transact-SQL query should you use?

A. SELECT Customer Name, Order Date FROM Customers LEFT OUTER JOIN Orders ON Customers.Cuscomer lD = Orders.CustomerId
B. SELECT Customer Name, Order Date FROM Customers RIGHT OUTER JOIN Orders ON Customers.Customer ID = Orders.CustomerId
C. SELECT Customer Name, Order Date FROM Customers CROSS JOIN Orders ON Customers.CustomerId = Orders.CustomerId
D. SELECT Customer Name, Order Date FROM Customers JOIN Orders ON Customers.CustomerId = Orders.CustomerId

Answer: D
Reference: http://msdn.microsoft.com/en-us/library/ms177634.aspx