What is an example of a use of a precedence constraint?
[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#
What is Centralization in using Multiple Servers?
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#
What is connection manager?
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#
What is Data Collector Sets?
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
What is Data Conversion transformation?
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#
What is Data Transformation
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.#
What is high availability
describes method to archive guarantees availability at various levels#
describes method to solve problems at various levels#
create new levels#
working with server#
What is Log Files?
starting point of the database and points to the other files in the database#
make up all the data files, other than the primary data file#
hold all the log information that is used to recover the database.#
What is Reliability Monitor?
calculates a System Stability Index that reflects whether unexpected problems reduced the reliability of the system#
There is no information about this in lectures#
What is Snapshot Replication?
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#
What is SQL Integration Services?
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.#
A platform for adding event handlers to the package and package objects#
What is SQLAgentUserRole?
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#
What is the SQL Server Profiler?
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#
What is this following task available to maintenance plan do? "Back Up Database Task"
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.#
What is this following task available to maintenance plan do? "Update Statistics Task"
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.#
What is this sysjobactivity table column doing? "next_scheduled_run_date"
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.#
What is this sysjobactivity table column doing? "run_requested_date"
Date and time that the job was requested to run.#
ID of the job#
Who requested the job to run#
What is this sysjobactivity table column doing? "session_id"
What job cannot run:
Handling alerts#
ActiveX scripts#
Integration Services packages#
replication tasks#
What kind of information needs to be present in format files?
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#
What object counters can be used to monitor for a low-memory condition?
Available Bytes, Pages/sec#
Bytes number, Pages/sec#
Available Bytes, Available Pages#
Bytes number, Available Pages#
What Publisher does?
create and modify the data#
store replication-specific data associated with one or more publishers#
Receives the data#
What role is used by Database Mail?
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#
What should be done, if Current Disk Queue Length and % Time counter are consistently high?
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#
What should you create first - the operator or the job?
What should you type in the run box to access the Backup utility?
NTBACKUP#
BACKUP#
MSBACKUP#
RESTOREBACKUP#
What SQLAgentReaderRole includes:
All the SQLAgentUserRole permissions#
All the SQLAgentOperatorRole permissions#
Schedules and their properties, and their history#
Master server, the target server and reports#
What statements do DDL Triggers primarily correspond to?
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#
What the OS need to use to work with Laboratory works befor module4?
Windows 7#
Windows vista#
Windows Server 2005#
Windows Server 2003#
What two types SQLServer are existed?
Uniform , Mixed#
Transaction, Relational#
Condition, Mixed#
Transaction, Uniform#
What type of backup do you need to perform for a database using the bulk-logged recovery model?
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#
What types of organizational data might you encrypt using PKI?
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.#
What types of server we use in Management Studio?
File server#
Database server#
Print server#
Apache server#
What use Database Mail to send mail:
Microsoft Outlook#
HTML message#
Instance message#
SMTP#
What values can be used to detect bottlenecks within the disk subsystem?
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#
What ways can you notify an operator?
