CREATE TEST

ERASED TEST, YOU MAY BE INTERESTED ON Oracle AD No Random

COMMENTS	STATISTICS	RECORDS

TAKE THE TEST

Title of test: Oracle AD No Random Description: Test Exam Author: DC Other tests from this author Creation Date: 09/12/2021 Category: Others Number of questions: 60

Share the Test:

New Comment

No comments about this test.

Content:

You see a clock icon in the Status column on the SQL Monitoring tab of the Performance Hub. What does it indicate? The SQL statement completed its execution The SQL statement is executing The SQL statement is queued The SQL statement did not complete due to an error. Which three event types are supported for Autonomous Database? (Choose all correct answers) Change Autoscaling Configuration Compartment Update 1oRM Begin Maintenance Begin Terminate End Change Compartment Begin. You have a requirement to create an Autonomous Transaction Processing database that can support up. to 300 concurrent statements per OCPU as well as parallelism. Which service will you need to connect to? TP Low TPURGENT MEDIUM. Which two actions are available to perform when an Autonomous Database is stopped? (Choose all correct answers) update License Type update Network Access Change administrator password Start. When cloning from a backup, what is the earliest timestamp of the backup allowed? 2 hours 1 hour 24 hours 30 minutes. Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure? cpu Utilization, Storage Utilization Query Latency, User Calls, Execute Count Transaction Count, Session, Running Statements IOPS, Storage Space Used By Tablespace, Apply and Transport Lag Dedicated. Which three tools can be used to monitor the usage and activities of Autonomous Database on Infrastructure? (Choose all correct answers) Performance Hub rman oci metrics Enterprise Manager Cloud Control LOGS. Which Database Actions tool is used to get information about the entities in your Oracle Autonomous Database and to see the effect that changing an object has on other objects? Data Load Catalog Data Insights JOSN. Which two license types does a customer need to benefit from Bring Your Own License (BYOL) when leveraging on-premises Enterprise Database licenses in Oracle Autonomous Database? (Choose all correct answers) eExadata Muttitenant active Data Guard Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs transparent Data Encryption (TDE). Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint? (Choose all correct answers) Subnet Route Table vcn network Security Group security List. In the Autonomous Database on Dedicated Infrastructure service, what does the fleet administrator use to control OCPU utilization? SQL Develope Web Console Compartment quotas Resource Manager settings oracle Machine Learning notebook. Autonomous Database's auto scaling feature allows your databa base number of OCPU cores at any time. As demand increases, auto number of cores in use. Likewise, as demand drops, auto scaling automatically cores in use. Which statement is FALSE regarding the auto scaling feature? The base number of OCPU core allocated to a database is not guaranteed 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. 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 available to a database depends on the total number of cores available in the Exadata infrastructure instance. 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? the Listener endpoint where the Autonomous Database should register on the container database in which the Autonomous instance should run the compartment of the dedicated infrastructure because each compartment only runs one dedicated enviorement the Client Credentials wallet, which is used to connect to the Autonomous Database. Which three are Oracle-recommended best practices for Autonomous Database alarms? (Choose all correct answers) Create a single alarm for each metric Routinely tune you alarms Use a single interval for all alarms Select the correct alarm interval for you metric Create multiple alarm metrics Suppress alarms during investigations. You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do? create an Oracle Cloud Infrastructure Alarm for Shutdown metric Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END" create a notification alert using DBMS_SNMP package. Which statement is FALSE about Oracle Autonomous JSON Database? JSON data in stored natively in the database You can promote Autonomous JSON Database to Autonomous Transaction Processing It supports NoSQt-style, document-centric applications There is a 20 GB limit on JSON collections. While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented? 60 days 15 days 7 days 120 days. Which is NOT needed to manage Oracle Autonomous Database with REST APIs? Fingerprint of the public key Tenancy's OCID User's OCID Database ADMIN password. Which three of the following data sources are available when using the Data Load page on Database Actions? (Choose all correct answers) REST endpoints Backup files in block storage Local Files Files in Oracle Cloud Storage Files in AWS S3 Storage. Which statement is correct about the Service console in an Autonomous Database? you can use the Service console to create manual backups of an Autonomous Database you can use the Service console to move an Autonomous Database between compartments You can use the Service console to manage runaway SQL statements on an Autonomous Database You can use the Service console to enable or disable autoscalling of an Autonomous Database . Which three options do NOT change when enabling auto scaling? (Choose all correct answers) I/O resources Parallelism settings amount of storage Level of concurrency. Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure? inside the Autonomous Database wallet in a separate key vault external to the Exadata infrastructure inside the backups of the container database on the Exadata infrastructure where Autonomous Database Dedicated is hosted. Which three advanced options can you enable or disable while creating a business model? (Choose all correct answers) analytic View Transparency Views Display private tables Autonomous Aggregate Cache Analytic View Base Table Query Transformations Business Object Security Feature. You have been tasked with analyzing a year's worth of sales data stored in an Autonomous Data Warehouse instance. Which tool would you use to automate data exploration and create pivot tables? APEX SQL Developer Web Business Models bata Load. What happens with the standby database when disabling Autonomous Data Guard? The standby database is started read/write The standby database is terminated The standby database is started read-only The standby database is transformed in a refreshable clone. Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is Stopped. Which statement is true? Failover is automatically initiated The standby database is also stopped The standby database is terminated Switchover is automatically initiated. Which statement is FALSE about setting up compartment quotas? Compartment quotas use policies that allow allocation of resources with a high level of flexibility You cannot manage quotas in a compartment, unless you belong to a group that has the correct permissions Compartment quotas cannot be set on the root compartments Quotas set on a parent compartment override quotas set on child compartments. Which statement is FALSE about Oracle Data Safe? It helps you evaluate risks to data, assess user security, monitor user activity, and address data security compliance requirements It evaluates user types, how users are authenticated, and the password policies assigned to each user It supports only Autonomous Database It helps you asses the security of your cloud database configurations by analyzing database configurations It helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary . Which option should you use to create a graph with Graph Studio? A graph license key Tables in an Autonomous Database instance Graph created by a special tool downloaded from oracle.com Graph analytics algorithms NoSQL configuration. Which three are use cases for Graph Studio? (Choose all correct answers) clustring facial recognition Churn analysis Pattern matching 3-D modeling. Which two of the following statements are correct? (Choose all correct answers) all of the capabilities of ODI Classic are available with ODI Web Edition ODI Web Edition is available only on Oracle Linux ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace The Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition. Which four file formats are supported when loading data from Cloud Storage? (Choose all correct answers) AVRO JSON DOC DDL CSV PARQUET. In which four ways can Oracle Database optimally access data in Object Storage? (Choose all correct answers) scan avoidance using columnar pruning for .csv files optimized data archive using hybrid partitioned tables scan avoidance using columnar pruning for columnar stores like parquet and orc optimized data archive using partitioned external tables scan avoidance using partitioned external tables scan avoidance using block skipping when reading parquet and orc files. Which statement is true about the use of Access Control Lists (ACLs) with an Autonomous Database on Shared Infrastructure? when you restore a database, the existing ACLs are not overwritten by the restore an ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure an ACL can be set up for an IP address or a virtual cloud network (VCN) but not both at the same time ACLs can only be used with private endpoints. Which two statements are true about using an Oracle Autonomous Database with private endpoints? (Choose all correct answers) an Autonomous Database with private endpoints can be accessed from the public Internet by adding your IP address yo an Access Control List A Network Security Group is required within your virtual cloud network before you can provision a Shared Autonomous Database to use private endpoints You can configure private endpoints for an Always Free Autonomous Database private endpoints can be configured when you clone an Autonomous Database on Shared Infrastructure that was liq initially created with public endpoints. Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure? The Autonomous Database must belong to a Network Security Group (NSG). O A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image The marketplace OCI image can be used with an Always Free Autonomous Database account The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure. 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? using JDBC Driver using SQL Developer using the Oracle Client and the cx_Oracle interface using the Oracle Client and the DBD-Oracle interface. An Autonomous Database (ADB) user with an instance wallet has left the company. The user had shared a database user ID with other users when accessing ADB. Other than changing the shared user password, what can an administrator do to protect the instance? Delete the user Trust the user who left to not access the database Rotate the instance wallet and share the new wallet with the remaining users Shut down and restart the instance. Which stage of the indexing pipeline divides text into tokens? FILTER sectioner LEXER ToxeNrzER. Which two methods can you use to create database users and grant roles in Autonomous Database services? (Choose all correct answers) SQL Developer the pams_cnoup_apmrn package SQL*Plus the Oracle Cloud Infrastructure service console. Which method will NOT permit you to change the database apsrn user's password of an Oracle Autonomous Database on Shared Infrastructure? OS command line from the database server SQL Developer OCI CLI Admin page of the Cloud Service Console. Which two options are available to restore an Oracle Autonomous Database? (Choose all correct answers) Specify the archived custom image Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up Select the snapshot of the backup Specify the point in time (timestamp) to restore Select the backup from which restore needs to be done. What are two differentiators of Oracle Autonomous Database on Dedicated Infrastructure? (Choose all correct answers) users have OS access to the database machine users can customize the OS stack and add additional packages Users have more control over the maintenance schedule users have sys privileges in the database to offers greater control and Isolation starting at the Exadata cloud infrastructure level . Your customer has upgraded their on-premises 11.2 Database to 12.2. Dui 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)? RO Unplug into an XML file so database files and XML file can be uploaded to object storage Create a database link from the source database to the ADB environment and clone the PDB Unplug into a PDB archive, which can be uploaded to object storage Pluggable databases cannot be migrated to ADB using plug, unplug, or clone. How do you change the tablespace quota for user mrizo on Autonomous Database on Shared Infrastructure? execute alter database for user MTHEO tablespace DATA quota = 10G; execute alter user MTHEO quota unlimited on tablespace DATA; Execute nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username => 'MTHEO', tablespace quota ~> "UNLIMITED"); Execute alter tablespace DATA set quota = 10G;. Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated? Quarter of the Year, Month of the Quarter, Date of the Month, Star Hour Month of the Quarter, Week of the Month, Day of the week, Start Hour Month of the Year, Week of the Month, Day of the Week, Start Hour Week of the Quarter, Day of the week, Strat Hour. Which two statements are true about Data Insights? (Choose all correct answers) Data Insights is available with on-premises deployments of Oracle Database You can retrieve previously executed Data Insights searches Data Insights is an additional priced option you can search for Data Insights against a base table or business model. Which native data type is used to store spatial information? spo_GroMeTry spo_retate Geo_sson spo_nocaTron. Which command should you issue to enable application continuity on Oracle Autonomous Database on Shared Infrastructure? alter system set application_continuity-true alter session set application_continuity=true exec dbms_cloud_admin.enable_app_cont(''); alter database set application_continuity-true. You need to create a new database by using the Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI) with the following requirements: Autonomous Transaction Processing License Included Shared Infrastructure Which parameter would you NOT use? db-workload is-dedicated License-model db-type. Which statement is correct with respect to the required action to move Oracle Autonomous Database resources to a different compartment? 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 You do not need to have sufficient access permissions on the compartment that the resource is being moved to Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remai their current compartments. Which is a difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases? only ATP manages optimizer statistics Only ADW uses columnar compression by default only ATP supports automatic backups Only ADW supports autoscaling. Which two cloud services are supported to import Data Pump files to Autonomou! Infrastructure? (Choose all correct answers) azure Blob Storage Google Cloud Storage oracle Cloud Infrastructure Object Storage Classic amazon S3 oracle Cloud Infrastructure Object Storage. Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose all correct answers) use oracle Zero Downtime Migration (ZDM) use GoldenGate use SFTP to copy CSV file into Autonomous Database Use Data Pump Use Recovery Manager (RMAN). Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure? autonomous Exadata infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates) and include container database patching If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarte 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 same quarter Autonomous Exadata infrastructure maintenance takes place at least once each quarter . Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources? Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator and Database Administrator Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous infrastructure Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure . 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 Autonomous Database's Data Tools. Which steps do you need to perform? Create a database user with the default privileges Create a REST-enabled database user (with connect and object privileges) and grant the pwRole role Create a database user with connect, resource, and object privileges Create an IDCS user. Create a database user with connect, resource, and object privileges . Which two statements are true about accessing Autonomous Database Tools? (Choose all correct answers) SQL Developer Web is available exclusively on the Autonomous Database Oracle APEX can be accessed only from the Developer menu in the Service Console Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database Database Actions is accessible from server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpoint networking Access to Database Actions is available for all users of Autonomous Database. Which three options are available to access data in an Autonomous JSON Database? (Choose all correct answers) oracle Cloud Infrastructure console using the JSON Online Developer tool Regular Oracle SQL statements using a connection through the listener REST API calls to the database ( not enabled by default) oracle JSON Developer tool downloaded from OTN NoSQ-statements using Oracle SODA drivers. A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment. What should they do to remove this bottleneck? Run the pBMS_CLOUD.INCREASE_THROUGHPUT procedure Ask Support to migrate their setup to a node without noisy neighbors Increase the number of OCPUs allocated to the database Remove any non-JSON data from the database.

Report abuse