Oracle Data Platform Foundations Associate

Which two statements are true about a converged Database are true?. It requires a dedicated hardware. It does not support analytical workloads. It supports both structured and unstructured data types. It supports graph and spatial workloads.

Which two interconnect solutions are available to connect Oracle Cloud to other cloud providers?. Cloud Router. Virtual Cloud Network. FastConnect. Virtual Private Cloud.

Which two statements are true about the Autonomous Database?. Indexes are added manually only after recommendations. It has self-service tools for analytics and data access. Running of complex applications, such as Siebel, is not available. Auto-scaling is based on workloads.

Which two self-service tools are available with the Autonomous Database?. Business Objects. Oracle Machine Learning. Encryption only in Object Storage. Low-Code App Dev, APEX.

Which two are true about Graph Analytics?. Graph Analytics can be used to discover influencers, dependencies, communities, and ranking. Oracle provides an Open-Source Graph Language (PGQL). There are no in-memory parallel analytic graph functions. Graph Analytics is not free with all Oracle Database editions.

Which three options can developers use to access spatial features?. Node.js. Python. Location. PL/SQL. JEE.

Which two are true about Spatial Studio?. Users can convert address data to coordinates so that they can plot locations on a map. It is not a self-service application. You can create interactive maps and perform spatial analysis on business data quickly and easily. Spatial Studio can be included at an additional cost with Oracle Autonomous Database.

Which two statements are true about an Autonomous JSON database?. It has instant auto-scaling. A DBA is required. The autonomous JSON database is accessed via document APIs. Applications cannot be built without SQL.

Which is NOT the responsibility of a customer in a simple cloud management model?. Manage database servers and VM hosts. Manage everything inside the database. Subscribe to database servers. Control access to customer VMs.

Which two are management interfaces for Exadata Cloud Service?. Oracle Cloud Web-Based UI. OCI Console. Oracle Cloud Rest APIs. SQL Worksheet.

Which update is Oracle’s responsibility for the maintenance of Exadata Cloud Service?. Grid Infrastructure. Database Updates. Exadata OS Updates. Infrastructure Updates.

Which are two advantages of Oracle Databases on Virtual Machines?. Run only OLTP database workloads. Provisioned with Block Storage. Lower cost with pay-per-use. Provide dedicated resources.

Which two statements are true about the default configuration for automatic database backups?. The retention period is set at 14 days. Archive redo log files are backed up every 30 minutes. Backups are executed in the primary site. Backups occur weekly.

Which three capabilities of Oracle autonomous Database can accelerate innovation?. instant scaling of storage. built-in AI and ML, which help find patterns that can identify undiscovered anomalies. scaling of CPUs with very little down time. provisioning a data warehouse in seconds.

Which two statements are true about Autonomous Transaction Processing?. Missing indexes are detected and created. Complex SQL queries are optimized. Data is stored in row format. Data is stored in columnar format.

Which three are required for provisioning an Oracle Autonomous Database instance?. number of tablespaces. number of CPUs. backup location FRA size. database name. workload type.

Which two actions can be performed from the OCI Console for an Oracle Autonomous Database?. Increase network bandwith. Increase the storage allocated for the database. Scale up or scale down memory. Scale up or scale down the CPU.

Which statement is true about Autonomous Transaction Processing?. it is used for OLTP and mixed workloads. it is used with data marts and machine learning. Data is stored in columnar format. it is used for analytic workloads.

Which three are a part of the five Lakehouse elements?. Data load. Data Catalog. Managed open-source services. Data analysis. Data Integration.

Which of the following helps avoid manual or exhaustive search techniques?. Auto Model Tuning. Auto Algorithm Selection. Auto Feature Selection. Feature Prediction Impact. Adaptive Sampling.

What protects against external and internal threats?. Data Security. Data Productivity. Data Governance. Data Liquidity.

What is Data Mesh?. It is a data solution for enterprise-scale domains and/or event-driven data-centric cloud projects. It is a finite project that can be run by an LoB Departmental IT org in isolation. It is an alternative point-solution for data warehouse or data lakes. It is a single tool or single cloud service that you can buy.

Which two are true about Data Catalog?. Management is required. It discovers data using a powerful search. Data Catalog does not integrate with Autonomous Database. It harvests object storage to derive schemas.