Which SQL statement or statements should you use?

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

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?

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

Which of the following is the default port for an SQL Server database to communicate over?

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

What should you do?

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

What should you do? Choose all that apply.

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