DBA Quizzes || with 100% Verified Solutions.

4 GB correct answers What is the recommended minimum starting point amount of RAM for SQL Server 2012 Enterprise Edition? Model correct answers The SQL Server template database is: Master correct answers The SQL Server system database that is composed of system tables and keeps track of server installation as a whole and all other databases that are subsequently created is called: Server group correct answers Which of the following is NOT an object (folder) that can be viewed in SSMS for a Database, such as AdventureWorks2012? True correct answers True or False. For SQL Server 2012 to license a physical server, you must license all the cores in the server with a minimum of 4 core licenses required for each physical processor in the server. Analysis Services correct answers Which SQL Server service delivers online analytical processing and data-mining functionality? Business Intelligence edition correct answers Which SQL Server product edition provides premium corporate and self-service BI? basic database, reporting and analytics capabilities correct answers The Standard edition of SQL Server 2012 is for: SQL Server Management Studio correct answers What does SSMS stand for? True correct answers True or False. SQL Server Management Studio allows you to easily comment out a portion of your script. Reporting Services correct answers Which SQL Server service provides a complete server-based platform for creating, managing, and distributing reports? Data Type correct answers Which of the following is displayed when you look at a table definition in SSMS? Master Data Services correct answers Which SQL Server service provides a framework for creating business rules that ensure the quality and accuracy of master data? True correct answers True or False. The Database Engine Query Editor is the primary way to write/execute a Transact-SQL script within SQL Server Management Studio. Mission critical applications and large scale data warehousing correct answers The Enterprise Edition of SQL Server 2012 is for: