ADB Practice Exam Questions and Answers 100% Verified

1 What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.) - A. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database. B. Data Pump is platform independent - it can migrate Oracle Datbases running on any platform 2 The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure? - MODIFY_SNAPSHOT_SETTINGS 3 Which task is NOT automatically performed by the Oracle Autonomous Database? - B. Mask your sensitive data. 4 Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.) - B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database. C. 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 or ADW E. 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.5 Which of these database features is NOT part of the Autonomous Database? - D. Java in the Database 6 Which two statements are true with regards to Oracle Data Sync? (Choose two.) - A. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase. C. Data Sync can load your data in parallel in order to speed up the loading process. 7 Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)? - C. The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet. 8 What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer? - C. DWROLE 9 Which two system privileges does a user need to create analytic views? (Choose two.) - D. CREATE ANALYTIC VIEW E. CREATE ATTRIBUTE DIMENSION 10 What are three methods to load data into the Autonomous Database? (Choose three.) - A. Oracle GoldenGate D. Oracle Data Pump E. SQL*Loader 11 While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads? - D. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar. 12When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions? - A. Active transactions continue running unaffected 13 Which three statements are correct when the Autonomous Database is stopped? (Choose three.) - B. Tools are no longer able to connect to a stopped instance. C. CPU billing is halted based on full-hour cycles of usage. D. In-flight transactions and queries are stopped. 14 Which two are correct actions to take in order to Download the Autonomous Database Credentials? (Choose two.) - A. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet. C. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet). 15 How many pre-defined service names are configured in for a single Autonomous Transaction Processing database instance, and what are they called? - D. Five. They are called tpurgent, tp, high, medium and low. 16 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? - A. C. 17 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? - C. Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files.18 The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usemames and 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? - C. The tablespace will resulot in a blocking error during datapump import because of ADB limitation