SQL Server 2014 - Part 1

Beschreibung

Intermediary SQL Server 2014 Quiz am SQL Server 2014 - Part 1, erstellt von Paul Doman am 01/11/2015.
Paul Doman
Quiz von Paul Doman, aktualisiert more than 1 year ago
Paul Doman
Erstellt von Paul Doman vor etwa 9 Jahre
60
1

Zusammenfassung der Ressource

Frage 1

Frage
A database may consist of multiple [blank_start]filegroups[blank_end], with each containing at least one data file. Data Files are divided into 8KB [blank_start]data pages[blank_end], which are part of 64KB [blank_start]Extents[blank_end].
Antworten
  • filegroups
  • data pages
  • Extents

Frage 2

Frage
The [blank_start]fill factor[blank_end] option when creating or altering a database controls how full each data page is for a database.
Antworten
  • fill factor

Frage 3

Frage
SQL Server 2014 can bring a database online if one of it's files is corrupted - true or false?
Antworten
  • True
  • False

Frage 4

Frage
Within each instance of SQL Server 2014, the [blank_start]master[blank_end] database contains meta data about each hosted database - and the [blank_start]resource[blank_end] database contains information about the instance itself.
Antworten
  • resource
  • master

Frage 5

Frage
If you want to include a stored procedure in all newly created databases, you should place this within the [blank_start]model[blank_end] database.
Antworten
  • model

Frage 6

Frage
The msdb database supports the following functions within a SQL Server 2014 instance...
Antworten
  • SQL Server Agent
  • Log Shipping
  • SQL Server Integration Services
  • Backup & Restore
  • Customer Data
  • Transaction Logs
  • Operators & Alerts

Frage 7

Frage
In order to group related objects together within a database, you could create and assign them to a [blank_start]schema[blank_end]
Antworten
  • schema

Frage 8

Frage
How would you select all data from a table called "Employees" within a schema called "HumanResources"? .... SELECT * FROM [blank_start]HumanResources.Employees[blank_end]
Antworten
  • HumanResources.Employees

Frage 9

Frage
You can create an alternative name for database objects, either on local or linked server instances, using a [blank_start]synonym[blank_end]
Antworten
  • synonym

Frage 10

Frage
If you regularly need to reference a table within a database on a linked server within your SQL Code, you could use a [blank_start]synonym[blank_end] in order to avoid widespread direct references to the server (therefore creating a binding dependency) in your code.
Antworten
  • synonym

Frage 11

Frage
Which of the following exist within SQL Server 2014?
Antworten
  • Dynamic Management Objects (DMO)
  • Dynamic Management Views (DMV)
  • Dynamic Management Functions (DMF)
  • Dynamic Management Tables (DMT)
  • Dynamic Management Stored Procedures (DMP)

Frage 12

Frage
As a general rule of thumb, character data types requiring 5 or less bytes of data should be stored in a [blank_start]char[blank_end] data type, above that, a [blank_start]varchar[blank_end] data type should be used.
Antworten
  • char
  • varchar

Frage 13

Frage
A char data type can store a maximum of [blank_start]8000[blank_end] characters, however an nchar data type can store a maximum of [blank_start]4000[blank_end] characters.
Antworten
  • 8000
  • 4000

Frage 14

Frage
Which of the following data types can store unicode data?
Antworten
  • char(n)
  • nchar(n)
  • nvarchar(max)
  • text
  • varchar(n)
  • varchar(max)

Frage 15

Frage
The [blank_start]bit[blank_end] data type can store the values 0, 1 or null.
Antworten
  • bit

Frage 16

Frage
The [blank_start]tinyint[blank_end] data type can store whole numbers between 0 and 255.
Antworten
  • tinyint

Frage 17

Frage
The [blank_start]smallint[blank_end] data type can store whole numbers between -32,768 and 32,767.
Antworten
  • smallint

Frage 18

Frage
The [blank_start]int[blank_end] data type can store whole numbers between -2,147,483,648 and 2,147,483,647.
Antworten
  • int

Frage 19

Frage
The [blank_start]bigint[blank_end] data type can store whole numbers between -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.
Antworten
  • bigint

Frage 20

Frage
The [blank_start]money[blank_end] data type can store financial values from -922,337,203,685,477.5808 to 922,337,203,685,477.5807.
Antworten
  • money

Frage 21

Frage
The [blank_start]smallmoney[blank_end] data type can store financial values between -214,748.3648 and 214,748.3647.
Antworten
  • smallmoney

Frage 22

Frage
If you wanted to define a field which could store the value 99999.999 using a decimal data type - you would specify the scale to be the value [blank_start]3[blank_end] and the precision to be the value [blank_start]8[blank_end].
Antworten
  • 3
  • 8

Frage 23

Frage
SQL Server 2014 would use the same "mantissa" if you defined a fields of data type ... float(10), float(15), float(19), float (25), float(30). True or False?
Antworten
  • True
  • False

Frage 24

Frage
An image data type can store up to [blank_start]2[blank_end]GB of binary data.
Antworten
  • 2

Frage 25

Frage
If you wished to store binary database within a data type, which *could* exceed 2GB of data - you would use the data type [blank_start]varbinary(max)[blank_end].
Antworten
  • varbinary(max)

Frage 26

Frage
The [blank_start]date[blank_end] data type can represent data from January 1st, 0001 to December 31st, 9999.
Antworten
  • date

Frage 27

Frage
The [blank_start]datetime[blank_end] data type can stored dates between January 1st, 1753 to December 31st, 9999 accurate to the nearest 3.33 millisecond.
Antworten
  • datetime

Frage 28

Frage
The [blank_start]datetime2[blank_end](n) data type can stored dates between January 1st, 0001 to December 31st, 9999 with fractions of a second represented to n decimal places.
Antworten
  • datetime2

Frage 29

Frage
The [blank_start]smalldatetime[blank_end] data type can stored dates between January 1st, 1900 to June 6th, 2079 accurate to 1 minute.
Antworten
  • smalldatetime

Frage 30

Frage
The [blank_start]time[blank_end](n) data type stores time in Hours, Minutes, Seconds with fractions of a second represented to n decimal places.
Antworten
  • time

Frage 31

Frage
The [blank_start]SQL_Variant[blank_end] data type can store the value of any other system data type - except text, ntext, image, timestamp, xml, varchar(max), nvarchar(max) and varbinary(max).
Antworten
  • SQL_Variant

Frage 32

Frage
The [blank_start]rowversion[blank_end] data type (synonym: [blank_start]timestamp[blank_end]) is automatically updated whenever a row is inserted or updated.
Antworten
  • rowversion
  • timestamp

Frage 33

Frage
A table can have multiple rowversion columns - true or false?
Antworten
  • True
  • False

Frage 34

Frage
A table can have multiple timestamp columns - true or false?
Antworten
  • True
  • False

Frage 35

Frage
A [blank_start]uniqueidentifier[blank_end] data type can be used to store a GUID.
Antworten
  • uniqueidentifier

Frage 36

Frage
Which statements are true regarding the functions NewSequentialID() and NewID()?
Antworten
  • the former is technically guessable, the latter isn't.
  • the former is not technically guessable, the latter is
  • the former is faster than the latter
  • the latter is faster than the former
  • they both require a network card to be globally unique
  • neither require a network card to be globally unique
  • neither need a network card to create a GUID

Frage 37

Frage
SQL Server 2014 is available in which of these editions?
Antworten
  • Standard Edition
  • Enterprise Edition
  • Business Intelligence Edition
  • Express Edition
  • Developer Edition
  • Web Edition
  • Compact Edition
  • Workgroup Edition
  • Small Business Edition
  • Data Centre Edition

Frage 38

Frage
SQL Server 2014 Standard Edition can use [blank_start]16[blank_end] CPU Cores and [blank_start]128[blank_end]GB of memory.
Antworten
  • 16
  • 128

Frage 39

Frage
SQL Server 2014 Business Intelligence Edition can use [blank_start]16[blank_end] CPU Cores and [blank_start]128[blank_end]GB of memory for databases (unlimited memory for business intelligence).
Antworten
  • 16
  • 128

Frage 40

Frage
SQL Server 2014 Enterprise edition can use all available cores and memory within a server - true or false?
Antworten
  • True
  • False

Frage 41

Frage
Which SQL Server Editions support Basic Online Transactional Processing?
Antworten
  • Standard Edition
  • Business Intelligence Edition
  • Enterprise Edition

Frage 42

Frage
Which SQL Server Editions support In Memory Online Transactional Processing?
Antworten
  • Standard Edition
  • Business Intelligence Edition
  • Enterprise Edition

Frage 43

Frage
Which SQL Server Editions support Advanced Auditing and Transparent Data Encryption?
Antworten
  • Standard Edition
  • Business Intelligence Edition
  • Enterprise Edition

Frage 44

Frage
Which SQL Server 2014 Editions support Data Warehousing (ColumnStore Index, Compression, Partitioning)?
Antworten
  • Standard Edition
  • Business Intelligence Edition
  • Enterprise Edition

Frage 45

Frage
Which SQL Server 2014 Editions support Always On functionality?
Antworten
  • Standard Edition
  • Business Intelligence Edition
  • Enterprise Edition

Frage 46

Frage
SQL Server 2014 is licensed on a per-processor basis.
Antworten
  • True
  • False

Frage 47

Frage
If your server has two CPU Sockets with 8 cores each, you would need to purchase [blank_start]8[blank_end] SQL Server 2014 license packs in order to fully license it.
Antworten
  • 8

Frage 48

Frage
When licensing SQL Server 2014 - you need to license a minimum of [blank_start]4[blank_end] cores for each CPU present on the server.
Antworten
  • 4

Frage 49

Frage
With a Software Assurance / Enterprise Agreement - a SQL Server 2014 Enterprise Edition may be licensed on a per-host basis - covering the maximum number of cores on the server. Once licensed in this manner, a maximum of 16 Virtual instances are permitted on the same machine.
Antworten
  • True
  • False

Frage 50

Frage
SQL Server 2014 will perform faster running on two 1.6 GHz processors than on a single 3.2 GHz processor - true or false?
Antworten
  • True
  • False

Frage 51

Frage
When specifying Key Storage performance for a device - it is recommended that the [blank_start]IOPS[blank_end] and [blank_start]Throughput[blank_end] are high and the [blank_start]I/O Latency[blank_end] is zero (or close to zero).
Antworten
  • Throughput
  • IOPS
  • I/O Latency
  • IUPS
  • IPS
  • OPS
  • Input
  • Output
  • MBps
  • Access Speed
  • Spin Up Speed

Frage 52

Frage
SQL Server [blank_start]collation[blank_end] specifies the set of rules regarding how data is stored, sorted and compared.
Antworten
  • collation

Frage 53

Frage
Which type of Account is recommended for running a SQL Server 2014 instance, if it requires network access?
Antworten
  • Domain Account
  • Local System Account
  • Local Service Account
  • Network Service Account
  • Local Server Account

Frage 54

Frage
How should SQL Server 2014 service accounts be configured across an enterprise?
Antworten
  • Each instance runs as a Network Service Account
  • Each instance runs as a Local Service Account
  • Each instance runs using a specially created Domain Service Account for all SQL Servers
  • Each instance runs using a specially created Domain Service Account per SQL Server instance
  • A mixture of the Network, Local and Domain Accounts depending on need

Frage 55

Frage
SQL Server 2014 Analysis Services can be installed in which of the following modes?
Antworten
  • Standard Mode
  • Advanced Mode
  • OLTP Mode
  • Multidimensional and Data Mining Mode (UDM)
  • Tabular Mode
  • ColumnStore Mode

Frage 56

Frage
Which of the following are storage and processing modes in SQL Server 2014 Analysis Services UDM mode?
Antworten
  • MOLAP
  • OLAP
  • ROLAP
  • HOLAP
  • SOLAP
  • ColumnStore
  • In Memory OLTP
  • Cubes

Frage 57

Frage
In SQL Server 2014 Analysis Services UDM mode ... [blank_start]MOLAP[blank_end] is a storage and processing mechanism where aggregates are stored in a separate specialised database to a typical SQL Database - and used to answer queries instead.
Antworten
  • MOLAP

Frage 58

Frage
In SQL Server 2014 Analysis Services UDM mode ... [blank_start]ROLAP[blank_end] is a storage and processing mechanism where aggregates are calculated via query cache or directly from the relational SQL Database data source.
Antworten
  • ROLAP

Frage 59

Frage
In SQL Server 2014 Analysis Services UDM mode ... [blank_start]HOLAP[blank_end] is a storage and processing mechanism where aggregates are stored and queried partially in a separate specialised database with more detailed queries retrieved directly from the SQL Server Relational Database data source.
Antworten
  • HOLAP

Frage 60

Frage
Analysis Services [blank_start]Tabular Mode[blank_end] databases are column based databases that enable high levels of compression because of the reduced need to store discrete values along with advanced compression algorithms.
Antworten
  • Tabular Mode

Frage 61

Frage
Analysis Services Tabular Mode supports a new approach model called the [blank_start]Business Intelligence Semantic Model[blank_end] (BISM)
Antworten
  • Business Intelligence Semantic Model

Frage 62

Frage
Which of the following Query Mode options when using Tabular Mode in Analysis Services?
Antworten
  • MOLAP
  • HOLAP
  • ROLAP
  • QueryDirect
  • DirectQueryWithInMemory
  • Partitioned Cubes
  • DirectAccess
  • InMemoryWithDirectQuery
  • InMemory
  • DirectQuery

Frage 63

Frage
Which of the following Tabular Mode Query Options is similar to the MOLAP processing mode in UDM mode?
Antworten
  • InMemory
  • DirectQuery
  • InMemoryWithDirectQuery
  • DirectQueryWithInMemory

Frage 64

Frage
Which of the following Tabular Mode Query Options is similar to the ROLAP processing mode in UDM mode?
Antworten
  • InMemory
  • DirectQuery
  • InMemoryWithDirectQuery
  • DirectQueryWithInMemory

Frage 65

Frage
What does UDM mean in SQL Server Analysis Services?
Antworten
  • Unified Development Mode
  • United Distribution Method
  • Universal Data model
  • Unified Development Model
  • Unified Dimensional Model
  • Universal Dimensional Model

Frage 66

Frage
Which of the following tools can help with 'Burning In' a new SQL Server 2014 installation?
Antworten
  • SQLLocalDB
  • iisreg
  • SQLIOSim
  • IOPSStress
  • IOMeter
  • SQLLoader
  • Prime95

Frage 67

Frage
When setting the Maximum Memory available to SQL Server, this should at least [blank_start]4[blank_end] GB less than the total available server memory.
Antworten
  • 4

Frage 68

Frage
The Minimum Memory setting within a SQL Server Instance is reserved when the SQL Service starts up, and never released back to the operating system whilst running.
Antworten
  • True
  • False

Frage 69

Frage
The default [blank_start]network packet[blank_end] size for SQL Server 2014 is 4096 bytes. If [blank_start]Jumbo Frames[blank_end] are supported by the server hardware, this should be increased to 8192 bytes in order to increase performance when the server is subject to a large number of bulk operations.
Antworten
  • network packet
  • Jumbo Frames

Frage 70

Frage
When database files are created or grow, they are zero-filled and block write operations until that task is finished. What should you do to enable Instant File Initialisation in your SQL Instance?
Antworten
  • Set the Instant File Initialisation checkbox in Database Properties
  • Set the Instant File Initialisation checkbox in Server Properties
  • issue the command: EXEC sp_configure 'instant file initialisation', '1';
  • Add the SQL Server Service Account to the Administrators group on the local machine
  • Add the SQL Server Service Account to the Perform Volume Maintenance Tasks Local Policy
  • Instant File Initialisation is not a SQL Server feature

Frage 71

Frage
Adding multiple tempdb data files can increase performance when SQL Server utilises multiple CPUs - true or false?
Antworten
  • True
  • False

Frage 72

Frage
As a guide, when sizing tempdb you should analyse a typical workload in a query plan to determine the rows affected in each stage of the plan - and workout the rows affected count * row size (bytes) to get a good starting size for tempdb. Which stages of the query plan are most useful for this process?
Antworten
  • sort
  • hash match
  • spool
  • export
  • index lookup
  • table scan
  • hash

Frage 73

Frage
It's a good idea to turn on (or auto schedule) auto shrinking on your database in order to reclaim unused space and keep the database small and fast - true or false?
Antworten
  • True
  • False

Frage 74

Frage
What is the preferred method of securing the SA account within a SQL Server Instance?
Antworten
  • Nothing - by default it's secured on installation
  • Set a strong password
  • Delete the SA Account altogether and use a Domain Admin account
  • Set a strong password and disable the SA account
  • Set a strong password, disable the account - and then rename it
  • Rename the SA Account to something else

Frage 75

Frage
SQL Server 2014 when installed in the default instance, communicates on port [blank_start]1433[blank_end].
Antworten
  • 1433

Frage 76

Frage
Which of the following tools can be used to analyse a current server to ensure an upgrade to 2014 will run successfully to completion by performing in place analysis of databases for potential compatibility issues.
Antworten
  • SQL Server Mangement Server
  • Visual Studio .NET IDE with Data Tools installed
  • SQL Server Upgrade Advisor
  • SQL Profiler
  • SQLDMO Object Library
  • SQL Server Upgrade Assistant

Frage 77

Frage
Which of the following should be performed as part of a pre-upgrade plan when upgrading to SQL Server 2014
Antworten
  • Set data and log files to autogrow
  • Set the master and msdb databases to single user mode
  • Execute the command: EXEC sp_configure 'no new connections',1
  • Disable all startup stored procedures
  • Shrink tempdb so it has enough room to grow during the upgrade
  • Disabled Trace Flags as they may not exist in SQL Server 2014
  • Migrate any SQL Mail instances into Database Mail

Frage 78

Frage
Use the SQL Server [blank_start]Upgrade Advisor[blank_end] tool to check for conditions, situations or known errors that might affect the upgrading process.
Antworten
  • Upgrade Advisor

Frage 79

Frage
RESTORE | BACKUP { DATABASE | LOG } WITH [blank_start]PASSWORD[blank_end] is no longer supported.
Antworten
  • PASSWORD

Frage 80

Frage
SQL Server 2014 supports returning result sets from triggers. True of False?
Antworten
  • True
  • False

Frage 81

Frage
SET [blank_start]ROWCOUNT[blank_end] for INSERT, UPDATE and DELETE statements has been depcrecated.
Antworten
  • ROWCOUNT

Frage 82

Frage
During an upgrade to SQL Server 2014 - all databases with Full-Text Catalog are marked as Full-Text [blank_start]Disabled[blank_end] - because of the potential time involved in rebuilding the catalog.
Antworten
  • Disabled

Frage 83

Frage
Which of the following can be upgraded, using an in place update, to SQL Server 2014 64bit Edition?
Antworten
  • SQL Server 2005 32bit Edition
  • SQL Server 2005 64bit Edition
  • SQL Server 2008 32bit Edition
  • SQL Server 2008 64bit Edition
  • All of them
  • None of them

Frage 84

Frage
Which of the following can be upgraded, using a side-by-side upgrade, to SQL Server 2014 64bit Edition?
Antworten
  • SQL Server 2005 32bit Edition
  • SQL Server 2005 64bit Edition
  • SQL Server 2008 32bit Edition
  • SQL Server 2008 64bit Edition
  • All of them
  • None of them

Frage 85

Frage
After upgrading to SQL Server 2014 - query performance may be poor due to outdated or unsupported statistics. In order to rectify this situation, you should call the sp_[blank_start]updatestats[blank_end] stored procedure with the [blank_start]resample[blank_end] argument to rebuild the statistics based on an inherited sampling ratio.
Antworten
  • updatestats
  • resample

Frage 86

Frage
In order to administer the SQL Server services - for example: changing the listening port for an instance - you would use the SQL Server [blank_start]Configuration Manager[blank_end] Tool.
Antworten
  • Configuration Manager

Frage 87

Frage
Which of the following communications protocols can SQL Server 2014 use?
Antworten
  • Shared Memory
  • Named Pipes
  • TCP/IP
  • VIA
  • Bonjour
  • IPX/SPX
  • Novell

Frage 88

Frage
If you wish to change the startup parameters of an instance of SQL Server 2014 - you should use the SQL Server [blank_start]Configuration Manager[blank_end] tool, access properties of the SQL Server instance and access the [blank_start]startup parameters[blank_end] tab.
Antworten
  • Configuration Manager
  • startup parameters

Frage 89

Frage
You can start SQL Server 2014 requesting it to use a different master database - useful if a SQL Instance won't start. How would you do this?
Antworten
  • Use the SQL Server Repair tool to repair the master database
  • Rename the existing master.mdf and master.ldf files - SQL will ask where it can find a replacement master database where you can choose the appropriate files.
  • Start the SQL Server via the command line, in 'safe' mode, and follow on screen instructions to point to a new master database.
  • Start the SQL Server via the command line, using the -d and -l switches to specify the path to the replacement master mdf and ldf files.

Frage 90

Frage
You can use the [blank_start]-T[blank_end] (uppercase) switch from the command line to start SQL Server and turn on Trace flags for all connections.
Antworten
  • T

Frage 91

Frage
Starting SQL Server 2014 from the command line, using the -[blank_start]m[blank_end] switch, starts SQL Server in single-user or 'master recovery mode' enabling you to perform critical server maintenance (e.g. restore master database).
Antworten
  • m

Frage 92

Frage
In order to instruct SQL Server 2014 to run startup stored procedures when an instance starts, you must do the following...
Antworten
  • issue the command: EXEC sp_configure 'scan for startup procs', 1
  • Issue the command: EXEC sp_configure 'startup procs',1
  • In the SQL Server properties, set the 'Run Startup Procedures' in the 'Start Up' tab
  • start SQL Server from the command line with the -s switch
  • Startup Stored Procedures are not supported by SQL Server 2014

Frage 93

Frage
In order to make the following stored procedure a 'startup stored procedure' you would use the syntax... sp_[blank_start]procoption[blank_end] @procname='master.dbo.MyStoredProcedure', @option='[blank_start]startup[blank_end]', @optionvalue='1'
Antworten
  • procoption
  • startup

Frage 94

Frage
When a SQL Server is not allowing new connections, or is overloaded, an administrator can connect using the [blank_start]Dedicated Administrator Connection[blank_end] (DAC) - to force a connection.
Antworten
  • Dedicated Administrator Connection

Frage 95

Frage
In order for an administrator to connect using the Dedicated Administrator Connection - you can connect to the server via SMSS by prefixing the server name with [blank_start]admin[blank_end]: - or, you can start SQL Server via the command line, using the -[blank_start]A[blank_end] switch.
Antworten
  • admin
  • A

Frage 96

Frage
The Dedicated Administrator Connection, as a default, listens on port [blank_start]1434[blank_end].
Antworten
  • 1434

Frage 97

Frage
In order to enable the Dedicated Administrator Connection on a remote SQL Instance, you would need to set the appropriate configuration options on the remote instance as follows... EXEC sp_configure '[blank_start]remote admin connection[blank_end]', 1
Antworten
  • remote admin connection

Frage 98

Frage
In order to view the Edition and version of SQL Server, any non-default configuration options, I/O and CPU statistics by type of activity - you could use the [blank_start]Server Dashboard[blank_end] report.
Antworten
  • Server Dashboard

Frage 99

Frage
Using SQL Management Studio, you can set configuration options by using the sp_[blank_start]configure[blank_end] stored procedure, or use the [blank_start]Server Properties[blank_end] dialog.
Antworten
  • configure
  • Server Properties

Frage 100

Frage
Typically it is recommended that you set the [blank_start]minimum[blank_end] and [blank_start]maximum[blank_end] amount of memory that your SQL instances use in your environment.
Antworten
  • minimum
  • maximum

Frage 101

Frage
Setting the Maximum Worker Threads property to [blank_start]0[blank_end] ensures that SQL Server chooses the optimum number of threads to enable on each processor.
Antworten
  • 0

Frage 102

Frage
Which of the following authentication mechanisms are available within SQL Server?
Antworten
  • Kerberos Authentication
  • Domain Trust Authentication
  • Secure Token Two Factor Authentication
  • SQL Server Integrated Authentication
  • Windows Authentication

Frage 103

Frage
By default, sp_configure only shows / sets basic and commonly used configuration options... in order to view and adjust all configuration options, you would use the command... sp_configure '[blank_start]show advanced options[blank_end]',1 ... and then issue the command [blank_start]RECONFIGURE[blank_end]
Antworten
  • show advanced options
  • RECONFIGURE

Frage 104

Frage
If, when setting a configuration value using sp_configure, SQL Server reports that the value is out of a recommended range - it warns the user. If you wished to proceed and force the change, regardless of the warning, you would use the command... RECONFIGURE WITH [blank_start]OVERRIDE[blank_end]
Antworten
  • OVERRIDE

Frage 105

Frage
To view Error Logs within SQL Server Management Studio, you should right click on the [blank_start]SQL Server logs[blank_end] node, within the [blank_start]Management[blank_end] folder in the Object Tree, and select View -> SQL Server and Windows Lg.
Antworten
  • SQL Server logs
  • Management

Frage 106

Frage
In the Log File Viewer screen in SQL Server Management Studio, you can load log files from Windows Logs - or other SQL instance logs, into one consolidated view - in order to view a unified timeline of events. True or False?
Antworten
  • True
  • False

Frage 107

Frage
Within SQL Server Management Studio, you would use the [blank_start]Activity Monitor[blank_end] screen to view current transactions and determine if there are blocking transactions.
Antworten
  • Activity Monitor

Frage 108

Frage
Using SQL Management Studio, there is a report which details all currently blocking transactions. You can access this by right clicking upon the [blank_start]Server Name[blank_end], select [blank_start]Reports[blank_end] - then, [blank_start]Standard Reports[blank_end], and then choose [blank_start]Activity - All Blocking Transactions[blank_end].
Antworten
  • Server Name
  • Database Name
  • Management Node
  • Security Tab
  • Reports
  • Transactions
  • Activity
  • Connections
  • Standard Reports
  • Current Connections
  • Blocking Transactions
  • Current Activity
  • Activity - All Blocking Transactions
  • Activity - All Current Connections
  • Activity - All Suspended Transactions
  • Activity - All Wait State
  • Activity - Blocked Users

Frage 109

Frage
Using Transact-SQL, you can see who is connected to your SQL instance with either the sp_[blank_start]who[blank_end] (or, more recently, sp_[blank_start]who2[blank_end]) stored procedures.
Antworten
  • who
  • who2

Frage 110

Frage
In order to see all active connections to your SQL Instance, you could use the following command.... sp_who2 '[blank_start]active[blank_end]'
Antworten
  • active

Frage 111

Frage
If you wanted to view the worst performing queries through history in your SQL Instance, you could query the following Dynamic Management View, sys.dm_exec_[blank_start]query[blank_end]_[blank_start]stats[blank_end].
Antworten
  • query
  • stats

Frage 112

Frage
Within SQL Server Management Studio, you can administer many servers at once, issuing commands on each server simultaneously, and consolidating the results into a single result set. This is achieved by creating a [blank_start]Central Management[blank_end] Server - and creating [blank_start]Server Groups[blank_end] within it.
Antworten
  • Central Management
  • Server Groups

Frage 113

Frage
When using a Central Management Server to manage multiple servers, all queries issued to managed servers are sent through [blank_start]trusted[blank_end] connections. If the servers cross domains, you must have [blank_start]trust[blank_end] relationships between them.
Antworten
  • trusted
  • trust

Frage 114

Frage
When installed, SQL Server 2014 will not allow SQL Agent to run - having an 'Agent XPs disabled' tag against it in SQL Server Management Studio. In order to allow SQL Agent to start, you must issue the following command... sp_[blank_start]configure[blank_end] '[blank_start]Agent XPs[blank_end]', 1
Antworten
  • configure
  • Agent XPs

Frage 115

Frage
[blank_start]Maintenance Plans[blank_end] are a quick and easy way to automate routine maintenance tasks in SQL Server 2014.
Antworten
  • Maintenance Plans

Frage 116

Frage
You can perform routine maintenance within SQL Server 2014 by using either the Maintenance Plan [blank_start]Wizard[blank_end] (the quick way) or the Maintenance Plan [blank_start]Designer[blank_end] (the more advanced editor).
Antworten
  • Wizard
  • Designer

Frage 117

Frage
SQL Server [blank_start]Agent[blank_end] can be used to automate tasks within SQL Server, and consists of four basic components... [blank_start]Jobs[blank_end] : Defines the work to be done [blank_start]Schedules[blank_end] : Defines when the job will be executed [blank_start]Operators[blank_end] : Lists the people who can be notified for job statuses and alerts [blank_start]Alerts[blank_end] : Enables you to set up an automatic response or notification
Antworten
  • Jobs
  • Schedules
  • Operators
  • Alerts
  • Agent

Frage 118

Frage
SQL Server Agent Jobs can be started by ...
Antworten
  • attaching the job to one or more schedules
  • being triggered in response to one or more alerts
  • by executing sp_start_job
  • Manually via SQL Server Management Studio
  • All of the above

Frage 119

Frage
A SQL Agent Job consists of Job Steps. Which of the following types of steps can be added to a job?
Antworten
  • ActiveX Script
  • Operating System Command
  • Powershell Script
  • SQL Server Analysis Services commands & queries
  • SQL Server SSIS Package
  • Transact-SQL Statements
  • Set Registry Entries
  • Server Control (Restart service)
  • Send an Email

Frage 120

Frage
SQL Server Agent can also host jobs relating to SQL Server Replication. Which of the following are valid Replication Job Steps?
Antworten
  • Replication Distributor
  • Replication Merge
  • Replication Queue Reader
  • Replication Snapshot
  • Replication Transaction Log Reader
  • Replication Backup Log
  • Replication Flush Transaction
  • Replication Sync

Frage 121

Frage
SQL Server Agent job steps have a number of outcomes which can determine the flow of the job. Which of the following are valid outcomes for a job steps...
Antworten
  • Quit the job, indicating success
  • Quit the job, with failure
  • Go to another job step
  • Retry a job step on failure, n number of times
  • Restart SQL Server
  • Restart SQL Server Agent
  • Place the SQL Server Agent Job into a 'suspended' state

Frage 122

Frage
You can organise your SQL Agent Jobs by creating and assigning a [blank_start]category[blank_end] to each job. This helps when there are a large number of jobs within an instance of SQL Server.
Antworten
  • category

Frage 123

Frage
In order to log the outcome of a SQL Agent Job Step, the step needs to be executed under a security context belonging to the [blank_start]sysadmin[blank_end] role.
Antworten
  • sysadmin

Frage 124

Frage
SQL Agent jobs support notifications when a step completes, succeeds or fails. These can trigger actions. Which of the following are permissible actions...
Antworten
  • Send an Email
  • Send a Pager Message
  • Send a Net Send Message
  • Write to the Windows Application event log
  • Write to the System event log
  • Automatically delete the job
  • Send a Tweet
  • Restart the SQL Server Agent after retrying n times

Frage 125

Frage
SQL Agent Jobs can be scheduled to run under which of the following schedules...
Antworten
  • When SQL Server Agent Starts
  • Once, at a specified date and time
  • On a recurring basis
  • When the CPU utilisation of the server is idle
  • On receipt of an Email
  • On receipt of a WCF API Call
  • On receipt of a Windows Workflow schedule
  • When a transaction log becomes full

Frage 126

Frage
SQL Server Agent provides the ability to chain Jobs together - i.e. when one completes, it triggers the execution of another. Which of the following statements are true?
Antworten
  • SQL Server Agent has no native support for this feature
  • You set the outcome of the job to be 'Execute another Job' and choose from a drop down list
  • You can start a job using the stored procedure sp_start_job and add it as a Transact-SQL job step
  • You create a job with a start trigger that is the completion of a previous task

Frage 127

Frage
If you wish to send an alert to an individual if a SQL Server Agent job fails, you must create an [blank_start]operator[blank_end] in order to represent the individual and their contact details.
Antworten
  • operator

Frage 128

Frage
In order to send an email to an individual when a SQL Agent Job fails, [blank_start]Database Mail[blank_end] must be set up and enabled, and the SQL Server [blank_start]Agent[blank_end] must be configured to use it.
Antworten
  • Database Mail
  • Agent

Frage 129

Frage
When defining an operator to be notified when a SQL Agent Job fails, it is best practice to define an email [blank_start]group[blank_end] and send the alerts to it, enabling you to change the recipient list externally to the SQL Job.
Antworten
  • group

Frage 130

Frage
SQL Server Agent, natively, cannot send alerts to pagers. True or False?
Antworten
  • True
  • False

Frage 131

Frage
In order to send a Net Send message to an individual when a SQL Agent job completes, the Windows [blank_start]Messaging[blank_end] Service needs to be installed upon the server - and the individual must provide their [blank_start]workstation[blank_end] name as the recipient destination.
Antworten
  • Messaging
  • workstation

Frage 132

Frage
A "fail safe operator" can be configured to be notified if a notification alert cannot be sent via Pager, Email or Net Send - True or False?
Antworten
  • True
  • False

Frage 133

Frage
If a notification message has to be sent to the "fail safe operator" because of a failed attempt to Page an on duty operator, which method will be used to send the message?
Antworten
  • Pager
  • Email
  • Net Send
  • Any - it depends on how it's configured

Frage 134

Frage
Within SQL Server Agent, an [blank_start]alert[blank_end] is an automated response to an [blank_start]event[blank_end].
Antworten
  • alert
  • event

Frage 135

Frage
An SQL Server Agent alert can be triggered in response to an Event. Valid Event types include...
Antworten
  • SQL Server Event
  • SQL Server Performance Condition
  • Windows Management Instrumentation (WMI) event
  • Receipt of an HTTP request
  • Receipt of an Email
  • Starting of the SQL Server Agent Service

Frage 136

Frage
Which of the following responses can be triggered as the result of an event alert?
Antworten
  • Start a SQL Server Agent Job
  • Notify one or more operators
  • Restart the SQL Server Agent Service
  • Restart the SQL Server Service
  • Write to a log file
  • Write to the Windows Event Log

Frage 137

Frage
When defining an Alert - you can instruct alert to apply to All databases as well as a specific database. True or False?
Antworten
  • True
  • False

Frage 138

Frage
SQL Server Event Alerts are defined based upon an error [blank_start]number[blank_end] or error [blank_start]severity[blank_end] level.
Antworten
  • number
  • severity

Frage 139

Frage
When defining a SQL Server Event Alerts, which of the following takes precedence if multiple alerts match the same condition?
Antworten
  • Error Number takes precedence over Error Severity
  • Error Severity takes precedence over Error Number
  • They are of equal importance, they will both fire
  • They are of equal importance, but the first defined alert will fire
  • Depends on the Severity level ( 19 or over takes precedence over all other alerts )

Frage 140

Frage
An alert can be defined when a SQL Server Event contains a specified piece of text. True or False?
Antworten
  • True
  • False

Frage 141

Frage
Leveraging the Windows Performance Monitor feature of Windows Servers - an alert can be defined based upon a SQL Server [blank_start]counter[blank_end] - one of the many performance values that are monitored and tracked natively.
Antworten
  • counter

Frage 142

Frage
The SQL Server Agent [blank_start]Service[blank_end] Account should be a [blank_start]domain[blank_end] account if you plan to use the features of [blank_start]Database Mail[blank_end] or require any network connectivity. The account must be mapped to a SQL Server [blank_start]Login[blank_end] that is also a member of the [blank_start]sysadmin[blank_end] role.
Antworten
  • Service
  • Startup
  • Administrator
  • Anonymous
  • domain
  • local system
  • local service
  • network service
  • administrator
  • Database Mail
  • SQL Full Text Searching
  • Backup & Restore
  • SSIS
  • SSRS
  • Login
  • User
  • Schema
  • Linked Server
  • sysadmin
  • serveradmin
  • adminusers
  • users
  • guests
  • networkservices
  • sa

Frage 143

Frage
Which of the following server roles could a login belong in order to see the SQL Server Agent within SQL Server Management Studio?
Antworten
  • sysadmin
  • sqlagentuserrole
  • sqlagentreaderrole
  • sqlagentoperatorrole
  • sqlagentadministrator
  • serveradmin

Frage 144

Frage
In order of capability (lowest to highest) - which roles allow access to the SQL Server Agent via SQL Management Studio?
Antworten
  • SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRole
  • SQLAgentUserRole, SQLAgentOperatorRole, SQLAgentReaderRole
  • SQLAgentReaderRole, SQLAgentUserRole, SQLAgentOperatorRole
  • SQLAgentReaderRole, SQLAgentOperatorRole, SQLAgentUserRole
  • SQLAgentOperatorRole, SQLAgentUserRole, SQLAgentReaderRole
  • SQLAgentOperatorRole, SQLAgentReaderRole, SQLAgentUserRole

Frage 145

Frage
Within SQL Server Agent, members of the SQLAgentUserRole can ...
Antworten
  • access only jobs and schedules that they own
  • access jobs and schedules for others in the SQLAgentUserRole
  • access all jobs and schedules on the server
  • access multi server jobs
  • delete job history for their own jobs
  • delete job history for all jobs
  • select the operators to be notified on outcomes of their own jobs
  • select the operators to be notified on outcomes of others jobs

Frage 146

Frage
A SQL Server Job Step can run, via impersonation, under a [blank_start]security[blank_end] context other than the context of the user that created the job. This can be useful if the job requires access to resources that are denied to the job creator. If this is required, the creator must create a SQL Server Agent [blank_start]Proxy[blank_end] that is associated with a domain account that has the appropriate rights.
Antworten
  • security
  • Proxy

Frage 147

Frage
The SQL Server Agent can pass on events to another server for processing, using a feature called
Antworten
  • Event Shipping
  • Event Log Replication
  • Distributed Event Co-ordinator
  • Event Forwarding
  • Event Log Distribution

Frage 148

Frage
SQL Agent can send only unhandled events to another server for processing. True or False?
Antworten
  • True
  • False

Frage 149

Frage
An unhandled event, in SQL Server, is an event which does not have an [blank_start]alert[blank_end] defined for it.
Antworten
  • alert

Frage 150

Frage
In SQL Server Agent advanced properties, you can define what consitutes an [blank_start]idle CPU[blank_end] condition. When setting this option, you are setting that the [blank_start]CPU[blank_end] is deemed [blank_start]idle[blank_end] if the [blank_start]Average[blank_end] CPU usage falls below x[blank_start]%[blank_end] and remains below this level for y[blank_start]seconds[blank_end].
Antworten
  • idle CPU
  • %
  • seconds
  • CPU
  • idle
  • Average

Frage 151

Frage
When you wish for placeholders to be replaced in job responses to alerts, you must enabled the [blank_start]Token Replacement[blank_end] option within the SQL Server Agent Alert System Properties dialog.
Antworten
  • Token Replacement

Frage 152

Frage
You can define how long the SQL Agent Service will wait before killing off executing jobs when it's asked to stop, by setting the [blank_start]shutdown[blank_end] time-out interval in the Job System Properties dialog.
Antworten
  • shutdown

Frage 153

Frage
You can limit the SQL Agent History logging feature by setting the Maximum job history [blank_start]log[blank_end] size (measured in [blank_start]rows[blank_end]) - and the maximum number of rows per [blank_start]job[blank_end].
Antworten
  • log
  • rows
  • job

Frage 154

Frage
When using Token Replacements within SQL Server Agent jobs, it is imperative that you protect the server from SQL Injection Attacks - using Escape Macros around tokens. Which of the following are valid Escape Macros?
Antworten
  • ESCAPE_SQUOTE
  • ESCAPE_DQUOTE
  • ESCAPE_RBRACKET
  • ESCAPE_LBRACKET
  • ESCAPE_BRACKETS
  • ESCAPE_NONE

Frage 155

Frage
When using Event Forwarding within SQL Agent, if you choose to forward 'All Events', you can specify a filter based upon the [blank_start]severity[blank_end] level.
Antworten
  • severity

Frage 156

Frage
Multiserver Administration enables a system to be configured with a [blank_start]master[blank_end] server (MSX) and one or more [blank_start]target[blank_end] servers (TSX) - where jobs can be sent on it's behalf.
Antworten
  • master
  • target

Frage 157

Frage
In order to set up MultiServer Administration on a SQL Server, you need to right click on the SQL Server [blank_start]Agent[blank_end] node in SQL Management Studio, then select Multi Server Administration...
Antworten
  • Agent

Frage 158

Frage
When setting up a master server, when configuring Multi Server Administration, the first thing that is requested is you set up a [blank_start]master server[blank_end] operator - the only operator that can be notified from multiserver jobs.
Antworten
  • master server

Frage 159

Frage
When using Multi Server Administration, and you connect to a Target server with administrative rights. You are unable to edit any multi server jobs that you may find in the SQL Agent. True of False?
Antworten
  • True
  • False

Frage 160

Frage
The SQL Server [blank_start]Service Broker[blank_end] can be used where a large amount of commands can be expected to be received, and need to be completed reliably, just not at the exact time the command was issued.
Antworten
  • Service Broker

Frage 161

Frage
The [blank_start]Service Broker[blank_end] feature of SQL Server enables you to build reliable, asynchronous services in a SQL Server Database.
Antworten
  • Service Broker

Frage 162

Frage
Service Broker Services can pass messages reliably and transactionally - and can contain up to [blank_start]2[blank_end]GB of binary data within each message, and, if so desired, can associate an [blank_start]XML[blank_end] schema with a message, for automatic schema validation.
Antworten
  • 2
  • XML

Frage 163

Frage
The Service Broker addresses wildly varying resource loads by a process that watches for messages on Service Broker queues. This background process is called the [blank_start]activation[blank_end] monitor - and maintains the optimum number of queue [blank_start]reader[blank_end] processes required to process the current load.
Antworten
  • activation
  • reader

Frage 164

Frage
Within a Service Broker system, Services depend on bidirectional exchange of messages. Requests are made of a service and the service returns responses. These exchanges are persisted within the Service Broker in persisted objects called [blank_start]conversations[blank_end].
Antworten
  • conversations

Frage 165

Frage
A Service Broker [blank_start]conversation[blank_end] is an object at each end of the message exchange that tracks what messages have been sent and received, what messages have been acknowledged and what acknowledgements have been received.
Antworten
  • conversation

Frage 166

Frage
Service Broker Conversations are stored as persistent database objects that can survive database restarts. They have a default lifetime of 24 hours from the time of receipt. True or False?
Antworten
  • True
  • False

Frage 167

Frage
The Service Broker feature uses three commands to manage conversations. These are... [blank_start]CREATE CONVERSATION[blank_end] : which generates a conversation on which messages are sent [blank_start]SEND[blank_end] : which dispatches messages on a previously created conversation [blank_start]RECEIVE[blank_end] : which receives messages from a conversation.
Antworten
  • SEND
  • RECEIVE
  • BEGIN DIALOG CONVERSATION

Frage 168

Frage
Within a SQL Service Broker Conversation, messages are GUARANTEED to be delivered once, in the order in which they were created.
Antworten
  • True
  • False

Frage 169

Frage
As the Service Broker is configured within a SQL Server instance, care must be taken when restoring system state from msdb - if you restore this to a different point in time to a database that uses the service broker, message inconsistencies can be introduced. True or False?
Antworten
  • True
  • False

Frage 170

Frage
When restoring a database, that uses the Service Broker, the Service Broker is disabled as a default - to stop the database immediately processing queued conversations. In order to restart the Service Broker at you convenience, you can issue the following command... ALTER DATABASE <database name> SET [blank_start]ENABLE_BROKER[blank_end]
Antworten
  • ENABLE_BROKER

Frage 171

Frage
If you have a database that uses Service Broker, and you wish to delete all existing conversations and messages, and create a new SERVICE_BROKER_GUID so the database will look like a new Service Broker database, as it was before, but with a new Identity, you would use the following command... ALTER DATABASE <database name> SET [blank_start]NEW_BROKER[blank_end]
Antworten
  • NEW_BROKER

Frage 172

Frage
If a database is using a Service Broker, and you wish to flush all conversations into an error state in order to clean up both ends of a conversation cleanly, you could use the following command... ALTER DATABASE <database name> SET [blank_start]ERROR_BROKER_CONVERSATIONS[blank_end]
Antworten
  • ERROR_BROKER_CONVERSATIONS

Frage 173

Frage
When configuring the Service Broker for a database, [blank_start]message[blank_end] types can be used in your service to determine what kind of data a message contains so that it knows how to process it.
Antworten
  • message

Frage 174

Frage
A Service Broker Message Type can be defined to be self validating. In order to do this, it requires a validation option within the definition. Valid options are...
Antworten
  • NONE
  • EMPTY
  • WELL_FORMED_XML
  • VALID_XML WITH SCHEMA COLLECTION
  • BINARY
  • STRING
  • SQL_VARIANT

Frage 175

Frage
When defining a Service Broker Message type, called RegRequest, that can contain any valid XML snippet as the message body - you should use the following command... CREATE MESSAGE TYPE [blank_start]RegRequest[blank_end] AUTHORIZATION dbo VALIDATION = [blank_start]WELL_FORMED_XML[blank_end]
Antworten
  • RegRequest
  • WELL_FORMED_XML

Frage 176

Frage
When using the Service Broker within a database, you can define which [blank_start]message[blank_end] types can be used in a [blank_start]conversation[blank_end] by defining a [blank_start]contract[blank_end].
Antworten
  • message
  • conversation
  • contract

Frage 177

Frage
When defining a Contract whilst configuring the Service Broker, you can define the message types that each type of participant can send. Which of these are valid participant types?
Antworten
  • INITIATOR
  • TARGET
  • ANY
  • ORIGINATOR
  • RECIPIENT
  • ALL

Frage 178

Frage
When setting up the Service Broker within a database, a [blank_start]queue[blank_end] represents a physical table within the database which stores a message during the time period between it's receipt - and when it is processed.
Antworten
  • queue

Frage 179

Frage
Which of the following commands are permissible on a queue table within the Service Broker...
Antworten
  • SEND
  • RECEIVE
  • INSERT
  • UPDATE
  • DELETE
  • SELECT

Frage 180

Frage
When creating a queue within the Service Broker, you can instruct it to keep an audit log by leaving actioned messages in the queue table, by using the following command... CREATE QUEUE <Queue Name> WITH [blank_start]RETENTION[blank_end] = ON
Antworten
  • RETENTION

Frage 181

Frage
In production systems, it is not recommended to create Service Broker Queues using the retention option - true of false?
Antworten
  • True
  • False

Frage 182

Frage
When using the Service Broker within a database, a message that continually fails processing, causing a transactional roll back and being placed back in the queue for reprocessing is called a [blank_start]poison[blank_end] message. By default, a queue will become disabled if it detects one of these messages rolling back [blank_start]5[blank_end] consecutive times.
Antworten
  • poison
  • 5

Frage 183

Frage
The preferred method of handling repeatedly failing transactions in the Service Broker is to turn off [blank_start]POISON_MESSAGE[blank_end]_HANDLING in the queue, trap the condition and action it in your own application code then [blank_start]COMMIT[blank_end] the transaction to remove it from the queue. This prevents the queue from being automatically disabled when discovering repeatedly failing transactions.
Antworten
  • POISON_MESSAGE
  • COMMIT

Frage 184

Frage
When using the Service Broker, if you wanted to create a Queue called RegQueue, that triggers the activator stored procedure, dbo.ActivateRegistration, with 20 simultaneous queue readers - running under the queue owner context - you would use the following procedure... CREATE QUEUE RegQueue WITH [blank_start]ACTIVATION[blank_end] ( STATUS = [blank_start]ON[blank_end], PROCEDURE_NAME = [blank_start]dbo.ActivateRegistration[blank_end], MAX_QUEUE_READERS = [blank_start]20[blank_end], EXECUTE AS [blank_start]OWNER[blank_end] )
Antworten
  • ACTIVATION
  • ON
  • dbo.ActivateRegistration
  • 20
  • OWNER

Frage 185

Frage
Within the Service Broker, when you define a [blank_start]Service[blank_end], you give it a name, then, you tell it which [blank_start]queue[blank_end] it will use - and then you choose which [blank_start]contracts[blank_end] it will use (which defines the message types and participants).
Antworten
  • Service
  • queue
  • contracts

Frage 186

Frage
When using the Service Broker, messages exchanged within a conversation are sent between the abstraction layer - the [blank_start]service[blank_end].
Antworten
  • service

Frage 187

Frage
Within the Service Broker - a [blank_start]Route[blank_end] is defined to represent the network path that messages to a service will follow.
Antworten
  • Route

Frage 188

Frage
Within the Service Broker, a route can define a network path through multiple SQL Servers until the destination service is located. True or False?
Antworten
  • True
  • False

Frage 189

Frage
When defining a Route within the Service Broker, omitting the name of the service within the Route Definition will ensure the route applies to ALL Services on the server. True or False?
Antworten
  • True
  • False

Frage 190

Frage
When defining a route within the Service Broker, you must set the [blank_start]ADDRESS[blank_end] parameter to be [blank_start]local[blank_end] so it knows that the service it points to resides on the instance of SQL Server you are adding the route to.
Antworten
  • ADDRESS
  • local

Frage 191

Frage
Within the Service Broker, messages within a conversation can be prioritised so more important messages will be processed first. True or False?
Antworten
  • True
  • False

Frage 192

Frage
Within the Service Broker, a [blank_start]priority[blank_end] can be assigned to a [blank_start]Conversation[blank_end] in order to fast track communications to a service.
Antworten
  • priority
  • Conversation

Frage 193

Frage
When defining a priority in the Service Broker, you can specify a matching criteria that defines which conversations are prioritised. Which of the following criteria can be used to match to a conversation?
Antworten
  • Contract Name
  • Local Service Name
  • Remote Service Name
  • Route
  • Message Type
  • Queue

Frage 194

Frage
Within the Service Broker, a Conversation Group allows multiple conversations to be received in a single threaded operation, simplifying the programming involved in dealing with related messages in different conversations. True of False?
Antworten
  • True
  • False

Frage 195

Frage
When using the Service Broker service queues, what are the equivalent commands to the typical table commands used for database tables? INSERT: [blank_start]SEND[blank_end] SELECT: [blank_start]RECEIVE[blank_end]
Antworten
  • SEND
  • RECEIVE

Frage 196

Frage
When sending a message through the Service Broker, the [blank_start]SEND[blank_end] command can be used with multiple [blank_start]conversation[blank_end] ID's as parameters, in order to send the message to multiple services. This process is known as [blank_start]multicasting[blank_end].
Antworten
  • SEND
  • conversation
  • multicasting

Frage 197

Frage
Which of the following commands can be used to start a service broker conversation?
Antworten
  • BEGIN DIALOG CONVERSATION
  • BEGIN DIALOG
  • START CONVERSATION
  • BEGIN CONVERSATION
  • OPEN CONVERSATION
  • OPEN DIALOG

Frage 198

Frage
When beginning a conversation within the Service Broker, which of the following parameters are mandatory?
Antworten
  • FROM SERVICE
  • TO SERVICE
  • SOURCE SERVICE
  • DESTINATION SERVICE
  • ON CONTRACT
  • RELATED_CONVERSATION
  • LIFETIME
  • QUEUE

Frage 199

Frage
When using the SEND command to send a message through the Service Broker, it requires a 'dialog handle' parameter. How do you obtain the dialog handle?
Antworten
  • You create a new UNIQUEIDENTIFIER variable, initialise it, and pass it to the BEGIN DIALOG CONVERSATION command, before using it again in the SEND command.
  • You create a new UNIQUEIDENTIFIER variable, pass it to the BEGIN DIALOG CONVERSATION as an output parameter, before using it again in the SEND command.
  • You obtain it using the GETCURRENTCONVERSATION() function after a successful BEGIN DIALOG CONVERSATION command
  • You use the @@CURRENTCONVERSATION global variable after a successful BEGIN DIALOG CONVERSATION command
  • You create a new UNIQUEIDENTIFIER variable, initialise it, and pass it to the OPEN DIALOG CONVERSATION command, before using it again in the SEND command.
  • You create a new UNIQUEIDENTIFIER variable, pass it to the OPEN DIALOG CONVERSATION as an output parameter, before using it again in the SEND command.

Frage 200

Frage
When using SEND and RECEIVE within the Service Broker, it is highly advisable to use Transactions in all Queue operations.
Antworten
  • True
  • False
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

System Analysis
R A
SQL Server 2014 - Part 2
Paul Doman
CCNA Security 210-260 IINS - Exam 3
Mike M
Application of technology in learning
Jeff Wall
Innovative Uses of Technology
John Marttila
Ch1 - The nature of IT Projects
mauricio5509
The Internet
Gee_0599
CCNA Answers – CCNA Exam
Abdul Demir
SQL Quiz
R M
Professional, Legal, and Ethical Issues in Information Security
mfundo.falteni
Flash Cards Networks
JJ Pro Wrestler