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 mehr als 5 Jahre
37
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

Staaten und Hauptstädte Europas
Peter Kasebacher
Stimmungen in Englisch lernen
Michelle Eichinger
Mathe Abiturvorbereitung
JuliaSt
Ökologie fürs Abitur - Lernfolien
disubbidienza
IKA-Theoriefragen Serie 05 (15 Fragen)
IKA ON ICT GmbH
Prüfungsthemen APSY EURO-FH B.Sc.
??? ???
Vetie Virologie 2014
J R
Vetie Chirurgie 2018
Johanna Müller
MS-1.3 Folienpaket 2
Markus Voßmann
Probefragen Tierschutz & Ethologie 2021
Nadine Zachau
Vetie Fleisch 2022
Maite J
Bibliothek durchsuchen