Hub for All Education Needs
Correct Answer for the Question – Which SQL statement or statements should you use? is given below You are the lead database administrator (DBA) of a Microsoft SQL Server 2012 environment.All DBAs are members of the DOMAINJrDBAs Active Directory group.You grant DOMAINJrDBAs access to the SQL Server.You need to create a server role named SpecialDBARole that … Read more
Correct Answer for the Question – What is the maximum number of SQL Server 2012 Enterprise edition Database Engine instances that you can deploy on a non-clustered server running Windows Server 2008 R2 Enterprise edition? is given below What is the maximum number of SQL Server 2012 Enterprise edition Database Engine instances that you can deploy … Read more
Correct Answer for the Question – Which of the following is the default port for an SQL Server database to communicate over? is given below Which of the following is the default port for an SQL Server database to communicate over?References:https://msdn.microsoft.com/en-us/library/ms177440%28v=sql.110%29.aspx 1433 21 C. 1344 D. 1521 Correct Answer The Correct Answer for this Question is … Read more
Correct Answer for the Question – What should you create? is given below You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.You need to prevent users from disabling server audits in Server01. What should you create? An Alert A Resource Pool An Extended Event session A Policy A Database Audit … Read more
Correct Answer for the Question – What should you do? is given below You administer a Microsoft SQL Server 2012 instance.The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week.You plan to define a backup … Read more
Correct Answer for the Question – What should you do? Choose all that apply. is given below You administer a Microsoft SQL Server 2012 instance.You need to configure a new database to support FILETABLES.What should you do? Choose all that apply.Reference: http://msdn.microsoft.com/en-us/library/gg509097.aspx Disable FILESTREAM on the Database. Enable FILESTREAM on the Server Instance. Configure the Database … Read more
