931

QUESTION 1 You have been tasked with analyzing a year's worth of sales data stored in an Autonomous Data Warehouse instance. Which tool would you use to automate data exploration and create pivot tables?. APEX. Business Models. Data Load. SQL Developer Web.

QUESTION 2 Which three advanced options can you enable or disable while creating a business model? While creating a business model what advanced options you can enable or disable? (Choose three). Autonomous Aggregate Cache. Analytic View Transparency Views. Business Object Security Feature. Analytic View Base Table Query Transformation. Display Private Tables.

QUESTION 3 Which statement is true about the use of Access Control Lists (ACLs) with an Autonomous Database on Shared Infrastructure?. When you restore a database, the existing ACLs are not overwritten by the restore action. An ACL can be set up for an IP address or a virtual cloud network (VCN) but not for both at the same time. ACLs can only be used with private endpoints. An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure.

QUESTION 4 Which two statements are true about using an Oracle Autonomous Database with private endpoints?. Private endpoints can be configured when you clone an Autonomous Database on Shared Infrastructure that was initially created with public endpoints. A Network Security Group (NSG) is required within your virtual cloud network before you can provision a Shared Autonomous Database to use private endpoints. You can configure private endpoints for an Always Free Autonomous Database. An Autonomous Database with private endpoints can be accessed from the public Internet by adding your IP address to an Access Control List (ACL).

QUESTION 5 Your customer has upgraded their on-premises 11.2 Database to 12.2. During this migration, the database was migrated to a pluggable database (PDB) and is now in production. How should the customer unplug their database to migrate to an Autonomous Database?. Create a database link from the source database to the Autonomous Database environment and clone the PDB. Unplug into an XML file so that the database and XML files can be uploaded to Object Storage. PDBs cannot be migrated to an Autonomous Database using plug, unplug, or clone. Unplug into a PDB archive, which can be uploaded to Object Storage.

How do you change the tablespace quota for user MTHEO on Autonomous Database on Shared Infrastructure?. Execute alter user MTHEO quota unlimited on tablespace DATA;. Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA(username => 'MTHEO',tablespace_quota => 'UNLIMITED');. Execute alter database for user MTHEO tablespace DATA quota = 10G;. Execute alter tablespace DATA set quota = 10G;.

When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?. 24 hours. 1 hour. 30 minutes. 2 hours.

Which two actions can be performed when an Autonomous Database is stopped?. Change Administrator Password. Update License Type. Start. Update Network Access.

Which two options are available for restoring an Autonomous Database?. Specifying the archived custom image. Specifying the point in time (timestamp) to restore. Selecting the backup from which restore needs to be done. Selecting the snapshot of the backup. Using Recovery Manager (RMAN) to connect to Autonomous Database and back it up.

Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?. The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image. The Autonomous Database must belong to a Network Security Group (NSG). The marketplace OCI image can be used with an Always Free Autonomous Database account. A private endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.

A new Python developer has joined your team and needs to access the Autonomous Database data. How does the developer connect to and interact with the Autonomous Database from Python?. By using SQL Developer. By using Oracle Client and the DBD-oracle interface. By using JDBC Driver. By using Oracle Client and the cx_oracle interface for python.

Which three are Oracle-recommended best practices for Autonomous Database alarms?. Use a single interval for all alarms. Tune your alarms routinely. Create a single alarm for each metric. Suppress alarms during investigations. Create multiple alarm metrics. Select the correct alarm interval for your metric.

Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?. Enterprise Manager Cloud Control. Logs. OCI Metrics. RMAN. Performance Hub.

Which set of Oracle Cloud Infrastructure (OCI) metrics is available only for Autonomous Database on Dedicated Infrastructure?. Query Latency, User Calls, Execute Count. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag. CPU Utilization, Storage Utilization. Transaction Count,sessions, Running Statements.

Which option should you use to create a graph with Graph Studio? In Graph Studio which you can use to create a graph?. NoSQL configuration. Graph created by a special tool downloaded from oracle.com. Tables in an Autonomous Database instance. Graph analytics algorithms. A graph license key.

What are the two differentiators of Oracle Autonomous Database on Dedicated Infrastructure?. Users have sYs privileges in the database. Users have OS access to the database machine. Users can customize the OS stack and add additional packages. Users have more control over the maintenance schedule. Users are offered greater control and isolation starting at the Exadata Cloud Infrastructure level.

During the provisioning of an Autonomous Database on dedicated hardware, what should the database administrator select to determine where the Autonomous Database is created on the dedicated infrastructure?. The Client Credentials wallet, which is used to connect to the Autonomous Database. The Listener endpoint where the Autonomous Database should register on. The compartment of the dedicated infrastructure because each compartment only runs one dedicated environment. The 'High Availability Container Database' in which the Autonomous instance should run.

Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of OCPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use. Which statement is FALSE regarding the auto scaling feature?. Auto scaling is enabled by default and can be enabled or disabled at any time. The base number of OCPU cores allocated to a database is not guaranteed. For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that are not being used by other auto scaling databases to meet high-load demands. For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.

Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with private endpoint?. Subnet. Security List. Route Table. VCN. Network Security Group (NSG).

In the Autonomous Database on Dedicated Infrastructure service, what does the fleet administrator use to control OCPU utilization?. Compartment quotas. Oracle Machine Learning notebook. SQL Developer Web Console. Resource Manager settings.

An Autonomous Database user with an instance wallet has left the company. The user had shared a database user ID with other users when accessing the Autonomous Database. Other than changing the shared user password, what can an administrator do to protect the instance?. Shut down and restart the instance. Rotate the instance wallet and share the new wallet with the remaining users. Delete the database. Delete the user who left.

Which two statements are true about Data Insights?. Data Insights is available with on-premises deployments of Oracle Database. Data Insights is an additional priced option. You can retrieve previously executed Data Insights searches. You can search for Data Insights against a base table or business model.

A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment. What should they do to remove this bottleneck?. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure. Ask Support to migrate their setup to a node without noisy neighbors. Remove any non-JSON data from the database. Increase the number of OCPUs allocated to the database.

Which three options do NOT change when enabling auto scaling?. I/O resources. Level of concurrency. Parallelism settings. Amount of storage. Number of OCPUs displayed in the console.

Which two license types does a customer need to benefit from Bring Your Own License (BYOL) when leveraging on-premises Enterprise Database licenses in Oracle Autonomous Database?. Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs. Transparent Data Encryption (TDE). Exadata. Active Data Guard. Multitenant.

Which statement is correct about the Service console in an Autonomous Database?. You can use the Service console to create manual backups of an Autonomous Database. You can use the Service console to manage runaway SQL statements on an Autonomous Database. You can use the Service console to move an Autonomous Database between compartments. You can use the Service console to enable or disable autoscaling of an Autonomous Database.

Which method does NOT permit you to change the database ADMIN user's password of an Oracle Autonomous Database on Shared Infrastructure?. SQL Developer. OCI CLI. Admin page of the Cloud Service Console. OS command line from the database server.

Which set of options can be specified when defining the preferred maintenance schedule of the Exadata Infrastructure for Autonomous Database Dedicated?. Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour. Month of the Year, Week of the Month, Day of the Week, Start Hour. Month of the Quarter, Week of the Month, Day of the Week, Start Hour. Week of the Quarter, Day of the Week, Start Hour.

Which two statements are true about accessing the Autonomous Database tools?. Oracle APEX can be accessed only from the Developer menu in Service Console. Access to Database Actions is available for all users of Autonomous Database. SQL Developer Web is available exclusively on Autonomous Database. Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database. Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with private endpoint networking.

Which four file formats are supported when loading data from Cloud Storage?. DOC. JSON. AVRO. DDL. Parquet. CSV.

Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator. Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure. Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database.

Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?. If a scheduled container database maintenance run cannot take place, Oracle automatically reschedulesthe container database maintenance for the following quarter. Autonomous Exadata infrastructure maintenance takes place at least once each quarter. Autonomous Exadata infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates) and includes container database patching. You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow.

Which is NOT needed to manage Oracle Autonomous Database with REST APIs?. Database ADMIN password. Tenancy's OCID. Fingerprint of the public key. User's OCID.

You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END.". Create a notification alert using DBMS_SNMP package. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database.

While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?. 120 days. 15 days. 60 days. 7 days.

Which statement is FALSE about Oracle Autonomous JSON Database? (REVISAR). JSON data is stored natively in the database. You can promote Autonomous JSON Database to Autonomous Transaction Processing. It supports NoSQL-style, document-centric applications. There is a 20 GB limit on JSON collections.

You need to create a new database by using the Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI) with the following requirements: · Autonomous Transaction Processing · License Included · Shared Infrastructure Which parameter would you NOT use?. is-dedicated. db-workload. db-type. license-model.

Which command should you issue to enable application continuity on Oracle Autonomous Database on Shared Infrastructure?. alter database set application_continuity=true. alter session set application_continuity=true. alter system set application_continuity=true. exec doms_cloud_admin.enable_app_cont( ' <service_name> ' ) ;.

Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is Stopped. Which statement is true?. Switchover is automatically initiated. Standby database is terminated. Failover is automatically initiated. Standby database is also stopped.

What happens with the standby database when disabling Autonomous Data Guard?. The standby database is started in read/write. The standby database is terminated. The standby database is started in read-only. The standby database is transformed into a refreshable done.

Which three methods can be used to migrate your existing Oracle database to Autonomous Database?. Using SFTP to copy CSV files into an Autonomous Database. Using GoldenGate. Using Recovery Manager (RMAN). Using Data Pump. Using Oracle Zero Downtime Migration (ZDM).

Which Database Actions tool is used to get information about the entities in your Oracle Autonomous Database and to also see how changing an object affects other objects?. JSON. Data Insights. Data Load. Catalog.

Which statement is FALSE about Oracle Data Safe?. It supports only Autonomous Databases. It helps you evaluate risks to data, assess user security, monitor user activity, and address data security compliance requirements. It helps you assess the security of your cloud database configurations by analyzing database configurations. It helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary. It evaluates user types, how users are authenticated, and the password policies assigned to each user.

Which statement is FALSE about setting up compartment quotas?. Compartment quotas cannot be set on the root compartment. Quotas in a compartment cannot be managed unless you belong to a group that has the correct permissions. Compartment quotas use policies that allow allocation of resources with a high level of flexibility. Quotas set on a parent compartment override quotas set on child compartments.

Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?. You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure. You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available.

What is the correct way to list all files in the default data pump directory?. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW). Log onto ADW server and issue is -al on the command line. By executing select * from utl_file . list ( ‘DATA_PUMP_DIR ' ) ;.

An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB. Other than changing the shared user password, what can the admin do to protect the instance?. Trust the user who left to not access the database. Shutdown and restart the instance. Rotate the instance wallet and share the new wallet with the remaining users. Delete the user.

While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance?. Release Update (RU). Prior Release Update Revision (PRUR). Prior Release Update (PRU). Quarterly Bundle Patch (QBP).

Which can be Scaled Independently of the number of CPUs In an Autonomous Database?. Parallelism. Storage. Concurency. Memory. Sessions.

You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX. What statement describes the step to provide the developer a new workspace in APEX?. Create an IDCS user with the APEX role. Access the APEX Administration Services and create the workspace for the developer. Create a new developer account. Create a database user with the APEX role.

A Business Analyst joined in your organization and wanted to explore the database tools. Which statement provides access to data tools page for business analyst. When restoring/cloning the ADB, you must select a backup which is at least hours/minutes old. 24 hrs. 2 hrs. 5 min. 1 day.

Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s). How can they achieve this?. Change the Automatic Maintenance Schedule to 'None’d. Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week or day. You cannot permanently disable scheduled Automatic Maintenance. Change the Automatic Maintenance Schedule to 'No Preference'.

A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well. Which Oracle Cloud Infrastructure database service is appropriate for this scenario?. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster. ADW since operational reporting is a higher priority in this scenario. t is best to build a separate data warehouse, and move the OLTP data on a nightly basis. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.

Which statement is true when the Autonomous Database has auto scaling enabled?. Database concurrency is scaled up when needed by the workload. Increases the number of sessions available to the database. Scales the PGA and SGA size when needed for the workload. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.

Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.). RMAN Cross-Platform backup and restore. Golden Gate on-premise installation. PDB unplug / plug operation. Datapump export / import. Dataguard Physical Standby. Golden Gate Cloud service.

What REST verb is used to create an Autonomous Database service using REST APIs?. An "INSERT" REST call. A "GET" REST call. A "POST" REST call. A "PUT" REST call.

You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web. What steps do you need to take?. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL. Create a database user with the default privileges. Create a database user with connect, resource, and object privileges. Create an IDCS user. Create a database user with connect, resource, and object privileges.

You have an Autonomous Transaction Processing Database with three OCPUs and autoscaling turned on and your application is using the TPURGENT service. The load on the database increases from three OCPUs to nine OCPUs. What is the total number of concurrent statements that the TPURGENT service can support?. 900. 1800. 2700. 1500.

Which statement is FALSE for Oracle Data Safe?. Oracle Data Safe helps you assess the security of your cloud database configurationsby analyzing database configurations. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user. Oracle Data Safe only supports Autonomous Databases. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.

Which two methods can you use to create database users and grant roles in Autonomous Database services?. service console. SQL Developer. the DBMS_CLOUD_ADMIN package. SQL *Plus.

Which predefined role that exists in Autonomous Database includes common privileges that are used by a Data Warehouse developer?. ADMIN. ADBDEV. DWROLE. ADWC.

What predefined user is created when provisioning an Autonomous Database (ADB) instance to which you connect to create other users and grant roles?. DWDEV. ADMIN. SCOTT. SYS.

Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?. Backup Retention. Memory Usage. Data Organization. Undo Management.

Which index type is designed to index catalog information?. CONTEXT. CTXRULE. CONTRAINS. CTXCAT.

Which statement is FALSE about loading data into the Autonomous Database using the Data Load card inDatabase Actions?. You must first manually create your database credentials using dbms_cloud.create_credential before accesing your Oracle Object Storage Bucket. Data can be uploaded from several cloud storage sources including S3, Azure, Google Cloud and Oracle Object Storage. Data formats supported include: text, csv, json, avro and parquet. Data can be loaded from a local data source. Data can be loaded from a remote database using Database Links (DBLinks).

Which subset of services is offered via OCI-CLI (command line interface) for Autonomous Database (ADB) via calls made to the OCI APIs?. Start, Delete, Update, Query, Stop. Create, Get, List, Stop, Restore. Create, Query, Update, List, Start. Create, Query, List, Stop, Restore.

Which predefined service connection should you use when running lots of high concurrent queries in Autonomous Database?. DBNAME_CONCURRENT. DBNAME_MEDIUM. DBNAME_HIGH. DBNAME_LOW.

Which of the following two statements regarding Data Transforms are correct?. Data Transforms allow you to design data transformations in the form of data loads, data, flows, and workflows. Data Transforms provides access to Oracle Data Integrator (ODI) Web Edition. All capabilities to transform data in ODI Classic are available with ODI Web Edition. Workflows for data transform is only available on the ODI Web Edition.

What two actions can you do when a refreshable clone passes the refresh time limit?. You can use the instance as a read only database. You can disconnect from the source to make the database a read/write database. You can extend the refresh time limit. You can manually refresh the clone.

Which are two available options when creating an Autonomous Database? (REVISAR). APEX Service on Shared Infrastructure. Autonomous JSON Database on Shared Infrastructure. Autonomous JSON Database on Dedicated Infrastructure. APEX Service on Dedicated Infrastructure.

What is the default time range in Performance Hub?. 1 Week. 1 Hour. 24 Hours. 15 MInutes.

You see a clock icon in the Status column on the SQL Monitoring tab of Performance Hub. What does it indicate?. The SQL statement did not complete due to an error. The SQL statement is queued. The SQL statement is executing. The SQL statement completed its execution.

Which three event types are supported for Autonomous Database?. Change Compartment Begin. Terminate End. Change Autoscaling Configuration Compartment. Maintenance Begin. Update IORM Begin.

Which vaults are used for storing customer-managed encryption keys for Autonomous Database on Dedicated Infrastructure?. Oracle Cloud Infrastructure Vault, Oracle Database Vault. Oracle Database Vault, Oracle Key Vault. Oracle Audit Vault, Oracle Key Vault. Oracle Key Vault, Oracle Cloud Infrastructure Vault.

Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of OCPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use. Which statement is FALSE regarding the auto scaling feature?. For database on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance. For database on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren't being used by other auto scaling databases to meet high-load demands. The base number of OCPU cores allocated to a database is not guaranteed. Auto scaling is enabled by default and can be enabled or disabled at any time.

During the provisioning of an Autonomous Databases on dedicated hardware, what should the database administrator select to determine where the Autonomous Database is created on the dedicated infrastructure?. The Listener endpoint where the Autonomous Database should register on. The Client Credentials wallet, which is used to connect to the Autonomous Database. The Container database in which the Autonomous instance should run. The compartment of the dedicated infrastructure because each comparment only runs one dedicated enviroment.

Which option describes the connection types that third -party sotfware an use to connect to an Autonomous Database (ADB)?. JDBC only. new ADB-specific protocols. any protocol supported by Oracle Net Services. SQL*NET only.

Your company has a .NET application and wants to deploy it on Autonomous Database (ADB). What software is used to connect to ADB from the .NET application?. You cannot use .NET with ADB. Java. SQL*Plus. Oracle Data Access Components for Windows.

Which two cloud services allow you to import Data Pump files to an Autonomous Database on Dedicated Infrastructure?. Oracle Cloud Infrastructure Object Storage. Amazon S3. Azure Blob Storage. Oracle Cloud Infrastructure Object Storage Classic. Google Cloud Storage.

Which workload is particularly suited to Oracle Autonomous JSON Database?. Transactions. Data Lakes. Schemaless, document centric. Data Marts.

Which three functions are provided by Spatial Studio?. Map visualization. Custom SQL queries. Spatial data editing. Spatial analysis. Geocoding.

Which two statements apply to the Autonomous Database service on Dedicated Infrastructure?. You, as the customer, are responsible for all patching operations. Patching occurs on the first Sunday of each quarter. You can set mantenance windows for each individual Autonomous Container Database. You can set mantenance windows for an Autonomous Exadata Infrastructure.

Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?. Autonomous Exadata Infrastructure maintenance runs are for Infrastructure patching (incluiding patching of the Exadata grid Infrastructure code and operating systems updates) and includes container database patching. You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow Infrastructure maintenance within the same quarter. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter.

Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?. Enterprise Manager Cloud Control. Performance Hub. Logs. RMAN. OCI Metrics.

Which two statements are true about Recovery Time Objective (RTO) and Recovery Point Objective (RPO) for Autonomous Data Guard?. RTO and RPO are 0 minutes for manual failovers. RPO is adjustable, but RTO is always 5 minutes. RPO is 0 minutes for an automatic failover. RTO and RPO are adjustable through the OCI console. RTO is 2 minutes for an automatic failover.

Users connect to Autonomous Data Warehouse by using one of the following consumer groups: High, Medium, and Low. High provides highest concurrency and lowest resources, and Dop is 1. Low provides highest concurrency and lowest resources, and Dop is 1. Medium provides intermediate resource and concurrency, and queries run serially. High provides highest resource and lowest concurrency, and Degree od parallelism (DoP) is 1.

Which statement is FALSE about the Catalog tool?. You can delete an entity from the autonomous Database via the Catalog tool. You can view the data definition of an entity. Impact shows the entities that depend on the source. You can limit the display of entities to only those with certain names, schemas, types, or applicactions by entering values in the Search field.

What are three characteristics of Data Lake data captured in Object Storage?. high concurrency. high transaction performance. multiple subject areas. mixed data types. schema on read.

Which is a feature of a graph query language?. Scripting language. Run key-value queries. Object-oriented language. Ability to specify patterns.

Which terminology is used to refer to a communication channel for sending messages to a subscription, such as email or SMS?. Event. Topic. Notification. Subject.

Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.). An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region. Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region. A single fault domain can be associated with multiple regions and availability domains. Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.

Which two statements are true regarding active transactions when scaling OCPUs in an Autonomous Database?. Scaling can happen while there are active transactions in the database. Active transactions are paused. Active transactions are terminated and rolled back. Active transactions continue running unaffected.

Which TWO infrastructure support deployment of Oracle Autonomous Database? (Choose all correct answers). Dedicated Exadata Infrastructure. Virtual Machines on Oracle Cloud Infrastructure. Shared Exadata Infrastructure. Oracle Bare Metal Servers.

Which is an Autonomous Database critical event?. NewMaintenanceSchedule. ScheduleMaintenanceWarning. DatabaseConnection. MaintenanceBegin. AdminPasswordWarning.

Which two objects are imported when using Data Pump to migrate your Oracle database Autonomous Database?. Data. Report. Schemas. Tablespaces.

To who, and in which order, provisions dedicated Exadata Infrastructure resources?. The database administrator provisions the Autonomous Container DB and the Autonomous DB. Then, the fleet administrator provisions the Autonomous Exadata Infrastructure. The Fleet administrator provisions the Autonomous Exadata Infrastructure. Then, The database administrator provisions the Autonomous Container DB and then the Autonomous DB. The database administrator provisions the Autonomous Exadata Infrastructure. Then, The Fleet administrator provisions the Autonomous Container DB and then the Autonomous DB. The Fleet administrator provisions the Autonomous Exadata Infrastructure and then the Autonomous Container DB and then, the database administrator provisions the Autonomous DB.

As a database architect you are tasked with configuring a high concurrency, production OLTP application toconnect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode. Which connection service is appropriate for such a workload?. TP. TPURGENT. MEDIUM. HIGH.

Which file is not a component of the client credentials wallet used to connect to an Oracle Autonomous Database?. cwallet.sso. sqlnet.ora. trustore.jks. keystore.jks. ewallet.p12. protocol.ora.

Which three operations are available for a quarterly maintenance update on Autonomous Container Database?. Reschedule patching. Reschedule and patch immediately. Apply a partial patch. patch immediately. Skip patching.

Which two actions can you perform with Autonomous Data Guard enabled on Autonomous Database on Shared Infrastructure?. Switchover. View Apply Lag. Reinstate. Failover. Change Protection Mode.

Which statement is FALSE about Data Insights?. 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. Data Insights display information about patterns and anormalles in the data of entities in your Oracle Autonnomous Database. Data Insight are automatically generated by varios analytic functions built into the database.

Which are the two restrictions for and Always free Autonomous Database?. Oracle Application Express (APEX) not included. supports only ATP as a workload type. maximum of two Always Free Database per OCI tenancy. maximum of one OCUP per Database.

How can you keep Autonomous Database tables in sync with an on-premises data source?. Use THE ords package on the Data Load page. Use the FEED DATA option on the Data Load page. Use the Cloud Locations card on the Data Load page. Use the Link Data option on the Data Load page.

Which statement is FALSE regarding provisioning an Autonomous Database and configuring private endponits with security rules to allow incoming and outgoing traffic to and form the Autonomous Database instance?. The destination port range is set to 1522. The source is set to the address range you want to allow to connect to your database. The IP Protocol is set to TCP. A stateless ingress rule is created to allow connections from the source to the Autonomous Database instance.

You created an Autonomous Database without auto scaling. Which two ways can you enable auto scaling?. Click Scale Up/Down and select the Auto Scaling checkbox. Shut down the Instance, click Scale Scale Up/Down and select the Auto Scaling checkbox, then restart the Instance. Use a Rest call to enable Auto Scalling. Use a Rest call to Shut down the Instance, Then a second Rest call to enable Auto Scalling, and a REST call to restart the instance.

Which of the following is not required for connecting to ADB via SQLDeveloper?. Connection Name. Usename. Password. Service. database name.

Which two statements are true about Recovery Time Objective (RTO and Recovery Point Objective (RPO) Tor Autonomous Data Guard?. RTO and RPO are 0 minutes on manual tailovers. RPO Is adjustable, but RTO Is always 5 minutes. RPO Is 0 minutes for an automatic failover. RTO and RPO are adjustable through the OCT console. RTO is 2 minutes for an automatic failover.

. Which three statements are true about changing license options in Oracle Autonomous Database?. You cannot update your BYOl to License Included after the Database has been created. You can update the License Included option to BYOL after the Database has been created. You cannot update the License Included option to BYOL after the Database has been created. You can update your Bring Your Own License (BYOL) to License Included after the Database has been created. You can upgrade from an Always Free Autonomous Database account to a paid account any time.

32. What are the two supported infrastructure options for deploying an Autonomous Database?. Any Oracle Engineered System. Bare-metal on Oracle cloud initastructure. Shared Exadata infrastructure. Dedicated Exadata Infrastructure. VM on Oracle Cloud Infrastructure.

22. What two actions can you do when a refreshable clone passes the refresh time limit?. You can use the instance as a read only database. You can disconnect from the source to make the database a read/write database. You can extend the refresh time limit. You can manually refresh the clone.

15. Which statement is correct about management operations on Autonomous Database on shared Infrastructure?. • You can skip a scheduled maintenance run. For Autonomous Databases on Shared Infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed. You can perform a "rolling restart" on, all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available. You cannot configure the scheduling for your Autonomous Databases on Shared Infrastructure. You can choose to use Release Update (RU) or.Release Update Revision (RUR) updates for your Autonomous Databases on Shared Infrastructure.

What is the number of concurrent statements that can be handled by the medium database service name?. 20 Х OCPU. unlimited. 1.25 Х OCPU. 5.

Which statement is FALSE regarding database links?. You can connect to a remote database from an Autonomous Database by using a database link. You can create a database link from one Autonomous Database to another Autonomous Database instance. You can call PL/SQL procedures and functions by using a database link. You can connect to an Autonomous Database from a remote database using a database link.

Which two protection modes are supported by Data Guard on Autonomous Database on Dedicated rastructure?. Махатит continuity|. Maximum Performance. Махітит Availability. Maximum Protection.

Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is Stopped. Which statement is true?. Standby database is also stopped. Switchover is automatically initiated. Standby database is terminated. Failover is automatically initiated.

Which privilege is NOT included in the DWROLE role?. READ, WRITE ON directory,DATA PUMP,DIR ALTER SESSION. ALTER SESSION. CREATE ANALYTIC VIEW. UNLIMITED TABLESPACE.

What can you do with graphs? (Choose two). Find patterns that are anomalous and use that to detect fraud. Facial recognition. Product recommendations. 3-D modeling.

Which 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 Database instance. Autonomous Exadata Infrastructure. Virtual Cloud Network and Subnet. Network Security Group(s). Autonomous Container Database. Oracle Database licenses. Identity and Access Management (IAM) policy rules that allow access to the database.

Which option is not available to access data in an Autonomous JSON Database?. Oracle Cloud Infrastructure console using the ISON Developer tool. NoSQL statements using Simple Oracle Document Access (SODA) drivers. Regular Oracle SQL statements using a connection string to the database. REST API calls to the database.

Which three tasks are performed from the service console of an Autonomous Database on Shared Infrastructure?. Download the wallet. Manage Oracle Machine Learning users. Set resource management rules. Enable autoscaling. Rotate the wallet.

Which two statements are true for Spatial Studio?. It is a developer IDE for Spatial. It is a free app on the OCI Marketplace. It is a self service no-code web tool for Spatial. It is a managed OCI service.

Which two security features are enabled by default by the Autonomous Database?. Transparent Data Encryption (TDE)|. Encrypted Database Links. SQL*Net Encryption. Read-only access to OS Audit logs. One SYSDBA account.

Which of the following two statements regarding Data Transforms are correct?. Data Transforms provides access to Oracle Data Integrator (ODI) Web Edition. Data Transforms allows you to design data transformations in the form of data loads, data flows, and workfiows. Workfiows for data transforms is only available on the ODI Web Edition. All capabilities to transform data in ODI Classic are available with ODI Web Edition.

Which two of the following data sources are available when using the Data Load page on Database Actions?. Local Files. Backup files in block storage. Files in Oracie Cloud Storage. REST endpoints.

Which three are Oracie-recommended best practices for Autonomous Database alarms?. Create a single alarm for each metric. Tune your alarms routinely. Suppress alarms during investigations. Create multiple alarm metrics. Select the correct alarm interval for your metric. Use a single interval for all alarms.

Which is the correct way to list all files in the default Data Pump directory?. Execute select * from utl file. list (*DATA PUMP DIR*}7. Log on to the Autonomous Data Warehouse (ADW) server and issue 1s line. Execute select • FROM DEMA_CLOUD.LIST_FILES (*DATA_POMP_DIR'):-. You cannot list the files in the default Data Pump directory from ADW. sion to commandi.