1Z0-931-20: Oracle Autonomous Database Cloud 2020 Speciali

What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.). Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database. Data Pump is platform independent - it can migrate Oracle Databases running on any platform. Data Pump is faster to migrate database than using RMAN. Data Pump creates the tablespaces used by your Autonomous Database.

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

Which task is NOT automatically performed by the Oracle Autonomous Database?. Backing up the database. Mask your sensitive data. Patching the database. Automatically optimize the workload.

Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.). The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database. 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 abadfile table on Autonomous Data Warehouse. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database. 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.

Which of these database features is NOT part of the Autonomous Database?. Online Indexing. Flashback Database. Real Application Clusters (RAC). Java in the Database.

Which two statements are true with regards to Oracle Data Sync? (Choose two.). Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase. Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database. Data Sync can load your data in parallel in order to speed up the loading process. Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.

Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?. In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database. The Oracle Client Credential file is downloaded as a ZIP file. The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet. You MUST have an Oracle Client Credential Wallet in order to connect to the Autonomous Database.

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

Which two system privileges does a user need to create analytic views? (Choose two.). CREATE ANALYTIC MEASURE. CREATE ANALYTIC LEVEL. CREATE ANALYTIC HIERARCHY. CREATE ANALYTIC VIEW. CREATE ATTRIBUTE DIMENSION.

What are three methods to load data into the Autonomous Database? (Choose three.). Oracle GoldenGate. Transportable Tablespace. RMAN Restore. Oracle Data Pump. SQL*Loader.

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations. Autonomous Data Warehouse workloads are optimized for mixed workloads. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?. Active transactions continue running unaffected. Active transactions are paused. Scaling cannot happen while there are active transactions in the database. Active transactions are terminated and rolled back.

Which three statements are correct when the Autonomous Database is stopped? (Choose three.). User with DWROLE can still access the database. Tools are no longer able to connect to a stopped instance. CPU billing is halted based on full-hour cycles of usage. In-flight transactions and queries are stopped.

Which two are correct actions to take in order to Download the Autonomous Database Credentials? (Choose two.). Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet). Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials. E. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.

How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?. Two. They are called ATP and ADW. None. There are no pre-defined service names in tnsnames.ora. Three. They are called high, medium and low. Five. They are called tpurgent, tp, high, medium and low.

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?. tnsnames.ora. keystore.jks. sqlnet.ora. cwallet.sso. ojdbc.properties.

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?. Data Sync can only load files into tables (insert-only), the customer has to write the additional code. Data Sync can not transform your data while loading it into the destination table. Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files. Data Sync can only load data from one source into one destination table.

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?. The migration can be technically a success but the 3-rd party vendor needs to support the result. The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful. The tablespace names will result in a blocking error during datapump import because of ADB limitations. The migration can be a success, both technically and functional due to datapump enhancements.

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?. Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB. Only the migration to ADB is possible from an on-premise installation of Golden Gate. Golden Gate on premise is not certified with ADB because Golden Gate Cloud Service exists for this. The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB. The described scenario is correct, can be used for migration and fallback scenarios.

Which statement is true regarding database client credentials file required to connect to your Autonomous Database?. Place the credential files on a share drive that all users can use to connect to the database. The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database. Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database. When you share the credential files with authorized users, mail the wallet password and the file in the same email.

In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?. In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition. In the TEST phase of the wizard a list is generated containing the records that would be rejected during import. In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition. In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table.

Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?. On the Autonomous Database Console. SSH keys are not required in Oracle Cloud Infrastructure. SSH keys cannot be added from console. They have to be added using REST APIs only. Navigate to Identity, select Users panel on the console and select "Add Public Key".

Which statement is true in regards to database links?. You can call PL/SQL procedures and functions using a database link. Connect from Autonomous Database to remote database using a database link. Connect to Autonomous Database from remote database using a database link. Create a database link from one Autonomous Database to another Autonomous Database instance.

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?. Using Database Configuration Assistant (DBCA) on the database server. It cannot be done. Connecting to the Cloud Infrastructure Command console via SSH wallet. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

Which Autonomous Database Cloud service ignores hints in SQL Statements by default?. Autonomous Transaction Processing. Autonomous Data Warehouse. Neither service ignores hints by default. Both services ignore hints by default.

Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?. Replicate the table using Golden Gate. Create a Data Set. Load data using Data Pump. Import Table.

Which is correct about security features that are available in Oracle Autonomous Database?. TDE but not Data Redaction. Data Redaction and TDE are both supported. Data Redaction but not TDE. Neither Data Redaction nor TDE are supported.

What is the default retention period for both Automatic and Manual Autonomous Database Backups?. One Year. 7 days. 60 days. 90 days. 30 days.

Which three statements are true regarding how Autonomous Database provides data security? (Choose three.). Data is encrypted at rest using transparent data encryption. Network connections from clients to Autonomous Database are encrypted using the client credentials wallet. Users are given OS logons or SYSDBA privileges to prevent phishing attacking. Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors.

When exporting a notebook, what type of file is created?. XML. TXT. JSON. ASCII. SQL.

What two tasks can be executed from the service console for Autonomous Databases? (Choose two.). Autonomous Databases monitoring for usage and query performance. Creating schemas. Creating and scaling of Autonomous Database service. Wizard to download connection wallet for connection from desktop tools.

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?. SCOTT. ADMIN. SYS. DWDEV.

What REST verb is used to create an Autonomous Database service using REST APIs?. A "POST" REST call. A "PUT" REST call. An "INSERT" REST call. A "GET" REST call.

Which operating system can Data Visualization Desktop be run on?. AIX. Linux. Windows. Solaris.

Which two PL/SQL functions can be used to validate an analytic view? (Choose two.). VALIDATE_LEVELS. VALIDATE_HIERARCHY. VALIDATE_DIMENSION. VALIDATE_ANALYTIC_VIEW. VALIDATE_MEASURES.

Which three tasks by default are taken care of by the Autonomous Database? (Choose three.). Backups. Firmware Patching. Data Loading. Database Upgrades. Application User Creation.

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?. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster. ADW since operational reporting is a higher priority in this scenario. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.

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?. HIGH. TP. MEDIUM. TPURGENT.

Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.). The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully. The target table will be created in Autonomous Database if it does not already exist.

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?. In Autonomous Data Warehouse direct access to the database node and the local file system is allowed. Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to. Adding, removing, or modifying tablespaces is allowed. Compression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands.

What are two security features enabled by default by the Autonomous Database? (Choose two.). Transparent Data Encryption. Encrypted Database Links. SQL Net Encryption. One SYSDBA account. Read Only access to OS Audit logs.

Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?. Original Import/Export tools. Physical migration method like database cloning. Data Pump. RMAN backup & restore.

Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.). An OCI 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 thesame region. A single fault domain can be associated with multiple regions and availability domains. Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.

Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.). through the Oracle Cloud Infrastructure service console. through SQL/Developer. using DBMS_CLOUD_ADMIN package. through SQLPIus.

Which Autonomous Database Service is NOT used to conned to an Autonomous Transaction Processing instance?. TPURGENT. MEDIUM. HIGH. TPPERFORMANT. LOY.

When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?. Storage in TB cannot be larger than the number of OCPUs. OCPUs and storage must remain in sync. Increasing OCPUs will automatically increase storage. OCPUs and storage can be scaled independently.

Which two options are available to restore an Autonomous Data Warehouse? (Choose two.). Backup and recovery must be done using Recovery Manager(RMAN). Select the snapshot of the backup. Select the archived redo logs. Select the backup from which restore needs to be done. Specify the point in time (timestamp) to restore.

Which is NOT required to connect to Autonomous Database from SQL developer?. Database name. Service name. Wallet file. Username and password.

What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database? (Choose two.). Golden Gate. Recovery Manager (RMAN). CSV files copied to Autonomous Database block storage. Data Pump.

Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure?. Terraform. REST API. Dlocker. Enterprise Manager.

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?. Create, Query, Update, List, Start. Create, Get, List, Stop, Restore. Start, Delete, Update, Query, Stop. Create, Query, List, Stop, Restore.

What two methods can you use to define Machine Learning Users? (Choose two.). Use DBMS_CLOUD_ADMIN package. SQL/Developer. Oracle Cloud Infrastructure Console. Client tools.

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.). SQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps. SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage. SQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running. SQL Developer can only export/move/import files using datapump from databases running on Linux systems.

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?. 18.1 onwards. Any version. 17.4 onwards. 12c Release 2 onwards.

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)?. Pluggable databases cannot be migrated to ADB using plug, unplug or clone. Create a database link from source database to the ADB environment and clone the PDB. Unplug to an xml file so database files and xml file can be uploaded to object storage. Unplug into a pdb archive which can be uploaded to object storage.

Which two steps are out of order when working with Oracle Machine learning? (Choose two.). Create Oracle Machine Learning User. Create workspaces. Create Notebooks. Run SQL Scripts. Create projects.

Which can be Scaled independently of the number of CPUs in an Autonomous Database?. Memory. Concurrency. Sessions. Parallelism. Storage.

Which statement about the Export Wizard used to export database objects and data is NOT correct?. If "Dependents" is checked as a DDL Option, for non-privileged users, only dependent objects in their schema are exported. Export DDL includes features such as "Show schema," "Storage," and "Terminator.". If "Grants" is checked as a DDL Option, GRANT statements are included for any grant objects on the exported objects, including those owned by the SYS schema. If "Clipboard" is selected as the "Output," the output will be placed on the system clipboard, so that it can be pasted into a file, a command line, or other location appropriate for the format.

When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?. TNSNAMES.ORA. CWALLET.SSO. OJDBC.PROPERTIES. SQLNET.ORA.

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?. Medium provides intermediate resource and concurrency, and queries run in a serial. Low provides highest concurrency, lowest resources, and DoP =1. High provides highest resources, lowest concurrency, and DoP is 1. High provides highest concurrency and lowest resources, and DoP is 1.

Topic: Database security being leveraged in ADB Which statement is true about the Security feature in the Oracle Autonomous Database?. Database clients can only connect securely using the wallet. Some connections use certificate-based authentication and SSL. Certificate-based authentication uses an encrypted key stored in a wallet on the server. Database clients can connect securely using TLS/Wallet.

Topic:Manage users and user privileges in ADB Which method can be used to connect to an Autonomous Database instance to create a database user?. Oracle Enterprise Manager Cloud Control as a system user. Autonomous Database Console as an Oracle Cloud user. SQL Developer connection as a dbadmin user. SQL*Plus connection as a sysdba. SQL Developer Web Console as an Admin user.

Topic:Auto Scaling and billing Which statement is true about the Auto Scaling feature while provisioning a Non-Free Tier Autonomous Database instance?. It is not a supported feature. It cannot be disable. It is enabled by default. It needs to be explicity enabled.

Topic: Use ADB with 3rd party software Which two valid ADB connectivity methods are used from a third-party software?. JDBC uses FastConnect only. ODBC uses SSL with public internet. SQL *Net uses SSL for encryption. .NET uses public internet only.

Topic:Load data using DBMS_CLOUD Which two can be used for troubleshooting the data load operation in the Autonomous Database?. Load operations logged in file system. Load operations logged in*_load_operations dictionary. Load files only accessible as tables. Log files accessible from file system. Log and bad files accessible as tables.

Topic: Provision a Dedicated Autonomous Database Which three selections are required for provisioning an Autonomous Database Service after login to the OCI Console?. object storage. fenant. availability domain. compartment. region. workload type.

Topic:Dedicated Infrastructure Which two satements are correct with respect to the Private Cloud setup in the Autonomous Database Dedicated deployment?. OCI Compartments are assigned to IT and end-users based on the organizational structure. You need to create private networking overlay for the organizational structure. Half rack does not offer various shapes to choose from. it is not necessary to create Compartments.

Topic: Understand OCI's infrastructure Which two features differentiate the Dedicated from the Shared Infrastructure Deployment options?. backups retention configuration. controllable software update version. availability domain placement choice. VCN and private IP connect.

Topic:Connect to an ADB service instance Which three are required to connect to the Autonomous Database instance from the SQL Developer?. Oracle cloud username and password. Oracle cloud service name. database service name. database unique name. wallet file. database username and password.

Topic: Monitor ADB performance Which metric shows the number of running SQL Statements during the selected interval in the Autonomous Database?. queued statements. SQL statements. current SQL statements. running SQL statements. top SQL statements.

Topic:OIC Polices for ADB Identify the correct policy for assigning Database Administrators to access the Autonomous Database Dedicated resources. Allow group ADB-Admins to manage autonomous-database in tenancy. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType='ADB.'. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType='ADB-D.'. Allow group ADB-Admins to manage autonomous-database in tenancy where target.worloadType='ANY.'.

Topic: Describe the options and considerations for migrating to ADB Which three considerations are necessary for migrating to the Autonomous Database?. How small is the dataset to be exported?. What is the output file format?. How large is the dataset to be imported?. Does the method support using Oracle and/or third-party Object Store?. Does the method support third-party database?.

Topic:Manage ADB Backup and Restore To configure manual backups in an Autonomous Data Warehouse instance,which one of these would you execute for creating a credential for Oracle Cloud Infrastructure Object Storage account and setting the database property to the credential?. BEGIN DBMS_CLOUD.CREATE_CREDENTIAL (credential_name=>'DEF_CRED_NAME', username=>'adwc_user@email.com', password=>'password' ); END; ALTER DATABASE PROPERTY SET default_credential ='ADMIN.DEF_CRED_NAME';. BEGIN DBMS_CLOUD.DEFINE_CREDENTIAL (credential_name=>'DEF_CRED_NAME', username=>'adwc_user@email.com', password=>'password' ); END; ALTER DATABASE PROPERTY SET default_credential ='adwc_user@email.com';. BEGIN DBMS_CLOUD.CREATE_CREDENTIAL (credential_name=>'DEF_CRED_NAME', username=>'adwc_user@email.com', password=>'password' ); END; ALTER DATABASE PROPERTY SET default_credential ='adwc_user@email.com';. BEGIN DBMS_CLOUD.DEFINE_CREDENTIAL (credential_name=>'DEF_CRED_NAME', username=>'adwc_user@email.com', password=>'password' ); END; ALTER DATABASE PROPERTY SET default_credential ='ADMIN.DEF_CRED_NAME';.

Topic: Use services in ADB Which predefined service is only applicable for the ATP Database?. CRITICAL. TP. URGENT. MEDIUM. HIGH.

Topic: Key features of ADB Which two Security features are enabled by default in the Autonorrous Database?. RMAN backups only. Oracle native network. transparent data encryption. cloud backups only. data pump export dump file.

Topic: ADB integration with the Oracle Cloud Platform Which three can be accessed via the Service Console of the Autonomous Database?. scaling CPU. database restore. enable database security. manage Oracle ML users. disable transparent data encryption.

Topic: Database security being leveraged in ADB Which statement is true about effectivety protecUng customer data in the Oracle Autonorrous Database?. Customers can identify sensitive data and mask it for use in production environments only. lt automatically identifies sensitive data and masks it for use in development environments only. Customers can identify sensitive data and mask it for use in partner or development environments. lt automatically identifies sensitive data and masks it for use in production environments only.

Topic: Load data using DBMS_CLOUD Which three source files are valid for loading data using DBMS CLOUD.COPY DATA in the Autonorrous Database?. Azure blob storage. Cloud block storage. Amazon S3 object storage. SAN or NAS storage. Oracle object storage.

Topic: Use services in ADB Which two services are applicable for both ATP and ADW Databases?. HIGH. TP. CRITICAL. URGENT. MEDIUM.

Topic: Manage ADB Backup and Restore Which two staterrents are correct about Autonorrous Database Backups?. Point-in-time recovery cannot be initiated using the Cloud console manually. Manual backups are placed in the Cloud Object Storage bucket. Manual backups are placed in ASM. The Autonomous Database automatically performs recovery of point-in-time specified . The retention period for backups is 30 days.

Topic: Provision a Dedicated Autonorrous Container Database Which is not a valid resource in the Autonorrous Database Dedicated Deployment?. autonomous container infrastructure. autonomous exadata infrastructure. autonomous container database. autonomous database.

Topic: Understand OCl's lnfrastructure Which three staternents are true about the Autonomous Database OCI lntegration?. lt allows connectivity to object stores such as Amazon S3. lt offers unlimited access to the Autonomous Database for all OCI resources. Autonomous Database is hosted in the availability domains. Backups can be accessed like any other file on object store. lts components include Oracle Machine Leaming.

Topic: Monitor ADB performance Which three tools are bundled with the Autonorrous Database?. SQL developer web. OC1 console. enterprise manager grid control. SQL developer. enterprise manager cloud control.

Topic: Key features of ADB Which three benefits are offered by the Setf-Securing capability of the Autonorrous Database?. Protection from externa! and malicious interna! threats . Sensitive data protection from privileged users . Automatic application of security updates offline. Automatic application of security updates online. Protection from externa! security threats only. Secure configuration with full database encryption.

Tapie: Architectural coíll)Onents of Autonorrous Database What is the differentiating factor between Autonormus Transaction Processing and Autonormus Database Warehouse?. provisioning database. patching database. backing up database. securing database. optimizing database workload.

Topic: Use ADB with 3rd party software Which file needs to be edited to enable a HTTP Proxy connection to an Autonormus Data Warehouse instance?. listener.ora. sqlnet.ora. tnsnames.ora. cwallet.sso.

Topic: Connect to an ADB service instance Which three can be considered as valid predefined service connection names?. DBNAME_HIGH. DBNAME_LOW. DBNAME_NONE. DBNAME_CRITICAL. DBNAME_TP. DBNAME_URGENT.

Topic: Describe the options and considerations for nigrating to ADB Which nigration approach is not supported for the Autonomous Database?. SQL developer migration workbench. datapump export/import. RMAN cross-platform backup and restore. golden gate cloud service. golden gate on-premise installation.

Topic: Architectural corrponents of Autonorrous Database Which three tasks are automatically performed by the Oracle Autonomous Database?. masking sensitive data. optimizing the workload. backing up the database. compressing historical data. patching the database.

Topic: Manage users and user privileges in ADB Which three statements are true with respect to the new Database role in the Autonorrous Database?. o lt requires a simple password. By default, the database password will not expire until 360 days.". There's no need to specify anything except the password. DWROLE includes all necessary privileges for a DW developer/user. ADBROLE includes all necessary privileges for a ADB developer/user. ADWROLE includes all necessary privileges for a ADW developer/user.

When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.). DBNAME_MEDIUM. DBNAME_HIGH. DBNAME_CONCURRENT. DBNAME_LOW.

When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?. The SQL statement is executing. The SQL statement did not complete either due to an error. The SQL statement is queued. The SQL statement completed its execution.

Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.). RMAN Cross-Platform backup and restore. Golden Gate on-premise installation. PDB unplug / plug operation. Datapump export / import. Dataguard Physical Standby. Golden Gate Cloud service.

Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing? (Choose two.). Backup Retention. Index Storage. Data Organization. Memory Usage. Undo Management.

To who, and in which order, are dedicated Exadata Infrastructure resources provisioned? (Choose the best answer.). Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator > Autonomous DB. Fleet Administrator, Autonomous Exadata Infrastructure > Database Administrator -> Autonomous Container DB -> Autonomous DB. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure. Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB.

Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.). Oracle Cloud Infrastructure Object Storage. Google Cloud Storage. Amazon S3. Azure Blob Storage. Oracle Cloud Infrastructure Object Storage Classic.

According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups. Which statement is true? (Choose the best answer.). Create at least 2 of each resource. Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised. Only 1 of each is allowed to be allocated per environment. Create a Separate VCN that contains only public subnets.

Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint? (Choose three.). Security List. Route Table. Subnet. VCN. Network Security Group.

Which three event types are supported for Autonomous Database? (Choose three.). Update IORM Begin. Maintenance Begin. Terminate End. Change Autoscaling Configuration Compartment. Change Compartment Begin.

You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX. What statement describes the step to provide the developer a new workspace in APEX? (Choose the best answer.). Create a new developer account. Access the APEX Administration Services and create the workspace for the developer. Create a database user with the APEX role. Create an IDCS user with the APEX role.

What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure? (Choose two.). Users have OS access to the database machine. It offers greater control and isolation starting at the Exadata cloud infrastructure level. Users can customize the OS stack and add additional packages. Users have SYS privileges in the database. Users can customize the maintenance schedule.

Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements Which statement is FALSE? (Choose the best answer.). Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user. Oracle Data Safe only supports Autonomous Databases. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.

Which statement is true when you provision an Autonomous Database using the cloning method? (Choose the best answer.). A clone database source can be a running database instance. A clone database source can be from a point-in-time backup that is less than 2 hours old. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database. After an Autonomous database is created using a clone, the network access option can be changed.

Which statement is NOT correct when setting up compartment quotas? (Choose the best answer.). Compartment quotas use policies that allow allocation of resources with a high level of flexibility. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending. Compartment quotas are set by Oracle. There are three types of quota policy statements which are set, unset and zero.

Which two statements are true about using an Autonomous Database with Private Endpoints? (Choose two.). Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints. You can configure Private Endpoints for an Always Free Autonomous Database. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints. An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.

How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure? (Choose the best answer.). Execute alter tablespace DATA set quota = 10G;. Execute alter tablespace for user MTHEO tablespace DATA quota = 10G;. . Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username => ‘MTHEO’,tablespace_quota => ‘UNLIMITED’);. Execute alter user MTHEO quota unlimited on tablespace DATA;.

An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB. Other than changing the shared user password, what can the admin do to protect the instance? (Choose the best answer.). Delete the user. Rotate the instance wallet and share the new wallet with the remaining users. Shutdown and restart the instance. Trust the user who left to not access the database.

Which workload type does the Autonomous Database on dedicated infrastructure service currently support? (Choose the best answer.). . Autonomous Data Warehouse only. Hybrid Columnar compression. Autonomous Transaction Processing only. ATP and ADW.

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure? (Choose two.). You have direct access to the database node. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default. Oracle Database Result Cache is enabled by default for all SQL statements. Parallelism is not enabled by default.

Which management operation is correct about Autonomous Databases on shared Exadata infrastructure? (Choose the best answer.). You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure. You can perform a “rolling restart” on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available.

While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance? (Choose the best answer.). Prior Release Update Revision (PRUR). Prior Release Update (PRU). Release Update (RU). Quarterly Bundle Patch (QBP).

When enabling auto-scaling, which three options do not change? (Choose three.). Number of OCPUs displayed in the console. Amount of storage. parallelism settings. I/O resources. Level of concurrency.

Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure? (Choose the best answer. Microsoft SQL Server (.mdf). Avro. Parquet. JSON. Text. Data Pump Export File.

Autonomous Database’s auto scaling feature allows your database to use up to three times the current base number of CPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use. Which statement is FALSE regarding the auto scaling feature? (Choose the best answer.). The base number of OCPU cores allocated to a database is not guaranteed. Auto scaling is enabled by default and can be enabled or disabled at any time. For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren’t being used by other auto scaling databases to meet high-load demands. For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.

In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization? (Choose the best answer.). Oracle Machine Learning notebook. Compartment quotas. SQL Developer Web Console. Resource Manager settings.

Which three security features are available in Oracle Autonomous Database Shared Infrastructure? (Choose three.). Data Redaction. Database Vault. Audit Vault. Customer Managed Keys. Transparent Data Encryption.

A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data. How does the developer connect to and interact with ADB from Python? (Choose the best answer.). The Oracle Client and the cx_Oracle interface for Python. You can’t use Python with ADB. SQL Developer. JAVA JDK.

Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s). How can they achieve this? (Choose the best answer.). Change the Automatic Maintenance Schedule to ‘Specify a Schedule’ but do not select any month, week or day. You cannot permanently disable scheduled Automatic Maintenance. Change the Automatic Maintenance Schedule to ‘No Preference’. Change the Automatic Maintenance Schedule to ‘None’.

Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure? (Choose the best answer.). OS command line from the database server. OCI CLI. Admin page of the Cloud Service Console. SQLDeveloper.

Which statement is correct about managing and monitoring of Autonomous Database? (Choose the best answer.). You can use Service console to enable or disable auto scaling of Autonomous DB. You can use Service console to manage runaway SQL statements on Autonomous DB. You can use Service console to move Autonomous DB between compartments. You can use Service console to create manual backups of Autonomous database.

You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service. The load on the database increases from three OCPUs to nine OCPUs. What is the total number of concurrent statements that the TPURGENT service can support? (Choose the best answer.). 2700. 1500. 900. 1800.

When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported? (Choose two.). Schemas. Tablespaces. Reports. Data.

Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment? (Choose the best answer.). Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure. Moving an Autonomous Database instance does not include its automatic backups. Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.

What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure? (Choose the best answer.). alter session set application_continuity=true. alter database set application_continuity=true. exec dbms_cloud_admin.enable_app_cont(‘<service_name>’);. alter system set application_continuity=true.

What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments? (Choose the best answer.). Fleet Administrators are responsible for patching and backups of all container databases. Fleet Administrators create, monitor and manage Autonomous Databases. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources. Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.

Which two statements are NOT correct about Autonomous Database Maintenance on dedicated Exadata infrastructure? (Choose two.). Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter. You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the samequarter. Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates), and include database patching.

Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database? (Choose two.). Transparent Data Encryption. Exadata. Active Data Guard. RAC, but only when scaling beyond 16 OCPUs. Multitenant.

When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata? (Choose the best answer.). Under Core Infrastructure then Compute then Autonomous Exadata. Under Database then Autonomous Transaction Processing then Autonomous Exadata. Under Solutions and Platform then Platform Services then Autonomous Exadata. Under Core Infrastructure then Autonomous Exadata.

You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism. Which service will you need to connect to? (Choose the best answer.). TP. Low. MEDIUM. TPURGENT.

For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned? (Choose the best answer.). Allow group ADB-Admins to manage autonomous-database-family in tenancy. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘DW’. Allow group ADB-Admins to manage autonomous-database in tenancy. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘OLTP’.

The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources? (Choose the best answer.). Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata InfrastructureD. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure.

During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure? (Choose the best answer.). . the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment. the ‘High Availability Container Database’ in which the Autonomous instance should run. the Client Credentials wallet which is used to connect to the Autonomous Database. the name or OCID of the Exadata infrastructure which was assigned by the Fleet AdministratorE. the Listener endpoint where the Autonomous Database should register on.

Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse? (Choose the best answer.). Process includes identify candidates, create invisible auto indexes, verify with implement if performance improved and delete unused. You can control behavior at the statement level using the USE_AUTO_INDEXES or NO_USE_AUTO_INDEXES hints. You can use the DBMS_AUTO_INDEX package to report on the automatic task and to set your preferences. The indexing feature is implemented as an automatic task that runs at a fixed interval. It is enabled by default.

Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option? (Choose two.). All OML notebooks are cloned. All resource management rules are cloned. All underlying data for OML notebooks is cloned. Current settings for ACLs are cloned. Clone can be in a different region.

You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web. What steps do you need to take? (Choose the best answer.). Create an IDCS user. Create a database user with connect, resource, and object privileges. Create a database user with the default privileges. Create a database user with connect, resource, and object privileges. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.

Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database? (Choose the best answer.). A Private Endpoint is required to connect to the Shared-Autonomous Database. The Autonomous Database must belong to a Network Security Group (NSG). The Autonomous Database must be in the same VCN and Subnet as the Compute instance. The OCI compute instance can be used with an Always-Free Autonomous Database account. The OCI compute instance does not support connecting to a Shared Autonomous Database.

You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements: Autonomous Transaction Processing License Included Shared Infrastructure Which parameter would you NOT use? (Choose the best answer.). license-model. is-dedicated. db-type. . db-workload.