🎧 New: AI-Generated Podcasts Turn your study notes into engaging audio conversations. Learn more

Autonomous Database Dedicated Infrastructure Quiz
18 Questions
5 Views

Autonomous Database Dedicated Infrastructure Quiz

Created by
@BlitheJackalope

Podcast Beta

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What type of graphical data presentation capabilities does Data Insights provide?

  • Bar charts (correct)
  • Scatter plots
  • Pie charts
  • Line graphs
  • When provisioning a dedicated Autonomous Container Database, which backup retention period cannot be implemented?

  • 60 days
  • 7 days
  • 15 days
  • 120 days (correct)
  • Which patch type is offered to be applied during maintenance after creating an Autonomous Container Database on dedicated infrastructure?

  • Release Update (RU)
  • Quarterly Bundle Patch (QBP) (correct)
  • Prior Release Update Revision (PRUR)
  • Prior Release Update (PRU)
  • Which resources need to be provisioned by the fleet administrator and the database administrator before a developer can connect to an Autonomous Database on Dedicated Infrastructure as a database user?

    <p>Autonomous Container Database, Network Security Group(s), Identity and Access Management (IAM) policy rules, Virtual Cloud Network and Subnet</p> Signup and view all the answers

    Which API is NOT available for developing with spatial on Autonomous Database?

    <p>Python</p> Signup and view all the answers

    Which statement about enabling Autonomous Data Guard is true?

    <p>The primary database is available in read-only mode.</p> Signup and view all the answers

    Which tool is used for automating data exploration and creating pivot tables in the context of analyzing sales data in an Autonomous Data Warehouse instance?

    <p>Data Load APEX</p> Signup and view all the answers

    In the context of Oracle Cloud Infrastructure (OCI), which resource is required to configure before provisioning an Autonomous Database with a Private Endpoint?

    <p>VCN Route Table</p> Signup and view all the answers

    What distinguishes Autonomous Data Warehouse (ADW) from Autonomous Transaction Processing (ATP) databases?

    <p>Only ADW supports autoscaling.</p> Signup and view all the answers

    When creating a business model, which feature can you enable or disable to control Business Object Security?

    <p>Private Tables</p> Signup and view all the answers

    In the context of Autonomous Database on Dedicated Infrastructure, what does the fleet administrator use to manage OCPU utilization?

    <p>Compartment quotas</p> Signup and view all the answers

    Which interface can be used to interact with Oracle Client for database connectivity in APEX Administration Services?

    <p>cx_Oracle interface</p> Signup and view all the answers

    Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?

    <p>In a separate key vault external to the Exadata Infrastructure</p> Signup and view all the answers

    Which statement is FALSE regarding provisioning an Autonomous Database and configuring private endpoints with security rules?

    <p>The destination port range is set to 1522.</p> Signup and view all the answers

    What is true about the use of Access Control Lists (ACLs) with an Autonomous Database on Shared Infrastructure?

    <p>When you restore a database, the existing ACLs are not overwritten by the restore action.</p> Signup and view all the answers

    What does Degree of Parallelism (DoP) refer to in the context of provisioning an Autonomous Database?

    <p>High provides highest concurrency and lowest resources.</p> Signup and view all the answers

    When configuring private endpoints for an Autonomous Database, what happens when setting up a stateless ingress rule?

    <p>The source is set to the address range you want to allow to connect to your database.</p> Signup and view all the answers

    Where can you configure Access Control Lists (ACLs) for an Autonomous Database on Shared Infrastructure?

    <p>Only during the creation of the Autonomous Database on Shared Infrastructure.</p> Signup and view all the answers

    Study Notes

    Data Insights

    • O Data Insights provides a wide range of graphical data presentation capabilities.
    • The results of the insight analysis appear as a series of bar charts in the Data Insights dashboard.

    Autonomous Container Database

    • While provisioning a dedicated Autonomous Container Database, 120 days backup retention cannot be implemented.
    • Quarterly Bundle Patch (QBP) is offered to be applied during maintenance after creating an Autonomous Container Database on dedicated infrastructure.

    Autonomous Database on Dedicated Infrastructure

    • Four resources need to be provisioned by the fleet administrator and the database administrator before a developer can connect to an Autonomous Database on Dedicated Infrastructure as a database user:
      • Autonomous Exadata Infrastructure
      • Autonomous Container Database
      • Oracle Database licenses
      • Network Security Group(s) and Identity and Access Management (IAM) policy rules that allow access to the database
      • Virtual Cloud Network and Subnet

    Spatial on ADB

    • Gremlin API is not available for developing with spatial on ADB.

    Autonomous Data Guard

    • Two true statements about enabling Autonomous Data Guard are:
      • The primary database is available for read/write operations.
      • The primary database is restarted for the new network configuration to be enabled.

    Business Model

    • Three advanced options can be enabled or disabled while creating a business model:
      • Analytic View Base Table
      • Query Transformation
      • Display Private Tables
      • Business Object Security Feature
      • Autonomous Aggregate Cache
      • Analytic View Transparency Views

    Data Analysis

    • To automate data exploration and create pivot tables, use Business Models.

    Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases

    • The difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases is that only ADW uses columnar compression by default.

    Oracle Cloud Infrastructure (OCI) Resources

    • Three OCI resources need to be configured before provisioning an Autonomous Database with Private Endpoint:
      • Subnet
      • VCN
      • Network Security Group (NSG)
      • Security List

    Autonomous Database on Dedicated Infrastructure Service

    • The fleet administrator uses Resource Manager settings to control OCPU utilization.

    Concurrency and Resources

    • Low provides highest concurrency and lowest resources, and Degree of Parallelism (DoP) is 1.

    Customer-Managed Encryption Keys

    • Customer-managed encryption keys are stored in a separate key vault external to the Exadata Infrastructure.

    Provisioning an Autonomous Database

    • A false statement regarding provisioning an Autonomous Database and configuring private endpoints with security rules to allow incoming and outgoing traffic to and from the Autonomous Database instance is that a stateless ingress rule is created to allow connections from the source to the Autonomous Database instance.

    Access Control Lists (ACLs) with an Autonomous Database on Shared Infrastructure

    • A true statement about the use of Access Control Lists (ACLs) with an Autonomous Database on Shared Infrastructure is that when you restore a database, the existing ACLs are not overwritten by the restore action.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Description

    Test your knowledge on Autonomous Database Dedicated Infrastructure, including topics like concurrency, resources, and customer-managed encryption keys storage. Questions cover information about Degree of Parallelism (DoP), Exadata Infrastructure, and key vaults.

    More Quizzes Like This

    Autonomous Maintenance and TPM Quiz
    11 questions
    Autonomous Data Guard Configuration Quiz
    3 questions
    Characteristics of Autonomous Agents
    18 questions
    Use Quizgecko on...
    Browser
    Browser