70-462 試験問題を無料オンラインアクセス

You administer a Microsoft SQL Server 2012 database.
You provide temporary securityadmin access to User1 to the database server.
You need to know if User1 adds logins to securityadmin.
Which server-level audit action group should you use?

• A.SERVER_PRINCIPAL_IMPERSONATION_GROUP
• B.SERVER_STATE_CHANGE_GROUP
• C.SUCCESSFUL_LOGIN_GROUP
• D.SERVER_ROLE_MEMBER_CHANGE_GROUP

You have a default installation of SQL Server that hosts an Online Transaction Processing (OLTP) application.
Users report that they experience poor overall query performance for the application.
You query the wait statistics and discover that the two top waits are CXPACKET and SOS_SCHEDULER_YIELD.
You need to modify the SQL Server settings to resolve the issue causing the poor query performance.
Which two settings should you modify? Each correct answer presents part of the solution.

• A.max degree of parallelism (MAXDOP)
• B.cost threshold for parallelism
• C.Minimum Memory
• D.Boost SQL Server priority
• E.optimize for ad hoc workloads

You develop a Microsoft SQL Server database that contains a heap named OrdersHistorical.
You write the following Transact-SQL query:
INSERT INTO OrdersHistorical
SELECT * FROM CompletedOrders
You need to optimize transaction logging and locking for the statement.
Which table hint should you use?

• A.TABLOCK
• B.HOLDLOCK
• C.UPDLOCK
• D.ROWLOCK
• E.XLOCK

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.
You need to diagnose deadlocks that happen when executing a specific set of stored procedures by recording events and playing them back on a different test server.
What should you create?

• A.A Database Audit Specification
• B.A Resource Pool
• C.A SQL Profiler Trace
• D.A Policy
• E.A Server Audit Specification
• F.An Alert
• G.An Extended Event session

You administer a SQL Server 2012 server that contains a database named SalesDb.
SalesDb contains a schema named Customers that has a table named Regions.
A user named UserA is a member of a role named Sales.
UserA is granted the Select permission on the Regions table and the Sales role is granted the Select permission on the Customers schema.
You need to ensure that the Sales role, including UserA, is disallowed to select from the Regions table.
Which Transact-SQL statement should you use?

• A.EXEC sp_droprolemember 'Sales', 'UserA'
• B.REVOKE SELECT ON Object::Regions FROM UserA
• C.EXEC sp_addrolemember 'Sales', 'UserA'
• D.DENY SELECT ON Schema::Customers FROM Sales
• E.REVOKE SELECT OK Schema::Customers FROM UserA
• F.DENY SELECT ON Object::Regions FROM Sales
• G.REVOKE SELECT ON Schema::Customers FROM Sales
• H.DENY SELECT ON Object::Regions FROM UserA
• I.DENY SELECT ON Schema::Customers FROM UserA
• J.REVOKE SELECT ON Object::Regions FROM Sales