What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.) Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database Data Pump is platform independent - it can migrate Oracle Databases running on any platform Data Pump is faster to migrate database than using RMAN Data Pump creates the tablespaces used by your Autonomous Database.
The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure? UPDATE_OBJECT_INFO MODIFY_SNAPSHOT_SETTINGS CREATE_BASELINE_TEMPLATE MODIFY_BASELINE_WINDOW_SIZE .
Which task is NOT automatically performed by the Oracle Autonomous Database? Backing up the database Mask your sensitive data Patching the database Automatically optimize the workload.
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.) The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.
Which of these database features is NOT part of the Autonomous Database? Online Indexing Flashback Database Real Application Clusters (RAC) Java in the Database.
Which two statements are true with regards to Oracle Data Sync? (Choose two.) Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database Data Sync can load your data in parallel in order to speed up the loading process Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.
Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)? In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database The Oracle Client Credential file is downloaded as a ZIP file The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet You MUST have an Oracle Client Credential Wallet in order to connect to the Autonomous Database.
What is the predefined role that exists in Autonomous Database that includes common
privileges that are used by a Data Warehouse developer? ADWC DWROLE ADMIN ADBDEV.
Which two system privileges does a user need to create analytic views? (Choose two.) CREATE ANALYTIC VIEW CREATE ATTRIBUTE DIMENSION CREATE ANALYTIC MEASURE CREATE ANALYTIC LEVEL CREATE ANALYTIC HIERARCHY.
What are three methods to load data into the Autonomous Database? (Choose three.) Oracle GoldenGate Transportable Tablespace RMAN Restore Oracle Data Pump SQL*Loader.
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads? Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.
Which three statements are true regarding how Autonomous Database provides data security? Data is encrypted at rest using transparent data encryption Users are given OS logons or SYSDBA privileges to prevent phishing attacking Network connections from clients to Autonomous Database are encrypted using the client credentials wallet Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors.
Which operating system can Data Visualization Desktop be run on? AIX Linux Windows Solaris.
Which procedure within the DBMS_CLOUD package is used to load data? PUT_OBJECT CREATE_EXTERNAL_TABLE LOAD_DATA LIST_FILES COPY_DATA.
Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data
involves multiple steps like creating a credential object, creating (access to) a storage object/location,
running datapump export and running a datapump import.
Which three statements are true for SQL Developer (18.3 and up) in combination with ADB Data
Loading?
(Choose three.) SQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running SQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps SQL Developer can only export/move/import files using datapump from databases running on Linux systems SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage.
When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions? Active transactions continue running unaffected Active transactions are paused Scaling cannot happen while there are active transactions in the database Active transactions are terminated and rolled back.
Which three statements are correct when the Autonomous Database is stopped? (Choose three.) User with DWROLE can still access the database Tools are no longer able to connect to a stopped instance CPU billing is halted based on full-hour cycles of usage In-flight transactions and queries are stopped.
Which two are correct actions to take in order to Download the Autonomous Database Credentials? (Choose two.) Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet). Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called? Two. They are called ATP and AD None. There are no pre-defined service names in tnsnames.ora Three. They are called high, medium and low Five. They are called tpurgent, tp, high, medium and low.
If you need to connect to Autonomous Data Warehouse (ADW) using Java Database Connectivity (JDBC) via an HTTP proxy, where do you set the proxy details? tnsnames.ora keystore.jks sqlnet.ora cwallet.sso ojdbc.properties.
Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP environment. The Oracle adviser recommends to use Oracle Data Sync for this. Which statement is true regarding Oracle Data Sync? Data Sync can only load files into tables (insert-only), the customer has to write the additional code Data Sync can not transform your data while loading it into the destination table Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files Data Sync can only load data from one source into one destination table.
The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usemames and init.ora parameters. The decision was made to adhere to the suggested migration method using an instant client and the datapump version that was suggested (and came with it). Which statement is true about the migration of the application’s database success? The migration can be technically a success but the 3-rd party vendor needs to support the result The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful The tablespace names will result in a blocking error during datapump import because of ADB limitations The migration can be a success, both technically and functional due to datapump enhancements.
A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window of downtime. Golden Gate was advised to be used during the migration. For maximum reassurance of their end-users, the customer also would like to use Golden Gate as a fall-back scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronized with the ADB Instance for a switch back. Which statement about the migration using Golden Gate is correct? Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on AD Only the migration to ADB is possible from an on-premise installation of Golden Gate Golden Gate on premise is not certified with ADB because Golden Gate Cloud Service exists for this The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on AD The described scenario is correct, can be used for migration and fallback scenarios.
Which statement is true regarding database client credentials file required to connect to your Autonomous Database? Place the credential files on a share drive that all users can use to connect to the database The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database When you share the credential files with authorized users, mail the wallet password and the file in the same email.
In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)? In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition In the TEST phase of the wizard a list is generated containing the records that would be rejected during import In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table.
Where can a user’s public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls? On the Autonomous Database Console SSH keys are not required in Oracle Cloud Infrastructure SSH keys cannot be added from console. They have to be added using REST APIs only Navigate to Identity, select Users panel on the console and select "Add Public Key".
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console? Using Database Configuration Assistant (DBCA) on the database server It cannot be done Connecting to the Cloud Infrastructure Command console via SSH wallet Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
Which Autonomous Database Cloud service ignores hints in SQL Statements by default? Autonomous Transaction Processing Autonomous Data Warehouse Neither service ignores hints by default Both services ignore hints by default.
Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)? Replicate the table using Golden Gate Create a Data Set Load data using Data Pump Import Table.
Which is correct about security features that are available in Oracle Autonomous Database? TDE but not Data Redaction Data Redaction and TDE are both supported Data Redaction but not TDE Neither Data Redaction nor TDE are supported.
What is the default retention period for both Automatic and Manual Autonomous Database Backups? One Year 7 days 60 days 30 days 90 days.
Which three statements are true regarding how Autonomous Database provides data security? Data is encrypted at rest using transparent data encryption Network connections from clients to Autonomous Database are encrypted using the client credentials wallet Users are given OS logons or SYSDBA privileges to prevent phishing attacking Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors.
What predefined user is created when an Autonomous Database (ADB) instance is created that you connect to in order to create other users and grant roles? SCOTT ADMIN SYS DWDEV.
When exporting a notebook, what type of file is created? XML TXT JSON SQL ASCII.
What two tasks can be executed from the service console for Autonomous Databases? (Choose two.) Autonomous Databases monitoring for usage and query performance Creating schemas Creating and scaling of Autonomous Database service Wizard to download connection wallet for connection from desktop tools.
What REST verb is used to create an Autonomous Database service using REST APIs? A "POST" REST call A "PUT" REST call An "INSERT" REST call A "GET" REST call.
Which three tasks by default are taken care of by the Autonomous Database? (Choose three.) Backups Firmware Patching Data Loading Database Upgrades Application User Creation .
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 It 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.
As a database architect you are tasked with configuring a high concurrency, production OLTP application to connect 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? HIGH TP MEDIUM TPURGENT.
What are two security features enabled by default by the Autonomous Database? (Choose two.) Transparent Data Encryption Encrypted Database Links SQL Net Encryption One SYSDBA account Read Only access to OS Audit logs.
Which method can be used to migrate on-premises databases to Autonomous Databases in cloud? Original Import/Export tools Physical migration method like database cloning Data Pump RMAN backup & restore.
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 methods can you use to create users and grant roles in Autonomous Database services? (Choose two.) through the Oracle Cloud Infrastructure service console through SQL/Developer's using DBMS_CLOUD_ADMIN package through SQLPIus.
Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance? TPURGENT MEDIUM HIGH TPPERFORMANT LOW.
When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage? Storage in TB cannot be larger than the number of OCPUs OCPUs and storage must remain in sync Increasing OCPUs will automatically increase storage OCPUs and storage can be scaled independently.
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.) Backup and recovery must be done using Recovery Manager(RMAN) Select the snapshot of the backup Select the archived redo logs Select the backup from which restore needs to be done Specify the point in time (timestamp) to restore.
Which is NOT required to connect to Autonomous Database from SQL developer? Database name Service name Wallet file Username and password.
What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database? (Choose two.) Golden Gate Recovery Manager (RMAN) CSV files copied to Autonomous Database block storage Data Pump.
Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure? Terraform REST API Dlocker Enterprise Manager.
Which is the correct subset of services offered via OCI-CLI (command line interface) for Autonomous Database (ABD) via calls made to the OCI API's? Create, Query, Update, List, Start Create, Get, List, Stop, Restore Start, Delete, Update, Query, Stop Create, Query, List, Stop, Restore.
What two methods can you use to define Machine Learning Users? (Choose two.) Use DBMS_CLOUD_ADMIN package SQL/Developer Oracle Cloud Infrastructure Console Client tools.
Which Java Database Connectivity (JDBC) thin client version supports the use of HTTP proxy settings that does NOT support TCP to connect to Autonomous Data Warehouse? 18.1 onwards Any version 17.4 onwards 12c Release 2 onwards.
Which two PL/SQL functions can be used to validate an analytic view? (Choose two.) VALIDATE_LEVELS VALIDATE_HIERARCHY VALIDATE_DIMENSION VALIDATE_ANALYTIC_VIEW VALIDATE_MEASURES.
Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production. How should the customer unplug their database to migrate to Autonomous Database (ADB)? Pluggable databases cannot be migrated to ADB using plug, unplug or clone Create a database link from source database to the ADB environment and clone the PDB Unplug to an xml file so database files and xml file can be uploaded to object storage Unplug into a pdb archive which can be uploaded to object storage.
Given the steps:
1. Create Oracle Machine Learning User
2. Create projects
3. Create workspaces
4. Create Notebooks
5. Run SQL Scripts
Which two steps are out of order when working with Oracle Machine learning? (Choose two.) Create Oracle Machine Learning User Create workspaces Create Notebooks Run SQL Scripts Create projects.
Which can be Scaled independently of the number of CPUs in an Autonomous Database? Memory Concurrency Sessions Parallelism Storage.
Which statement about the Export Wizard used to export database objects and data is NOT correct? If "Dependents" is checked as a DDL Option, for non-privileged users, only dependent objects in their schema are exported Export DDL includes features such as "Show schema," "Storage," and "Terminator." If "Grants" is checked as a DDL Option, GRANT statements are included for any grant objects on the exported objects, including those owned by the SYS schema If "Clipboard" is selected as the "Output," the output will be placed on the system clipboard, so that it can be pasted into a file, a command line, or other location appropriate for the format.
When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded? TNSNAMES.ORA CWALLET.SSO OJDBC.PROPERTIES SQLNET.ORA.
Users are required to select a service when connecting to Autonomous Data Warehouse and these services match to one of three different consumer groups: High, Medium, and Low. Which statement about these consumer groups is correct? Medium provides intermediate resource and concurrency, and queries run in a serial Low provides highest concurrency, lowest resources, and DoP =1 High provides highest resources, lowest concurrency, and DoP is 1 High provides highest concurrency and lowest resources, and DoP is 1.
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure? alter database set application_continuity=true alter session set application_continuity=true exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ; alter system set application_continuity=true.
In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization? Oracle Machine Learning notebook Compartment quotas Resource Manager settings SQL Developer Web Console.
Which three security features are available in Oracle Autonomous Database Shared Infrastructure? Transparent Data Encryption Database Vault Customer Managed Keys Data Redaction Audit Vault.
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure? Execute alter database for user MTHEO tablespace DATA quota = 10G; Execute alter user MTHEO quota unlimited on tablespace DATA; Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO', tablespace__quota => 'UNLIMITED'); Execute alter tablespace DATA set quota = 10G; .
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure? Data Pump Export File Avro Parquet Text JSON Microsoft SQL Server (.mdf).
Which statement is correct about managing and monitoring of Autonomous Database? You can use Service console to move Autonomous DB between compartments You can use Service console to create manual backups of Autonomous database You can use Service console to enable or disable auto scaling of Autonomous DB You can use Service console to manage runaway SQL statements on Autonomous DB.
Which statement is true when you provision an Autonomous Database using the cloning method? After an Autonomous database is created using a clone, the network access option can be changed A clone database source can be a running database instance A clone database source can be from a point-in-time backup that is less than 2 hours old When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.
For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access? SQLDEV_ADMIN.GRANT_SCHEMA ORDS_ADMIN.ENABLE_SCHEMA ORDS_ADMIN.GRANT_SCHEMA ORDS_PRIV.ENABLE_SCHEMA.
According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups. Which statement is true? Create a separate VCN that contains only public subnets Only 1 of each is allowed to be allocated per environment Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised Create at least 2 of each resource .
Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements. Which statement is FALSE? Oracle Data Safe only supports Autonomous Databases Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.
You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling 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 correct with respect to required action to move Autonomous Database resources to a different compartment? Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments Moving an Autonomous Database instance does not include its automatic backups You do not need to have sufficient access permissions on the compartment that the resource is being moved to You do not need to have sufficient access permissions on the compartment that the resource is being moved to.
Which statement is NOT correct when setting up compartment quotas? There are three types of quota policy statements which are set, unset and zero Compartment quotas use policies that allow allocation of resources with a high level of flexibility Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending Compartment quotas are set by Oracle.
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata? Under Core Infrastructure then Compute then Autonomous Exadata Under Solutions and Platform then Platform Services then Autonomous Exadata Under Database then Autonomous Transaction Processing then Autonomous Exadata Under Core Infrastructure then Autonomous Exadata .
When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean? The SQL statement completed its execution The SQL statement is executing The SQL statement is queued The SQL statement did not complete either due to an error.
For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned? Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'DW' Allow group ADB-Admins to manage autonomous-database in tenancy Allow group ADB-Admins to manage autonomous-database-family in tenancy Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP' .
Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure? 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 and is mandatory 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 Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates), and include database patching.
When enabling auto-scaling, which three options do not change? Number of OCPUs displayed in the console Amount of storage I/O resources parallelism settings Level of concurrency.
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console? Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused You can use the dbms_auto_index package to report on the automatic task and to set your preferences It is enabled by default You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints The indexing feature is implemented as an automatic task that runs at a fixed interval.
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources? Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure.
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database? Exadata Active Data Guard RAC, but only when scaling beyond 16 OCPUs Transparent Data Encryption Multitenant.
What are three methods to load data into the Autonomous Database? Oracle GoldenGate Transportable Tablespace RMAN Restore Oracle Data Pump SQL*Loader.
Which three event types are supported for Autonomous Database? Terminate End Maintenance Begin Change Compartment Begin Change Autoscaling Configuration Compartment Update IORM Begin.
Which two are correct actions to take in order to Download the Autonomous Database Credentials? Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:
* Autonomous Transaction Processing
* License Included
* Shared Infrastructure
Which parameter would you NOT use? db-workload is-dedicated db-type license-model.
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.) Backup and recovery must be done using Recovery Manager(RMAN) Select the snapshot of the backup Select the archived redo logs Select the backup from which restore needs to be done Specify the point in time (timestamp) to restore.
Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints? A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List. Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints You can configure Private Endpoints for an Always Free Autonomous Database.
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 two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure? Parallelism is not enabled by default Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default Oracle Database Result Cache is enabled by default for all SQL statements You have direct access to the database node.
Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of CPU 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 databases 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 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 Auto scaling is enabled by default and can be enabled or disabled at any time.
A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data. How does the developer connect to and interact with ADB from Python? SQL Developer JAVA JDK You can't use Python with ADB The Oracle Client and the cx_Oracle interface for Python .
During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure? the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator the Client Credentials wallet which is used to connect to the Autonomous Database the 'High Availability Container Database' in which the Autonomous instance should run the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment the Listener endpoint where the Autonomous Database should register on.
Which workload type does the Autonomous Database on dedicated infrastructure service currently support? TPURGENT TP MEDIUM LOW.
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure? Admin page of the Cloud Service Console OCI CLI OS command line from the database server SQLDeveloper.
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 you 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.
To who, and in which order, are dedicated Exadata Infrastructure resources provisioned? Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB.
Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database? The Autonomous Database must be in the same VCN and Subnet as the Compute instance The OCI compute instance does not support connecting to a Shared Autonomous Database The Autonomous Database must belong to a Network Security Group (NSG) The OCI compute instance can be used with an Always-Free Autonomous Database account A Private Endpoint is required to connect to the Shared-Autonomous Database.
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option? Current settings for ACLs are cloned Clone can be in a different region All OML notebooks are cloned All underlying data for OML notebooks is cloned All resource management rules are cloned.
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint? Network Security Group Security List VCN Route Table Subnet.
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'.
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads? Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations Autonomous Data Warehouse workloads are optimized for mixed workloads Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.
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 It 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 © size when needed for the workload Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.
What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments? Fleet Administrator defines and gains access to the ADMIN administrative user account for the database Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources Fleet Administrators are responsible for patching and backups of all container databases Fleet Administrators create, monitor and manage Autonomous Databases.
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.
What is the default port number for accessing a newly created Autonomous Database? 1524 1522 1521 1523 1526.
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure? Users have OS access to the database machine Users can customize the maintenance schedule It offers greater control and isolation starting at the Exadata cloud infrastructure level Users have SYS privileges in the database Users can customize the OS stack and add additional packages.
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported? Data Schemas Tablespaces Reports.
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 ' ) ; .
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.
Wich two valid ADB connectivity methods are used from a third-party software? JDBC uses FastConnect only .NET uses public internet only ODBC uses SSL with public internet SQL *Net uses SSL for encryption.
Which three benefits are offered by the Self-Securing capability of the Autonomous database? Protection from external security threats only Secure configuration with full database encryption Sensitive data protection from privileged users Protection from external and malicious internal threats Automatic application of security updates offline Automatic application of security updates online.
Which three can be considered as valid predefined service connection names? DBNAME_URGENT DBNAME_HIGH DBNAME_LOW DBNAME_CRITICAL DBNAME_NONE DBNAME_TP.
Which three considerations are necessary for migrating to the Autonomous Database? Does the method support using Oracle and/or third-party Object Store? Does the method support third-party database? How small is the dataset to be exported? What is the output file format? How large is the dataset to be imported?.
Which three tasks are automatically performed by the Oracle Autonomous Database? patching the database baking up the database optimizing the workload masking sensitive data compressing historical data.
Which two Security features are enabled by default in the Autonomous Database? Oracle native network transparent data encryption RMAN backups only cloud backups only data pump export dump file.
To configure manual backups in an Autonomous Data Warehouse instance, which one of these would you execute for creating a credential for Oracle Cloud Infrastructure Object Storage account and setting the database property to the credential? BEGIN
DBMS_CLOUD.CREATE_CREDENTIAL
(credential_name => 'DEF_CRED_NAME',
Username => 'adwc_user@email.com'
Password => 'password'
);
END;
ALTER DATABASE PROPERTY SET default_credential =
'ADMIN.DEF_CRED_NAME'; BEGIN
DBMS_CLOUD.CREATE_CREDENTIAL
(credential_name => 'DEF_CRED_NAME',
Username => 'adwc_user@email.com'
Password => 'password'
);
END;
ALTER DATABASE PROPERTY SET default_credential =
'adwc_user@email.com'; BEGIN
DBMS_CLOUD.DEFINE_CREDENTIAL
(credential_name = 'DEF_CRED_NAME',
Username => 'adwc_user@email.com'
Password => 'password'
);
END;
ALTER DATABASE PROPERTY SET default_credential =
'adwc_user@email.com'; BEGIN
DBMS_CLOUD.DEFINE_CREDENTIAL
(credential_name = 'DEF_CRED_NAME',
Username => 'adwc_user@email.com'
Password => 'password'
);
END;
ALTER DATABASE PROPERTY SET default_credential =
'ADMIN.DEF_CRED_NAME';.
Which three selections are required for provisioning an Autonomous Database Service after login to the OCI Console? availability domain region compartment object storage workload type tenant.
Which three tools are bundled with Autonomous Database? enterprise manager cloud control OCI console enterprise manager grid control SQL developer SQL developer web.
Which statement is true about the Security feature in the Oracle Autonomous feature? Database clients can only connect securely using the wall Certificate-base authentication uses an encrypted key stored in a wallet on the server Some connections use certificate-based authentication and SSL Database clients can connect securely using TLS/wallet.
Which predefined service is only applicable for the ATP Database? TP URGENT CRITICAL HIGH MEDIUM.
Which migration approach is not supported for the Autonomous Database? golden gate cloud service RMAN cross-platform backup and restore golden gate on-premise installation SQL developer migration workbench datapump export/import.
Which is not a valid resource in the Autonomous Database dedicated deployment? Autonomous container database Autonomous exadata infrastructure Autonomous container infrastructure Autonomous database.
What is the differentiating factor between Autonomous Transaction Processing and Autonomous Database Warehouse? securing database patching database backing up database provisioning database optimizing database workload.
Which two statements are correct about Autonomous Database Backups? Point-in-time recovery cannot be initiated using the Cloud console manually The Autonomous Database automatically performs recovery of point-in-time specified Manual backups are placed in the cloud Object Storage bucket The retention period for backups is 30 days Manual backups are placed in ASM.
Which two statements are correct with respect to the Private Cloud setup in the Autonomous Database Dedicated deployment? OCI Compartments are assigned to IT and end-users based on the organizational structure Half rack does not offer various shapes to choose from It is not necessary to create Compartments You need to create private networking overlay for the organizational structure.
Which metric shows the number of running SQL statements during the selected interval in the Autonomous Database? queued statements current SQL statements top SQL statements running SQL statements SQL statements.
Which method can be used to connect to an Autonomous Database instance to create a database user? Autonomous Database Console as Oracle Cloud user Oracle Enterprise Manager Cloud Control as a system user SQL Developer connection as a dbadmin user SQL *Plus connection as a sysdba SQL Developer Web Console as an Admin user.
Which two features differentiate the Dedicated from the Shared Infrastructure Deployment options? backup retention configuration controllable software update version availability domain placement choice VCN and private IP connect .
Which two services are applicable for both ATP and ADW Databases? TP URGENT CRITICAL HIGH MEDIUM.
Which three statements are true about the Autonomous Database OCI Integration? Its components include Oracle Machine Learning It offers unlimited access to the Autonomous Database for all OCI resources it allows connectivity to objects stores such as Amazon S3 Autonomous Database is hosted in the availability domains Backups can be accessed like any other file on object store.
Which three can be accessed via the Service Console of the Autonomous Database? enable database security scaling CPU disable transparent data encryption database restore manage Oracle ML Users.
Which file needs to be edited to enable a HTTP Proxy connection to an Autonomous Data Warehouse instance? listener.ora sqlnet.ora tnsnames.ora cwallet.sso.
Which two can be used for troubleshooting the data load operation in the Autonomous Database? Log and bad files accessible as tables Load operations logged in file system Log files accessible from file system Load operations logged in *_load_operations dictionary Log files only accessible as tables.
Which three source files are valid for loading data using DBMS_CLOUD.COPY_DATA in the Autonomous Database? SAN or NAS storage Cloud block storage Azure blob storage Oracle object storage Amazon S3 object storage.
Which statement is true about the Auto Scaling feature while provisioning a Non Free Tier Autonomous Database instance? It cannot be disabled It is enabled by default It is not a supported feature It needs to be explicitly enabled.
Which three are required to connect to the Autonomous Database instance from the SQL Developer? Oracle cloud username and password wallet file database service name database username and password Oracle cloud service name database unique name.
Which statement is true about effectively protecting customer data in the Oracle Autonomous Database? It automatically identifies sensitive data and masks it for use in development environments only It automatically identifies sensitive data and masks it for use in production environments only Customers can identify sensitive data and mask it for use in partner or development environments Customers can identify sensitive data and mask it for use in production environments only.
Identify the correct policy for assigning Database Administrators to access the Autonomous Database Dedicated resources Allow group ADB-Admins to manage autonomous-database in tenancy Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'ADB-D' Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'ANY' Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'ADB'.
Which three statements are true respect to the new Database role in the Autonomous Database? ADWROLE includes all necessary privilegies for a ADW developer/user It requires a simple password By default, the databases password will not expire until 360 days ADBROLE includes all necessary privilegies for a ADB developer/user DWROLE includes all necessary privilegies for a DW developer/user There's no need to specify anything except the password.
Which of these requires user intervention while using an Autonomous Database? Patching and Upgrades Defining the number of CPs to be used Backup ot the Database Performance tuning of the Database as per the number of queries.
Which two activities are performed by Fleet administrator? Provisions Exadata Infrastructure Provisions Container Databases Provisions new Autonomous Databases Creates users in the Autonomous Databases Backup Autonomous Databases.
Which two are used to secure a connection to the Autonomous Database Share Infra? Certificate Authentication and SSL TDE Wallet Client Credentials Wallet Connections are done using Oracle Net Protocol.
A user working on Autonomous Database stops the Database for a day but finds that he has been charged for the Database even in stopped state. What could be the reason? User has been incorrectly charged and should contact Oracle Support User has been charged for the CPU as the database was no terminated User has been charged for the CPU and storage as the database was not terminated User has been charged for the storage as the database was not terminated.
Which cannot be gathered from the web-based monitoring console? Queued SQL statements in each consumer group SQL statements executed per sec SQL queries failed in last 24 hours Average number of session in the database using CPU.
Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database. Which statement is true regarding the default configuration of the Autonomous Data Warehouse? In Autonomous Data Warehouse direct access to the database node and the local file system is allowed Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to Adding, removing, or modifying tablespaces is allowed Compression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands.
Which statement is true in regards to database links? You can call PL/SQL procedures and functions using a database link Connect from Autonomous Database to remote database using a database link Connect to Autonomous Database from remote database using a database link Create a database link from one Autonomous Database to another Autonomous Database instance.
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.) The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully The target table will be created in Autonomous Database if it does not already exist.
Which workload type does the Autonomous Database on dedicated infrastructure service currently support? Autonomous Transaction Processing only ATP and ADW Autonomous Data Warehouse only Hybrid Columnar compression.
|
