CREAR TEST

TEST BORRADO, QUIZÁS LE INTERESE: 1Z0-1093-23

COMENTARIOS	ESTADÍSTICAS	RÉCORDS

REALIZAR TEST

Título del Test: 1Z0-1093-23 Descripción: Examen OCI 2023 Autor: rjayalan OTROS TESTS DEL AUTOR Fecha de Creación: 11/09/2024 Categoría: Informática Número Preguntas: 71

COMPARTE EL TEST

COMENTAR

No hay ningún comentario sobre este test.

Temario:

How many DB systems must you provision before you can enable Oracle Data Guard for a virtual machine DB system database? Three, first for the primary database, second for the standby database, and a third for the staging database in the Oracle Data Guard configuration. TWo for both the primary and standby database, because a DB system with the database that you want to use as the standby must already exist before you enable Oracle Data Guard. One with the primary database, because a new DB system with the standby database is created and associated with the primary database when you enable Oracle Data Guard. It depends on how many standby databases you want for your primary database in the Oracle Data Guard configuration in Oracle Cloud Infrastructure. Which FOUR storage options are available in Oracle Cloud Infrastructure (OCI)? (Choose all correct answers) EBS Storage EFS Storage Local storage Block Storage File Storage Object Storage. The /u02 directory containing Oracle Homes (OH) is 80% utilized and you need to free up space in it. you own two Oracle Homes (OH193_A and OH193_B), each with a test database (193A and 193B respectively). You decide to consolidate both databases into a single Oracle Home (OH193. |_A) to free up space. Which TWO actions must you perform? (Choose all correct answers) Copy the sqinet.ora file from OH193_B to OH193_A. use the Move Database option from the console. Schedule a downtime window with the Test teams who use the 193B database. Create a new container under 0H193B and migrate the pluggable databases (PDBs) from 193B to 193A. You want to stops unauthorized attempts from the operating system to access database data stored in files. Which actions must you perform to encrypt data in the database data files and in backups? You enable automatic backups on your Exadata Cloud@Customer. database control files server parameter file (SP file) Transparent Data Encryption (TDE) keystore (wallet) database archivelog files. After you have provisioned a virtual machine (VM) database (DB) system, what action can you take to meet changes in block storage requirements? Only bare metal DB systems can increase block storage at any time without impacting the system. If a vm DB system requires more block storage, increase the storage at any time without impacting the system. If a vm DB system has different requirements for block storage, increase or decrease the storage at any time without impacting the system. After you have provisioned a VM DB system, you cannot increase or decrease block storage. Which is NOT a prerequisite for patching Grid Infrastructure or database homes when using the console? Oracle Clusterware is down on the VM cluster. All database compute nodes of the VM cluster are up and running. The required patch is available on the Control Plane server. The /u01 directory on the database host file system has at least 15 GB of free space for the execution of Patching processes. What THREE steps must you perform to connect to a MySQL database in the database system by using SSH and MySQL Shell? Connect to the MySQL Database Service instance. Instantiate MySQL Shell on the MySQL database system instance. Start MySQL Shell on the compute instance. SSH into the compute instance from your local machine. Add an ingress rule for port 20. You want to permanently delete the DB System and its attached HeatWave cluster. Which action should you perform? Terminate the DB system and drop the associated HeatWave Cluster. Drop the DB system and terminate the associated HeatWave Cluster. Delete the Heatwave Cluster and it will also delete the DB system. Delete the DB system and it will also delete the attached HeatWave Cluster. In addition to the automatic backup of your Oracle Database associated with a database deployment, you are planning to take an on-demand backup of a database on Exadata Cloud Service. How do you do this? Use the Create Backup button in the backup section of the Database Details page. Disable the automatic backup configuration and then take an on-demand backup. Perform a recovery operation to a specific long-term backup. First connect to the Exadata Cloud Instance as the oracle user and then take a backup. What information is required to connect to the NoSQL Database Cloud Service? API signing key, admin ID, user ID tenancy 1D, passphrase, handshake key signing key fingerprint, API signing key, tenancy OCID user ID, tenancy ID, component ID. What is the NoSQLHandle interface NOT used for? to set the row retention time to gets rows from a table to get dynamic information on a table to access multiple tables. You have permanently deleted your MySQL database system. What happens to the two backups that are associated with the deleted database system? They are archived and moved to Oracle Cloud Infrastructure file storage. They are retained for their retention periods. They are automatically deleted along with the database system. They are moved to Oracle Cloud Infrastructure Object Storage. Your MySQL Database Service system is automatically backed up between midnight and 1 AM. What must you do to change the starting time to 4 AM? Select Backup Window from the Edit MySQL DB System Details page and set the start time to 4 AM. Use the mysqlbackup command to establish a 4 AM backup start time. Update the Oracle Cloud Infrastructure (OCI) MySQL DB System Details page to specify the 4 AM backup window start time. Edit the OCI MySQL DB System Details to set the Enable Automatic Backups time to 4 AM. What statement is FALSE regarding the differences between the Exadata Cloud@Customer X8M and X8 Infrastructure? X8 uses InfiniBand for its internal network fabric whereas X8M uses RoCE. Both X8M and X8 Exadata System models use InfiniBand for their internal network fabric. X8M has more total OCPUs available than an equivalent X8 configuration. X8M uses Persistent Memory (PMEM). Which two external databases can be monitored by the Oracle Cloud Infrastructure (OCI) Database Management Service? (Choose two.) Oracle 18c Database deployed on Oracle Exadata Cloud@Customer Oracle Autonomous Database 19c deployed on an OCI Tenant Oracle 12cR1 Database deployed on an Oracle Exadata Database Machine Oracle 11gR2 Database deployed on an Oracle Private Cloud. You define a maintenance window for your MySQL DB systems. When the automatic maintenance process takes place, which two activities does the system perform while its status is set to UPDATING? It upgrades the associated compute instance to the latest Linux operating system version. It analyzes, rebuilds, and optimizes MySQL database tables and indexes. It patches the MySQL server itself along with any underlying hardware. It patches the underlying operating system of the MySQL database. Which two use cases can be used by the Oracle database with Object Storage in Oracle Cloud Infrastructure (OCI)? (Choose two.) Database datafiles Database backups Database log files Database binaries. How many IPs are required for the Backup Subnet supporting an Exadata Database Service with six Database Compute Servers? 12 9 16 24. Which two statements are true about recommended Subnet configurations for Exadata Database Service? (Choose two.) Use Regional Subnets for both Client and Backup. Use a Public Subnet for Client and a Service Subnet for Backup. Use a Private Subnet for Client and a Service Subnet for Backup. Use two Public Subnets for Client and Backup. Use a Private Subnet for Client and Private Subnet for Backup. Which three statements are true about Exadata Snapshots on the Exadata Database Service? (Choose three.) Exadata Snapshots utilize the Exadata SPARSE disk group to store the sparse files that contain all the data that is read and written by the Snapshots. Exadata Snapshots are unable to utilize all the Exadata features. Exadata Snapshots utilize the Exadata SPARSE disk group to store the sparse files that contain only changed blocks. Multiple users can create independent Exadata Snapshots from the same test master, which is a full Read-Only clone of the source database. Before creating Exadata Snapshots from the test master, you can modify the data in the test master, if required. You want to check if cloud tools are up-to-date in Exadata Database Service. Which two steps should you perform to obtain the current version of cloud tooling on a database server? (Choose two.) You must first connect to Exadata Cloud Service as the oracle user. Run the dbaascli patch tools list command. You must first connect to Exadata Cloud Service as opc and sudo to the root user. Run the rpm -qa|grep -i dbaastools_exadata command. Which two tools are used to monitor Exadata Database Service? (Choose two.) Oracle Enterprise Manager Oracle Management Cloud Oracle Cloud Monitor Oracle Internet Monitoring Suite (IMS) Service Console. Which tool can be used to monitor a storage server in Exadata Database Service? dbaascli exacli OCI CLI ocpucli. You are asked to measure useful quantitative data about a MySQL Database Service system. You must provide information such as current connection information, statement activity, latency, and host OCPU, memory, and disk I/O utilization. Which three Oracle Cloud Infrastructure monitoring methods should you use? (Choose three.) Notifications Data points Data points Metrics Queries. Which two must you create or configure to manage an external database? (Choose two.) A dynamic group A database handle A database group A database connection. In which case can you fast provision a virtual machine (VM) database (DB) systems, using Logical Volume Manager (LVM) for storage management? Oracle Database versions 18c and greater Oracle Database versions 12.2 and greater Oracle Databases that could use Automatic Storage Management any currently supported release of the Oracle Database. Which vaults are used for storing customer-managed encryption keys for Autonomous Database on Dedicated Infrastructure? Oracle Database Vault, Oracle Key Vault Oracle Audit Vault, Oracle Key Vault Oracle Cloud Infrastructure Vault, Oracle Database Vault Oracle Key Vault, Oracle Cloud Infrastructure Vault. Which two are ways Oracle Database can optimally access data in Object Storage? (Choose two.) Scan avoidance using partitioned external tables Optimized data archive using partitioned external tables Optimized data archive using hybrid partitioned tables Scan avoidance using columnar pruning for .csv files. 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 nonpeak hours. The architecture team is debating whether such reports should be run on the online transaction processing (OLTP) database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and 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? It is best to build a separate data warehouse, and move the OLTP data on a nightly basis. Use Autonomous Transaction Processing (ATP) with "tpurgent" and "high" TNS services to separate connection types. Use Autonomous Data Warehouse (ADW) because operational reporting is a higher priority this scenario. The application should be deployed on a Kubernetes Cluster because it needs to be highly available. Which statement is correct with respect to the required action to move Oracle Autonomous Database resources to a different compartment? You do not require sufficient access permissions on the compartment that the resource is being moved to. 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. Moving the compartment of the Autonomous Database also moves the Autonomous Container Database and Autonomous Exadata Infrastructure. Which statement is true when the Autonomous Database has auto scaling enabled? It scales the PGA and SGA size when needed for the workload. Database concurrency is scaled up when needed by the workload. It enables the database to use up to 3x OCPU/IO resources immediately when needed by the workload. It increases the number of sessions available to the database. Which statement is true about the use of Access Control Lists (ACLs) with an Autonomous Database on Shared Infrastructure? 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 for both at the same time. ACLs can only be used with private endpoints. When you restore a database, the existing ACLs are not overwritten by the restore action. Your company has a .NET application and wants to deploy it on Autonomous Database (ADB). What software is used to connect to ADB from the .NET application? SQL*Plus Java You cannot use .NET with ADB. Oracle Data Access Components for Windows. A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck in the storage I/Os of their environment. What should they do to remove this bottleneck? Run the DBMS_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. Which two of the following data sources are available when using the Data Load page on Database Actions? (Choose two.) Backup files in block storage REST endpoints Local Files Files in Oracle Cloud Storage. Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing? (Choose two.) Memory Usage Backup Retention Undo Management Data Organization. Which statement is FALSE about Data Insights? Data Insights provides a wide range of graphical data presentation capabilities. Data insights are automatically generated by various analytic functions built into the database. The results of the insight analysis appear as a series of bar charts in the Data Insights dashboard. Data Insights displays information about patterns and anomalies in the data of entities in your Oracle Autonomous Database. Which three operations are available for a quarterly maintenance update on Autonomous Container Database? (Choose three.) Reschedule and patch immediately. Patch immediately. Reschedule patching. Skip patching. Apply a partial patch. Which set of Oracle Cloud Infrastructure (OCI) metrics is available only for Autonomous Database on Dedicated Infrastructure? CPU Utilization, Storage Utilization Transaction Count, Sessions, Running Statements Query Latency, User Calls, Execute Count IOPS, Storage Space Used By Tablespace, Apply and Transport Lag. Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources? Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator. Which option should you use to create a graph with Graph Studio? Graph analytics algorithms NoSQL configuration Tables in an Autonomous Database instance Graph created by a special tool downloaded from orade.com A graph license key. Which API is NOT available for developing with spatial on ADB? REST Python Java PL/SQL Gremlin. What can you do with graphs? (Choose two.) Find patterns that are anomalous and use that to detect fraud. 3-D modeling Product recommendations Facial recognition. Which two options are available for restoring an Autonomous Database? (Choose two.) Selecting the snapshot of the backup. Specifying the archived custom image. Using Recovery Manager (RMAN) to connect to Autonomous Database and back it up. Selecting the backup from which restore needs to be done. Specifying the point in time (timestamp) to restore. You see a clock icon in the Status column on the SQL Monitoring tab of 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. You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do? Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database. Create a notification alert using DBMS_SNMP package. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END." Create an Oracle Cloud Infrastructure Alarm for Shutdown metric. Oracle offers a range of Database Services in Oracle Cloud. Which Database Service is built on standard compute and storage options, offers both Oracle Database Standard and Enterprise Edition, and is typically for workloads with smaller processing and storage requirements? Exadata Cloud@Customer Exadata Database Service Autonomous Database Base Database Service. Oracle Base Database Service provides a License-included Oracle Database consumption option. There are four licensing tiers of functionality to meet application-specific requirements. Which licensing tier has the Active Data Guard, RAC, and Database In-Memory features? Enterprise Edition High Performance Standard Edition 2 Enterprise Edition Enterprise Edition Extreme Performance. Which three of the following does Base Database Service use to provide high availability and disaster recovery? Regions Availability domains Compute Instances Virtual Cloud Networks Fault domains. Which two must first be in place in order to create an Exadata Database Service Instance? You need to define the VCN, Private Client Subnet, and Private Backup Subnet. It is recommended to use a Private Subnet for Client and Service Subnet for Backup. You need to create an Exadata Infrastructure and VM Cluster resource. It is recommended to use a Public Subnet for Client and Service Subnet for Backup. It is recommended to use a Public Subnet for Client and Service Subnet for Backup. Which OCI Management interface allows you to build and deploy apps that integrate with Oracle Cloud Infrastructure services? Oracle Cloud REST APIs Command Line Interface (CLI) Terraform and Ansible Software Development Kit (SDK). MySQL HeatWave offers three flexible deployment options. Which deployment option is recommended for applications that require higher uptime or zero data loss? The High Availability option The Standalone option The HeatWave option. Which three are the MySQL HeatWave user responsible for? OS installation Query design and optimization Defining data access and retention policies Backup and recovery Logical schema modeling. Which three are reasons that make MySQL HeatWave better than the other MySQL cloud offerings? Ease of use Security Enterprise readiness Pricing. Which of the following is a key feature of NoSQL databases? Fixed schema Horizontal scalability Limited data types ACID transactions. In which scenario would a NoSQL database be more suitable than a traditional relational database? High computation tasks like data warehousing Storing hierarchical data with flexible schema requirements Complex queries involving multiple tables High consistency and transactional integrity are required. Which of the following is a common characteristic of Column-Family NoSQL databases? Data is grouped and stored in columns rather than rows Data is stored in rows Data is stored as key-value pairs Data is stored as nodes and edges. Which of the following statements is true about arrays in Oracle NoSQL Database Cloud Service? Arrays can contain NULL values if they are defined as JSON. Arrays cannot contain NULL values, regardless of how they are defined. Arrays are unordered collections and can contain NULL values. Arrays are always ordered collections and can contain NULL values. Which statement about AWR is false? AWR is a built-in repository in the Oracle Database, which collects, processes, and maintains performance statistics of the database. AWR Hub is only available on Oracle Cloud Infrastructure Operations Insights Service. AWR Explorer in the Database Management service consists of performance and data visualization tools that display historical performance data from AWR snapshots in easy-to-interpret charts. Using AWR Explorer, you cannot download various reports from the database. Which two are true about the Basic Management option? The Basic Management option is available for the Oracle Database Enterprise Editions and the Oracle Database Standard Edition at an additional service cost. The Basic Management option has Advanced Performance Hub features such as Automatic Database Diagnostic Monitor (ADDM) and Blocking Sessions. The Basic Management option has ASH Analytics and SQL Monitoring features in Performance Hub for CDBs. The Basic Management option is available at no additional cost. Which is false about the Database Management Service? It compares performance across different periods of time. It is integrated with other OCI services. It does not support on-premises and Oracle Cloud deployments on VM/BM, ExaCS, ExaCC, or ADB. It is a Managed service. What is a primary feature of the Base Database Service (BaseDB) in Oracle Cloud? On-premises data management Cloud-based database management Automated data entry Manual system upgrades. What is the first step in provisioning a Base Database Service? Configuring database security Selecting a database version Allocating storage Creating a new database instance. What does Database Lifecycle Management in BaseDB typically involve? Data entry and report generation Management of database creation, backup, patching, and monitoring Automation of SQL queries On-premises server management. What is the purpose of Backup and Recovery in BaseDB? To automate database upgrades To ensure data integrity and availability To monitor user activity To manage database performance. Which components can be patched and upgraded in a User Managed BaseDB environment? Database software only Database and operating system Network configurations Storage systems. What is a key function of Base Database Service Monitoring & Management Interfaces? Automated data entry Real-time performance monitoring and management Manual backup configuration User role assignment. How does the Exadata Database Service differ from the Base Database Service in Oracle Cloud? Exadata offers enhanced performance and scalability Exadata is used only for small databases Exadata does not support backup and recovery Exadata is limited to on-premises deployment. What is a key consideration when provisioning an Exadata Database Service? Selecting the correct hardware configuration Automating patch management Setting up manual backups Limiting user access. What is the benefit of using the Base Database Service Monitoring & Management Interfaces? Enhanced data entry automation Improved database security Real-time monitoring and easy management of databases Manual patch application. What should be considered when managing backups in BaseDB? The frequency and retention policy of backups The number of users accessing the database The location of backup files The type of data being backed up.

Denunciar Test