Some QA - ORACLE 1Z0-1105-23

Prévia do material em texto

What component is not included in a MySQL Database Service DB System?
 FastConnect (*)
 
 Which statement is true about Autonomous Transaction Processing?
 It is used for OLTP and mixed workloads. (*)
 Which statement is not the responsibility of the customer in a simple cloud management model?
 Manage database servers and VM hosts (*)
 Which three are required for provisioning an Oracle Autonomous Database instance? (Choose three)
 Database Name (*)
 Number of CPUs (*)
 Workload Type (*)
 Which two are true about the Data Catalog?
 Discover data using powerful search (*)
 Harvest object storage to derive schemas (*)
 What is the most important reason to upgrade and patch?
 Security (*)
 Which statements are true about built-in SQL Worksheet and Notebook? (Choose two)
 No need to install a client query tool (*)
 Quickly start running queries with built-in web-based notebooks (*)
 Which self-service tools are available with the Autonomous Database?
 Oracle Machine Learning (*
 Low-Code App Dev, APEX (*)
 Which are the capabilities of Oracle Autonomous Database that can accelerate innovation? (Choose three)
 Built-in AI and ML helps find patterns that could identify undiscovered anomalies (*)
 Instant scaling of storage (*)
 Provisions a data warehouse in seconds (*)
 Which two are true about the Autonomous JSON database?
 Instant auto-scaling (*)
 Accessed via document APIs (*)
 Which command for the MySQL Data Service will resume OCPU billing?
 Restart (*)
 Which statements are included in default configuration for automatic database backups?
 Backups are executed on primary site (*)
 Archive redo log files are backed up every 30 minutes (*)
 What interconnect solutions are available to connect Oracle Cloud to other cloud provider?
 FastConnect (*)
 Cloud Router (*)
 Which ADB tool can you use to discover anomalies, outliers, and hidden patterns in your data?
 Data Insights (*)
 Which migration types uses Datapump and GoldenGate tools?
 Logical Migration (*)
 Which of the following has expanded flexibility with shared or dedicated Exadata infrastructure?
 Oracle Autonomous Database (*)
 What are the three security zones of control?
 Detect (*)
 Prevent (*)
 Assess (*)
 Which two actions can be performed from the OCI Console for an Oracle Autonomous Database?
 Increase Storage allocated for Database (*)
 Scale up/down CPU (*)
Which are two characteristics of Autonomous Data Warehouse (ADW)? (não resolvida)
-Optimized for complex SQL
-Stores data in row format
Which two choices are true for Autonomous Data Warehouse (ADW)?
-Billing for compute stops when ADW is stopped
-Billing for storage continues when ADW is stopped
What are two typical reasons why customers CANNOT move their database into the public cloud?
-Putting data in the cloud would break data residency rules
-Regulations that prevent moving data into the public cloud
When Customers are using the Exadata Cloud Service, what are they responsible for managing
-Databases and Customer VM
What is NOT a feature of the Oracle Autonomous Database to protect data from external and internal threats?
-None of the above
Which are two characteristics of Autonomous Transaction Processing (ATP)?
-Focused on creation
-optimized for response
Which three can be selected when using the console to create an autonomous database on an Autonomous Exadata Cloud@Customer? (não resolvida)
amount of database OCPUs required
amount of database storage required
size of the shared global area (SGA) to use
workload type
client network
Which security measure is implemented out-of-the-box, and is included if you are not using BYOL licensing with Exadata Cloud@Customer?
-Oracle Native Network Encryption and TDE 
Which two statements are true when deciding which Oracle Cloud Infrastructure (OCI) region to register an Exadata Cloud@Customer infrastructure in?
-Consider any business policies or regulations that preclude the use of a particular region.
-Exadata Cloud@Customer is hosted in a customer data center so the Exadata infrastructure is not registered in an OCI region.
Which two statements about ORDS are true?
-ORDS makes a REST API
-ORDS stores, manages and indexes JSON documents
What does ORDS stand for?
-Oracle REST Data Services
The Demand Side is data that is active and does something. What two data services are typically part of the demand side?
-Payloads
-Inert algorithms.
The Supply Side is data that is passive and means something. What two models and libraries are included in the supply side?
-Business rules
-Domain objects
What is a main feature of APEX's low code platform?
-Use graphical interfaces...
Which ability is NOT provided out of the box with the Autonomous Database Tools set?
-The ability to change encryption or disable TDE. No control over tablespaces. No monitoring via Oracle Enterprise Manager. No ability to control database instance memory sizes and configurations.
What is NOT a workload that can be selected when provisioning an Autonomous Database?
-MySQL
Exadata is the integration of the software and hardware and is available to customers on which deployments? (nao respondida)
-in the Oracle Cloud and customer site
 
 New hardware innovations of the Exadata X8M allow customers to take advantage of Remote Direct Memory Access (RDMA). What resource does RDMA access?
 -Persistent Memory
 Oracle ExaC@C brings the Oracle Cloud to the customer data center. The Oracle Cloud Infrastructure is the same, but responsibilities are adjusted so that customer can perform which two tasks?
-Allow only the Oracle Staff to perform control access.
-Secure access configured to the customer network.
 Which component is NOT included as part of an Oracle NoSQL table Oracle Cloud Identifier (OCID)?
 -Unique ID
Which two target database environments provide both high availability (HA) and disaster recovery (DR) options in the cloud?
-Exadata Cloud Service
-Autonomous Database
After you have provisioned a virtual machine (VM) database (DB) system, what action can you take to meet changes in block storage requirements
-If a vm DB system requires more block storage, increase the storage at any time without impacting the system.
Which statement is true about moving virtual machine (VM) database (DB) systems from one compartment to another?
-You can move DB systems to a different compartment if you have sufficient access permissions to thecompartment that the resource is being moved to, as well as the current compartment.
Which is NOT a prerequisite for patching Grid Infrastructure or database homes when using the console?
-Oracle Clusterware is down on the VM cluster.
What is a prerequisite of running APEX on an Autonomous Database?
-An antonomus database..
Which is NOT an option in Database Actions to load data into Autonomous Database?
-LOAD DATA USING FTP
How does the Converged Database help to access data using an API?
-A REST API is automatically generated on top of SQL or stored procedures.
Which tool is provided to support Continuous Integration/Continuous Deliver (CI/CD) workflows?
Which two are objectives of Oracle's Data Management strategy?
-OFFER MULTIPLE INTEGRATION..
-AUTOMATE EVERYTING..
Which two are key characteristics of Oracle Autonomous Database?
-Oracle manages everything
-Lower cost
Multicloud strategy eliminates the reliance of a single cloud provider but also provides which two advantages?
-COMPLIANCE FOR USE SPECIFIC..
-WORKLOAD UTILIZATION..
 
Oracle Cloud and Microsoft Azure have an interconnect for workloads across cloud. Which two are also benefits this partnership and interconnect provide?
Low Latency
Upgrade compliance
Connection to other multicloud environments
Unified identity and access management
 What connections to multiple public clouds are provided through 3rd party connectivity?
 -VCN E VPC
 Oracle Maximum Security Architecture is used for data that requires something higher than normal baseline security. Which two controls added to the baseline security apply to maximum securityarchitecture?
 -Network Encryption
 -Database Vault
 Which two locations can be used to store your DB system database backups
 -You can store your DB system database backups in Oracle Cloud Infrastructure Object Storage.
 -You can store your DB system database backups in on-premises local storage.
 In order to support multicloud strategies, what is offered as an industry first by Oracle
 -Oracle FastConnect
Which two are key features of MySQL Database Service
-Integration with Oracle Technologies: Uses a diem s existing Oracle investments and easily integrates MySQL Database Service with Oracle technologies
-Regulatory Compliance: Uses advanced security to help clients meet industry and regulatory compliance requirements. including GDPR, PCI, and HIPPA
What security control area determines if there is sensitive data in a system?
-USERS
Which workload CANNOT be run on Oracle Database 19c?
-HADOOP CLUSTERS
What are three platforms where Oracle's Autonomous Database service can be deployed?
-ORACLE PUBLIC CLOUD
-DEDICADED REGION..
-HYBYRD CLOUD..
What are two characteristics of Oracle SQLcl (SQL Developer Command Line)?
-Available in the OCI Cloud Shell by default
-Ability to execute SQL batch le
What set of NoSQL-style APIs can be used in Autonomous JSON Database?
-SODA
What THREE steps must you perform to connect to a MySQL database in the database system by using SSHand MySQL Shell?
-Instantiate MySQL Shell on the MySQL database system instance.
-Connect to the MySQL Database Service instance.
-SSH into the compute instance from your local machine.
Which network is used to facilitate the secure monitoring and administration of Oracle-managed infrastructurecomponents in Exadata Cloud@Customer
-Cloud operations network
You want to move an Exadata Cloud@Customer VM cluster to a different OCI compartment for increasedisolation from other teams that use Exadata. What happens when you use the console to do this?
-The vm cluster, compute nodes, and associated databases will move compartments. All other resourceswill remain in the existing compartment.
When configuring connectivity for hosts in the VCN, security lists contain defaults for implementing securityrules. Which TWO additional rules are needed for database systems?
-allows SSH traffic from anywhere
-allows Path MTU Discovery fragmentation messages
Which tool should you use to run the LIST FLASHCACHE DETAIL command in the Exadata Cloud Serviceenvironment?
-exacli
You notice that throttling is occurring on your NoSQL Database Cloud Service. What must you increase tosolve this
-OCPU for all servers in the cluster
The Oracle Cloud Infrastructure (OCI) Data Catalog is an integral part of the Lakehouse solution. What level of data detail does Data Catalog provide when integrated with Autonomous Databases and Object storage?
- View of data for discovery
Oracle Lakehouse provides extensive data processing capabilities, to accommodate the migration of existing architectures or the creation of new, agile ones. Which service does NOT provide data processing on Oracle Cloud Infrastructure (OCI) Lakehouse? (não resolvida)
-OCI Data Flow
Lakehouse on Oracle Cloud Infrastructure (OCI) is the premier platform for analyzing any data for any insights. Which is NOT a component of this solution?
What does the Oracle Cloud Infrastructure (OCI) Data Catalog primarily provide for data in the Lakehouse on OCI? (não resolvida)
converged Database
Analytic environment
Data Integration
Machine Learning
Metdata source of truth
Which Lakehouse service should you use for serverless Spark processing?
-OCI DATAFLOW
What information is required to connect to the NoSQL Database Cloud Service?
-SIGNING KEY FINGERPRINT,API SINGING KEY,TENANCY OCID
Which Oracle Cloud Infrastructure (OCI) service is NOT available as part of Oracle Cloud Free Tier?
-Exadata DB Systems
Which Oracle Cloud Infrastructure (OCI) service is NOT available for provisioning in your tenancy as an Always Free resource?
-Connect (1Gbps public peering)
Assume that there are no resource limits on your underlying Exadata Cloud@Customer hardware. What is themaximum number of Autonomous container databases that can be created on one Autonomous VM cluster?
- 12
What are two important reasons to upgrade and patch? 
-SECURITY
-SUPPORT COMPLIANCE 
What is the FINAL release supporting the non-CDB architecture?
-ORACLE DATABASE 19C 
When should you change COMPATIBLE? 
When Customers are using the Exadata Cloud Service, what are they responsible for managing?
-Databases and Customer VM
What are the two main features of APEX's low code platform?
-use graphical..
-focus on bussiness
What are two main benefits of Oracle APEX?
-RAPIDLY DEVELOP...
-DEVELOP RESPONSIVE COMPARED...
Which Oracle Cloud Infrastructure (OCI) service is NOT available for provisioning in your tenancy as an Always Free resource
-Exadata DB Systems
What is NOT a feature of the Oracle Autonomous Database to protect data from external andinternal threats?
-Admin passwords are disable aer provisioning
Which Oracle Cloud Infrastructure storage platform is used by MySQL Database Service for all data storage?
-Flash Local Storage
Which statement is true about MySQL Database Service?
- It is a fully managed Oracle Cloud Infrastructure (OCI) native service.
Which two statements are true regarding MySQL Database Service HeatWave?
-HeatWave uses machine learning to automate operations, increasing DBA productivity and reducing costs.
-HeatWave is a in-memory, query-processing engine designed for fast execution of ana-lytic queries.
You have stopped the HeatWave cluster. Which two statements are correct?
-The data loaded in HeatWave cluster memory is lost
-???HeatWave is a in-memory, query-processing engine designed for fast execution of ana-lytic queries.
Which three are prerequisites for using the MySQL Database Service?
-YOU MUST CREATE A TENANCY..
-YOU OR YOUR GROUP MUST..
-YOU MUST DOWNLOAD THE LATEST..
What are two characteristics of CI/CD?
-It introduces automation into all stages of app/database development.
-Development changes are automatically V tested on push/commits and merges.
Which tool allows users to execute SQL statements, create relational models, load data, and monitor SQL queries from your browser?
-SQL Developer
How can the goal of scale out high availability be achieved?
-provisioning nodes with Real Application Clusters
What is the primary goal of Oracle Maximum Availability Architecture for customer systems?
-Active Replication, Data Protection and continuous availability
Which feature allows you to logically group and isolate your Oracle Cloud Infrastructure resources?
-Compartments
Which Oracle Cloud Infrastructure (OCI) Identity and Access Management (IAM) capability helps you to organize multiple users into teams?
-Policies
A customer is looking to migrate their old database backups from their on-premises data center to Oracle Cloud Infrastructure (OCI).
Which OCI service is the most cost-effective?
-Object storage (standard)
Oracle Automated Machine Learning (AutoML) has options for using in-database and opensource algorithms. Which is an example of an in-database option?
-Oracle Machine Learning for Python (OML4Py) APIs
Which two methods can you use to create or modify Oracle Cloud Infrastructure (OCI) re-sources?
-oci rest api
-oci command line interface
Where should you store unstructured, high volume data sets of unknown value for best price/performance?
-OCI Object Storage
Oracle Data Lakehouse streamlines the integration, storage, and processing of data. Which two services are used for persistence of the data in Lakehouse?
-OCI Object Storage
-Autonomous Database
Which is NOT a resource type for NoSQL Database Cloud Service?
-NOSQL-KEYS
Oracle Data Lakehouse streamlines the integration, storage, and processing of dat
-WHICH TWO SERVICES ARE USED FOR PERSISTANCE...
-AUTONOMUS DATABASE
Which deployment option provides the highest degree of security and governance while providinga completely self-service database experience?
-EXADATA CLOUD SERVICE
The DBA has determined that number of OCPU assigned to an Autonomous Database does not provide sufficient performance. Which option does the DBA have in this case 
-Open the database in OCI Console and increase the number of OCPU. No downtime required.
Call Oracle Cloud Support and raise a request to increase number of OCPU. Expect a downtime of approximately one hour.
Which three data file formats can be loaded using Oracle Database Actions?
-JSON
-AVRO
-CSV
Which statement can be detected by monitoring of access to sensitive data?
-SELECT*FROM EMPLOYEES
What three typical data types/models are covered by Oracle's Converged Database?
-GRAPH
-RELATIONAL
-SPATIAL
Which two target database environments provide both high availability (HA) and disaster re-covery (DR) options in the cloud?
-EXADATA CLOUD SERVICE
-AUTONOMUS DATABASE
Which service is used by default by the MySQL Database Service to store user data to make it more resistant to failures?
-OCI BLOCK VOLUMES
A customer wants to use Oracle Cloud Infrastructure (OCI) for storing application backups which can be stored for months, but retrieved immediately based on business needs.
Which OCI storage service can be used to meet this requirement?
-OBJECT STORAGE (STANDART)
The DBA has determined that number of OCPU assigned to an Autonomous Database does not provide sufficient performance. Which option does the DBA have in this case?
-Open the database in OCI Console and increase the number of OCPU. No downtime required.
The Demand Side is data that is active and does something.
What two data services are typi-cally part of the demand side? (Choose all correct answers)
-PAYLOADS
-DATAMODELS
The DBA has determined that number of OCPU assigned to an Autonomous Database does not provide sufficient performance.
Which option does the DBA have in this case?
-OPEN THE DATABASE IN OCI CONSOLE AND INCREASE...
Oracle ExaC@C brings the Oracle Cloud to the customer data center. The Oracle Cloud In-frastructure is the same, but responsibilities are adjusted so that customer can perform which two tasks? 
-SECURE ACCESS CONFIGURED..
-ALLOW only oracle staff..
Oracle Cloud and Microsoft Azure have an interconnect for workloads across cloud.
Which two are also benefits this partnership and interconnect provide?
-UNIFIED IDENTITY AND ACCESS...
-LOW LATENCY...
Which statement is true about moving virtual machine (VM) database (DB) systems fro one compartment to another?
-YOU CAN MOVE DB SYSTEMS TO A DIFFERENT..
Which tool is provided to support Continuous Integration/Continuous Deliver (CI/CD) work-flows?
-SQLcI (LIQUIBASE)
Oracle & Automated Machine Learning (AutoML) has options for using in-database and opensource algorithms.
Which is an example of an in-database option?
-ORACLE MACHINE LEARNING..
Which feature allows you to logically group and isolate your Oracle Cloud Infrastructure re-sources?
-COMPARTMENTS
The Oracle Cloud Infrastructure (OCI) Data Catalog is an integral part of the Lakehouse so-lution.
What level of data detail does Data Catalog provide when integrated with Autonomous Databases and Object storage?
-VIEW OF DATA FOR DESOVERY
What is the Oracle recommended way to upgrade databases?
-AUTOUPGRADE
Which is NOT a key to successful database upgrades? (não resolvida)
Download and use AutoUpgrade 
Enable Performance Stability with SPM, STA, and RAT 
Download and install Oracle 19c 
Download and install Oracle 21c 
Download and install newest RU 
What are the two main features of APEX's low code platform? 
-USE GRAPHICAL..
-FOCUS ON BUSSINESS
The Oracle Cloud Infrastructure (OCI) Data Catalog is an integral part of the Lakehouse so-lution. What level of data detail does Data Catalog provide when integrated with Autonomous Databases and Object storage?
-View of data for discovery
In what two ways does Oracle Cloud Infrastructure (OCI) offer industry leading price-performance?
-OCI backs performance claims with Service Level Agreements
-With OCI, pricing is low and predictable across all regions and services
What does compute instance horizontal scaling mean?
-adding additional compute instances