Question

1. When restoring a database from backup, any transactions that were in progress
while the backup was being performed are finished before the database restore is
initiated.
True
False

2. MyTag is a tag originally historized with an older version of Historian that used
the classic storage system. You upgrade Historian Server, and classic storage is
replaced by the new storage system. The Runtime database has historical data
for MyTag stored prior to the upgrade, so data now exists in both storage
methods. When retrieving data for a time window that goes across the time of
the upgrade, which of the following is TRUE?
The query will retrieve two sets of data
You can only retrieve data from one storage at a time
The retrieval subsystem will present data from both storages in a seamless manner
In the query, you must specify the AIHistory property value to get data from each
storage subsystem

3. An UPDATE query against the Historian Server (Runtime) database can only be
executed using OpenQuery syntax.
True
False

4. Which of the following retrieval modes use cycles?

Slope
Interpolated
Minimum
BestFit
ValueState
All of the Above

5. What is the smallest time resolution allowed by the Historian Server for data
storage of any kind?
1 millisecond
1000 milliseconds
 3.33 seconds
Whatever the I/O Server is capable of

6. The following time domain extension is used to return rows at evenly-spaced

time intervals across a specified time period:
wwVersion
wwEdgeDetection
wwTimeDeadband
wwResolution

7. What is the relationship between HCAL and HCAP?

IDAS sends data to HCAL and MDAS sends data to HCAP
HCAL receives data from HCAP
HCAP receives data from HCAL
MDAS sends data to HCAL and HCAP
There is no relationship between HCAL and HCAP

8. How many wwFilter modes can be applied in a single query?

Depends on the type of filter being applied
One
As many as necessary
One of each type of wwFilter

9. The statement wwEdgeDetection = 'Leading' in a query for an analog tag would

return:
The first value that meets the criteria
The last value that fails the criteria
The first value to fail the criteria
The first value to fail the criteria after a value meets the criteria

10. The Holding database:

Temporarily stores data imported from an InTouch node
Is a secondary storage after the Runtime database reaches the storage limit
Serves as permanent storage for data imported from an InTouch node
Is used to map imported InTouch data to its table structures and then move it to the
Runtime database
Stores data imported from an InTouch node until it reaches 2 GB
11. The wwFilter SnapTo filter is used to:
Force values within a defined range of a base value to return as the base value
Return values within a defined range as True and values outside that range as False
Apply multiple tolerance ranges to filter noise surrounding base values
Filter out values outside of a defined range

12. The phantom cycle is used to:

Find the last known value prior to the query start time
Calculate initial value to return at the query start time
Calculate aggregates
All of the above

13. In a SQL query, specifying wwQualityRule = 'Optimistic' means that

calculations that include some good values and some NULL values do not cause
the overall calculations to return NULL.
True
False

14. When storing values for a tag, data from a topic that is not enabled for late data
will be discarded if:
Data is delayed less than 30 seconds
Data is ahead less than 999 milliseconds
Data is delayed more than 30 seconds
Data is ahead more than 999 milliseconds

15. New data from which of the following sources is accepted by a classic storage
"redirector" service (aahStoreSvc.exe) and sent to the storage subsystem?
Wonderware Application Server 2012 (version 3.5) and later
Wonderware Application Server 2012 (version 3.5) and earlier
Applications that use the Wonderware Historian SDK version 9.0 and earlier
Remote IDAS that has not been upgraded to Historian 2014 R2

16. How many rows will the following query return?

SELECT DateTime, TagName, Value, Quality,
QualityDetail
FROM AnalogHistory
WHERE TagName = 'SysTimeSec'
AND DateTime >= '20020707 11:00:00'
AND DateTime <= '20020707 12:00:00'
 0 rows, the syntax is incorrect
100
1000
3601

17. It is possible to store alarm and event data in history blocks.

True
False

18. For counter retrieval, how do you specify a counter deadband?

Set the deadband in the properties for the tag
Specify the deadband with the wwCounterDeadband statement in a SQL query
Set the deadband with the CounterDeadband system parameter
It is not possible to set a counter deadband for counter retrieval

19. Which utility is available for migrating alarm and event data in the A2ALMDB
database to history blocks?
Migrating Alarm and Event to Block Storage utility
Historian Data Importer utility
Alarm DB Purge/Archive utility
None of the above

20. With counter retrieval, setting a counter deadband can help to:
Distinguish between counter rollovers
Filter out counter reversals
Distinguish between counter resets
It is not possible to set a counter deadband for counter retrieval

21. The WideHistory tables are ONLY accessible using:

A 4-part query
An OpenQuery
An OpenRowset
All of the above responses are valid methods of accessing the WideHistory tables

22. When backing up history blocks, you should always back up the current block
first.
True
 False

23. Any desktop client application can retrieve historical data if it is:
DH+ enabled
OPC Compliant
DDE/SuiteLink enabled
ODBC compatible

24. The name of the Historian Server OLE DB provider is:

MSDASQL
NODENAME
INSQL
SQLOLEDB

25. What is the name of the alarm database managed by Wonderware Historian?
WWALMDB
RuntimeAlmDB
A2ALMDB
Runtime

26. The following query syntax will show values for two separate value ranges for
the same analog tag:
SELECT DateTime, Value
FROM History
WHERE TagName = 'SysTimeMin'
AND Value < 10
OR Value > 50
True
False

27. The term versioned in the context of Historian Server data retrieval refers to data
that is:
Visible during retrieval either as Original or Latest
Inserted into the Runtime database tables after 1 minute
Older than the first history block
Collected outside of the Historian Server

28. HCAL synchronizes tags with Historian:

On each reconnection
 After a restart of the Historian Server
After each deployment
Before each deployment

29. Historian Server can run while a database backup operation is performed.
True
False

30. Which of the following is NOT a Historian Server service?

aahDrvSvc.exe
aahIOSvrSvc.exe
aahEventSvc.exe
aahMDASSvc.exe

31. When a loss of connection occurs, the Historian Server classic event system will
automatically recover when the Historian Server connection is restored.
True
False

32. An aaAdmin has privileges in the Runtime database to access all data and
objects:
And create read-only tables
And create and modify objects in all databases
But cannot modify data
But cannot drop the database or truncate tables

33. It is possible to run the Historian Data Importer in console mode from a
command prompt to process .csv files.
True
False

34. Which Historian Server data storage location is populated by xp_DiskCopy?

Buffer
Circular
Temporary
Permanent
35. When defining an event, which of the following SQL action syntax examples is
used to retrieve the data that occurred at the time of the detected event?
SELECT * FROM History WHERE DateTime = '@EventTime'
SELECT * FROM History WHERE DateTime = DateDiff(ss, @EventTime,
GetDate())
SELECT * FROM History WHERE DateTime = '@@EventTime'
SELECT * FROM History WHERE DateTime = GetDate()

36. The Reset Error Counts task will reset which of the following items on the
Status window of the System Management Console?
Critical errors
Errors
License errors
Value errors
Fatal errors
Warnings

37. The following real-time extension is useful in a SQL-based event detection

string for determining when satisfaction of event criteria has been met:
wwResolution
wwTimeZone
wwCycleCount
wwEdgeDetection

38. Which of the following is NOT a specified unit of measurement for defining a
schedule-type event detector?
Hour
Shift
Day
Week

39. The Historian Data Importer can be used to import history data from the
following types of files:
Excel spreadsheets
Comma Separated Value (.csv) files
InTouch history files (.lgh)
Text files (.txt)
40. The collection of files on the hard disk in which the Historian Server stores
analog, discrete, and string data collected from I/O sources is called:
The Active Image
A linked server
A history block
An extension table

41. When configuring Historian Server system tags, it is necessary to commit

changes.
True
False

42. Which separator characters are valid in a .csv file designed for importing data
into Historian Server?
Comma and tab
Comma and pipe character ( | )
Comma and star ( * )
Comma and space

43. The @StartTime and @EndTime variables are:

Placeholders for the detector component to coordinate event detection over a
moving time range
Variables that can be used in action strings and detector strings
Variables that cannot be used in detector strings
Variables that can be used in action strings

44. SQL Server Management Studio can be used to:

Create Historian Server wide tables
Manage database objects, backups, logins and permissions, and so on
Configure Historian Server event detections and actions
Store Historian Server process data

45. When importing InTouch tags to Historian, it is possible to specify a storage

method on a per-topic basis.
True
False

46. A discrete tag can be configured to be acquired and not stored.

True
 False

47. The ArchestrA System Management Console can manage several Historian
Servers simultaneously.
True
False

48. The variables @StartTime and @EndTime are used by:

Event detector actions only
Event detector and action strings
Event action strings
Event detector strings

49. The Historian Database Configuration Export/Import Utility is useful for

performing bulk changes to the Historian Server configuration.
True
False

50. MDAS is used to:

Accept data from a host application and forward it to the Historian Server
Dynamically change the IP address of the Historian Server
Enable remote data storage in case of a server failure
Define the Historian Server Manual History Tables

51. Within SQL Server Management Studio, InSQL is:

A second instance of Historian Server
The primary server instance
A linked server
An older version of Historian Server for backward compatibility

52. The variables @EventTime and @EventTagName are used by:

Event action strings only
Event detector actions
Event detector strings and actions only
Event detector strings only

53. After exporting the Historian Server configuration, it is possible to edit the
configuration file using Microsoft Excel.
 True
False

54. If you wish to invoke an event action when a particular detector condition
becomes False, which form of edge detection is best?
Trailing
Leading
Both
None

55. When importing InTouch tags to Historian, you can import from multiple
InTouch applications on each InTouch node.
True
False

56. Which of the following is NOT a valid event action type?

E-mail
Snapshot
Schedule
Summary

57. It is possible to specify ONLY discrete tags when performing a Historian Server
configuration export operation.
True
False

58. Alarm and event data stored in the A2ALMDB database can be retrieved with
the Open Data Protocol (OData).
True
False

59. In a redundant Historian configuration:

If the engine loses connection to one Historian, it will fail over the backup to
ensure data collection
A Historian Client automatically detects and selects the online Historian from the
redundant pair
Configuration on the redundant engines will decide how Historian partners work at
runtime
60. Which of the following is used to store Application Server data to Historian
Server?
IDAS
Message Exchange
SuiteLink
HCAL

61. In a redundant Historian configuration, both Historian partners must be able to

see each other over the network.
True
False

62. The Enable Tag Hierarchy option allows the:

Objects to be historized automatically for an engine
Model view hierarchy to be replicated to the public name space in Historian Server
and exposed in Historian Client
Containing object to enable historization for everything it contains
Usage of the model view hierarchy in the Historian section of the System
Management Console

63. Historian Server redundancy is configured at the engine level.

True
False

64. Custom replication schedules allow users to define their own schedules based
on:
Conditions
Fixed times of the day
The event system
Defined intervals
SQL queries
All of the above

65. To be able to accept data from the System Platform, the Historian Server node
must have a platform deployed to it.
True
False

66. Alarm and event data stored in history blocks can be retrieved with the Open
Data Protocol (OData).
 True
False

67. In an OData query, which resource can be specified to return a list of properties
in the system?
$metadata
Events
Null string
None of the above

68. To be able to accept data from the System Platform, the Historian Server node
must have the bootstrap component installed.
True
False

69. When a Galaxy attribute is configured for historization and a forced storage
period of 3 seconds is defined:
At least one value for the attribute will be historized every 3 seconds, even if the
value does not change
Only one value will be historized every 3 seconds for that attribute
All values for the attribute will be historized every 3 seconds

70. When an engine is configured for historization, and the Historian Server is
configured as a redundant pair:
The engine only needs to resolve the network address for one of the Historian
partners
The engine must be able to resolve the network address for both Historian partners
The engine must maintain connection to the primary Historian to avoid data loss

71. When an engine is configured for historization, and the Historian Server is
configured as a redundant pair:
The engine can send data to either Historian as they will synchronize periodically
The engine establishes connection to the first Historian that goes online and fails
over the partner when the connection to the primary is lost
The engine sends data to both Historian partners

72. A Tier-1 Historian is:

A Historian Server that accepts replicated data from one or more Historian Servers
An individual Historian Server that sends replicated data to a destination Historian
Server
 A remote Historian Server backing up the local Historian Server
A local Historian Server that is exclusively replicating summary data

73. In a redundant Historian configuration, the engine configured for historization

will stream data to both Historian partners and will create individual store-and-
forward locations for each.
True
False

74. If the connection to the Tier-2 Historian is lost, what will happen to the data for
that time period?
It is lost
It is updated on the Tier-2 Historian using queued replication
It must be manually updated
It is updated on the Tier-2 Historian using a store-forward process

75. The default replication schedules are:

1 minute, 5 minutes, 15 minutes, 30 minutes, 1 hour, 1 day
5 minutes, 15 minutes, 30 minutes, 1 hour, 1 day
1 minute, 5 minutes, 15 minutes, 30 minutes, 1 hour
1 minute, 5 minutes, 10 minutes, 15 minutes, 30 minutes, 1 hour, 1 day

76. Local replication can refer to:

Summary data replication without a Tier-2 Historian
One-to-one (1:1) replication of data to a Tier-2 Historian
Two Historian Servers acting as Tier-2 Historians to each other
Replication between a Tier-1 and Tier-2 Historian on the same network

77. When configuring redundant Historians, they must belong to the same network
subnet.
True
False

78. In Application Server, which of the following objects have the option to enable
storage to Historian?
RedundantDIObject
AppEngine
WinPlatform
 Area
User defined object

79. In a redundant Historian Server configuration:

After rebooting the partners, they synchronize history blocks
CSV updates and inserts must be repeated in both partners
CSV updates and inserts can be done in either Historian partner as they will
synchronize after the next reboot

80. Members of which Windows security groups can run OData queries to retrieve
event data from Historian?
aaOperators
Any Windows user can retrieve events
aaPowerUsers
aaUsers
aaAdministrators

81. Simple replication refers to:

Duplicating only selected analog tag values to a Tier-2 Historian

Replicating tag values to a secondary database on the local Historian Server
Replicating all values for all tags to a Tier-2 Historian
Replicating all values for the selected Tier-1 tag(s) to the Tier-2 Historian

82. A Historian Server can simultaneously act as a Tier-1 Historian replicating data
to other Historians, and a Tier-2 Historian collecting replicated data from other
Tier-1 Historians.
True
False

83. What is the smallest storage rate allowed by the Historian Server for cyclically-
stored analog values?
1 millisecond
10 milliseconds
1000 milliseconds
3.3 seconds

84. With the following query, results in the wwResolution column will show:
SELECT Datetime, Tagname, Value, wwResolution
FROM History
WHERE Tagname = 'M100.LT.PV'
AND wwRetrievalMode = 'cyclic'
AND Datetime > Dateadd(mi, -10, Getdate())
AND Datetime <= Getdate()
AND wwCycleCount = 10
Time between value changes
The cycle duration
Sampling interval

85. Setting wwCycleCount to 5 (wwCycleCount = 5) in Delta retrieval mode will:

Return 5 evenly-spaced rows across a specified time period
Not work in Delta retrieval
Return the LAST five value changes of the tag
Return the FIRST five value changes of the tag

86. Analyze the following SQL detection query. Which of the following statements
correctly describes the query?

SELECT DateTime FROM History

WHERE Tagname = 'ReactorLevel'
AND Value > 75
AND DateTime > @StartTime
AND DateTime < @EndTime

The query will not function because of the date comparisons; the operators must be
limited on at least one side with <= or >=
The query will function as written
The query will not function since there is no DateTime column in the History table
The query will not function because event system variables must be enclosed in
single quotes

87. What is the size limit on a .csv file designed for import into the Historian
Server?
16 MB
2 GB
100,000 values or 1,024 tags
No size limit

88. Which tool can be used to select an InTouch tagname database and import
information from an InTouch application into the Historian Runtime database?
 Tag Importer Wizard
Historian Data Importer
Database Export/Import Utility
None of the above

89. To configure Historian redundancy, you have to:

Set the redundancy registry values in both Historian partners
Check the Historian Redundancy option in both engines
Deploy a platform on each Historian configuring the Redundancy attribute
Configure the HistorianPartner system parameter on each Historian Server

90. What is the default Trend High for PV in an object derived from the
$AnalogDevice template?
10
100
1000
None

91. Data that is modified on a Tier-1 Historian using an insert or update is:
Updated on the Tier-2 Historian by queued replication
Modified on the Tier-2 Historian in parallel with the Tier-1 Historian
Not updated on the Tier-2 Historian
Updated on the Tier-2 Historian by store-forward

92. The wwFilter SigmaLimit filter removes outliers from a set of analog points
based on the assumption that:
The distribution of point values in the set is of a normal distribution
The set of point values follows a pattern, so that non-normal points can be filtered
A tag has a defined sigma limit
The data points follow the rules of statistical data sampling

93. Setting wwCycleCount to 0 (wwCycleCount = 0) in Cyclic retrieval mode will:

Return one row
Return 100000 rows
Return all rows with duplicates
Return all rows
94. After a normal stop of Wonderware Historian Server, which of the following
services continue to run?
Configuration Manager
OLE DB provider
Replication
Event system
Retrieval service

95. When using the wwFilter SigmaLimit filter, if you do not provide a sigma limit
for the filter, what is the default?
1
2
3
A sigma limit must always be applied

96. When restoring a database from backup, any information saved to the database
since the backup was performed is overwritten with the restored information
unless the Append option is selected.
True
False

97. If an object is undeployed and deleted from the Galaxy, the historized attributes
for that object are automatically deleted from the Historian Server database.
True
False

98. Replicated tags on a Tier-2 Historian can be further replicated to a

third Historian Server.
True
False

99. The Historian Server classic event system was designed to respond immediately
to real-time alarms.
True
False

100. Historical data is stored in _____; configuration data and classic event
history are stored in _____.
History blocks, Runtime database
 Custom SQL Server database, OLE database
Runtime database, Runtime database
History blocks, History blocks
Runtime database, History blocks

101. Historical data collected by the classic storage system with previous
releases of Historian:
Remains fully accessible in a seamless manner
Cannot be accessed
Must be manually inserted into storage before it can be accessed
None of the above

102. New history blocks are created:

If the data file becomes larger than 3.0 GB
If the data file becomes larger than 1.5 GB
Based on the time duration specified by the HoursPerBlock system parameter
When manually created using the Start New History block option from the SMC

103. Which mechanism is used for determining when the set of event criteria
for an event tag has been satisfied?
Time Deadband
EventTag
Action
Detector

104. The attribute Valve.PV is configured for historization in the Galaxy and
the changes are deployed. However, if Historian Server is temporarily
disconnected from the network:
Valve.PV values will not be historized until the Historian Server is back online
Valve.PV values will start getting historized only when the Historian Server is
back online
Valve.PV values will immediately go to store-and-forward and the Historian
Server will be updated when it gets back online
When the Historian Server is back online, the valve object will require
redeployment to start the historization

105. The AnalogSummaryHistory table will only return values for tags being
used for summary data replication.
True
 False

106. With redundant Historian partners, which of the following is TRUE?

If you add data using SQL on one historian, the data is automatically added to the
partner historian
If you make configuration changes for one historian, you should perform the same
action on the partner
The initial historian configuration is automatically synchronized between the
partners
If you perform a CSV import on one of the historians, the data is automatically
imported to the partner historian

107. An IDAS applies storage rules before the data is stored locally only when
it is disconnected from the Historian Server and is operating in store-and-
forward mode.
True
False

108. Committing changes is defined as:

Dynamically changing tag storage properties
Stopping and restarting the Historian Server
Stopping and restarting the Configuration Editor
An operation to make the Historian Server act on changes in the Runtime database

109. Before you can import .lgh original data into Historian, which system
parameter needs to be set to 1?
DataImportPath
RealTimeWindow
AllowOriginals
OriginalDataEnabled

110. Which of the following is NOT a Historian Server system module?

Classic Event system
System driver
TSQL
Data acquisition

111. When using Delta retrieval mode, if wwResolution and wwCycleCount

are both set in the query, then:
wwResolution is ignored
 wwCycleCount is ignored
The biggest value takes precedence
The query defaults to retrieve 100 rows

112. Which Historian Server ActiveX control is available for external events?
ActiveReport
ActiveQuery
ActiveTrend
ActiveEvent

113. The default retrieval mode for the History table is Delta.
True
False

114. When configuring IDAS for store-and-forward:

Primary and alternate I/O Servers can be configured
Redundant IDASs can be used
The IDAS must reside on the Historian Server node
IDAS can also be configured for failover

115. Configuration of client connection parameters can be done using:

Microsoft SQL Server Client Network Utility
ArchestrA System Management Console
Microsoft SQL Enterprise Manager
Historian Control

116. Which of the following statements is NOT TRUE about the TagID
property of a tag?
A unique TagID can identify one or more tag metadata instances
It allows you to have several versions of the same tag
It is defined as a 16-byte GUID
One new TagID is created for an existing tag every time you change its storage
mode
During a Historian configuration import, if left empty, a new TagID is generated

117. When importing InTouch tags to Historian, which of the following are
TRUE for tag uniqueness strings?
When configuring the import process, a uniqueness string must be specified
 A uniqueness string can be added to the beginning of a tag name or to the end of a
tag name
Uniqueness strings can be added to all tag names imported from an InTouch node
or only to duplicates
Up to 15 characters can be used in a uniqueness string
Uniqueness strings provide a way for the Tag Importer to handle duplicate tag
names

118. For a discrete tag being summarized locally every 15 minutes, the default
tagname is:
15M.TAGNAME
TAGNAME.15m
TAGNAME.S15M
S15M.TAGNAME

119. The configuration of a Tier-2 Historian requires which kind of license?

Consignment
Historian Server Advanced
Historian Server Enterprise
Development Studio

120. Which of the following attributes for Galaxy historized tags can be
dynamically changed, pushing their new values immediately to Historian?
EngUnits
TrendLo
Desc
TrendHi

121. By default, a historized Galaxy attribute is configured with Application

Server as the current editor. If you modify this tag using the Historian Server
Configuration Editor:
The current editor is changed to Historian
There will be two current editors enabled: Historian and Application Server
The next time you redeploy the engine, the current editor is changed back to
Application Server
The current editor is changed to InTouch

122. When configuring a redundant Historian:

The Tier-2 Historian will append a suffix to each tag to identify the source
Historian partner
 You must use independent Tier-2 Historians for each Tier-1 Historian partner
Both Tier-1 Historians must use the same Tier-2 Historian
You cannot configure Tier-2 replication

123. The Force Storage Period value for an object:

Determines the rate that the tag will store its value, only if the tag changes
Is overridden by the update frequency of the tag's data source
Is overridden by the scan period of the host if it is less than the scan period of the
host
Determines the rate that the tag will store its value, regardless of the tag value
changing

124. One place where you can determine whether the total number of tags in
the database exceeds the number of licensed tags in the database is:
In the Status pane of the ArchestrA System Management Console
In the context menu of the Configuration Editor in the ArchestrA System
Management Console
In the SQL Query Analyzer by executing SELECT @@Version
From the wwClient utility

125. Which tags are included in the total tag count enforcement?
MDAS
String
System
Analog
Discrete
All of the above

126. Redundant Historian partners:

Must be located in the same physical location
Must be able to ping each other
Must be connected to the same network subnet
All of the above
None of the above