1Z0-931-21 Online Practice Questions and Answers

Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.

Which statement is FALSE?

A. Oracle Data Safe only supports Autonomous Databases.

B. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.

C. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.

D. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.

You are requested to analyze a year's stock purchase data which is stored in Autonomous Data Warehouse instance.

Which tool would you use to automate data exploration and create pivot tables?

A. Business Models

B. Data Load

C. SQL Developer Web

D. APEX

While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure(OCI) console, which patch type is offered to be applied during maintenance?

A. Release Update (RU)

B. Prior Release Update Revision (PRUR)

C. Prior Release Update (PRU)

D. Quarterly Bundle Patch (QBP)

Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?

A. Current settings for ACLs are cloned.

B. Clone can be in a different region.

C. All OML notebooks are cloned.

D. All underlying data for OML notebooks is cloned.

E. All resource management rules are cloned.

Which native data type is used to store spatial information?

A. SDO_RELATE

B. SDO_GEOMETRY

C. SDO_LOCATION

D. GEO_JSON

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

A. It cannot be done.

B. Using Database Configuration Assistant (DBCA) on the database server.

C. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

D. Connecting to the Cloud Infrastructure Command console via SSH wallet.

A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run onthe OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well.

Which Oracle Cloud Infrastructure database service is appropriate for this scenario?

A. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.

B. ADW since operational reporting is a higher priority in this scenario.

C. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.

D. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.

For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

A. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = `DW'

B. Allow group ADB-Admins to manage autonomous-database in tenancy.

C. Allow group ADB-Admins to manage autonomous-database-family in tenancy.

D. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'

Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?

A. The Autonomous Database must be in the same VCN and Subnet as the Compute instance.

B. The OCI compute instance does not support connecting to a Shared Autonomous Database.

C. The Autonomous Database must belong to a Network Security Group (NSG).

D. The OCI compute instance can be used with an Always-Free Autonomous Database account.

E. A Private Endpoint is required to connect to the Shared-Autonomous Database.

A BusinessAnalyst joined in your organization and wanted to explore the database tools. Which statement provides access to data tools page for business analyst.

When restoring/cloning the ADB, you must select a backup which is atleast___hours/minutes old.

A. 24hrs

B. 2 hrs

C. 5 min

D. 1 day