Cuestiones
ayuda
option
Mi Daypo

TEST BORRADO, QUIZÁS LE INTERESEOracle Autonomous Database Cloud 2020 Specialist (1Z0-931)

COMENTARIOS ESTADÍSTICAS RÉCORDS
REALIZAR TEST
Título del test:
Oracle Autonomous Database Cloud 2020 Specialist (1Z0-931)

Descripción:
Exam Oracle Autonomous Database Cloud 2020 Specialist (1Z0-931)

Autor:
AVATAR

Fecha de Creación:
30/06/2021

Categoría:
Informática

Número preguntas: 60
Comparte el test:
Facebook
Twitter
Whatsapp
Comparte el test:
Facebook
Twitter
Whatsapp
Últimos Comentarios
No hay ningún comentario sobre este test.
Temario:
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 s using DBMS_CLOUD_ADMIN package through SQLPIus .
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure? alter database set application_continuity=true alter session set application_continuity=true exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ; alter system set application_continuity=true .
In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization? Oracle Machine Learning notebook Compartment quotas Resource Manager settings SQL Developer Web Console .
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 three security features are available in Oracle Autonomous Database Shared Infrastructure? Transparent Data Encryption Database Vault Customer Managed Keys Data Redaction Audit Vault .
How do you change the tablespace quota for a user 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 DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => 'UNLIMITED*); Execute alter tablespace DATA set quota = 10G;.
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure? Data Pump Export File Avro Parquet Text JSON Microsoft SQL Server (.mdf).
Which statement is correct about managing and monitoring of Autonomous Database? You can use Service console to move Autonomous DB between compartments. You can use Service console to create manual backups of Autonomous database. 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.
Which statement is true when you provision an Autonomous Database using the cloning method? After an Autonomous database is created using a clone, the network access option can be changed. 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.
For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access? SQLDEV_ADMIN.GRANT_SCHEMA ORDS_ADMIN.ENABLE_SCHEM ORDS_ADMIN.GRANT_SCHEMA ORDS_PRIV.ENABLE_SCHEMA.
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.
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? Create a separate VCN that contains only public subnets Only 1 of each is allowed to be allocated per environment. Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised. Create at least 2 of each resource.
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? Oracle Data Safe only supports Autonomous Databases. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.
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? 900 1800 2700 1500.
Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment? 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. 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. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.
Which statement is NOT correct when setting up compartment quotas? There are three types of quota policy statements which are set, unset and zero. 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.
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata? Under Core Infrastructure then Compute then Autonomous Exadata Under Solutions and Platform then Platform Services then Autonomous Exadata Under Database then Autonomous Transaction Processing then Autonomous Exadata Under Core Infrastructure then Autonomous Exadata.
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 completed its execution. The SQL statement is executing. The SQL statement is queued. The SQL statement did not complete either due to an error.
For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned? 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-family in tenancy. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'.
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 statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure? If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory. 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 runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates), and include database patching.
When enabling auto-scaling, which three options do not change? Number of OCPUs displayed in the console. Amount of storage. I/O resources parallelism settings Level of concurrency.
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console? It cannot be done. Using Database Configuration Assistant (DBCA) on the database server. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls. Connecting to the Cloud Infrastructure Command console via SSH wallet.
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse? Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused. You can use the dbms_auto_index package to report on the automatic task and to set your preferences. It is enabled by default. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints. The indexing feature is implemented as an automatic task that runs at a fixed interval.
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources? . Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator, Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure.
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database? Exadata Active Data Guard RAC, but only when scaling beyond 16 OCPUs Transparent Data Encryption Multitenant.
What are three methods to load data into the Autonomous Database? Oracle GoldenGate Transportable Tablespace RMAN Restore Oracle Data Pump SQL*Loader.
Which three event types are supported for Autonomous Database? Terminate End Maintenance Begin Change Compartment Begin Change Autoscaling Configuration Compartment Update IORM Begin.
Which two are correct actions to take in order to Download the Autonomous Database Credentials? 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. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance? TPPERFORMANT MEDIUM HIGH LOW TPURGENT.
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? db-workload is-dedicated db-type license-model.
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 TWO statements are TRUE about using an Autonomous Database with Private Endpoints . 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. 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.
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? Trust the user who left to not access the database. Shutdown and restart the instance. Rotate the instance wallet and share the new wallet with the remaining users. Delete the user.
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? Release Update (RU) Prior Release Update Revision (PRUR) Prior Release Update (PRU) Quarterly Bundle Patch (QBP).
Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure? Parallelism is not enabled by default 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. You have direct access to the database node.
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? 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 highload demands. The base number of OCPU cores allocated to a database is not guaranteed. 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. Auto scaling is enabled by default and can be enabled or disabled at any time.
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? SQL Developer JAVA JDK You can't use Python with ADB. The Oracle Client and the cx_Oracle interface for Python.
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 name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator. the Client Credentials wallet which is used to connect to the Autonomous Database. the 'High Availability Container Database' in which the Autonomous instance should run. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment the Listener endpoint where the Autonomous Database should register on.
Which workload type does the Autonomous Database on dedicated infrastructure service currently support? Autonomous Transaction Processing only ATP and ADW Autonomous Data Warehouse only Hybrid Columnar compression.
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? TPURGENT TP MEDIUM LOW.
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure? Admin page of the Cloud Service Console OCI CLI OS command line from the database server SQLDeveloper.
Which management operation is correct about Autonomous Databases on shared Exadata infrastructure? 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.
To who, and in which order, are dedicated Exadata Infrastructure resources provisioned? Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB.
Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database? The Autonomous Database must be in the same VCN and Subnet as the Compute instance. The OCI compute instance does not support connecting to a Shared Autonomous Database. The Autonomous Database must belong to a Network Security Group (NSG). The OCI compute instance can be used with an Always-Free Autonomous Database account. A Private Endpoint is required to connect to the Shared-Autonomous Database.
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option? Current settings for ACLs are cloned. Clone can be in a different region. All OML notebooks are cloned. All underlying data for OML notebooks is cloned. All resource management rules are cloned.
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint? Network Security Group Security List VCN Route Table Subnet.
Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s). How can they achieve this? Change the Automatic Maintenance Schedule to 'None'd. 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'.
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.
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.
Which statement is true when the Autonomous Database has auto scaling enabled? Database concurrency is scaled up when needed by the workload. Increases the number of sessions available to the database. Scales the PGA and © size when needed for the workload. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.
What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments? Fleet Administrator defines and gains access to the ADMIN administrative user account for the database. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources. Fleet Administrators are responsible for patching and backups of all container databases. Fleet Administrators create, monitor and manage Autonomous Databases.
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? Create an IDCS user with the APEX role. Access the APEX Administration Services and create the workspace for the developer. Create a new developer account. Create a database user with the APEX role.
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 a badfile 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.
What is the default port number for accessing a newly created Autonomous Database? 1524 1522 1521 1523 1526.
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure? Users have OS access to the database machine. Users can customize the maintenance schedule. It offers greater control and isolation starting at the Exadata cloud infrastructure level. Users have SYS privileges in the database. Users can customize the OS stack and add additional packages.
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported? Data Schemas Tablespaces Reports.
What REST verb is used to create an Autonomous Database service using REST APIs? An 'INSERT' REST call A 'GET' REST call A 'POST' REST call A 'PUT' REST call.
What is the correct way to list all files in the default data pump directory? By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR'); You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW). Log onto ADW server and issue is -al on the command line. By executing select * from utl_file . list ( 'DATA_PUMP_DIR ' ) ;.
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? 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. Create a database user with the default privileges. Create a database user with connect, resource, and object privileges. Create an IDCS user. Create a database user with connect, resource, and object privileges.
Denunciar test Consentimiento Condiciones de uso