Latest Real 70-462 Tests Dumps and VCE Exam Questions 41-50

Ensurepass

QUESTION 41

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to be notified immediately when fatal errors occur on Server01. What should you create?

 

A.      an Alert

B.      a Server Audit Specification

C.      an Extended Event session

D.      a Resource Pool

E.       a Policy

F.       a SQL Profiler Trace

G.      a Database Audit Specification

 

Correct Answer: A

 

 

QUESTION 42

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.      an Extended Event session

B.      a Policy

C.      a Database Audit Specification

D.      an Alert

E.       a Server Audit Specification

F.       a SQL Profiler Trace

G.      a Resource Pool

 

Correct Answer: F

 

 

QUESTION 43

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to prevent users from disabling server audits in Server01. What should you create?

 

A.      an Alert

B.      a Resource Pool

C.      an Extended Event session

D.      a Database Audit Specification

E.       a SQL Profiler Trace

F.       a Server Audit Specification

G.      a Policy

 

Correct Answer: G

 

 

QUESTION 44

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. 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 any of the tables in the Customers schema. Which Transact-SQL statement should you use?

 

A.      REVOKE SELECT ON Schema::Customers FROM UserA

B.      DENY SELECT ON Object::Regions FROM UserA

C.      EXEC sp_addrolemember ‘Sales’, ‘UserA’

D.      DENY SELECT ON Object::Regions FROM Sales

E.       REVOKE SELECT ON Object::Regions FROM UserA

F.       DENY SELECT ON Schema::Customers FROM Sales

G.      DENY SELECT ON Schema::Customers FROM UserA

H.      EXEC sp_droprolemember ‘Sales’, ‘UserA’

I.        REVOKE SELECT ON Object::Regions FROM Sales

J.        REVOKE SELECT ON Schema::Customers FROM Sales

 

Correct Answer: F

 

 

 

QUESTION 45

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. The Sales role is granted the Select permission on the Customers schema. You need to ensure that UserA is disallowed to select from any of the tables in the Customers schema. Which Transact-SQL statement should you use?

 

A.      DENY SELECT ON Object::Regions FROM UserA

B.      DENY SELECT ON Object::Regions FROM Sales

C.      REVOKE SELECT ON Schema::Customers FROM Sales

D.      REVOKE SELECT ON Schema::Customers FROM UserA

E.       REVOKE SELECT ON Object::Regions FROM Sales

F.       REVOKE SELECT ON Object::Regions FROM UserA

G.      DENY SELECT ON Schema::Customers FROM Sales

H.      DENY SELECT ON Schema::Customers FROM UserA

I.        EXEC sp_addrolemember ‘Sales’, ‘UserA’

J.        EXEC sp droprolemember ‘Sales’, ‘UserA’

 

Correct Answer: H

 

 

QUESTION 46

You administer a SQL 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. The Sales role is granted the Select permission on the Customers schema. You need to remove the Select permission for UserA on the Regions table. You also need to ensure that UserA can still access all the tables in the Customers schema, including the Regions table, through the Sales role permissions. Which Transact-SQL statement should you use?

 

A.      DENY SELECT ON Object::Regions FROM UserA

B.      DENY SELECT ON Schema::Customers FROM UserA

C.      EXEC sp_addrolemember ‘Sales’, ‘UserA’

D.      REVOKE SELECT ON Object::Regions FROM UserA

E.       REVOKE SELECT ON Object::Regions FROM Sales

F.       EXEC sp_droproiemember ‘Sales’, ‘UserA’

G.      REVOKE SELECT ON Schema::Customers FROM UserA

H.      DENY SELECT ON Object::Regions FROM Sales

I.        DENY SELECT ON Schema::Customers FROM Sales

J.        REVOKE SELECT ON Schema::Customers FROM Sales

 

Correct Answer: D

 

 

QUESTION 47

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.      REVOKE SELECT ON Schema::Customers FROM UserA

B.      REVOKE SELECT ON Object::Regions FROM UserA

C.      EXEC sp_addrolemember ‘Sales’, ‘UserA’

D.      DENY SELECT ON Schema::Customers FROM Sales

E.       EXEC sp_droprolemember ‘Sales’, ‘UserA’

F.       REVOKE SELECT ON Schema::Customers FROM Sales

G.      DENY SELECT ON Object::Regions FROM UserA

H.      REVOKE SELECT ON Object::Regions FROM Sales

I.        DENY SELECT ON Schema::Customers FROM UserA

J.        DENY SELECT ON Object::Regions FROM Sales

 

Correct Answer: J

 

 

QUESTION 48

You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that an OLTP database that includes up-to-the-minute reporting requirements can be off-loaded from the primary database to another server. You also need to be able to add indexes to the secondary database. Which configuration should you use?

 

A.        Two servers configured in different data centers

SQL Server Availability Group configured in Synchronous-Commit Availability Mode

One server configured as an Active Secondary

B.        Two servers configured in the same data center

SQL Server Availability Group configured in Asynchronous-Commit Availability Mode

One server configured as an Active Secondary

C.        Two servers configured in the same data center

A primary server configured to perform log-shipping every 10 minutes

A backup server configured as a warm standby

D.        Two servers configured in different data centers

SQL Server Availability Group configured in Asynchronous-Commit Availability Mode

E.         Two servers configured on the same subnet

SQL Server Availability Group configured in Synchronous-Commit Availability Mode

F.         SQL Server that includes an application database configured to perform transactional replication

G.        SQL Server that includes an application database configured to perform snapshot replication

H.        Two servers configured in a Windows Failover Cluster in the same data center

SQL Server configured as a clustered instance

 

Correct Answer: F

 

 

QUESTION 49

You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that data changes are sent to a non-SQL Server database server in near real time. You also need to ensure that data on the primary server is unaffected. Which configuration should you use?

 

A.        SQL Server that includes an application database configured to perform transactional

replication

B.        Two servers configured in different data centers

SQL Server Availability Group configured in Asynchronous-Commit Availability Mode

C.        Two servers configured in different data centers

SQL Server Availability Group configured in Synchronous-Commit Availability Mode

One server configured as an Active Secondary

D.        SQL Server that includes an application database configured to perform snapshot replication

E.         Two servers configured in the same data center

SQL Server Availability Group configured in Asynchronous-Commit Availability Mode

One server configured as an Active Secondary

F.         Two servers configured on the same subnet

SQL Server Availability Group configured in Synchronous-Commit Availability Mode

G.        Two servers configured in a Windows Failover Cluster in the same data center

SQL Server configured as a clustered instance

H.        Two servers configured in the same data center

A primary server configured to perform log-shipping every 10 minutes

A backup server configured as a warm standby

 

Correct Answer: A

 

 

QUESTION 50

You administer all the deployments of Microsoft SQL Server 2012 in your company. A database contains a large product catalog that is updated periodically. You need to be able to send the entire product catalog to all branch offices on a monthly basis. Which configuration should you use?

 

A.      Two servers configured in the same data center

A primary server configured to perform log-shipping every 10 minutes

A backup server configured as a warm standby

 

B.      SQL Server that includes an application database configured to perform transactional replication

C.      Two servers configured in the same data center

SQL Server Availability Group configured in Asynchronous-Commit Availability Mode

One server configured as an Active Secondary

D.      Two servers configured in a Windows Failover Cluster in the same data center

SQL Server configured as a clustered instance

E.       SQL Server that includes an application database configured to perform snapshot replication

F.       Two servers configured in different data centers

SQL Server Availability Group configured in Synchronous-Commit Availability Mode

One server configured as an Active Secondary

G.      Two servers configured on the same subnet

SQL Server Availability Group configured in Synchronous-Commit Availability Mode

H.      Two servers configured in different data centers

SQL Server Availability Group configured in Asynchronous-Commit Availability Mode

 

Correct Answer: E

 

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.