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?
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?
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?
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?
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?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail.Solution: You add the DatabaseMailUserRole to Mail1 in the tempdb database.Does the solution meet the goal?
