61-74_sql

Description

Quiz on 61-74_sql, created by Bekzhan Borbekov on 20/12/2018.
Bekzhan Borbekov
Quiz by Bekzhan Borbekov, updated more than 1 year ago
Bekzhan Borbekov
Created by Bekzhan Borbekov over 5 years ago
51
1

Resource summary

Question 1

Question
Which of the following is not a recognized type of backup
Answer
  • Incremental
  • Differential
  • Full
  • Supplemental

Question 2

Question
Which of the following is not database role of the SQL Server
Answer
  • SQLAgentRole
  • SQLAgentUserRole
  • SQLAgentReaderRole
  • SQLAgentOperatorRole

Question 3

Question
Which of the following is true?
Answer
  • 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

Question 4

Question
Which of the following options is Not included in SQL Server Profiler Trace
Answer
  • Select a Trace Template
  • Save Trace Data
  • Re-run, Replay, Pause and Stop Traces
  • Create Event Notifications

Question 5

Question
Which of the following recovery technologies completely restores a system?
Answer
  • Safe Mode
  • Last Known Good Configuration
  • Automated System Recovery (ASR)
  • System Restore

Question 6

Question
Which of the following statement is TRUE concerning to Event Notification
Answer
  • 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

Question 7

Question
Which software tool assists installing SQL Server 2008, by checking the current server software and applications?
Answer
  • 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.

Question 8

Question
Which Windows XP system utility can you use to perform scheduled maintenance tasks on your system?
Answer
  • Scheduled tasks
  • System Restore
  • Maintenance Manager
  • Disk Defragmenter

Question 9

Question
Why is hardware data compression for backups preferred over software data compression?
Answer
  • 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.

Question 10

Question
Why need to install evaluation mode to SQL Server?
Answer
  • because it requires by step working
  • because it's best version
  • because it needs to develop
  • none of them

Question 11

Question
Why would you choose that licensing model?
Answer
  • 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

Question 12

Question
Working with Managing with security, what protocol is using?
Answer
  • Secure Sockets Layer#
  • Apache Server Layer#
  • Application Layer#
  • Socket device Layer#

Question 13

Question
Would data partitioning be helpful to your organization's SQL deployment?
Answer
  • 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

Question 14

Question
Would you deploy any collations besides Western European Latin1?
Answer
  • 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.

Question 15

Question
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?
Answer
  • 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

Question 16

Question
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?
Answer
  • 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

Question 17

Question
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?
Answer
  • ]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.

Question 18

Question
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?
Answer
  • Row compression
  • Page compression
  • Backup compression
  • Windows NTFS file system compression

Question 19

Question
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?
Answer
  • You should check SQL1.log
  • You should check SQLAGENT.OUT
  • You should check log_xx.trc
  • You should check ERRORLOG

Question 20

Question
]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?
Answer
  • 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

Question 21

Question
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?
Answer
  • 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.

Question 22

Question
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?
Answer
  • You should set query governor cost limit
  • You should set cost threshold for parallelism
  • You should set priority boost
  • You should set precompute rank

Question 23

Question
You can forward to an instance of SQL Server all event messages that meet or exceed a specific error severity level. This is called\
Answer
  • Event Forwarding
  • Increased traffic
  • Server load
  • Event transfer

Question 24

Question
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?
Answer
  • Differential backups
  • Normal backups
  • Incremental backups
  • Optimized backups

Question 25

Question
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?
Answer
  • Last Known Good Configuration
  • Automated System Recovery (ASR)
  • Recovery Console
  • Safe Mode

Question 26

Question
You notice that your mobile computer seems to run more slowly when you are not using the AC adapter. What could be causing this?
Answer
  • 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

Question 27

Question
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?
Answer
  • Perform a full system backup
  • Back up the system state
  • Create an Automated System Recovery (ASR) backup
  • Create a restore point with System Restore

Question 28

Question
]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?
Answer
  • 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
Show full summary Hide full summary

Similar

BIOLOGY B1 5 AND 6
x_clairey_x
Narrative Writing
amberbob27
The Brain and the Nervous System
feelingthepayne
Psychology A1
Ellie Hughes
Romeo and Juliet: Key Points
mbennett
Strength and Limitations of research methods
Isobel Wagner
Musical Terms
Abby B
NSI Test First day
Adedipe Odunayom
1PR101 2.test - Část 16.
Nikola Truong
International Collaboration for Public Health
Minnie Hui
Organizadores Gráficos
Eunice Sabaján