- All Exams Instant Download
Which type of user should you create?
You use a contained database named ContosoDb within a domain. You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations. Which type of...
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...
Which three actions should you perform in sequence?
DRAG DROP You administer a Microsoft SQL Server 2012 server that has multiple databases. You need to ensure that users are unable to create stored procedures that begin with sp_. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to...
Which configuration should you use?
Topic 1, Exam Pool A You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that an OLTP database that includes up-to-the-minute reporting requirements can be off-loaded from the primary database to another server. You also need to be able to add indexes...
What should you do?
You administer a Microsoft SQL Server instance. You discover that the SQL Agent Error Log file is rapidly growing in size. You need to ensure that the SQL Agent Error Log file does not grow rapidly when SQL Server agent jobs execute. What should you do?A . Execute the sp_cycle_agent_errorlog...
Which Transact-SQL statement should you use?
You administer a Microsoft SQL Server 2012. A process that normally runs in less than 10 seconds has been running for more than an hour. You examine the application log and discover that the process is using session ID 60. You need to find out whether the process is being...
Which server-level audit action group should you use?
You administer a Microsoft SQL Server 2012 database. You provide temporary securityadmin access to User1 to the database server. You need to know if User1 adds logins to securityadmin. Which server-level audit action group should you use?A . SERVER_STATE_CHANGE_GROUPB . SERVER_PRINCIPAL_IMPERSONATION_GROUPC . SUCCESSFUL_LOGIN_GROUPD . SERVER_ROLE_MEMBER_CHANGE_GROUPView AnswerAnswer: D Explanation: The SERVER_ROLE_MEMBER_CHANGE_GROUP...
Which setting should you configure?
HOTSPOT You administer a Microsoft SQL Server 2012 database instance. Other applications run on the server. Some of the applications are throwing errors because of insufficient memory. You need to ensure that the other applications have sufficient memory. Which setting should you configure? View AnswerAnswer:
Which backup option should you use?
You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: - A data file of 2 terabytes is located on a dedicated LUN (drive D). - A transaction log of 10 GB is...
What should you do?
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...
