Copy and Edit

ScriptingSQL (41-60)

Description

Quiz on ScriptingSQL (41-60), created by Имя Фамилия on 20/12/2018.
Имя Фамилия
Quiz by Имя Фамилия, updated more than 1 year ago
Имя Фамилия
Created by Имя Фамилия about 6 years ago
51
0
0

Resource summary

Question 1

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

Question 2

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

Question 3

Question
What is connection manager?
Answer
  • 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#

Question 4

Question
What is Data Collector Sets?
Answer
  • 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

Question 5

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

Question 6

Question
What is Data Transformation
Answer
  • 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.#

Question 7

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

Question 8

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

Question 9

Question
What is Reliability Monitor?
Answer
  • 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#

Question 10

Question
What is Snapshot Replication?
Answer
  • 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#

Question 11

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

Question 12

Question
What is SQLAgentUserRole?
Answer
  • 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#

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

Question 22

Question
What Publisher does?
Answer
  • 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#

Question 23

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

Question 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

Question
What two types SQLServer are existed?
Answer
  • Uniform , Mixed#
  • Transaction, Relational#
  • Condition, Mixed#
  • Transaction, Uniform#

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

Question
What ways can you notify an operator?
Answer
  • 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#
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

MR BRYANT AMERICAN NATION FINAL FLASHCARDS
grantwilliammaxe
GCSE PHYSICS: Energy Transfer
magykman1998
Maths Revision- end of year test
hannahsquires
French Essay Writing Vocab
caitlindavies8
Master French
jedimaster3721
Summary of AS Psychology Unit 1 Memory
Asterisked
Nervous System
4everlakena
Chemistry C1
Phoebe Drew
PHR Sample Questions
Elizabeth Rogers8284
Management 1. PT (3MA101) - 1. část
Vendula Tranová
CST Module 6a
Jane Foltz
Browse Library