nerdexam
Microsoft

98-372 · Question #20

98-372 Question #20: Real Exam Question with Answer & Explanation

The correct answer is D. Transparent Data Encryption. Transparent Data Encryption (often abbreviated to TDE) is a technology employed by both Microsoft and Oracle to encrypt database content. It offers encryption at a column, table, and tablespace level. TDE solves the problem of protecting data at rest, encrypting databases both on

Question

Which is a technology employed by both Microsoft and Oracle to encrypt database content and offers encryption at a column, table, and tablespace level?

Options

  • AGlobally Unique Identifier
  • BOne-way encryption
  • CEncryption key
  • DTransparent Data Encryption

Explanation

Transparent Data Encryption (often abbreviated to TDE) is a technology employed by both Microsoft and Oracle to encrypt database content. It offers encryption at a column, table, and tablespace level. TDE solves the problem of protecting data at rest, encrypting databases both on the hard drive and consequently on backup media. Enterprises typically employ TDE to solve compliance issues such as PCI DSS. Microsoft offers TDE as part of its Microsoft SQL Server 2008. Oracle requires the Advanced Security Option for Oracle 10g and 11g to enable TDE. Keys for TDE can be stored in a Hardware Security Module to manage keys across servers, protect keys with hardware, and introduce a separation of duties. Answer: C is incorrect. In cryptography, a key is a piece of information (a parameter) that determines the functional output of a cryptographic algorithm or cipher. Without a key, the algorithm would have no result. In encryption, a key specifies the particular transformation of plaintext into ciphertext, or vice versa during decryption. Keys are also used in other cryptographic algorithms, such as digital signature schemes and message authentication codes. Answer: B is incorrect. One-way encryption is also known as hash function. It is used to determine whether the data has changed. The message gets converted into a numerical value. The recipient then verifies the hash value using a known algorithm. This method checks the integrity of messages but it does not provide confidentiality. Answer: A is incorrect. A Globally Unique Identifier (GUID) is a special type of identifier used in software applications to provide a reference number, which is unique in any context. While each generated GUID is not guaranteed to be unique, the total number of unique keys (2128 or 3.4 1038) is so large that the probability of the same number being generated twice is extremely The term GUID usually refers to Microsoft's implementation of the Universally Unique Identifier (UUID) standard. However, the term is common in applications not written by Microsoft, or for their operating systems. The GUID is also the basis of the GUID Partition Table, Intel's replacement for Master Boot Records under EFI, and of Preboot Execution Environment, Intel's environment to boot computers using a network interface. GUIDs are most commonly written in text as a sequence of hexadecimal digits such as:

Community Discussion

No community discussion yet for this question.

Full 98-372 Practice