1Z0-931-20 Exam Questions
125 real 1Z0-931-20 exam questions with expert-verified answers and explanations. Page 3 of 3.
- Question #104Provisioning and Connecting to Autonomous Database
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?
SSH public keyOCI IdentityAPI authenticationconsole configuration - Question #105Developing with Autonomous Database
Which statement is true in regards to database links?
database linksADB-to-ADB connectivityremote databaseinter-database access - Question #106
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?
- Question #107Autonomous Database Concepts
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
SQL hintsADW auto-optimizationquery optimizerhint behavior - Question #108
Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?
- Question #109Autonomous Database Concepts
Which is correct about security features that are available in Oracle Autonomous Database?
TDEData Redactionsecurity featuresencryption - Question #110Managing and Monitoring Autonomous Database
What is the default retention period for both Automatic and Manual Autonomous Database Backups?
backup retentionautomatic backupsmanual backupsdefault configuration - Question #112Managing and Monitoring Autonomous Database
You must implement a backup solution for your Autonomous Data Warehouse (ADW) that will enable you to restore data as old as one year with a recovery point objective (RPO) of 10 da...
backup strategyRPOmanual backupsdata retention - Question #113Provisioning and Connecting to Autonomous Database
You have just created an Autonomous Data Warehouse (ADW) and you want to connect to the ADW using SQL Developer. What three items are needed to connect to the ADW using SQL Develop...
SQL Developerclient credentials walletconnection setupadmin password - Question #114Developing with Autonomous Database
Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)
analytic viewVALIDATE_HIERARCHYVALIDATE_ANALYTIC_VIEWPL/SQL functions - Question #115Autonomous Database Concepts
Which three tasks by default are taken care of by the Autonomous Database? (Choose three.)
autonomous managementpatchingdatabase upgradesself-managing - Question #116
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 hou...
- Question #117Provisioning and Connecting to Autonomous Database
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 requireme...
connection servicesTPURGENTATP concurrencyparallel queries - Question #118
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)
- Question #119Autonomous Database Concepts
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. W...
ADW default configurationdegree of parallelismOCPUautonomous optimization - Question #120Managing and Monitoring Autonomous Database
What are two security features enabled by default by the Autonomous Database? (Choose two.)
TDEencrypted database linksdefault securityAutonomous Database security - Question #121Migrating to Autonomous Database
Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?
Data Pumpon-premises migrationmigration methodscloud migration - Question #122Autonomous Database Concepts
Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)
OCI regionsavailability domainsfault domainsOCI infrastructure - Question #123Provisioning and Connecting to Autonomous Database
Your company is developing a new database application in Oracle Cloud Infrastructure. You need to test application functionality including a hardware failure scenario. Since the ap...
RAChigh availabilitydeployment optionscost optimization - Question #124Managing and Monitoring Autonomous Database
Which two Oracle Cloud Infrastructure database services allow you to dynamically scale both CPU and storage? (Choose two.)
dynamic scalingCPU scalingstorage scalingdatabase services - Question #125Developing with Autonomous Database
When exporting a notebook, what type of file is created?
notebooksexport formatJSONOracle Machine Learning - Question #126
What two tasks can be executed from the service console for Autonomous Databases? (Choose two.)
- Question #127Provisioning and Connecting to 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?
ADMIN userpredefined usersADB provisioninguser management - Question #129Developing with Autonomous Database
Which operating system can Data Visualization Desktop be run on?
Data Visualization DesktopWindowsOS requirementsOracle Analytics - Question #130Managing and Monitoring Autonomous Database
Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)
user creationrole grantsSQL DeveloperOCI console