This page was exported from Latest Exam Prep [ http://certify.vceprep.com ] Export date:Sat Sep 21 11:33:48 2024 / +0000 GMT ___________________________________________________ Title: 1z0-931-23 Free Certification Exam Material from VCEPrep with 183 Questions [Q60-Q80] --------------------------------------------------- 1z0-931-23 Free Certification Exam Material from VCEPrep with 183 Questions Use Real 1z0-931-23 - 100% Cover Real Exam Questions QUESTION 60Which three security features are available in Oracle Autonomous Database Shared Infrastructure?  Transparent Data Encryption  Database Vault  Customer Managed Keys  Data Redaction  Audit Vault https://docs.oracle.com/en/cloud/paas/atp-cloud/atpfg/security-features-adb1.html#GUID-89E3C22E-D4EB-472B-8287-41682C2B61B3QUESTION 61Which is a feature of a graph query language?  Scripting language  Run key-value queries  Object-oriented language  Ability to specify patterns QUESTION 62Which can be Scaled Independently of the number of CPUs In an Autonomous Database?  Parallelism  Storage  Concurency  Memory  Sessions https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A-84FF65A65846 Key Features Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:QUESTION 63You 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. https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-database-actions.html#GUID-55BA432E-098A-48ED-B2EA-F2960A9EF586 To enable a user to access SQL Developer Web, you need to create a database user with the appropriate privileges, enable the schema for SQL Developer Web, and provide the user with the modified URL that includes the schema name. See Enabling Users to Access SQL Developer Web for more details.QUESTION 64During 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 https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adb_dedicated_creating.htmQUESTION 65Which two methods can you use to define Oracle Machine Learning users?  SQL Developer  the DBMS_CLOUD_ADMIN package  Oracle Cloud Infrastructure Console  Service Console QUESTION 66Which four file formats are supported when loading data from Cloud Storage?  Parquet  DOC  DDL  JSON  CSV  AVRO QUESTION 67The 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 https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/components.html#GUID-268B36E1-87D8-4649-A370-226E2AE3FC5CQUESTION 68A 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 https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connecting-nodejs.html#GUID-AB1E323A-65B9-47C4-840B-EC3453F3AD53https://developer.oracle.com/databases/database-for-python-developers-1.htmlQUESTION 69Which 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 Reference:https://k21academy.com/1z0-931/migrate-database-to-oracle-autonomous-database-cloud-optionsdata-pump-sql-loader-dbms_cloud-goldengate/QUESTION 70What 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 https://docs.oracle.com/en/cloud/paas/autonomous-database/adbat/index.html#articletitleQUESTION 71Which two statements are true about Oracle Cloud Infrastructure (OCI)?  An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region  A single fault domain can be associated with multiple regions and availability domains  Regions are dependent on other regions and must be located within five thousand kilometers of each other  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 u likely to impact the availability of the there within the same region QUESTION 72Which two statements are true about Data Insights?  You can retrieve previously executed Data Insights searches.  Data Insights is available with on-premises deployments of Oracle Database.  Data Insights is an additional priced option.  You can search for Data Insights against a base table or business model. QUESTION 73Which statement is FALSE regarding database links?  You can call PL/SQL procedures and functions by using a database link  You can connect to an Autonomous Database from a remote database using a database link  You can create a database link from one Autonomous Database to another Autonomous Database instance  You can connect to a remote database from an Autonomous Database by using a database line QUESTION 74When 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 https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-scale.html#GUID-27FAB1C1-B09F-4A7A-9FB9-5CB8110F7141QUESTION 75Which 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 https://oracle-base.com/articles/vm/oracle-cloud-autonomous-data-warehouse-adw-create-servicehttps://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sqlplus.html#GUID-A3005A6E-9ECF-40CB-8EFC-D1CFF664EC5Ahttps://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sql-dev.html#GUID-FB611317-2999-4C8C-8A3B-B3B3D3C5B417https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud-admin.html#GUID-D76B229E-781E-45C0-9F14-CAF30F9E6E3B“To create users in your database, connect to the database as the ADMIN user using any SQL client tool.” https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-create.html#GUID-54CA837B-CD6A-4ED2-A960-5874535818CBQUESTION 76Which statement is correct about management operations on Autonomous Database on Shared. 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  You can skip a scheduled maintenance run. For Autonomous Databases on Shared Infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed  You cannot configure the scheduling for your Autonomous Databases on Shared Infrastructure  You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your Autonomous Databases on Shared Infrastructure QUESTION 77Which three are Oracle-recommended best practices for Autonomous Database alarms?  Suppress alarms during investigations.  Create multiple alarm metrics.  Create a single alarm for each metric.  Select the correct alarm interval for your metric.  Routinely tune your alarms.  Use a single interval for all alarms. QUESTION 78Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)  Use SFTP to copy CSV files into Autonomous Database  Use Oracle Zero Downtime Migration (ZDM)  Use Recovery Manager (RMAN)  Use GoldenGate  Use Data Pump https://www.oracle.com/sa/database/technologies/cloud-migration.htmlQUESTION 79Which 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 QUESTION 80You are requested to analyze a year’s stock purchase data which is stored in Autonomous Data Warehouse instance.Which tool would you use to automate data exploration and create pivot tables?  Business Models  Data Load  SQL Developer Web  APEX  Loading … Oracle 1z0-931-23 Exam Syllabus Topics: TopicDetailsTopic 1Use ADB connectivity: Wallets, service handles Manage Autonomous Database instances: REST APIs, OCI CLI, moving resourcesTopic 2Monitor Autonomous Database Shared instances - events and alarms Describe Autonomous Database architecture, integrations, and license typesTopic 3Monitor ADB performance and set up service notifications Describe ADB Dedicated and ADB Cloud@Customer resources, workflows, and functionalityTopic 4Understand the Oracle Cloud Infrastructure Manage Autonomous Database Shared Backups and RestoresTopic 5Managing and Maintaining Autonomous Database Create Autonomous Database Shared Instances - provisioning, scaling OCPU and storageTopic 6Describe the Different Autonomous Database offerings Articulate the key features of Autonomous DatabaseTopic 7Use Access Control Llist (ACL) and Private End Points Configure Disaster Recovery (Data Guard) - both Shared and DedicatedTopic 8Use services in ADB: auto-indexing, data safe, compartment quotas Migrate to Autonomous Database using Data Pump   Dumps Brief Outline Of The 1z0-931-23 Exam: https://www.vceprep.com/1z0-931-23-latest-vce-prep.html --------------------------------------------------- Images: https://certify.vceprep.com/wp-content/plugins/watu/loading.gif https://certify.vceprep.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2024-07-11 15:18:07 Post date GMT: 2024-07-11 15:18:07 Post modified date: 2024-07-11 15:18:07 Post modified date GMT: 2024-07-11 15:18:07