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

Conceptos Generales De Robótica
fede ramos
GCSE Mathematics Topics
goldsmith.elisa
GCSE Chemistry C2 topic notes
imogen.shiels
GCSE Science - B1 - You and Your Genes - Genes, Chromosomes and DNA
GeorgeHaines
Business Studies Unit 1
emily.mckechnie
GCSE REVISION TIMETABLE
nimraa422
Lesson Planning: 4 Organisational Tips for Teachers
miminoma
Memory-boosting tips for students
Micheal Heffernan
GCSE Revision Tips
miminoma
Acids and Bases quiz
Derek Cumberbatch
Data Protection Act 1998
Carina Storm
Browse Library