PDF 1z0-931-25 Study Guide

Graph query languages, like Oracle’s Property Graph Query Language (PGQL), are designed for graph databases:

Correct Answer (D): “Ability to specify patterns” is a defining feature. Graph queries excel at defining and matching patterns (e.g., nodes and edges) to explore relationships, such as finding paths or subgraphs, critical for applications like social network analysis or fraud detection.

Incorrect Options:

A: Key-value queries are typical of NoSQL key-value stores, not graph databases.

B: While scripting may be possible in some contexts, it’s not a core feature of graph query languages.

When designing access controls for an Autonomous Dedicated environment, Oracle recommends redundancy and separation for security and manageability:

Correct Answer (D): “Create at least 2 of each resource” (subnets, compartments, user groups) is a best practice:

Subnets: Using at least two subnets (e.g., one public, one private) enhances security by segregating traffic and provides failover options if one subnet encounters issues.

Compartments: Multiple compartments allow logical separation (e.g., dev, test, prod), simplifying access control and resource management.

User Groups: At least two groups (e.g., admins, developers) streamline permission assignments and reduce the risk of over-privileging users.

Incorrect Options:

A: OCI allows multiple subnets and compartments; restricting to one limits flexibility and security.

B: There’s no such limitation; multiple resources are supported and encouraged.

Moving resources between compartments in OCI has specific rules:

Correct Answer (C): “Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments” is correct. For dedicated deployments, moving these resources leaves related items (e.g., backups, network configurations) in their original compartments unless explicitly moved.

Incorrect Options:

A: Backups move with the database instance in shared infrastructure, not dedicated.

B: Permissions are required for both source and target compartments.

Full Detailed In-Depth Explanation:

Bring Your Own License (BYOL) allows using existing on-premises Oracle licenses in the cloud:

A:False. Exadata is included in Autonomous Database; no separate license is needed.

B:False. Active Data Guard is an optional feature, not required for BYOL.

C:True. RAC is needed for BYOL when scaling beyond 16 OCPUs, as Autonomous Database uses RAC for high availability in larger deployments.

D:True. Multitenant is mandatory, as Autonomous Database uses a multitenant architecture (CDB/PDB).

E:False. TDE is included by default, not a BYOL requirement.