Question 1:
What two tasks can be executed from the service console for Autonomous Databases?
Explanation
Each Autonomous Database instance has its own service console for monitoring that specific instance. The Overview and Activity tabs in the Service Console provide information about the performance of the service. The Activity tab also shows past and current monitored SQL statements and detailed information about each statement.
Also from the Service Console for your Autonomous Database you can download Client Credentials (Wallet) , pick Administration, then Download the Client Credentials (Wallet).
Question 2:
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
Explanation
Optimizer Hints Ignored by default in ADW. where honored by default in ATP
Question 3:
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
c) Data that Is bulk loaded, by default, uses the row format in Autonomous Transaction Processing |
|
where Autonomous Data Warehouse data format Is columnar |
Explanation
- Both ADW and ATP share the Autonomous Database platform of Oracle Database on Exadata Cloud infrastructure.
The difference is how the services have been optimized within the database. When you start loading data into the autonomous database, we store the data in the appropriate format for the workload.
- Oracle Autonomous Database is offered in two workload-optimized flavors
Question 4:
Which two statements are true when running DBMS_CLOUD.COPY_DATA?
b) The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob |
|
storage |
Object Store
Explanation
your Autonomous Transaction Processing and then use the procedure DBMS_CLOUD.COPY_DATA to load data
Question 5:
When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?
Explanation
Oracle allows you to scale compute and storage independently, no need to do it together. these scaling activities fully online (no downtime required)
Question 6:
What are two security features enabled by default by the Autonomous Database? a) Encrypted Database Links
Explanation
In Autonomous Database, Oracle encrypt your data everywhere—whether in motion in SQL*Net traffic, and at rest in tablespaces and backups by default, each Autonomous Database service is automatically configured to use industrystandard TLS 1.2 to encrypt data in transit between the database service and clients or applications. Required client certificates and networking information are automatically packaged for the service consumer when the service is provisioned
Oracle encrypt data at rest, by default the Autonomous Database is automatically encrypted using Oracle Transparent Data Encryption in tablespaces and backups
Question 7:
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)? a) Unplug into a pdb archive which can be uploaded to object storage
Explanation
Since an ADB database has some restrictions on the object types and Oracle Database Options you need to use a logical migration method rather than a physical one.
The main migration tool for migrating to ADB is Data Pump. You can export your schemas and import them into ADB using Data Pump. To sync up the additional/incremental changes on the source database during the export/import process you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB.
In the current release you cannot use physical migration methods like backup/restore, Data Guard, Pluggable/Unplug , database clones, and transportable tablespaces to move your existing database to ADB.
Question 8:
What are three methods to load data into the Autonomous Database?
Explanation
You can load data into the autonomous database using Oracle Database tools and Oracle and third-party data integration tools. ( Oracle Data Pump & PL/SQL package, DBMS_CLOUD & SQL*Loader)
You can export your schemas and import them into ADB using Data Pump. To sync up the additional/incremental changes on the source database during the export/import process you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB
Question 9:
Which two statements are true about the The Oracle Cloud Infrastructure (OCI)?
a) 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 unlikely to impac |
t |
|
the availability of the others within the same region |
d) An OCI region is a localized geographic area, and an availability domain is one or more data |
|
centers located within a region |
Explanation
Oracle Cloud Infrastructure is physically hosted in regions and availability domains. A region is a localized geographic area, and an availability domain is one or more data centers located within a region. A region is composed of one or more availability domains.
Availability domains are isolated from each other, fault tolerant, and very unlikely to fail simultaneously or be impacted by the failure of another availability domain. When you configure your cloud services, use multiple availability domains to ensure high availability and to protect against resource failure.
Question 10:
A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window of downtime. Golden Gate was advised to be used during the migration. For maximum reassurance of their
end-users, the customer also would like to use Golden Gate as a fall-back scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronised with the ADB instance for a switch back.
Which statement about the migration using Golden Gate is correct?
a) The fallback scenario is not possible using Golden Gate because the capture-process cannot be |
|
installed on ADB |
Explanation
You can replicate data to Oracle Autonomous Data Warehouse Cloud and Autonomous Transaction Processing using Oracle GoldenGate On Premises and Oracle GoldenGate Cloud Service.
Question 11:
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
Explanation
Optimizer Hints Ignored by default in ADW. where honored by default in ATP
Question 12:
What two methods can you use to define Machine Learning Users? a) Use DBMS_CLOUD_ADMIN package
Explanation
An administrator can add an existing database user account to Oracle Machine Learning or create a new user account and user credentials with the Oracle Machine Learning User Management interface.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-usersoml.html#GUID-94476A16-F873-4079-831F-ED0580EA2CD4
Question 13:
In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?
d) In the TEST phase of the wizard a list is generated containing the records that would be rejected |
|
during import |
Explanation
Question 14:
Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)? a) Import Table
Explanation
Data sets contain data from subject areas, Oracle Applications, databases, or uploaded data files such as spreadsheets.
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/create-project-and-add-datasets.htmlhttps://docs.oracle.com/en/cloud/paas/analytics-cloud/tutorial-create-first-visualization/
Question 15:
Given the steps:
Which two steps are out of order when working with Oracle Machine learning? a) Run SQL Scripts
Explanation
Which statement is true in regards to database links?
Explanation
ADB support ongoing database links only. so the correct answer is B
Yes, database links are fully supported in ADB.
For serverless ADB deployments the target database must be configured to use TCP/IP with SSL (TCPS) authentication. ATP Dedicated does not support TCP/IP with SSL (TCPS) encrypted connections for DB Links.
so the correct answer should be all
Let's assume this question from old questions bulk and the answer is B
Question 17:
Which operating system can Data Visualization Desktop be run on? a) Linux
Explanation
System requirements to install Oracle Data Visualization Desktop
MacOS Sierra (10.12), MacOS High Sierra (10.13), MacOS Mojave (10.14)
https://www.oracle.com/solutions/business-analytics/analytics-desktop/oracle-analyticsdesktop.htmlhttps://oracle.github.io/learning-library/workshops/journey4-adwc/?page=LabGuide5.md
Question 18:
The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usernames and init.ora parameters. The decision was made to adhere to the suggested migration method using an instant client and the datapump version that was suggested (and came with it).
Which statement is true about the migration of the application's database success?
a) The tablespace names will result in a blocking error during datapump import because of ADB |
|
limitations |
Explanation
Autonomous Database configures and optimizes your database. You do not need to perform administration operations for configuring the database. SQL commands used for database administration such as CREATE TABLESPACE are not available.
The default data and temporary tablespaces for the database are configured automatically. Adding, removing, or modifying tablespaces is not allowed.
Question 19:
Which Java Database Connectivity (JDBC) thin client version supports the use of HTTP proxy settings that does NOT support TCP to connect to Autonomous Data Warehouse? a) 17.4 onwards
Explanation
JDBC Thin client versions earlier than 18.1 do not support connections through HTTP proxy
Question 20:
Which is NOT required to connect to Autonomous Database from SQL developer? a) Service name
Explanation
This is the information required to connect to ADB from SQL Developer:
Question 21:
Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database. Which statement is true regarding the default configuration of the Autonomous Data Warehouse? a) Adding, removing, or modifying tablespaces is allowed
b) Degree of parallelism for SQL statements is set based on the number of OCPUs in the system |
|
and the database service the user is connecting to |
Explanation
Question 22:
Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure? a) Terraform
Explanation https://www.terraform.io/docs/providers/oci/r/database_autonomous_database.html
Question 23:
Which is the correct subset of services offered via OCI-CLI (command line interface) for Autonomous Database (ABD) via calls made to the OCI API's? a) Create, Query, Update, List, Start
Explanation https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase.html Available Commands: change-compartment create create-from-clone delete generate-wallet get
list
restore start stop update
Question 24:
What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database?
b) Data Pump can exclude migration of objects like indexes and materialized views that are not |
|
needed by Autonomous Database |
Explanation
The default data and temporary tablespaces for the database are configured automatically. Adding, removing, or modifying tablespaces is not allowed.
Oracle Data Pump offers very fast bulk data and metadata movement between Oracle databases and Autonomous Database.
Data Pump Import lets you import data from Data Pump files residing on Oracle Cloud
Infrastructure Object Storage, Microsoft Azure, AWS S3, and Oracle Cloud Infrastructure Object Storage Classic. You can save your data to your Cloud Object Store and use Oracle Data Pump to load data to
Question 25:
What is the default retention period for both Automatic and Manual Autonomous Database Backups?
Explanation
Autonomous Database automatically backs up your database for you. The retention period for backups is 60 days. You can restore and recover your database to any point-in-time in this retention period.
Question 26
Users are required to select a service when connecting to Autonomous Data Warehouse and these services match to one of three different consumer groups: High, Medium, and Low.
Which statement about these consumer groups is correct?
Explanation
Predefined Database Service Names for Autonomous Data Warehouse
Question 27:
Which two are correct actions to take in order to Download the Autonomous Database Credentials?
a) Find the Service Console for your Autonomous Database, then pick Administration, then |
|
Download the Client Credentials (Wallet |
Wallet
Download the Wallet
d) Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose |
|
DB Connection button, then Download the Wallet |
Explanation
- To download client credentials, do the following from Oracle Cloud Infrastructure console:
(1)
Navigate to the Autonomous Database details page.
Click DB Connection.
On the Database Connection page click Download
(2)
Navigate to the Autonomous Database details page.
Click Service Console
Pick Administration tab, then Download the Client Credentials
Question 28:
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? a) DBNAME_MEDIUM
Explanation
Question 29:
Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP environment. The Oracle adviser recommends to use Oracle Data Sync for this.
Which statement is true regarding Oracle Data Sync?
Explanation
Use Data Sync to upload, and manage data. You can load data from files (CSV and XLSX), various relational sources (tables, views, SQL statements), OTBI, JDBC data sources, and Oracle Service Cloud. You can load to relational tables or data sets.
Use Data Sync when you want to:
Question 30:
Which two statements are true with regards to Oracle Data Sync?
b) Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL |
|
Server, MySQL and Teradata |
Explanation
Use Data Sync when you want to:
Use Data Sync to load data from these databases:
Load data from generic JDBC data sources too, for example:
Connection Type
================
Question 31:
Which two methods can you use to create users and grant roles in Autonomous Database services?
Explanation
To create users/grant roles in ADB, connect to the database as the ADMIN user using any SQL client tool.
Question 32:
Which three tasks by default are taken care of by the Autonomous Database? a) Database Upgrades
Explanation
Our motto is deliver assignment on Time. Our Expert writers deliver quality assignments to the students.
Get reliable and unique assignments by using our 100% plagiarism-free.
Get connected 24*7 with our Live Chat support executives to receive instant solutions for your assignment.
Get Help with all the subjects like: Programming, Accounting, Finance, Engineering, Law and Marketing.
Get premium service at a pocket-friendly rate at AssignmentHippo
I was struggling so hard to complete my marketing assignment on brand development when I decided to finally reach to the experts of this portal. They certainly deliver perfect consistency and the desired format. The content prepared by the experts of this platform was simply amazing. I definitely owe my grades to them.
Get instant assignment help