You administer a Microsoft SQL Server 2012 database.The database contains a customer table created by using the following definition:You need to ensure that the minimum amount of disk space is used to store the data in the customer table.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?
DRAG DROP -You administer a Microsoft SQL Server database.You need to convert the database to a contained database. You also need to ensure that all users are converted to contained users.Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)Select and Place:
You administer a Microsoft SQL Server 2012 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.Which three actions should you perform? Each correct answer presents part of the solution.
DRAG DROP -You administer a Microsoft SQL Server 2012 clustered instance that has two nodes named Node 1 and Node 2.Node 1 fails and the cluster fails over to Node 2.You need to replace Node 1 and add it to the cluster.Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)Select and Place:
Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.You administer all the deployments of Microsoft SQL Server in your company.You need to ensure that an OLTP database that uses a storage area network (SAN) remains available if any of the servers fail.You also need to minimize the amount of storage used by the database.Which configuration should you use?
