Which two infrastructure types support deployment of Oracle Autonomous Database? (Choose two.)
Correct Answer: B,D
Oracle Autonomous Database is designed to run on specific infrastructure optimized for its managed capabilities: Correct Answer (B): Dedicated Exadata Infrastructure provides a fully dedicated Exadata system for a single tenant, offering maximum isolation, performance, and customization (e.g., maintenance scheduling). Correct Answer (D): Shared Exadata Infrastructure allows multiple Autonomous Database instances to share Exadata resources, providing a cost-effective option for smaller workloads while retaining automation benefits. Incorrect Options: A: Virtual Machines (VMs) on OCI are not a supported deployment platform for Autonomous Database. It requires Exadata hardware for its self-managing features, unlike traditional OCI VMs used for manual database setups. C: Oracle Bare Metal Servers are not used for Autonomous Database; they lack the specialized Exadata architecture needed for its autonomous operations. These infrastructure types ensure high performance and scalability tailored to Autonomous Database's requirements.
Question 42
Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?
Correct Answer: A
Full Detailed In-Depth Explanation: Autonomous Database on Dedicated Infrastructure comprises: Autonomous Exadata Infrastructure: The hardware and software foundation. Autonomous Container Database: Hosts multiple ADB instances. Autonomous Database: The managed database instance. Autonomous Backup: Automatic backups to OCI Object Storage. Other options include roles (B, C) or general OCI resources (D), not core components of the service. A is the correct composition.
Question 43
Which are the two restrictions for an Always Free Autonomous Database? (Choose two.)
Correct Answer: B,D
The Always Free tier of Autonomous Database has specific limits. The two correct restrictions are: Maximum of two Always Free Databases per OCI tenancy (B): OCI's Always Free tier allows up to two free ADB instances per tenancy (e.g., one ATP, one ADW). This limit ensures fair resource distribution across users. For example, you might create FREEATP1 (1 OCPU, 20 GB) and FREEADW1 (1 OCPU, 20 GB) in your tenancy, but a third free instance isn't permitted-you'd need a paid upgrade. This is tracked by tenancy OCID, visible in the OCI console under "Limits." Maximum of one OCPU per Database (D): Each Always Free ADB is capped at 1 OCPU, non-scalable, with 20 GB of storage. This restricts compute power (e.g., no auto-scaling to 3x like paid tiers), suitable for small workloads like dev/test apps. For instance, a free ATP instance runs a lightweight app with SELECT * FROM users, but can't handle heavy concurrency due to the single OCPU. The incorrect options are: Supports only ATP as a workload type (A): False. Always Free supports both ATP (transactional) and ADW (warehouse) workload types, giving flexibility for OLTP or analytics (e.g., ATP for a web app, ADW for reports). Oracle Application Express (APEX) not included (C): False. APEX is included in both free ATP and ADW instances, pre-installed and accessible via the OCI console (e.g., "Development" > "APEX"). You can build apps like a task tracker without extra cost. These restrictions balance free access with resource constraints, encouraging upgrades for heavier use.
Question 44
Users connect to Autonomous Data Warehouse by using one of the following consumer groups: High, Medium, and Low. Which statement is true?
Correct Answer: A
Autonomous Data Warehouse (ADW) uses consumer groups (High, Medium, Low) to manage resource allocation: Correct Answer (A): "Low provides highest concurrency and lowest resources, and DoP is 1" is true. The Low group is designed for many lightweight, short-running queries, offering maximum concurrent sessions but minimal CPU/memory per session, with a Degree of Parallelism (DoP) of 1 (serial execution). Incorrect Options: B: High prioritizes resources, not concurrency; it has fewer sessions with more power. C: Medium offers balanced resources and concurrency; queries can run in parallel (DoP > 1), not just serially. D: High has high resources but low concurrency; DoP is typically higher than 1 for resource-intensive tasks. This setup optimizes ADW for varied workloads.
Question 45
Which two statements are true about accessing the Autonomous Database Tools?
Correct Answer: B,E
Full Detailed In-Depth Explanation: Since only four options are provided but the format requests two answers, I'll assume E from a prior question context. Let's evaluate: A: True but conditional. Database Actions is accessible with a Private Endpoint, but requires proper network setup (e.g., VCN peering), not guaranteed by default. B: True. Oracle APEX is accessed exclusively via the "Developer" menu in the Service Console, not other interfaces. C: False. Oracle Machine Learning (OML) is available in both ADW and ATP, not just ADW. D: False. Database Actions access requires specific user privileges (e.g., DWROLE), not granted to all users by default. E (assumed): True. SQL Developer Web is exclusive to Autonomous Database, not traditional Oracle databases. B and E are the most definitively true statements per documentation.