OCI Autonomous DB Practice 2 Exam With Questions And Answer Rated 100% Correct 2022

OCI Autonomous DB Practice 2 Exam With Questions And Answer Rated 100% Correct 2022 Which two tasks can be executed from the service console for Autonomous Database? Correct Answer: Autonomous Database for monitoring usage and query performance Wizard to download connection wallet for connection from desktop tools The default port number to connect to Autonomous database? Correct Answer: 1522 While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads? Correct Answer: Data that is bulk loaded, bu default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar Which two statements are true when running DBMS_CLOUD.COPY_DATA? Correct Answer: valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure The source files can reside in Oracle Object Storage, Amazon S3 Object storage or Azure Blob storage When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage? Correct Answer: OCPUs and storage can be scaled independently What are two security features enabled by default by the Autonomous Database? Correct Answer: SQL Net Encryption Transparent Data Encryption 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)? Correct Answer: Pluggable databases cannot be migrated to ADB using plug, unplug or clone What are three methods to load data into the Autonomous Database? Correct Answer: Oracle Data Pump Oracle GoldenGate SQL*Loader Which three statements are correct when the Autonomous Database is stopped? (Choose three.) Correct Answer: Tools are no longer able to connect to a stopped instance CPU billing is halted based of full-hour cycles of usage In-flight transactions and queries are stopped 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...