READ Free Dumps For Microsoft- 70-461
| Question ID 15046 | You have a database application that uses Microsoft SQL Server 2012. You have a query
named Query1 that returns four columns from a frequently updated table that has a
clustered index. Three of the columns are referenced in the WHERE clause of the query.
The three columns are part of a non-clustered index. The fourth column is not referenced in
the WHERE clause.
Users report that the application begins to run slowly. You determine that the root cause for
the performance issue is Query1.
You need to optimize the statement.
What should you do?
|
| Option A | Add a HASH hint to the query.
|
| Option B | Add a LOOP hint to the query.
|
| Option C | Add a FORCESEEK hint to the query.
|
| Option D | Add an INCLUDE clause to the index.
|
| Option E | Add a FORCESCAN hint to the Attach query.
|
| Option F | Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query.
|
| Correct Answer | K |
Explanation Explanation: SET SHOWPLAN_XML (Transact-SQL) causes SQL Server not to execute Transact-SQL statements. Instead, SQL Server returns detailed information about how the statements are going to be executed in the form of a well-defined XML document Incorrect: Not F: Columnstore indexes in the SQL Server Database Engine can be used to significantly speed-up the processing time of common data warehousing queries. Typical data warehousing workloads involve summarizing large amounts of data. But in this question the query is run on a table that is updated frequently, not a warehousing table. Reference: SET SHOWPLAN_XML (Transact-SQL) https://msdn.microsoft.com/en-us/library/ms187757.aspx
| Question ID 15047 | You develop a Microsoft SQL Server 2012 database. The database is used by two web
applications that access a table named Products.
You want to create an object that will prevent the applications from accessing the table
directly while still providing access to the required data.
You need to ensure that the following requirements are met:
✑ Future modifications to the table definition will not affect the applications' ability to
access data.
✑ The new object can accommodate data retrieval and data modification.
You need to achieve this goal by using the minimum amount of changes to the
applications.
What should you create for each application?
|
| Option A | Synonyms
|
| Option B | Common table expressions
|
| Option C | Views
|
| Option D | Temporary tables
|
| Correct Answer | C |
Explanation Reference: http://msdn.microsoft.com/en-us/library/ms190174.aspx