Chat with AIExam 2: Deploying SQL Server 2012
Describe the process of SQL Server 2012 uninstallation, including uninstalling single or multiple instances.
(32) 
VerifiedBefore uninstalling a SQL Server 2012 instance or making changes to installed features, make sure that you have taken a full backup of all production user databases. Under normal circumstances, you should always use functionality provided by the Uninstall or Change a Program feature that can be accessed from the Windows Server 2008 R2 Control Panel. Attempting to delete files, shortcuts, services, or Registry keys directly may result in undesirable system behavior or an unrecoverable error state. You can choose to uninstall an individual instance and associated features or the shared SQL Server features on the host. If you need to uninstall multiple instances, you will need to perform the operation multiple times for each instance that you want to remove.
User databases contain data associated with a client application.
(34) VerifiedTrue
Which SQL Server 2012 component offers the capability to extract, transform, and load data from external sources?
(35) VerifiedC
You can uninstall an individual instance of shared SQL Server features on a host.
(33) Describe the physical and logical security consideration when planning an SQL Server 2012 installation.
(35) The ____________ contains a few important configuration values such as the authentication mode, network settings, and paths to the application directories.
(38) The database engine hosts several _______________ databases, created during the installation process.
(37) Microsoft recommends that SQL server be installed on a ____________ server that is not shared with other Windows services.
(42) It's best to just install SQL Server 2012 using default settings and fine-tune it later.
(37) ______________ databases contain the data associated with a client application.
(32) Compare and contrast an attended installation and an unattended installation of SQL Server 2012.
(34) What happens if a client connects to the database server without specifying a named instance?
(35) SQL Server 2012 stores the majority of configuration values within one of the user databases that was created automatically during installation.
(38) What are the three commonly selected components installed in a SQL Server 2012 instance?
(38) Which of the following is NOT a setup type for SQL Server 2012?
(34) Which SQL Server 2012 component provides a centralized means to manage and validate data?
(39) Which of the following is the first step in SQL Server 2012 installation planning?
(35) Which of the following is a recommendation for installing SQL Server 2012 for optimal logical security?
(40) Describe how to perform an SQL Server 2012 repair and why this might be necessary.
(46) 
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)