70_765 questions • Exam prepare

Exam contains 168 questions

Page 13 of 28

Question 73 🔥

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?

Which database solution meets these requirements?

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

B. Set up Service Broker to ensure that application are not allowed to consume more than the specified amount of resource

C. Create a new rule for each application that sets the resource limit allowed

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

Discussion of the question

Question 74 🔥

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?

Which database solution meets these requirements?

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_AddInventory to all users. Add all users to the db_datareader role.

Highly voted

Discussion of the question

Question 75 🔥

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?

Which database solution meets these requirements?

A. A domain user

B. The BUILTIN\SYSTEM account

C. A local user with Run as Service permissions

D. The SQLBrowser account

Discussion of the question

Question 76 🔥

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 SalaryDetailstable.✑ Logins are based only on Windows security groups.What should you do?

Which database solution meets these requirements?

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.

Highly voted

Discussion of the question

Question 77 🔥

You administer a Microsoft SQL Server 2012 database instance.You plan to migrate the database to Windows Azure SQL Database. You verify that all objects contained in the database are compatible with Windows Azure SQLDatabase.You need to ensure that database users and required server logins are migrated to Windows Azure SQL Database.What should you do?

Which database solution meets these requirements?

A. Use the copy database wizard

B. Use the Database Transfer wizard

C. Use SQL Server Management Studio to deploy the database to Windows Azure SQL Database

D. Backup the database from the local server and restore it to Windows Azure SQL Database

Discussion of the question

Question 78 🔥

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets stated goals.Your company plans to use Microsoft Azure Resource Manager templates for all future deployments of SQL Server on Azure virtual machines.You need to create the templates.Solution: You use Visual Studio to create a XAML template that defines the deployment and configuration settings for the SQL Server environment.Does the solution meet the goal?

Which database solution meets these requirements?

A. Yes

B. No

Discussion of the question

Ready to Pass Your Certification Test

microsoft 70_765

Exam contains 168 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us