Bekzhan Borbekov
Quiz by , created more than 1 year ago

Quiz on 61-74_sql, created by Bekzhan Borbekov on 20/12/2018.

57
1
0
No tags specified
Bekzhan Borbekov
Created by Bekzhan Borbekov almost 6 years ago
Close

61-74_sql

61-74_sql

Question 1 of 28

1

Which of the following is not a recognized type of backup

Select one of the following:

  • Incremental

  • Differential

  • Full

  • Supplemental

Explanation

Question 2 of 28

1

Which of the following is not database role of the SQL Server

Select one of the following:

  • SQLAgentRole

  • SQLAgentUserRole

  • SQLAgentReaderRole

  • SQLAgentOperatorRole

Explanation

Question 3 of 28

1

Which of the following is true?

Select one of the following:

  • 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

Explanation

Question 4 of 28

1

Which of the following options is Not included in SQL Server Profiler Trace

Select one of the following:

  • Select a Trace Template

  • Save Trace Data

  • Re-run, Replay, Pause and Stop Traces

  • Create Event Notifications

Explanation

Question 5 of 28

1

Which of the following recovery technologies completely restores a system?

Select one of the following:

  • Safe Mode

  • Last Known Good Configuration

  • Automated System Recovery (ASR)

  • System Restore

Explanation

Question 6 of 28

1

Which of the following statement is TRUE concerning to Event Notification

Select one of the following:

  • 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

Explanation

Question 7 of 28

1

Which software tool assists installing SQL Server 2008, by checking the current server software and applications?

Select one of the following:

  • 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.

Explanation

Question 8 of 28

1

Which Windows XP system utility can you use to perform scheduled maintenance tasks on your system?

Select one of the following:

  • Scheduled tasks

  • System Restore

  • Maintenance Manager

  • Disk Defragmenter

Explanation

Question 9 of 28

1

Why is hardware data compression for backups preferred over software data compression?

Select one of the following:

  • 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.

Explanation

Question 10 of 28

1

Why need to install evaluation mode to SQL Server?

Select one of the following:

  • because it requires by step working

  • because it's best version

  • because it needs to develop

  • none of them

Explanation

Question 11 of 28

1

Why would you choose that licensing model?

Select one of the following:

  • 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

Explanation

Question 12 of 28

1

Working with Managing with security, what protocol is using?

Select one of the following:

  • Secure Sockets Layer#

  • Apache Server Layer#

  • Application Layer#

  • Socket device Layer#

Explanation

Question 13 of 28

1

Would data partitioning be helpful to your organization's SQL deployment?

Select one of the following:

  • 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

Explanation

Question 14 of 28

1

Would you deploy any collations besides Western European Latin1?

Select one of the following:

  • 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.

Explanation

Question 15 of 28

1

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?

Select one of the following:

  • 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

Explanation

Question 16 of 28

1

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?

Select one of the following:

  • 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

Explanation

Question 17 of 28

1

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?

Select one of the following:

  • ]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.

Explanation

Question 18 of 28

1

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?

Select one of the following:

  • Row compression

  • Page compression

  • Backup compression

  • Windows NTFS file system compression

Explanation

Question 19 of 28

1

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?

Select one of the following:

  • You should check SQL1.log

  • You should check SQLAGENT.OUT

  • You should check log_xx.trc

  • You should check ERRORLOG

Explanation

Question 20 of 28

1

]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?

Select one of the following:

  • 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

Explanation

Question 21 of 28

1

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?

Select one of the following:

  • 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.

Explanation

Question 22 of 28

1

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?

Select one of the following:

  • You should set query governor cost limit

  • You should set cost threshold for parallelism

  • You should set priority boost

  • You should set precompute rank

Explanation

Question 23 of 28

1

You can forward to an instance of SQL Server all event messages that meet or exceed a specific error severity level. This is called\

Select one of the following:

  • Event Forwarding

  • Increased traffic

  • Server load

  • Event transfer

Explanation

Question 24 of 28

1

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?

Select one of the following:

  • Differential backups

  • Normal backups

  • Incremental backups

  • Optimized backups

Explanation

Question 25 of 28

1

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?

Select one of the following:

  • Last Known Good Configuration

  • Automated System Recovery (ASR)

  • Recovery Console

  • Safe Mode

Explanation

Question 26 of 28

1

You notice that your mobile computer seems to run more slowly when you are not using the AC adapter. What could be causing this?

Select one of the following:

  • 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

Explanation

Question 27 of 28

1

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?

Select one of the following:

  • Perform a full system backup

  • Back up the system state

  • Create an Automated System Recovery (ASR) backup

  • Create a restore point with System Restore

Explanation

Question 28 of 28

1

]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?

Select one of the following:

  • 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

Explanation

Previous
Check answer
Next