70-462 試験問題を無料オンラインアクセス
| 試験コード: | 70-462 |
| 試験名称: | Administering Microsoft SQL Server 2012/2014 Databases |
| 認定資格: | Microsoft |
| 無料問題数: | 305 |
| 更新日: | 2025-08-29 |
You are planning to install a Microsoft SQL Server database server that will be used by a web application.
You need to minimize the attack surface area.
Which two actions should you perform? Each correct answer presents part of the solution.
You administer a Microsoft SQL Server 2012 database named Orders.
Orders contain a table named OrderShip that is defined as follows:
A NULL value represents a domestic order. Ninety percent of the values in CountryCode are NULL.
Customers require a procedure that will return orders for all customers from a specified country. You create a new procedure:
Performance on this procedure is slow.
You need to alter the schema to optimize this query. Objects created must use a minimum amount of resources.
Which Transact-SQL statement should you use?
You administer a Microsoft Azure SQL Database database named Orders.
You need to create a copy of Orders named Orders_Reporting.
Which Transact-SQL command should you use?
You administer a Microsoft SQL Server database that includes a table named Application.Events.
Application.Events contains millions of records about user activity in an application.
Records in Application.Events that are more than 90 days old are purged nightly. When records are purged, table locks are causing contention with inserts.
You need to be able to modify Application.Events without requiring any changes to the applications that utilize Application.Events.
Which type of solution should you use?