Policy categories apply
to servers
to databases and servers
to database
to routers
SQL Server can not notify operators of alerts which of the following
Instance messages
E-mail
Pager
net send
SQL Server Integration Services Tools
Extraction, transformation, loading
None above them
Only SSIS designer
Wizards, SSIS Designer, Command-prompt Utilities
SQLAgentOperatorRole is
The most privileged of the SQL Server Agent fixed database roles
Proxy defines the security context for a non-Transact-SQL job
Impersonates the credentials defined in the proxy, and then runs the job
Automate common administrative tasks
SQLAgentUserRole is
Permissions to view the list of available multi-server jobs, their properties
Properties for operators and proxies, and enumerate available proxies and alerts on the server
The least privileged of the SQL Server Agent fixed database roles
only granted access to those subsystems
Steps to open Activity Monitor
In SQL Server Management Studio Right click the Management then select the Activity Monitor
In SQL Server Management Studio Right click the Server Objects then select the Activity Monitor
]In SQL Server Management Studio Right click the server then select the Activity Monitor
In SQL Server Management Studio expand Management click Activity Monitor
sys.dm_db_partition_stats returns the following
Returns information about pending input/output (I/O) requests
Returns information about each Service Broker queue monitor in the system
Returns page and row count information for each partition in the database
Returns information about all the current sessions connected to the server
The ... database must use the full or bulk-logged recovery model; switching the database to simple recovery will cause log shipping to stop functioning
Primary
Secondary
Reserve
copied
The advantage of setting up an alerts management server
Centralazation
Increased traffic
Single point of failure
Server load
The basic syntax for bulk importing data is
INSERT ... SELECT * FROM OPENROWSET(BULK...)
INSERT ... SELECT * FROM OPENROWSET
SELECT * FROM OPENROWSET
SELECT * FROM (BULK...)
The CFO calls you in because he is running a large spreadsheet on his system and it is running unusually slowly. He wants you to try to get his system moving faster again. Which Windows XP utility will give you a quick look at the performance of this system?
Director
Speed Analyzer
Computer Manager
Task Manager
The disadvantage of setting up an alerts management server
Centralization
Scalability
Efficiency
The list of available providers includes the following data sources
SQL Server
Flat files
Microsoft Office Access(r), Microsoft Office Excel(r)
All of the above
The name of component of Microsoft SQL Server Management Studio used to get information about user connections to the Database Engine and the locks that they hold?
Activity Monitor
System Monitor
Event Log Reader
The number and characteristics of the properties are built into the facet and can be added or removed
by administrator
by all users
by only the maker of facet
There are factors affecting availability. Find wrong answer
System failure
Software failure
Network failure
Hardware component failure
This is common dynamic management view (DMVs). What information is it return?
Returns information about the threads in the system
This is common dynamic management view (DMVs). What information is it return? "sys.dm_db_partition_stats"
This is common dynamic management view (DMVs). What information is it return? "sys.dm_broker_queue_monitors"
To bulk import data from a data file into a SQL Server table or non-partitioned view, you can use the following
bcp utility
bcp tools
bcp all
bcp bulk
To design an event notification, you must determine the following\: I.The scope of the notification. II.The Transact-SQL statement, or group of statements, that raises the event notification. III.Server-scoped DDL triggers
I, II, II
I and III
I and II
II and III
To determine whether SQL Server or another process is cause of excessive paging, monitor the following Process
Page Faults/sec
%Privileged Time
%User Time
%Disk Time
To enable and configure Database Mail accounts and profiles, what can you use
Tools->Configure->Database Mail
Right click accounts and profiles then click configure
In the Database Mail Wizard clear check box accounts and profiles
Database Mail Configuration Wizard
To install SQL Server to Windows Server 2008 what we installing?
.NET FRAMEWORK
transact sql
install key
registre
To lock or disable access to database or some authorizing elements what is using?
Key
Insert
Duplicate
protocol
To modifying elements in database what transact queries we are using?
insert, update, drop, create
lock, grand, select, show
use, work, execute, run
play, set, ord, record
To reserve some db firstly we use
Backup
Recovery
Restore
update
To send Database Mail, you must be a member of the
DatabaseMailUserRole
Sysadmin role
TargetServerRole
SQL Server Agent role
To work with Server Agent and execute some parametres, what we turn on?
Configuration Manager
Bussines Development Studio
Management Studio
Server services
Unlike standard triggers they do not execute in response to which of the following statements
UPDATE, DELETE, CREATE
DROP, INSERT, GRANT
REVOKE, ALTER, CREATE
UPDATE, INSERT, DELETE
Was a backup device specified in the restore statement?
When using this statement, you must specify a snapshot name rather than a backup device.
Perform a full database and transaction log backup strategy for frequently modified databases
Phases of a restore include the data copy phase, the redo phase and the undo phase
The data copy phase involves copying all data, log and index pages from the backup
What are Key Areas to Monitor in SQL Server?
Disk system, Memory, CPU
CPU performance, Memory performance
Hardware stability, software availability
Operability, stability, organization
What are the primarily uses of the SQL Server Configuration Manager?
Managing SQL Server Services, Changing the Accounts Used by the Services, Manage Server and Client Network Protocols, Configure Server Startup Options, and Manage Instances of SQL Server.
The Database Engine Services.
The System Configuration Checker checks for conditions that prevent a successful SQL Server installation and will verify the computer where the installation is running.
Bussiness Intelegent Studio
What Backup Job does?
It performs the backup operation, logs history to the local server and the monitor server, and deletes old backup files and history information.
This job restores only the copied backup files to the secondary databases.
This job is shared by the primary and secondary databases of all log shipping configurations using this monitor server instance.
There is no information about this in lectures
What benefits would that offer?
It could avoid the unnecessary expense and administrative overhead of deploying multiple physical servers
Enterprise edition would satisfy the needs of large corporate SQL deployments. Other editions would be appropriate in difference scenarios.
A fast, multi-core CPU, with lots of RAM (at least 2 Gigs, 8 Gigs or more for an enterprise server), and a redundant disk array.
Amount of RAM, number of CPUs, and highly optimized disk storage arrays (in that order) are the most critical items for performance.
What can indicate that there is an overall shortage of memory on the computer or that an application is not releasing memory?
Low values for the Available Bytes
High values for the Available Bytes
Low values for the Busy Bytes
High values for the Busy Bytes
What condition is wrong ?
The policy is enabled.
The target belongs to the target set of the policy.
The target or one of the targets ancestors subscribes to the policy group that contains this policy.
Only policies from its subscribed categories can govern a database.
What is an efficient way to determine CPU usage?
To use the Processor\: %Processor Time counter in System Monitor
To use the Processor\:%Processor Avg. Time counter in Event Log Reader
To use System\:%Total Processor Time
To use the Processor\: %User Time counter in System Monitor
What counter monitors the percentage of time that the disk is busy with read/write activity?
% Disk Time
Avg. Disk Queue Length
Current Queue Length
%Busy Time
What counter shows the number of requests that were outstanding on the disk at the time that the performance data was collected.
Universal Disk Performance Measure
What counter used to determine how many system requests, on average, are waiting for disk access
What Distributors do?
store replication-specific data associated with one or more publishers
create and modify the data
Receive the data. With merge replication, this situation is altered slightly because modifications occur at both the publisher and the subscribers
Modify data for something
What does bcp utility do?
bulk copies data between an instance of Microsoft SQL Server 2008 and a data file in a user-specified format
loads data from a data file into a table
used to access remote data from OLE DB data sources only when the DisallowAdhocAccess registry option is explicitly set to 0 for the specified provider
manage existing packages
What does Dtutil do?
run an existing package at the command prompt
Adding event handlers to the package and package objects.
Constructing the data flows in a package
What does the Available Bytes counter indicates?
How many bytes of memory are currently available for use by processes
The number of bytes that either retrieved from disk due to hard page faults or written to disk due to free space in the working set due to page faults
How many bytes of hard disk are currently available for use by processes
Available system resources
What information do Dynamic management views and functions return?
Server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance
Information about user connections to the Database Engine and the locks that they hold
Server processing information and use connections report
All the information available about the server
What is "article"?
It can be a whole table or a database object, or a part of one.
It can only have articles from the same database
It is generally created against a publication
What is a Maintenance Plan:
helps database administrators schedule core tasks
Plan which will tell you how a query will be executed, or how a query was executed.
An ordered set of steps used to access or modify information in a SQL relational database management system
Typically diagram or list of steps with timing and resources
What is a transaction log?
The transaction log is a special DBMS table that contains a description of all the database transactions executed by the DBMS.
The transaction log is the DBMS component that establishes the order in which concurrent database operations are executed.
The transaction log is important because it is the DBMS component that will ensure transaction serializability
full
