Oracle Autonomous Database Cloud 2019 Specialist.

What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.)

The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?

Which task is NOT automatically performed by the Oracle Autonomous Database?

Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)

Which of these database features is NOT part of the Autonomous Database?

Which two statements are true with regards to Oracle Data Sync? (Choose two.)

Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?

What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer?

Which two system privileges does a user need to create analytic views? (Choose two.)

What are three methods to load data into the Autonomous Database? (Choose three.)

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?

Which three statements are correct when the Autonomous Database is stopped? (Choose three.)

Which two are correct actions to take in order to Download the Autonomous Database Credentials? (Choose two.)

How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?

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?

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.

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?

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 synchronised with the ADB Instance for a switch back. Which statement about the migration using Golden Gate is correct?

Which statement is true regarding database client credentials file required to connect to your Autonomous Database?

In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?

Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?

Which statement is true in regards to database links?

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?

Which is correct about security features that are available in Oracle Autonomous Database?

What is the default retention period for both Automatic and Manual Autonomous Database Backups?

Which three statements are true regarding how Autonomous Database provides data security? (Choose three.)

When exporting a notebook, what type of file is created?

What two tasks can be executed from the service console for Autonomous Databases? (Choose two.)

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?

What REST verb is used to create an Autonomous Database service using REST APIs?

Which operating system can Data Visualization Desktop be run on?

Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)

Which three tasks by default are taken care of by the Autonomous Database? (Choose three.)

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?

 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?

Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

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?

What are two security features enabled by default by the Autonomous Database? (Choose two.)

Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?

Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)

Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?

Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

Which is NOT required to connect to Autonomous Database from SQL developer?

What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database? (Choose two.)

Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure?

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?

What two methods can you use to define Machine Learning Users? (Choose two.)

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.)

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?

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)?

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.)

Which can be Scaled independently of the number of CPUs in an Autonomous Database?

Which statement about the Export Wizard used to export database objects and data is NOT correct?

When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?

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?