Which of the following is not a recognized type of backup
Which of the following is not database role of the SQL Server
Which of the following is true?
A data source view cannot be refreshed to reflect changes in its underlying data sources.
A data source view can be defined many time and then used by multiple data flow components
A data source view can be defined many time and then used by one data flow components.
A data source view can be defined one time and then used by multiple data flow components
Which of the following options is Not included in SQL Server Profiler Trace
Select a Trace Template
Save Trace Data
Re-run, Replay, Pause and Stop Traces
Create Event Notifications
Which of the following recovery technologies completely restores a system?
Last Known Good Configuration
Automated System Recovery (ASR)
Which of the following statement is TRUE concerning to Event Notification
Event Notification is used to create a target service
Event Notification provides a highly scalable mechanism for monitoring SQL Server activity
Event Notification creates a queue to receive messages
Event Notification is used to view process and lock information
Which software tool assists installing SQL Server 2008, by checking the current server software and applications?
The System Configuration Checker checks for conditions that prevent a successful SQL Server installation and will verify the computer where the installation is running.
Windows Installer 3.1 (WindowsInstaller-KB893803-v2-x86.exe), .NET Framework 3.5 (dotnetfx35.exe), SQL Server Native Client (sqlncli.msi), Windows Management Instrumentation service, and Windows PowerShell.
Managing SQL Server Services, Changing the Accounts Used by the Services, Manage Server and Client Network Protocols, Configure Server Startup Options, and Manage Instances of SQL Server.
The Database Engine Services.
Which Windows XP system utility can you use to perform scheduled maintenance tasks on your system?
Why is hardware data compression for backups preferred over software data compression?
Hardware compression can be used with any type of backup, including differential.
Hardware compression is more accurate than software compression
Hardware compression can gain much higher compression ratios than software compression.
Hardware compression occurs on the tape drive and does not burden the system processor.
Why need to install evaluation mode to SQL Server?
because it requires by step working
because it's best version
because it needs to develop
none of them
Why would you choose that licensing model?
The chosen licensing models should offer the lowest cost and most efficient deployment options
Multinational organizations would benefit from multiple or non-Western collation.
In-Place upgrade may be easier and less expensive. Side-by-side upgrade offers more control over upgrade process and can reduce downtime
Choose in-place if financial concerns are higher. Choose side-by-side if downtime concerns are significant and IT staffing can support a more detailed upgrade process
Working with Managing with security, what protocol is using?
Secure Sockets Layer#
Apache Server Layer#
Socket device Layer#
Would data partitioning be helpful to your organization's SQL deployment?
Partitioning allows you to organize your organizations database tables on specific data usage patterns using predefined data ranges.
You might set a database to expand automatically if you have a large disk array or NAS device.
You might preset a maximum size for a database and restrict filegrowth when you have a limited amount of disk storage.
If a database exceeds the maximum size for a single Windows file, you can use secondary data files so the database can continue to grow
Would you deploy any collations besides Western European Latin1?
Multinational organizations would benefit from multiple or non-Western collation
Choose in-place if financial concerns are higher. Choose side-by-side if downtime concerns are significant and IT staffing can support a more detailed upgrade process.
It could avoid the unnecessary expense and administrative overhead of deploying multiple physical servers
You could configure different departments to have an instance of SQL Server over which they have independent control.
You are the administrator of a SQL Server 2008 instance with a database named DB1. The customers access their profile data by using a Web application. You must ensure the security of the customer data, that is to say, even if the backup media is lost, you must guarantee that data files, log files and subsequent backups and so on are as safe as possible. Which action should you perform to achieve this goal?
For both the CustomerDB database and the master database, enable Transparent Database Encryption
You should use the built-in encryption functions to encrypt the sensitive data at the cell level
You should make the CustomerDB database accessible only through stored procedures and functions.
For the CustomerDB database, enable Transparent Database Encryption and back up the transaction log
You are the administrator of a SQL Server 2008 instance with an Internet Information Services application. This application will use anonymous access to access the SSAS instance. You have to make sure that the application can access the SSAS instance. What should you do?
The Security\\RequireClientAuthentication server configuration should be set to False
The Security\\RequireClientAuthentication server configuration should be set to True
The NTLM Security Support Provider Interface (SSPI) provider should be added to the Security \\SecurityPackageList server configuration.
The Kerberos Security Support Provider Interface (SSPI) provider should be added to the Security \\SecurityPackageList server configuration
You are the administrator of a SQL Server 2008 instance. All the instances run on their independent server. The three instances are respectively named InstanceA, InstanceB, and InstanceC. Between InstanceA and InstanceB, you configure a mirroring mission-critcal database. InstanceA currently acts as the Principal and InstanceC acts as the witness. You intend to apply a patch to both servers as soon as possible, the patch needs to restart the server. You must make sure that the database is online on the partner that currently does not apply the patch and during this time the database does not failover to the other partner. Which action should you perform to achieve this goal?
]First, you should stop the mirroring session. Second you apply the patch to the server that runs InstanceB. Third, you should resume the mirroring session. Fourth, you should manually failover the mirroring session. At last, you should apply the patch to the server that runs Instance1.
First, you should apply the patch to the server that runs InstanceB. Second you apply the patch to the server that runs InstanceA
First, you should apply the patch to the server that runs InstanceB. Second you failover the mirroring session manually. At last apply the patch to the server that runs InstanceA
]First, you should remove the mirroring session. Second you apply the patch to the server that runs InstanceB. Third, you should apply the patch to the server that runs Instance1. At last re-establish the mirroring session.
You are the administrator of a SQL Server 2008 instance. The instance contains an On-Line Analytical Processing (OLAP) database along with a dimension table named Customers. The data of the Customers table is updated every hour. The Customers table contains redundant data.You need to conserve the disk space used to store the Customers table.Which compression technology should you use?
Windows NTFS file system compression
You are the administrator of a SQL Server 2008 instance. There is a text file which is named SQL01.log on the E\: drive. A SQL Server Agent job executes every 2 minutes and logs information to the text file. You get a report from users saying that the sever doesn't make response. As the technical support, you check and find that the SQL Server Agent service does not run and the SQL Server Agent job no longer functions. You have to identify the reason why the SQL Server Agent service is unresponsive.Which log should you check?
You should check SQL1.log
You should check SQLAGENT.OUT
You should check log_xx.trc
You should check ERRORLOG
]You are the administrator of a SQL Server 2008 instance. There is an internal application which uses Analysis Services and Reporting Services. According to the requirement of company security policy, the surface area for all the deployed components of SQL Server 2008 should be configured. You have to implement the security policy and devise a method to evaluate the security policy against other database servers. What should you do?
You should create policies based on the appropriate facets. Apply the policies against a server group. The server group includes the database servers that need to be configured
You should create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to run the script against a server group that includes the database servers that need to be configured
You should edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured
You should analyze your database servers by using the SQL Server Best Practices Analyzer (BPA). Implement the recommendations of the BPA
You are the administrator of a SQL Server 2008. According to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met\: 1. 2. 3. 4.the data collector is used to gather performance information a single database stores performance information for all instances performance information that
to manage performance to the least. Which action should you perform to achieve this goal?
You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances.
You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances.
You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances.
You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances.
You are the administrator of a SQL Server 2008. There are queries that have an estimated execution cost less than 3. You intend to configure the instance, make it use a single thread for these queries. Which sp_configure configuration option should you set?
You should set query governor cost limit
You should set cost threshold for parallelism
You should set priority boost
You should set precompute rank
You can forward to an instance of SQL Server all event messages that meet or exceed a specific error severity level. This is called\
You company backs up the entire server each Sunday. Monday through Saturday, only those files that have changed since Sunday are backed up. Which backup methodology are you using?
You have installed a new device driver for your sound card, and now your system will not boot. What recovery technology allows your system to boot with the previous set of drivers?
Last Known Good Configuration
Automated System Recovery (ASR)
You notice that your mobile computer seems to run more slowly when you are not using the AC adapter. What could be causing this?
The CPU is designed to run more slowly while on battery power
The CPU isn't getting the power it needs to run efficiently.
The battery is of the wrong type
The battery needs charging
You want to install an application but are concerned about its effect on system configuration. What can you do to ensure that you can quickly recover your settings?
Perform a full system backup
Back up the system state
Create an Automated System Recovery (ASR) backup
Create a restore point with System Restore
]You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database which is named Sellings in the instance. The Sellings database contains a table named Productions. The table is used to stores information about all types of products.The Productions table is often queried by users on the basis of the RadioSize column. The RadioSize column contains the NULL value for all products other than Radios. Currently no index exists on the RadionSize column. According to the requirement of the company CIO, you have to optimize the query performance and reduce the effect on the disk space to the least. Which action should you perform to achieve this goal?
On the Products table, you should create a view.
On the RadioSize column, you should create a clustered index
On the RadioSize column, you should create a filtered index
On the RadioSize column, you should create a unique clustered index