Free Microsoft 70-461 Exam Dumps Questions & Answers
| Exam Code/Number: | 70-461Join the discussion |
| Exam Name: | Querying Microsoft SQL Server 2012/2014 |
| Certification: | Microsoft |
| Free Question Number: | 252 |
| Publish Date: | Nov 14, 2026 |
| # of views: | 4903 |
|
|
|
You develop a Microsoft SQL Server 2012 database. You need to create a batch process that meets the following requirements:
* Status information must be logged to a status table.
* If the status table does not exist at the beginning of the batch, it must be created.
Which object should you use?
You use a Microsoft SQL Server 2012 database that contains two tables named SalesOrderHeader and SalesOrderDetail. The indexes on the tables are as shown in the exhibit. (Click the Exhibit button.)
You write the following Transact-SQL query:
You discover that the performance of the query is slow. Analysis of the query plan shows table scans where the estimated rows do not match the actual rows for SalesOrderHeader by using an unexpected index on SalesOrderDetail.
You need to improve the performance of the query.
What should you do?
Your application contains a stored procedure for each country. Each stored procedure accepts an employee identification number through the @EmpID parameter.
You need to build a single process for each employee that will execute the appropriate stored procedure based on the country of residence.
Which approach should you use?
You have a database that contains the tables as shown in the exhibit. (Click the Exhibit button.)
You need to create a query that returns a list of products from Sales.ProductCatalog. The solution must meet the following requirements:
* UnitPrice must be returned in descending order.
* The query must use two-part names to reference the table.
* The query must use the RANK function to calculate the results.
* The query must return the ranking of rows in a column named PriceRank.
* The list must display the columns in the order that they are defined in the table.
* PriceRank must appear last.
Which code segment should you use?
To answer, type the correct code in the answer area.
You are writing a set of queries against a FILESTREAM-enabled database.
You create a stored procedure that will update multiple tables within a transaction.
You need to ensure that if the stored procedure raises a runtime error, the entire transaction is terminated and rolled back.
Which Transact-SQL statement should you include at the beginning of the stored procedure?