Which of the following is NOT a PowerShell comparison operator type?
Matching
Containment
Replacement
Assignment
EXPLANATION
Comparison operators are used in PowerShell to compare
values. There are four types of operators: equality, matching,
containment, and replacement. The one big gotcha in PowerShell has to do
with syntax: rather than using traditional comparison operators like
< or > PowerShell uses -lt or -gt to perform comparisons.
Two organizations are partnering and sharing systems. Which of the following would outline how the shared systems interface?
BPA
SLA
ISA
ROA
EXPLANATION
An interconnection security agreement (ISA) documents the
technical requirements of a connection between organizations,
such as
the basic components, methods and levels of interconnectivity, and
potential security risks.
You need to encrypt and compress your backups
before replicating them off site. Which is best practice, compress
then encrypt, or encrypt then compress?
Neither!
Encrypt first!
Doesn't matter!
Compress first!
EXPLANATION
If you encrypt the data first, it will be randomized and
unintelligible by your compression application which need to compress
the data in a logical format.
For every unique constraint on a column, SQL server will create which of the following?
An entry for that column
A non-clustered index for that column
A clustered index for that column
A filtered index
EXPLANATION
For every unique constraint on a column, SQL server creates a
non-clustered index. A non-clustered index has a structure separate
from the data rows. It contains non-clustered index key values and each
key value entry has a pointer to the data row that contains the key
value.