Bekzhan Borbekov
Test por , creado hace más de 1 año

Test sobre 61-74_sql, creado por Bekzhan Borbekov el 20/12/2018.

57
1
0
Sin etiquetas
Bekzhan Borbekov
Creado por Bekzhan Borbekov hace casi 6 años
Cerrar

61-74_sql

61-74_sql

Pregunta 1 de 28

1

Which of the following is not a recognized type of backup

Selecciona una de las siguientes respuestas posibles:

  • Incremental

  • Differential

  • Full

  • Supplemental

Explicación

Pregunta 2 de 28

1

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

Selecciona una de las siguientes respuestas posibles:

  • SQLAgentRole

  • SQLAgentUserRole

  • SQLAgentReaderRole

  • SQLAgentOperatorRole

Explicación

Pregunta 3 de 28

1

Which of the following is true?

Selecciona una de las siguientes respuestas posibles:

  • 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

Explicación

Pregunta 4 de 28

1

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

Selecciona una de las siguientes respuestas posibles:

  • Select a Trace Template

  • Save Trace Data

  • Re-run, Replay, Pause and Stop Traces

  • Create Event Notifications

Explicación

Pregunta 5 de 28

1

Which of the following recovery technologies completely restores a system?

Selecciona una de las siguientes respuestas posibles:

  • Safe Mode

  • Last Known Good Configuration

  • Automated System Recovery (ASR)

  • System Restore

Explicación

Pregunta 6 de 28

1

Which of the following statement is TRUE concerning to Event Notification

Selecciona una de las siguientes respuestas posibles:

  • 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

Explicación

Pregunta 7 de 28

1

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

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 8 de 28

1

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

Selecciona una de las siguientes respuestas posibles:

  • Scheduled tasks

  • System Restore

  • Maintenance Manager

  • Disk Defragmenter

Explicación

Pregunta 9 de 28

1

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

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 10 de 28

1

Why need to install evaluation mode to SQL Server?

Selecciona una de las siguientes respuestas posibles:

  • because it requires by step working

  • because it's best version

  • because it needs to develop

  • none of them

Explicación

Pregunta 11 de 28

1

Why would you choose that licensing model?

Selecciona una de las siguientes respuestas posibles:

  • 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

Explicación

Pregunta 12 de 28

1

Working with Managing with security, what protocol is using?

Selecciona una de las siguientes respuestas posibles:

  • Secure Sockets Layer#

  • Apache Server Layer#

  • Application Layer#

  • Socket device Layer#

Explicación

Pregunta 13 de 28

1

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

Selecciona una de las siguientes respuestas posibles:

  • 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

Explicación

Pregunta 14 de 28

1

Would you deploy any collations besides Western European Latin1?

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 15 de 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?

Selecciona una de las siguientes respuestas posibles:

  • 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

Explicación

Pregunta 16 de 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?

Selecciona una de las siguientes respuestas posibles:

  • 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

Explicación

Pregunta 17 de 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?

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 18 de 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?

Selecciona una de las siguientes respuestas posibles:

  • Row compression

  • Page compression

  • Backup compression

  • Windows NTFS file system compression

Explicación

Pregunta 19 de 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?

Selecciona una de las siguientes respuestas posibles:

  • You should check SQL1.log

  • You should check SQLAGENT.OUT

  • You should check log_xx.trc

  • You should check ERRORLOG

Explicación

Pregunta 20 de 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?

Selecciona una de las siguientes respuestas posibles:

  • 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

Explicación

Pregunta 21 de 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?

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 22 de 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?

Selecciona una de las siguientes respuestas posibles:

  • You should set query governor cost limit

  • You should set cost threshold for parallelism

  • You should set priority boost

  • You should set precompute rank

Explicación

Pregunta 23 de 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\

Selecciona una de las siguientes respuestas posibles:

  • Event Forwarding

  • Increased traffic

  • Server load

  • Event transfer

Explicación

Pregunta 24 de 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?

Selecciona una de las siguientes respuestas posibles:

  • Differential backups

  • Normal backups

  • Incremental backups

  • Optimized backups

Explicación

Pregunta 25 de 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?

Selecciona una de las siguientes respuestas posibles:

  • Last Known Good Configuration

  • Automated System Recovery (ASR)

  • Recovery Console

  • Safe Mode

Explicación

Pregunta 26 de 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?

Selecciona una de las siguientes respuestas posibles:

  • 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

Explicación

Pregunta 27 de 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?

Selecciona una de las siguientes respuestas posibles:

  • Perform a full system backup

  • Back up the system state

  • Create an Automated System Recovery (ASR) backup

  • Create a restore point with System Restore

Explicación

Pregunta 28 de 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?

Selecciona una de las siguientes respuestas posibles:

  • 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

Explicación

Anterior
Revisar respuesta
Siguiente