Copiar e Editar

ScriptingSQL (41-60)

Descrição

Quiz sobre ScriptingSQL (41-60), criado por Имя Фамилия em 20-12-2018.
Имя Фамилия
Quiz por Имя Фамилия, atualizado more than 1 year ago
Имя Фамилия
Criado por Имя Фамилия mais de 5 anos atrás
36
0
0

Resumo de Recurso

Questão 1

Questão
What is an example of a use of a precedence constraint?
Responda
  • [moodle]A precedence constraint could allow an email to be sent when a data flow process successfully executes.#
  • [moodle]SSIS designer packages could be created and the DTExec tool can then be used in a script or a schedule to run the package regularly.#
  • [moodle]To manipulate object properties, such as the connection manager string.#
  • [moodle]None of them#

Questão 2

Questão
What is Centralization in using Multiple Servers?
Responda
  • Centralized control and a consolidated view of the events of several instances of SQL Server are possible from a single server.#
  • Many physical servers can be administered as one logical server. You can add or remove servers to this physical server group as needed.#
  • Configuration time is reduced, because you need to define alerts and operators only once.#
  • moodle]There is no information about this in lectures#

Questão 3

Questão
What is connection manager?
Responda
  • A digital representation of a connection#
  • A logical representation of a connection#
  • It can be defined many time and then used by one data flow components.#
  • a named, saved subset of a relational schema#

Questão 4

Questão
What is Data Collector Sets?
Responda
  • groups data collectors into reusable elements for use with different performance monitoring scenarios#
  • Adding counters to log files and scheduling their start, stop, and duration can now be performed through a Wizard interface#
  • provides a real-time graphical overview of CPU, disk, network, and memory usage#
  • There is no information about this in lectures

Questão 5

Questão
What is Data Conversion transformation?
Responda
  • Connects to a data source by using a .NET provider#
  • Converts the data in an input column to a different data type#
  • Connects to a web server.#
  • Connects to a message queue#

Questão 6

Questão
What is Data Transformation
Responda
  • converts the data in an input column to a different data type and then copies it to a new output column#
  • A data source view can be defined many time and then used by one data flow components.#
  • ]It can be defined many time and then used by one data flow components.#
  • Adding event handlers to the package and package objects.#

Questão 7

Questão
What is high availability
Responda
  • describes method to archive guarantees availability at various levels#
  • describes method to solve problems at various levels#
  • create new levels#
  • working with server#

Questão 8

Questão
What is Log Files?
Responda
  • starting point of the database and points to the other files in the database#
  • A logical representation of a connection#
  • make up all the data files, other than the primary data file#
  • hold all the log information that is used to recover the database.#

Questão 9

Questão
What is Reliability Monitor?
Responda
  • calculates a System Stability Index that reflects whether unexpected problems reduced the reliability of the system#
  • provides a real-time graphical overview of CPU, disk, network, and memory usage#
  • groups data collectors into reusable elements for use with different performance monitoring scenarios#
  • There is no information about this in lectures#

Questão 10

Questão
What is Snapshot Replication?
Responda
  • Sends all the data in a publication each time it is synchronized.#
  • Sends modifications of the data only when synchronization takes place.#
  • Allows modifications at both the publisher and the subscribers.#
  • Modify data for something#

Questão 11

Questão
What is SQL Integration Services?
Responda
  • a platform for building enterprise-level data integration and data transformations solutions.#
  • converts the data in an input column to a different data type and then copies it to a new output column.#
  • It can be defined many time and then used by one data flow components.#
  • A platform for adding event handlers to the package and package objects#

Questão 12

Questão
What is SQLAgentUserRole?
Responda
  • It is the least privileged of the SQL Server Agent fixed database roles#
  • It includes all the SQLAgentUserRole permissions as well as permissions to view the list of available multi-server jobs, their properties, and their history#
  • It is the most privileged of the SQL Server Agent fixed database roles#
  • have additional permissions on local jobs and schedules#

Questão 13

Questão
What is the SQL Server Profiler?
Responda
  • It is a tool to trace server and database activity#
  • It is a tool to monitor server performance#
  • It is a universal tool that can help in any situation#
  • There is no that tool in SQL Server#

Questão 14

Questão
What is this following task available to maintenance plan do? "Back Up Database Task"
Responda
  • Performs different types of SQL Server database backups.#
  • Checks the allocation and structural integrity of database objects and indexes#
  • Runs Transact-SQL statements#
  • Rebuilds indexes in SQL Server database tables and views.#

Questão 15

Questão
What is this following task available to maintenance plan do? "Update Statistics Task"
Responda
  • Updates information about the distribution of key values for one or more sets of statistics on the specified table or view.#
  • Reduces the size of SQL Server database data and log files.#
  • Runs Transact-SQL statements#
  • Rebuilds indexes in SQL Server database tables and views.#

Questão 16

Questão
What is this sysjobactivity table column doing? "next_scheduled_run_date"
Responda
  • Next date and time that the job is scheduled to run.#
  • Date and time this job was queued. If the job is run directly, this column is NULL.#
  • ID of the session stored in the syssessions table in the msdb database.#
  • ID of the job.#

Questão 17

Questão
What is this sysjobactivity table column doing? "run_requested_date"
Responda
  • Date and time that the job was requested to run.#
  • ID of the job#
  • ID of the session stored in the syssessions table in the msdb database.#
  • Who requested the job to run#

Questão 18

Questão
What is this sysjobactivity table column doing? "session_id"
Responda
  • ID of the session stored in the syssessions table in the msdb database.#
  • ID of the job.#
  • Date and time that the job was requested to run.#
  • Who requested the job to run#

Questão 19

Questão
What job cannot run:
Responda
  • Handling alerts#
  • ActiveX scripts#
  • Integration Services packages#
  • replication tasks#

Questão 20

Questão
What kind of information needs to be present in format files?
Responda
  • The format file needs to contain correct column or record information to function.#
  • The format file needs to access remote data from OLE DB data sources only#
  • The format file needs the full or differential backup after the bulk-import operation finishes#
  • All of the above#

Questão 21

Questão
What object counters can be used to monitor for a low-memory condition?
Responda
  • Available Bytes, Pages/sec#
  • Bytes number, Pages/sec#
  • Available Bytes, Available Pages#
  • Bytes number, Available Pages#

Questão 22

Questão
What Publisher does?
Responda
  • create and modify the data#
  • store replication-specific data associated with one or more publishers#
  • Receives the data#
  • There is no information about this in lectures#

Questão 23

Questão
What role is used by Database Mail?
Responda
  • Add the SQL Server Agent user to the DatabaseMailUserRole.#
  • Create the operators first so that you can configure the operators for each job as you create it.#
  • An operator can be notified by Net Send, email, or pager.#
  • All variants are correct#

Questão 24

Questão
What should be done, if Current Disk Queue Length and % Time counter are consistently high?
Responda
  • Using a faster disk drive#
  • Moving some files to an additional disk or server#
  • Adding disk to a RAID array, if one is being used#
  • All answers are correct#

Questão 25

Questão
What should you create first - the operator or the job?
Responda
  • Create the operators first so that you can configure the operators for each job as you create it.#
  • Add the SQL Server Agent user to the DatabaseMailUserRole.#
  • An operator can be notified by Net Send, email, or pager.#
  • All variants are correct#

Questão 26

Questão
What should you type in the run box to access the Backup utility?
Responda
  • NTBACKUP#
  • BACKUP#
  • MSBACKUP#
  • RESTOREBACKUP#

Questão 27

Questão
What SQLAgentReaderRole includes:
Responda
  • All the SQLAgentUserRole permissions#
  • All the SQLAgentOperatorRole permissions#
  • Schedules and their properties, and their history#
  • Master server, the target server and reports#

Questão 28

Questão
What statements do DDL Triggers primarily correspond to?
Responda
  • Transact-SQL statements that start with the keywords CREATE, ALTER, and DROP#
  • All transact-SQL statements#
  • Transact-SQL statements that start with the keywords UPDATE, INSERT, DELETE#
  • Transact-SQL statements that start with the keywords UPDATE, INSERT, DELETE, CREATE, ALTER, and DROP#

Questão 29

Questão
What the OS need to use to work with Laboratory works befor module4?
Responda
  • Windows 7#
  • Windows vista#
  • Windows Server 2005#
  • Windows Server 2003#

Questão 30

Questão
What two types SQLServer are existed?
Responda
  • Uniform , Mixed#
  • Transaction, Relational#
  • Condition, Mixed#
  • Transaction, Uniform#

Questão 31

Questão
What type of backup do you need to perform for a database using the bulk-logged recovery model?
Responda
  • Only a log backup is necessary.#
  • The format file can include information to map columns and provide column information such as data type.#
  • The students who have had prior experience with database projects will be able to relate some experience related to one of the points on the slide.#
  • None of them#

Questão 32

Questão
What types of organizational data might you encrypt using PKI?
Responda
  • Payroll or other sensitive information that other users should not have access to.#
  • Individual employees would have no access to view any.#
  • Some examples could be Logins, Tables, Databases, Schemas, etc.#
  • Identify the database snapshot to which you want to revert the database, Drop any other database snapshots, and Perform the revert operation.#

Questão 33

Questão
What types of server we use in Management Studio?
Responda
  • File server#
  • Database server#
  • Print server#
  • Apache server#

Questão 34

Questão
What use Database Mail to send mail:
Responda
  • Microsoft Outlook#
  • HTML message#
  • Instance message#
  • SMTP#

Questão 35

Questão
What values can be used to detect bottlenecks within the disk subsystem?
Responda
  • the Current Disk Queue Length and % Disk Time counters#
  • the Avg. Disk Queue Length and % Disk Time counters#
  • the Avg. Disk Queue Length and Current Queue Length#
  • %Disk Time counters#

Questão 36

Questão
What ways can you notify an operator?
Responda
  • An operator can be notified by Net Send, email, or pager.#
  • Create the operators first so that you can configure the operators for each job as you create it.#
  • Add the SQL Server Agent user to the DatabaseMailUserRole.#
  • All variants are correct#

Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.

Semelhante

Segunda Guerra Mundial 1939-1945
Alessandra S.
Matemática Básica
Alessandra S.
Como Transformar sua Anotação em Suporte
Alessandra S.
Tectónicas de placas
amanda.cadete05
Lei 8666
Rômulo Campos
RESUMOS EXAME GEOGRAFIA A
beatriizcunha
GESTAO ESTRATÉGICA DE RH
Matheus Miranda
Mapa Conceitual
ana.gazzola
120 pegadinhas em lingua portuguesa parte 1
Fabio Lima
Ecologia
Hugo Fonseca
I wish I..
Timothy Harris
Explore a Biblioteca