What two tasks can be executed from the service console for Autonomous Databases? (Choose two.)
Answer : AC
Reference:
https://sqlmaria.com/2019/10/22/how-do-i-scale-an-autonomous-database/
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?
Answer : B
Reference:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-privileges.html#GUID-50450FAD-9769-4CF7-B0D1-
EC14B465B873 -
What REST verb is used to create an Autonomous Database service using REST APIs?
Answer : A
Reference:
https://medium.com/@fathi.ria/rest-apis-easily-manage-an-autonomous-database-in-oracle-cloud-b105d29b5c05
Which operating system can Data Visualization Desktop be run on?
Answer : C
Reference:
https://www.oracle.com/middleware/technologies/oracle-data-visualization-desktop.html
Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)
Answer : BD
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dwhsg/overview-analytic-views.html#GUID-6F948948-6AE6-4A89-8AAC-
5B8952CEF41D
Which three tasks by default are taken care of by the Autonomous Database? (Choose three.)
Answer : BCD
Reference:
http://www.oracle.com/us/products/database/autonomous-database-self-securing-5116048.pdf
(6)
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?
Answer : A
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?
Answer : D
Reference:
https://github.com/oracle/cloudtestdrive/blob/master/ATP/LabGuideOSC200Connect.md
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)
Answer : AC
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?
Answer : B
Reference:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/experienced-database-users.html#GUID-58EE6599-6DB4-4F8E-
816D-0422377857E5
What are two security features enabled by default by the Autonomous Database? (Choose two.)
Answer : AB
Reference:
https://juliandontcheff.wordpress.com/category/cloud/
Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?
Answer : C
Explanation:
Oracle Data Pump provides very fast bulk data movement between Oracle Databases and Autonomous Data.
Reference:
https://k21academy.com/1z0-931/migrate-database-to-oracle-autonomous-database-cloud-options-data-pump-sql-loader-dbms_cloud-goldengate/
Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)
Answer : AB
Explanation:
A 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.
Reference:
https://docs.cloud.oracle.com/iaas/Content/General/Concepts/regions.htm
Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)
Answer : AB
Reference:
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html
Which Autonomous Database Service is NOT used to conned to an Autonomous Transaction Processing instance?
Answer : D
Reference:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE