Free Oracle 1Z0-920 Exam Actual Questions

The questions for 1Z0-920 were last updated On Nov 19, 2024

Question No. 1

MySQL Enterprise Masking and De-identification can hide or obfuscate sensitive data, by controlling how the data appears. Which three are MySQL Enterprise Masking and De-identification functions?

Show Answer Hide Answer
Correct Answer: B, C, E

Robust Data Masking Functions

MySQL Enterprise Masking and De-identification can hide or obfuscate sensitive data, by controlling how the data appears. It features robust masking algorithms including selective masking, blurring, random data substitution and other special techniques for credit card numbers, account numbers and other personally identifiable information, enabling IT departments to maintain structural rules to de-identify values. MySQL Enterprise Masking and De-identification functions include:

* Selective Masking - Obscures a particular portion of numbers or strings such as phone numbers, and payment card numbers.

* Strict or Relaxed Masking - Implement strict or relaxed masking to obfuscate data.

* Random Data Substitution - Replace real values with random values while maintaining format consistency.

* Blurring - Add a random variance to existing values such as randomized numeric ranges for salaries.

* Dictionary Substitution - Randomly replace values from task specific dictionaries.

* Blacklisting and Substitution - Replace specifically blacklisted data, but leave non-blacklisted in place.

https://www.mysql.com/products/enterprise/masking.html#:~:text=Robust%20Data%20Masking%20Functions,controlling%20how%20the%20data%20appears.&text=Random%20Data%20Substitution%20%2D%20Replace%20real,values%20while%20maintaining%20format%20consistency.


Question No. 2

You are testing a new application and want to use data masking but the database is empty. What option will generate dummy data for you to use for testing?

Show Answer Hide Answer
Correct Answer: B

Question No. 3

Which three are characteristics of the JSON data type?

Show Answer Hide Answer
Correct Answer: B, C, E

Question No. 4

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH)

For accessing a new MySQL Enterprise Edition on an Oracle Cloud Infrastructure (OCI) Instance you " Add SSH key " information during the OCI instance setup. You want to use Putty from your Windows Client to install MySQL.

What are the correct steps to accomplish this?

Show Answer Hide Answer
Correct Answer: A

Question No. 5

The slave connects to the master and asks for updated records. What command was issued for this to happen?

Show Answer Hide Answer
Correct Answer: B