70-764

70-764 practice questions, page 12 of 14, with answer review and explanations.

Question 56

You have configured Resource Governor with three resource pools. You have assigned the first resource pool a minimum CPU and memory value of 20%. You have assigned the second resource pool a minimum CPU and memory value of 30%. You want to assign maximum CPU and memory values to the third resource pool. What is the maximum CPU and memory value you can assign to this resource pool?

  1. 30%
  2. 50%
  3. 70%
  4. 100%

Question 57

You administer a single server that contains a Microsoft SQL Server 2016 default instance on which several production databases have been deployed. You plan to install a new ticketing application that requires the deployment of a database on the server. The SQL login for this application requires sysadmin permissions. You need to ensure that the login for the ticketing application cannot access other production databases. What should you do?

  1. Use the SQL Server default instance and enable Contained Databases.
  2. Use the SQL Server default instance and configure a user-defined server role. Add the login for the ticketing application to this role.
  3. Install a new named SQL Server instance on the server.
  4. Install a new default SQL Server instance on the server.

Question 58

You administer a Microsoft SQL Server 2016 failover cluster that contains two nodes named Node A and Node B. A single instance of SQL Server is installed on the cluster. An additional node named Node C has been added to the existing cluster. You need to ensure that the SQL Server instance can use all nodes of the cluster. What should you do?

  1. Create a ConfigurationFile.ini file from Node B, and then run the AddNode command-line tool on Node A.
  2. Use Node A to install SQL Server on Node C.
  3. Run the Add Node to SQL Server Failover Cluster Wizard on Node C.
  4. Use Cluster Administrator to add a new Resource Group to Node B.

Question 59

You are creating an application that will connect to the AgentPortal database by using a SQL login named AgentPortalUser. Stored procedures in the database will use sp_send_dbmail to send email messages. You create a user account in the msdb database for the AgentPortalUser login. You use the Database Mail Configuration Wizard to create a Database Mail profile. Security has not been configured for the Database Mail profile. You need to ensure that AgentPortalUser can send email messages. What should you do?

  1. In the Database Mail Configuration Wizard, configure the Database Mail profile as a private profile for the AgentPortalUser account.
  2. Disable the guest user in the msdb database.
  3. Use the sysmail_help_profileaccount_sp stored procedure to add accounts to the Database Mail profile.
  4. In the Database Mail Configuration Wizard, create an email account for each recipient's email address in the Database Mail profile.

Question 60

You administer a Microsoft SQL Server 2016 default instance. The instance is hosted by a server that has a local firewall configured. The firewall only allows inbound connections on port 1433. The server only hosts a single instance of SQL Server. You need to ensure that the instance is configured to allow remote connections even if the SQL Server is unresponsive to client connections. What should you do?

  1. Enable inbound connections on TCP port 1434 in the Windows Firewall on the server.
  2. Execute the following Transact-SQL command: sp_configure 'remote admin connections',
  3. Execute the Reconfigure command.
  4. Execute the following Transact-SQL command: sp_configure 'remote access', 1
  5. Restart the SQL Server Agent Service.
  6. Enable inbound connections on TCP port 135 in the Windows Firewall on the server.