Kopieren und bearbeiten

ScriptingSQL (41-60)

Beschreibung

Quiz am ScriptingSQL (41-60), erstellt von Имя Фамилия am 20/12/2018.
Имя Фамилия
Quiz von Имя Фамилия, aktualisiert more than 1 year ago
Имя Фамилия
Erstellt von Имя Фамилия vor fast 6 Jahre
50
0
0

Zusammenfassung der Ressource

Frage 1

Frage
What is an example of a use of a precedence constraint?
Antworten
  • [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#

Frage 2

Frage
What is Centralization in using Multiple Servers?
Antworten
  • 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#

Frage 3

Frage
What is connection manager?
Antworten
  • 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#

Frage 4

Frage
What is Data Collector Sets?
Antworten
  • 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

Frage 5

Frage
What is Data Conversion transformation?
Antworten
  • 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#

Frage 6

Frage
What is Data Transformation
Antworten
  • 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.#

Frage 7

Frage
What is high availability
Antworten
  • describes method to archive guarantees availability at various levels#
  • describes method to solve problems at various levels#
  • create new levels#
  • working with server#

Frage 8

Frage
What is Log Files?
Antworten
  • 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.#

Frage 9

Frage
What is Reliability Monitor?
Antworten
  • 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#

Frage 10

Frage
What is Snapshot Replication?
Antworten
  • 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#

Frage 11

Frage
What is SQL Integration Services?
Antworten
  • 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#

Frage 12

Frage
What is SQLAgentUserRole?
Antworten
  • 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#

Frage 13

Frage
What is the SQL Server Profiler?
Antworten
  • 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#

Frage 14

Frage
What is this following task available to maintenance plan do? "Back Up Database Task"
Antworten
  • 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.#

Frage 15

Frage
What is this following task available to maintenance plan do? "Update Statistics Task"
Antworten
  • 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.#

Frage 16

Frage
What is this sysjobactivity table column doing? "next_scheduled_run_date"
Antworten
  • 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.#

Frage 17

Frage
What is this sysjobactivity table column doing? "run_requested_date"
Antworten
  • 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#

Frage 18

Frage
What is this sysjobactivity table column doing? "session_id"
Antworten
  • 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#

Frage 19

Frage
What job cannot run:
Antworten
  • Handling alerts#
  • ActiveX scripts#
  • Integration Services packages#
  • replication tasks#

Frage 20

Frage
What kind of information needs to be present in format files?
Antworten
  • 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#

Frage 21

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

Frage 22

Frage
What Publisher does?
Antworten
  • 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#

Frage 23

Frage
What role is used by Database Mail?
Antworten
  • 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#

Frage 24

Frage
What should be done, if Current Disk Queue Length and % Time counter are consistently high?
Antworten
  • 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#

Frage 25

Frage
What should you create first - the operator or the job?
Antworten
  • 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#

Frage 26

Frage
What should you type in the run box to access the Backup utility?
Antworten
  • NTBACKUP#
  • BACKUP#
  • MSBACKUP#
  • RESTOREBACKUP#

Frage 27

Frage
What SQLAgentReaderRole includes:
Antworten
  • All the SQLAgentUserRole permissions#
  • All the SQLAgentOperatorRole permissions#
  • Schedules and their properties, and their history#
  • Master server, the target server and reports#

Frage 28

Frage
What statements do DDL Triggers primarily correspond to?
Antworten
  • 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#

Frage 29

Frage
What the OS need to use to work with Laboratory works befor module4?
Antworten
  • Windows 7#
  • Windows vista#
  • Windows Server 2005#
  • Windows Server 2003#

Frage 30

Frage
What two types SQLServer are existed?
Antworten
  • Uniform , Mixed#
  • Transaction, Relational#
  • Condition, Mixed#
  • Transaction, Uniform#

Frage 31

Frage
What type of backup do you need to perform for a database using the bulk-logged recovery model?
Antworten
  • 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#

Frage 32

Frage
What types of organizational data might you encrypt using PKI?
Antworten
  • 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.#

Frage 33

Frage
What types of server we use in Management Studio?
Antworten
  • File server#
  • Database server#
  • Print server#
  • Apache server#

Frage 34

Frage
What use Database Mail to send mail:
Antworten
  • Microsoft Outlook#
  • HTML message#
  • Instance message#
  • SMTP#

Frage 35

Frage
What values can be used to detect bottlenecks within the disk subsystem?
Antworten
  • 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#

Frage 36

Frage
What ways can you notify an operator?
Antworten
  • 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#
Zusammenfassung anzeigen Zusammenfassung ausblenden

Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.

ähnlicher Inhalt

Der elektrische Stromkreis
Robert Mairginter
Ökologie
vere2400
AOW-Verständnisfragen
Lisa-Maria Hauschild
PAED
Anna Huber
Vetie - Radiologie 2017
Fioras Hu
Veti Pharma
Anna Leps
Vetie Radio 2014
S J
Mewa WS 18/19
Adrienne Tschaudi
Vetie - Pharma Übungsfragen 2019
E. König
Vetie Tierseuchen 2018
Schmolli Schmoll
Vetie Fleisch 2022
Maite J
Bibliothek durchsuchen