getcertified4sure.com

Top Refined 70-462 dumps Tips!




Act now and download your Microsoft 70-462 test today! Do not waste time for the worthless Microsoft 70-462 tutorials. Download Up to the minute Microsoft Administering Microsoft SQL Server 2012 Databases exam with real questions and answers and begin to learn Microsoft 70-462 with a classic professional.

2021 Mar 70-462 exam answers

Q11. You administer a Windows Azure SQL Database database named Inventory that contains a stored procedure named p_AddInventory. 

Users need to be able to SELECT from all tables in the database and execute the stored procedure. 

You need to grant only the necessary permissions. 

What should you do? 

A. Grant EXECUTE permission on p_AddInventory to all users. Grant VIEW DEFINITION to all users. 

B. Grant EXECUTE permission on p_AddInventory to all users. Add all users to the db_datawriter role. 

C. Add all users to the db_owner role. 

D. Grant EXECUTE permission on p_Add!nventory to all users. Add all users to the db_datareader role. 

Answer:


Q12. You administer several Microsoft SQL Server 2012 database servers. Merge replication has been configured for an application that is distributed across offices throughout a wide area network (WAN). 

Many of the tables involved in replication use the XML and varchar (max) data types. Occasionally, merge replication fails due to timeout errors. 

You need to reduce the occurrence of these timeout errors. 

What should you do? 

A. Set the Merge agent on the problem subscribers to use the slow link agent profile. 

B. Create a snapshot publication, and reconfigure the problem subscribers to use the snapshot publication. 

C. Change the Merge agent on the problem subscribers to run continuously. 

D. Set the Remote Connection Timeout on the Publisher to 0. 

Answer:


Q13. You administer a Windows Azure SQL Database database named Human_Resources. The database contains 2 tables named Employees and SalaryDetails. 

You add two Windows groups as logins for the server: 

CORP\Employees - All company employees CORP\HRAdmins - HR administrators only HR Administrators are also company employees. 

You need to grant users access according to the following requirements: 

CORP\Employees should have SELECT access to the Employees table. 

Only users in CORP\HRAdmins should have SELECT access to the SalaryDetails table. 

Logins are based only on Windows security groups. 

What should you do? 

A. Create a database role called Employees. 

Add CORP\Employees to the db_datareader role. 

Add all company employees except HR administrators to the Employees role. 

Deny SELECT access to the SalaryDetails table to the Employees role. 

B. Create a database role called HRAdmins. 

Add all company employees except HR administrators to the db_datareader role, 

Add all HR administrators to the HRAdmins role. 

Grant SELECT access to the SalaryDetails table to the HRAdmins role. 

Deny SELECT access to the SalaryDetails table to the db_datareader role. 

C. Create two database roles: Employees and HRAdmins. Add all company employees to the Employees role. 

Add HR administrators to the HRAdmins role. 

Grant SELECT access to all tables except SalaryDetails to the Employees role. 

Grant SELECT access to the SalaryDetails table to the HRAdmins role. 

Deny SELECT access to the SalaryDetails table to the Employees role. 

D. Create a database role called Employees. 

Add all HR administrators to the db_datareader role. 

Add all company employees to the Employees role. 

Grant SELECT access to all tables except the SalaryDetails table to the Employees role. 

Deny SELECT access to the SalaryDetails table to the Employees role. 

Answer:


Q14. You install a Microsoft SQL Server 2012 instance. 

The instance will store data extracted from two databases running on Windows Azure SQL Database. 

You hire a data steward to perform interactive data cleansing and ad hoc querying and updating of the data. 

You need to ensure that the data steward is given the correct client tools to perform these tasks. 

Which set of tools should you install? 

A. SQL Server Management Studio and Distributed Reply Client 

B. Data Quality Client and SQL Server Data Tools 

C. Data Quality Client and Distributed Replay Client 

D. SQL Server Management Studio and Master Data Services 

Answer: B


Q15. 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 

Answer:


Improve 70-462 testing engine:

Q16. You administer a Microsoft SQL Server 2012 instance. After a routine shutdown, the drive that contains tempdb fails. 

You need to be able to start the SQL Server. 

What should you do? 

A. Modify tempdb location in startup parameters. 

B. Start SQL Server in minimal configuration mode. 

C. Start SQL Server in single-user mode. 

D. Configure SQL Server to bypass Windows application logging. 

Answer:


Q17. You are the administrator of a Microsoft SQL Server 2012 server. 

Some applications consume significant resources. You need to manage the server workload by restricting resource-intensive applications 

You need to dynamically limit resource consumption. 

What should you do? 

A. Set up Service Broker to ensure that applications are not allowed to consume more than the specified amount of resources. 

B. Configure Resource Pools, Workload Groups, and Classifier Function, and then enable the Resource Governor. 

C. Configure Extended Events to monitor and restrict resource limits allowed by each application type. 

D. Create a new Plan Guide with a Scope Type of sql and define the resource limits for each application. 

Answer:


Q18. You administer a SQL Server 2012 database instance. 

You need to configure the SQL Server Database Engine service on a failover cluster. 

Which user account should you use? 

A. The BUILTIN\LocalService account 

B. A domain user 

C. A local administrative user 

D. The BUILTIN\NetworkService account 

Answer:


Q19. You administer a Microsoft SQL Server 2012 database. You want to make a full backup of the database to a file on disk. 

In doing so, you need to output the progress of the backup. 

Which backup option should you use? 

A. STATS 

B. COMPRESSION 

C. CHECKSUM 

D. IN IT 

Answer:


Q20. 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 

Answer: