I85PREP
⌘ K
Oracle Data Platform Foundations Associate study materials
Oracle Data Platform Foundations Associate study resources

Oracle Data Platform Foundations Associate practice questions

One question at a time. Build your Oracle Data Platform Foundations Associate understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Oracle Data Platform Foundations

An enterprise wants a single, self-driving cloud data platform that automatically provisions, tunes, scales, and patches its own infrastructure while running Autonomous Database workloads. Which Oracle offering matches this requirement?

  1. Oracle Database Free edition running in a local container
  2. Oracle MySQL HeatWave running on a laptop
  3. Oracle Exadata Database Machine deployed on-premises
  4. Oracle Autonomous Database on shared Exadata infrastructure Correct answer.

Explanation

Autonomous Database is the self-driving, self-securing, self-repairing cloud service that automates provisioning, tuning, scaling, and patching on Oracle-managed Exadata infrastructure. The other choices are either customer-managed hardware or non-Oracle engines that lack this automation.

Question 2Oracle Data Platform Foundations

A team must run analytical queries against operational data in Oracle Database without first copying that data into a separate warehouse. Which Oracle capability is designed for this?

  1. Oracle Recovery Manager incremental backups
  2. Oracle Database In-Memory with real-time analytics on transactional tables Correct answer.
  3. Oracle Connection Manager
  4. Oracle Data Guard physical standby

Explanation

Oracle Database In-Memory keeps a columnar in-memory representation alongside the row store, letting analytic queries run directly against live transactional data without extraction. Backup, standby, and connection-routing features do not provide analytical acceleration.

Question 3Oracle Data Platform Foundations

Which Oracle Cloud Infrastructure service is the managed, autonomous data warehouse used for large-scale analytics workloads?

  1. Oracle Cloud Infrastructure Functions
  2. Oracle Cloud Infrastructure Load Balancer
  3. Oracle Autonomous Data Warehouse Correct answer.
  4. Oracle Cloud Infrastructure Object Storage

Explanation

Autonomous Data Warehouse is the preconfigured autonomous service optimized for analytic and data-warehouse workloads. Object Storage, Functions, and Load Balancer are infrastructure services that do not provide a data warehouse engine.

Question 4Oracle Data Platform Foundations

A data engineer needs a fully managed Apache Spark and Hadoop service on OCI for batch processing jobs. Which service should be selected?

  1. Oracle Cloud Infrastructure Vault
  2. Oracle Autonomous Transaction Processing
  3. Oracle Cloud Infrastructure Data Catalog
  4. Oracle Cloud Infrastructure Data Flow Correct answer.

Explanation

OCI Data Flow is the managed service that runs Apache Spark applications without requiring the customer to operate clusters. Data Catalog is metadata management, ATP is a transactional database, and Vault manages secrets and keys.

Question 5Oracle Data Platform Foundations

Which Oracle Cloud Infrastructure service provides a governed, searchable inventory of metadata about data assets across the platform?

  1. Oracle Cloud Infrastructure Streaming
  2. Oracle Cloud Infrastructure Bastion
  3. Oracle Cloud Infrastructure Data Catalog Correct answer.
  4. Oracle Cloud Infrastructure File Storage

Explanation

Data Catalog harvests technical, business, and operational metadata so users can discover and govern data assets. Streaming ingests event streams, Bastion provides restricted SSH access, and File Storage offers a shared file system.

Question 6Oracle Data Platform Foundations

An organization wants to capture continuous clickstream events and process them in real time before landing them in a data warehouse. Which OCI service is purpose-built for this ingestion pattern?

  1. Oracle Cloud Infrastructure Streaming Correct answer.
  2. Oracle Cloud Infrastructure Monitoring
  3. Oracle Cloud Infrastructure DNS
  4. Oracle Cloud Infrastructure Block Volume

Explanation

OCI Streaming is a durable, scalable publish-subscribe service for ingesting continuous event streams that consumers process in real time. Block Volume, DNS, and Monitoring are infrastructure services unrelated to event ingestion.

Question 7Oracle Data Platform Foundations

A data platform team must move large volumes of data between on-premises Oracle databases and OCI Object Storage with minimal manual scripting. Which Oracle Cloud Infrastructure service is designed for this?

  1. Oracle Cloud Infrastructure Data Integration Correct answer.
  2. Oracle Cloud Infrastructure WAF
  3. Oracle Cloud Infrastructure Notifications
  4. Oracle Cloud Infrastructure API Gateway

Explanation

OCI Data Integration provides managed extract, transform, and load capabilities including connectors for databases and object stores. API Gateway, WAF, and Notifications are application and messaging services without ETL functionality.

Question 8Oracle Data Platform Foundations

Which statement correctly describes the relationship between a compartment and resources in Oracle Cloud Infrastructure?

  1. Compartments are network subnets that segment IP address ranges
  2. Compartments are logical containers that group related resources for access control and cost tracking Correct answer.
  3. Compartments are physical data centers that host Exadata hardware
  4. Compartments are database schemas that store application tables

Explanation

Compartments are logical groupings used to organize cloud resources, apply IAM policies, and separate costs. They are not physical facilities, database schemas, or network subnets.

Question 9Oracle Data Platform Foundations

A business wants to run Oracle Database 19c in the cloud but retain full control over patching schedules, operating system access, and database configuration. Which deployment option best fits?

  1. Oracle Base Database Service on a VM cluster with customer-managed administration Correct answer.
  2. Oracle Autonomous Data Warehouse with auto-scaling enabled
  3. Oracle MySQL HeatWave with managed patching
  4. Oracle Autonomous Database with automatic patching enabled

Explanation

Base Database Service provides Oracle-managed infrastructure while leaving database and OS administration, including patch timing and configuration, to the customer. Autonomous services automate patching and tuning, reducing that control.

Question 10Oracle Data Platform Foundations

An analytics team needs to query data stored in OCI Object Storage using SQL without loading it into a database first. Which Oracle capability best supports this?

  1. Oracle Data Guard fast-start failover
  2. Oracle Real Application Clusters node affinity
  3. External tables in Oracle Database pointing to Object Storage files Correct answer.
  4. Oracle Recovery Manager duplicate database

Explanation

External tables let Oracle Database read data directly from files in Object Storage and expose it to SQL queries without a load step. Data Guard, RMAN duplication, and RAC affinity address availability and clustering, not external data access.

Question 11Oracle Data Platform Foundations

A company wants near-zero data loss and fast failover for a mission-critical Oracle Database deployment. Which Oracle feature directly addresses this?

  1. Oracle Database In-Memory column store
  2. Oracle SQL Tuning Advisor
  3. Oracle Multitenant pluggable databases
  4. Oracle Data Guard with synchronous redo transport and fast-start failover Correct answer.

Explanation

Data Guard with synchronous redo transport keeps the standby current before commit acknowledgment, and fast-start failover automates role transition. In-Memory, SQL Tuning Advisor, and Multitenant improve performance or consolidation but not disaster protection.

Question 12Oracle Data Platform Foundations

A data warehouse team is consolidating many small departmental databases onto a single Oracle Database instance while keeping each isolated. Which feature is most appropriate?

  1. Oracle Flashback Drop
  2. Oracle Advanced Queuing
  3. Oracle Multitenant with pluggable databases Correct answer.
  4. Oracle Exadata Smart Scan

Explanation

Multitenant architecture places many pluggable databases inside one container database, giving isolation with shared administration. Smart Scan, Advanced Queuing, and Flashback Drop address performance, messaging, and recovery respectively.

Question 13Oracle Data Platform Foundations

A team needs to automatically discover sensitive data such as credit card numbers across Oracle Database tables and classify it. Which Oracle capability is intended for this?

  1. Oracle Data Safe sensitive data discovery Correct answer.
  2. Oracle Data Pump export
  3. Oracle Automatic Workload Repository reports
  4. Oracle SQL Plan Baseline

Explanation

Data Safe includes sensitive data discovery that scans database contents, identifies sensitive columns, and supports classification and masking. Data Pump, AWR, and plan baselines serve data movement, performance diagnostics, and plan stability.

Question 14Oracle Data Platform Foundations

An organization wants to enforce row-level access so that each regional manager sees only their own region's records in a shared table. Which Oracle feature is designed for this?

  1. Oracle Unified Auditing
  2. Oracle Transparent Data Encryption
  3. Oracle Database Vault realm
  4. Oracle Virtual Private Database with row-level security policies Correct answer.

Explanation

Virtual Private Database attaches security policies that append predicates to queries, restricting rows by user context. Database Vault controls privileged access, TDE encrypts data at rest, and Unified Auditing records activity.

Question 15Oracle Data Platform Foundations

A data scientist needs a managed notebook environment on OCI to explore data and build machine learning models. Which service should be used?

  1. Oracle Cloud Infrastructure Streaming
  2. Oracle Cloud Infrastructure Object Storage
  3. Oracle Cloud Infrastructure Data Science Correct answer.
  4. Oracle Cloud Infrastructure Data Flow

Explanation

OCI Data Science provides managed notebooks, model training, and model deployment for machine learning teams. Data Flow runs Spark jobs, Streaming ingests events, and Object Storage holds files.

Question 16Oracle Data Platform Foundations

A company needs to build a graph of relationships between customers, accounts, and transactions and run path queries across them. Which Oracle Database capability is designed for this?

  1. Oracle Database Advanced Queuing
  2. Oracle Database Flashback Query
  3. Oracle Database Resource Manager
  4. Oracle Database property graph with SQL graph queries Correct answer.

Explanation

Oracle Database property graphs store vertices and edges and support graph pattern queries using SQL. Advanced Queuing handles messaging, Resource Manager allocates resources, and Flashback Query reads past data states.

Question 17Oracle Data Platform Foundations

A team must load JSON documents into Oracle Database and query individual fields efficiently while preserving document structure. Which feature is most appropriate?

  1. Oracle Database XML DB with binary XML storage
  2. Oracle Database partitioned tables with hash partitioning
  3. Oracle Database LOBs with BasicFile storage
  4. Oracle Database JSON with JSON data type and SQL/JSON functions Correct answer.

Explanation

The native JSON data type combined with SQL/JSON functions lets Oracle Database store documents and query fields with indexing support. XML DB targets XML, BasicFile LOBs store unstructured content, and partitioning is orthogonal to document querying.

Question 18Oracle Data Platform Foundations

An administrator wants to automate the creation of a copy of a production pluggable database for testing with minimal impact on the source. Which capability supports this?

  1. Oracle Multitenant pluggable database clone with snapshot copy Correct answer.
  2. Oracle Flashback Database to a restore point
  3. Oracle Data Pump full export and import
  4. Oracle GoldenGate bidirectional replication

Explanation

Pluggable database cloning, including snapshot copy clones, creates a test copy quickly while sharing storage until changes occur. Data Pump is slower, GoldenGate is for replication, and Flashback Database rewinds the source rather than creating a separate copy.

Question 19Oracle Data Platform Foundations

A data platform must ingest files from Object Storage, transform them, and load them into Autonomous Data Warehouse on a schedule. Which OCI service provides managed ETL with scheduling?

  1. Oracle Cloud Infrastructure Monitoring with alarm schedules
  2. Oracle Cloud Infrastructure Data Integration with pipeline tasks and schedules Correct answer.
  3. Oracle Cloud Infrastructure Bastion with session schedules
  4. Oracle Cloud Infrastructure Vault with rotation schedules

Explanation

OCI Data Integration models source-to-target data flows and runs them on schedules as managed pipelines. Vault, Monitoring, and Bastion provide security, observability, and access control rather than ETL execution.

Question 20Oracle Data Platform Foundations

A reporting workload on Autonomous Data Warehouse must scale compute up during business hours and down at night without affecting storage. Which action accomplishes this?

  1. Change the number of ECPU or OCPU compute resources while leaving storage unchanged Correct answer.
  2. Move the database to a different compartment
  3. Restart the database with a larger SGA parameter
  4. Resize the Object Storage bucket used by the warehouse

Explanation

Autonomous Data Warehouse separates compute from storage, so adjusting ECPU or OCPU count scales compute independently while data remains in place. Bucket resizing, SGA restarts, and compartment moves do not scale warehouse compute.

Question 21Oracle Data Platform Foundations

A security architect must ensure that database encryption keys are stored in a hardware security module managed by OCI and rotated on a defined schedule. Which service combination satisfies this?

  1. Oracle Cloud Infrastructure Identity and Access Management with dynamic groups
  2. Oracle Cloud Infrastructure Object Storage with bucket versioning
  3. Oracle Cloud Infrastructure Audit with log retention
  4. Oracle Cloud Infrastructure Vault with a managed HSM key and rotation schedule Correct answer.

Explanation

OCI Vault provides managed HSM-backed master encryption keys and supports scheduled rotation, which database services can use for TDE. Object Storage versioning, IAM dynamic groups, and Audit logs do not provide HSM key management.

Question 22Oracle Data Platform Foundations

A data platform team observes that an Autonomous Data Warehouse query is slow and wants to understand which SQL statement consumed the most database time. Which approach is most direct?

  1. Query the Object Storage bucket inventory
  2. Review the Load Balancer access log
  3. Inspect Vault secret version history
  4. Review Automatic Workload Repository SQL monitoring and performance hub reports Correct answer.

Explanation

AWR and Performance Hub reports rank SQL statements by elapsed time and resource consumption, making the top consumer visible. Storage inventories, secret histories, and load balancer logs do not contain database SQL performance data.

Question 23Oracle Data Platform Foundations

A company must keep data within a specific country for regulatory reasons and also achieve low-latency access for users in that country. Which OCI design decision primarily addresses both requirements?

  1. Enable cross-region replication to a distant region
  2. Store data in a bucket in the home region only
  3. Use a public load balancer with global anycast
  4. Deploy the data platform in a region located in that country Correct answer.

Explanation

Data residency is determined by the region where data is stored, and placing the platform in-country also reduces network latency for local users. Cross-region replication moves data abroad, global anycast does not change storage location, and the home region may not be in the required country.

Question 24Oracle Data Platform Foundations

An architect must choose between Autonomous Transaction Processing and Autonomous Data Warehouse for a mixed workload that is mostly short OLTP transactions with occasional reporting. Which choice is best justified?

  1. Autonomous Data Warehouse, because it is optimized for high-concurrency transactional workloads
  2. Autonomous Data Warehouse, because it disables all reporting queries
  3. Autonomous Transaction Processing, because it cannot run analytic queries at all
  4. Autonomous Transaction Processing, because it is optimized for high-concurrency transactional workloads Correct answer.

Explanation

Autonomous Transaction Processing is tuned for OLTP concurrency and can still serve reporting, whereas Autonomous Data Warehouse is tuned for analytic scans and columnar access. The descriptions claiming ATP cannot run analytics or that ADW handles OLTP concurrency are inaccurate.

Question 25Oracle Data Platform Foundations

A team wants to minimize egress cost and latency when repeatedly querying a large curated dataset stored in Object Storage from Autonomous Data Warehouse. Which design is most effective?

  1. Replicate the dataset to a bucket in another region
  2. Load the curated dataset into ADW tables and query it there Correct answer.
  3. Query the Object Storage files directly on every dashboard refresh
  4. Copy the dataset to a Block Volume attached to a compute instance

Explanation

Persisting curated data in ADW tables avoids repeated reads from Object Storage and benefits from warehouse optimization. Repeated direct reads, Block Volume copies, and cross-region replication add latency and cost without improving query efficiency.

Question 26Oracle Data Platform Foundations

Which Oracle Cloud Infrastructure service is designed to automatically provision, tune, scale, and patch an Oracle Database environment with minimal administrator involvement?

  1. Autonomous Database Correct answer.
  2. Oracle Exadata Database Service on Cloud@Customer
  3. Compute instance with a manually installed database
  4. Bare metal database system

Explanation

Autonomous Database is the self-driving managed database service: it handles provisioning, tuning, scaling, and patching automatically. The other choices require the customer to perform most lifecycle administration tasks themselves.

Question 27Oracle Data Platform Foundations

In OCI Identity and Access Management, which construct is a collection of users who share the same set of permissions and is typically mapped to a group in an identity provider?

  1. Compartment
  2. Group Correct answer.
  3. Policy
  4. Dynamic group

Explanation

An IAM group collects users so that policies can grant permissions to many principals at once, and it is commonly mapped to an identity provider group. Policies are the statements that grant access, not the collection of users.

Question 28Oracle Data Platform Foundations

A team wants a fully managed, serverless Apache Spark environment on OCI for large-scale data processing without managing clusters. Which service fits?

  1. OCI Data Catalog
  2. OCI Data Flow Correct answer.
  3. OCI Streaming
  4. OCI Data Integration

Explanation

OCI Data Flow is the managed Apache Spark service that runs Spark applications on serverless infrastructure without cluster administration. The other services cover metadata, ETL orchestration, and event ingestion rather than Spark execution.

Question 29Oracle Data Platform Foundations

Which Oracle Database feature stores data in a columnar in-memory format optimized for analytic queries while the row-store remains available for transactional work?

  1. Flashback Data Archive
  2. Database In-Memory Correct answer.
  3. Automatic Storage Management
  4. Real Application Clusters

Explanation

Database In-Memory maintains a columnar in-memory representation of table data so analytic scans run fast while row-based OLTP access continues normally. The other features address storage management, historical tracking, and clustering.

Question 30Oracle Data Platform Foundations

What is the primary role of a compartment in an OCI tenancy?

  1. To isolate and organize resources so access and quotas can be managed at a granular level Correct answer.
  2. To provide a private network path between on-premises systems and OCI
  3. To store database backups in a separate region automatically
  4. To encrypt all block volumes attached to compute instances

Explanation

Compartments are logical partitions used to organize resources and to scope IAM policies and service limits. Encryption, connectivity, and backup replication are handled by other features.

Question 31Oracle Data Platform Foundations

Which OCI service provides a centralized, managed repository for storing and rotating secrets such as database passwords and API keys?

  1. OCI Monitoring
  2. OCI Bastion
  3. OCI Vault Correct answer.
  4. OCI Logging

Explanation

OCI Vault stores secrets and encryption keys in a managed, hardened service and supports rotation and audit. Logging, Monitoring, and Bastion provide observability and access brokering rather than secret storage.

Question 32Oracle Data Platform Foundations

An organization needs a managed service that ingests high-volume continuous event streams and lets multiple consumers read the same stream independently. Which OCI service should it use?

  1. OCI Streaming Correct answer.
  2. OCI Object Storage
  3. OCI File Storage
  4. OCI Data Catalog

Explanation

OCI Streaming is a Kafka-compatible service for durable, high-throughput event ingestion where multiple consumer groups can read the same stream at their own pace. Object and file storage are not designed for ordered, replayable event consumption.

Question 33Oracle Data Platform Foundations

Which statement best describes the shared responsibility model for Oracle Autonomous Database?

  1. Oracle manages the infrastructure and database software lifecycle while the customer manages data, users, and access policies Correct answer.
  2. Oracle manages customer data classification while the customer manages network security only
  3. The customer manages physical hardware while Oracle manages only the console
  4. The customer manages all patching of the underlying operating system and database binaries

Explanation

Under the shared responsibility model, Oracle handles infrastructure, patching, and database software maintenance, while the customer remains responsible for its data, schema, users, and access controls. This division is what allows Autonomous Database to be largely self-managing.

Question 34Oracle Data Platform Foundations

A team has semi-structured JSON files in OCI Object Storage and wants to query them with SQL directly, without copying the data into a database table. Which capability should it use?

  1. A materialized view refreshed on commit
  2. A tablespace with a data file on a mounted file system
  3. External tables that reference the Object Storage files Correct answer.
  4. A database link to a remote Oracle Database

Explanation

External tables let Oracle Database read data files, including JSON and other formats, stored in Object Storage and query them with SQL without loading them into database segments. The other options require data to reside in database storage or another database.

Question 35Oracle Data Platform Foundations

An architect needs a low-latency, fully managed key-value store for session state in a global application. Which Oracle Cloud Infrastructure service is the best fit?

  1. OCI Object Storage
  2. Autonomous Data Warehouse
  3. OCI Block Volume
  4. OCI Cache with Redis Correct answer.

Explanation

OCI Cache with Redis is a managed in-memory key-value store suited to low-latency session and cache workloads. Object Storage and Block Volume are persistent storage with higher latency, and Autonomous Data Warehouse targets analytics.

Question 36Oracle Data Platform Foundations

A data engineer must transform and orchestrate movement of data from multiple sources into Autonomous Data Warehouse on a schedule, using a managed visual ETL service. Which OCI service should be selected?

  1. OCI Data Flow
  2. OCI Streaming
  3. OCI GoldenGate
  4. OCI Data Integration Correct answer.

Explanation

OCI Data Integration is the managed ETL/ELT service with a visual designer for building data pipelines and scheduling them. Data Flow runs Spark code, Streaming ingests events, and GoldenGate performs replication.

Question 37Oracle Data Platform Foundations

A company needs to replicate ongoing changes from an on-premises Oracle Database to Autonomous Data Warehouse with minimal impact on the source system. Which Oracle product is designed for this?

  1. Oracle Data Pump
  2. Oracle Recovery Manager
  3. Oracle GoldenGate Correct answer.
  4. Oracle SQL Developer

Explanation

Oracle GoldenGate performs low-impact, log-based change data capture and replication between heterogeneous systems, which suits continuous replication to Autonomous Data Warehouse. The other tools perform backup, bulk export/import, or interactive development.

Question 38Oracle Data Platform Foundations

A data analyst wants to use a spreadsheet-like interface in Oracle Cloud to visualize and explore curated datasets and build dashboards without writing SQL. Which service should be recommended?

  1. OCI Data Catalog
  2. Oracle APEX
  3. OCI Data Science
  4. Oracle Analytics Cloud Correct answer.

Explanation

Oracle Analytics Cloud provides self-service visualization, exploration, and dashboarding for business analysts. Data Science targets model building, Data Catalog manages metadata, and APEX builds applications.

Question 39Oracle Data Platform Foundations

What is the main benefit of partitioning a large fact table by range on a date column in Oracle Database?

  1. It automatically encrypts each partition with a separate key
  2. It converts the table into a columnar in-memory store
  3. It removes the need to gather optimizer statistics
  4. Queries filtering on the date can prune irrelevant partitions and scan far less data Correct answer.

Explanation

Range partitioning enables partition pruning so that queries with date predicates read only the relevant partitions, reducing I/O. Partitioning does not provide encryption, statistics gathering, or automatic columnar conversion.

Question 40Oracle Data Platform Foundations

A team needs to expose a curated dataset in Autonomous Data Warehouse to an external partner with read-only access for a limited period. Which approach best follows least privilege?

  1. Share the ADMIN account credentials with the partner
  2. Create a dedicated database user granted only SELECT on the specific views and set an expiry date on the account Correct answer.
  3. Grant SELECT ANY TABLE to the partner user
  4. Grant the DBA role to the partner user so it can read any table

Explanation

Least privilege means granting only the specific object privileges required and limiting the credential's lifetime. A dedicated user with SELECT on named views and an expiry date satisfies both constraints.

Question 41Oracle Data Platform Foundations

Which Oracle Database capability lets an application continue issuing the same SQL while the database transparently redirects read-only queries to a standby database?

  1. Active Data Guard with read-only redirection Correct answer.
  2. Automatic Workload Repository
  3. Unified Auditing
  4. Flashback Database

Explanation

Active Data Guard keeps a standby open for read-only access and can transparently route read queries to it, offloading the primary. Flashback, auditing, and AWR address recovery, compliance, and performance diagnostics rather than read offloading.

Question 42Oracle Data Platform Foundations

An organization must ensure that all data written to OCI Object Storage buckets by a specific application is encrypted with a customer-managed key. Which combination should be used?

  1. Service-level default encryption only
  2. OCI Vault master encryption key assigned to the bucket plus an IAM policy restricting key use Correct answer.
  3. A pre-authenticated request with read access
  4. Client-side compression before upload

Explanation

Object Storage buckets can be associated with a customer-managed master encryption key held in OCI Vault, and IAM policies control who may use that key. Default encryption does not give the customer key control, and the other options do not affect encryption keys.

Question 43Oracle Data Platform Foundations

A developer must grant a compute instance permission to read objects from a bucket without storing user credentials on the instance. Which OCI mechanism is appropriate?

  1. An API signing key committed to the application source repository
  2. A user account with a console password placed in a file on the instance
  3. A pre-authenticated request embedded in the application code
  4. A dynamic group matching the instance plus a policy granting object read access Correct answer.

Explanation

Instance principals use dynamic groups, which match resources by rule, so the instance obtains short-lived credentials automatically and no secret is stored on disk. Policies then grant the dynamic group the required access.

Question 44Oracle Data Platform Foundations

An Autonomous Data Warehouse user reports that a long-running report consumes too many resources and slows other workloads. Which action limits the resources a consumer group may use?

  1. Increase the database's storage quota
  2. Define a resource plan with a consumer group and a resource share for that workload Correct answer.
  3. Convert the tables to external tables
  4. Disable the automatic indexing feature

Explanation

Resource manager consumer groups and resource plans allocate CPU and other resources among workloads so a heavy report cannot monopolize the system. Storage quotas, indexing, and table type do not govern runtime resource allocation.

Question 45Oracle Data Platform Foundations

A team wants to query data across an Autonomous Database and an external object store using a single SQL statement while preserving the ability to join the results. Which feature supports this?

  1. Using SQL*Plus to run two separate sessions
  2. Querying Object Storage data through external tables that participate in joins with local tables Correct answer.
  3. Creating a synonym for each remote file
  4. Exporting the local tables to CSV before every query

Explanation

External tables expose Object Storage files as relational sources, so they can be joined with local tables in one SQL statement. Exporting data or opening separate sessions does not provide a single joined query, and synonyms only alias existing objects.

Question 46Oracle Data Platform Foundations

A company must retain database backups for seven years at the lowest storage cost while still being able to restore them. Which OCI Object Storage tier is most appropriate for this long-term archive?

  1. Standard Storage
  2. A boot volume
  3. Archive Storage Correct answer.
  4. Infrequent Access Storage

Explanation

Archive Storage is the lowest-cost tier for data that is rarely accessed and can tolerate longer retrieval times, which fits multi-year retention. Standard and Infrequent Access cost more for rarely read data, and a boot volume is not an archival store.

Question 47Oracle Data Platform Foundations

An architect is designing a data platform where ingestion must be resilient to consumer outages, and the same events must be replayed later by a new analytics job. Which design element is essential?

  1. A direct in-memory queue that discards messages after the first read
  2. A file share that overwrites the file each hour
  3. A database table truncated after each load
  4. A durable, partitioned stream that retains events with consumer-managed offsets Correct answer.

Explanation

Durable retention with consumer-managed offsets lets independent consumers read at their own pace and replay history after an outage. Discarding messages, overwriting files, or truncating tables destroys the events needed for replay.

Question 48Oracle Data Platform Foundations

A team observes that an analytic query on a partitioned table scans every partition despite a filter on the partition key. Which condition most likely explains the loss of partition pruning?

  1. The filter applies a function to the partition key column, such as TO_CHAR(order_date) Correct answer.
  2. The query uses a parallel hint
  3. The table statistics were gathered recently
  4. The table has local indexes on each partition

Explanation

Partition pruning requires predicates that the optimizer can map directly to partition boundaries. Wrapping the partition key in a function hides the column value, so the optimizer cannot eliminate partitions.

Question 49Oracle Data Platform Foundations

An organization wants to combine relational tables, JSON documents, and graph queries in one Oracle Database so that a single transaction can update all three. Which capability makes this possible?

  1. Exporting relational data to a graph product before every transaction
  2. Storing JSON as opaque binary large objects and querying it with external tools
  3. Deploying three separate database instances and using two-phase commit across them
  4. The converged database architecture with relational, JSON, and graph features in one engine Correct answer.

Explanation

Oracle Database is a converged database: relational, JSON, graph, and other models are supported in the same engine, so one transaction can span them with full consistency. Separate instances or external products require distributed coordination and data movement.

Question 50Oracle Data Platform Foundations

A security team requires that sensitive columns be encrypted so that even users with SELECT privilege see plaintext only through authorized application paths, while DBAs cannot read the values directly. Which approach best meets this requirement?

  1. Compressing the columns with advanced row compression
  2. Transparent Data Encryption with column-level encryption plus data redaction for privileged users Correct answer.
  3. Granting SELECT on the columns only to the DBA role
  4. Storing the columns in an unencrypted tablespace with an audit policy

Explanation

Column-level TDE encrypts data at rest, and data redaction masks values for users who should not see them, including privileged accounts, while authorized application paths can still retrieve plaintext. Auditing and compression do not prevent reading the values.