16359157
Descripción
Test por Имя Фамилия, actualizado hace más de 1 año
|
Creado por Имя Фамилия
hace más de 5 años
|
|
Pregunta 1
Pregunta
What is an example of a use of a precedence constraint?
Respuesta
-
[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#
Pregunta 2
Pregunta
What is Centralization in using Multiple Servers?
Respuesta
-
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#
Pregunta 3
Pregunta
What is connection manager?
Respuesta
-
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#
Pregunta 4
Pregunta
What is Data Collector Sets?
Respuesta
-
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
Pregunta 5
Pregunta
What is Data Conversion transformation?
Respuesta
-
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#
Pregunta 6
Pregunta
What is Data Transformation
Respuesta
-
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.#
Pregunta 7
Pregunta
What is high availability
Respuesta
-
describes method to archive guarantees availability at various levels#
-
describes method to solve problems at various levels#
-
create new levels#
-
working with server#
Pregunta 8
Pregunta
What is Log Files?
Respuesta
-
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.#
Pregunta 9
Pregunta
What is Reliability Monitor?
Respuesta
-
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#
Pregunta 10
Pregunta
What is Snapshot Replication?
Respuesta
-
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#
Pregunta 11
Pregunta
What is SQL Integration Services?
Respuesta
-
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#
Pregunta 12
Pregunta
What is SQLAgentUserRole?
Respuesta
-
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#
Pregunta 13
Pregunta
What is the SQL Server Profiler?
Respuesta
-
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#
Pregunta 14
Pregunta
What is this following task available to maintenance plan do? "Back Up Database Task"
Respuesta
-
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.#
Pregunta 15
Pregunta
What is this following task available to maintenance plan do? "Update Statistics Task"
Respuesta
-
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.#
Pregunta 16
Pregunta
What is this sysjobactivity table column doing? "next_scheduled_run_date"
Respuesta
-
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.#
Pregunta 17
Pregunta
What is this sysjobactivity table column doing? "run_requested_date"
Respuesta
-
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#
Pregunta 18
Pregunta
What is this sysjobactivity table column doing? "session_id"
Respuesta
-
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#
Pregunta 19
Pregunta
What job cannot run:
Respuesta
-
Handling alerts#
-
ActiveX scripts#
-
Integration Services packages#
-
replication tasks#
Pregunta 20
Pregunta
What kind of information needs to be present in format files?
Respuesta
-
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#
Pregunta 21
Pregunta
What object counters can be used to monitor for a low-memory condition?
Respuesta
-
Available Bytes, Pages/sec#
-
Bytes number, Pages/sec#
-
Available Bytes, Available Pages#
-
Bytes number, Available Pages#
Pregunta 22
Pregunta
What Publisher does?
Respuesta
-
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#
Pregunta 23
Pregunta
What role is used by Database Mail?
Respuesta
-
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#
Pregunta 24
Pregunta
What should be done, if Current Disk Queue Length and % Time counter are consistently high?
Respuesta
-
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#
Pregunta 25
Pregunta
What should you create first - the operator or the job?
Respuesta
-
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#
Pregunta 26
Pregunta
What should you type in the run box to access the Backup utility?
Respuesta
-
NTBACKUP#
-
BACKUP#
-
MSBACKUP#
-
RESTOREBACKUP#
Pregunta 27
Pregunta
What SQLAgentReaderRole includes:
Respuesta
-
All the SQLAgentUserRole permissions#
-
All the SQLAgentOperatorRole permissions#
-
Schedules and their properties, and their history#
-
Master server, the target server and reports#
Pregunta 28
Pregunta
What statements do DDL Triggers primarily correspond to?
Respuesta
-
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#
Pregunta 29
Pregunta
What the OS need to use to work with Laboratory works befor module4?
Respuesta
-
Windows 7#
-
Windows vista#
-
Windows Server 2005#
-
Windows Server 2003#
Pregunta 30
Pregunta
What two types SQLServer are existed?
Respuesta
-
Uniform , Mixed#
-
Transaction, Relational#
-
Condition, Mixed#
-
Transaction, Uniform#
Pregunta 31
Pregunta
What type of backup do you need to perform for a database using the bulk-logged recovery model?
Respuesta
-
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#
Pregunta 32
Pregunta
What types of organizational data might you encrypt using PKI?
Respuesta
-
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.#
Pregunta 33
Pregunta
What types of server we use in Management Studio?
Respuesta
-
File server#
-
Database server#
-
Print server#
-
Apache server#
Pregunta 34
Pregunta
What use Database Mail to send mail:
Respuesta
-
Microsoft Outlook#
-
HTML message#
-
Instance message#
-
SMTP#
Pregunta 35
Pregunta
What values can be used to detect bottlenecks within the disk subsystem?
Respuesta
-
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#
Pregunta 36
Pregunta
What ways can you notify an operator?
Respuesta
-
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#
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.