Which three options are available to access data in an Autonomous JSON Database

Scheduled maintenance: Saturday, December 10 from 10PM to 11PM PST

Home

Subjects

Expert solutions

Create

Log in

Sign up

Upgrade to remove ads

Only SGD 41.99/year

• Flashcards

• Learn

• Test

• Match

• Flashcards

• Learn

• Test

• Match

Terms in this set (60)

1
What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.)

A. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.

C. Data Pump is faster to migrate database than using RMAN.

2
The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?

MODIFY_SNAPSHOT_SETTINGS

3
Which task is NOT automatically performed by the Oracle Autonomous Database?

B. Mask your sensitive data.

4
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)

B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.

C. 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.

E. 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.

5 Which of these database features is NOT part of the Autonomous Database?

D. Java in the Database

6 Which two statements are true with regards to Oracle Data Sync? (Choose two.)

A. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
C. Data Sync can load your data in parallel in order to speed up the loading process.

7 Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?

C. The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet.

8
What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer?

C. DWROLE

9 Which two system privileges does a user need to create analytic views? (Choose two.)

D. CREATE ANALYTIC VIEW
E. CREATE ATTRIBUTE DIMENSION

10 What are three methods to load data into the Autonomous Database? (Choose three.)

A. Oracle GoldenGate
D. Oracle Data Pump
E. SQL*Loader

11
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

D. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

12
When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?

B. Active transactions are paused.

13 Which three statements are correct when the Autonomous Database is stopped? (Choose three.)

B. Tools are no longer able to connect to a stopped instance.
C. CPU billing is halted based on full-hour cycles of usage.
D. In-flight transactions and queries are stopped.

14 Which two are correct actions to take in order to Download the Autonomous Database
Credentials? (Choose two.)

A. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
C. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).

15
How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?

D. Five. They are called tpurgent, tp, high, medium and low.

16
If you need to connect to Autonomous Data Warehouse (ADW) using Java Database Connectivity (JDBC) via an HTTP proxy, where do you set the proxy details?

A. tnsnames.ora
C. sqlnet.ora

17
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?

C. Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files.

18
The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usemames 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?

B. The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful.

19
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?

B. Only the migration to ADB is possible from an on-premise installation of Golden Gate.

20 Which statement is true regarding database client credentials file required to connect to your Autonomous Database?

C. Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database.

21 In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?

C. In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition.

22 Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?

D. Navigate to Identity, select Users panel on the console and select "Add Public Key".

23
Which statement is true in regards to database links?

C. Connect to Autonomous Database from remote database using a database link.

24 How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

D. A. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

25 Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

B. Autonomous Data Warehouse.

26 Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?

B. Create a Data Set

27 Which is correct about security features that are available in Oracle Autonomous Database?

B. Data Redaction and TDE are both supported.

28 What is the default retention period for both Automatic and Manual Autonomous Database Backups?

C. 60 days

29 Which three statements are true regarding how Autonomous Database provides data security?
(Choose three.)

A. Data is encrypted at rest using transparent data encryption.
B. Network connections from clients to Autonomous Database are encrypted using the client credentials wallet.
D. Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors.

30 When exporting a notebook, what type of file is created?

C. JSON

31 What two tasks can be executed from the service console for Autonomous Databases? (Choose two.)

A. Autonomous Databases monitoring for usage and query performance.
D. Wizard to download connection wallet for connection from desktop tools.

32
What predefined user is created when an Autonomous Database (ADB) instance is created that you connect to in order to create other users and grant roles?

B. ADMIN

33 What REST verb is used to create an Autonomous Database service using REST APIs?

A. A "POST" REST call

34 Which operating system can Data Visualization Desktop be run on?

C. Windows

35 Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)

B. VALIDATE_HIERARCHY
D. VALIDATE_ANALYTIC_VIEW

36 Which three tasks by default are taken care of by the Autonomous Database?

A. Backups
B. Firmware Patching
D. Database Upgrades

37
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?

D. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.

38
As a database architect you are tasked with configuring a high concurrency, production OLTP application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode.
Which connection service is appropriate for such a workload?

D. TPURGENT

39
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

B. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
C. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

40
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?

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.

41 What are two security features enabled by default by the Autonomous Database? (Choose two.)

A. Transparent Data Encryption
B. Encrypted Database Links

42 Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?

C. Data Pump

43 Which two statements are true about the Oracle Cloud Infrastructure
(OCI)? (Choose two.)

A. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region.
B. 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 impact the availability of the others within the same region.

44
Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

A. through the Oracle Cloud Infrastructure service console
B. through SQL Developer

45
Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

D. TPPERFORMANT

46 When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?

D. OCPUs and storage can be scaled independently.

47 Which two options are available to restore an Autonomous Data
Warehouse? (Choose two.)

D. Select the backup from which restore needs to be done.
E. Specify the point in time (timestamp) to restore.

48
Which is NOT required to connect to Autonomous Database from SQL developer?

A. Database name

49 What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database? (Choose two.)

A. Golden Gate
D. Data Pump

50 Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure?

A. Terraform

51
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?

B. Create, Get, List, Stop, Restore

52 What two methods can you use to define Machine Learning
Users? (Choose two.)

B. SQL/Developer
C. Oracle Cloud Infrastructure Console

53
Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data involves multiple steps like creating a credential object, creating (access to) a storage object/location, running datapump export and running a datapump import.
Which three statements are true for SQL Developer (18.3 and up) in combination with ADB Data Loading? (Choose three.)

A. SQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps.
B. SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage.
C. SQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running.

54 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. 18.1 onwards

55
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)?

B. Create a database link from source database to the ADB environment and clone the PDB.

56
Given the steps:
1. Create Oracle Machine Learning User
2. Create projects
3. Create workspaces
4. Create Notebooks
5. Run SQL Scripts
Which two steps are out of order when working with Oracle Machine learning? (Choose two.)

B. Create workspaces
E. Create projects

57 Which can be Scaled independently of the number of CPUs in an Autonomous Database?

E. Storage

58 Which statement about the Export Wizard used to export database objects and data is NOT correct?

C. If "Grants" is checked as a DDL Option, GRANT statements are included for any grant objects on the exported objects, including those owned by the SYS schema.

59
When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?

B. CWALLET.SSO

60
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?

B. Low provides highest concurrency, lowest resources, and DoP =1.

Students also viewed

auto

60 terms

williamdwalker

1Z0-931-20

82 terms

DBADiegoAndrade

YJSH

65 terms

sam_horning4

1Z0-931 Autonomous Database Specialist

43 terms

CIoudGuru

Sets found in the same folder

ADB Certification

79 terms

dganey95

ADB Certification Practice Questions

72 terms

brandon_alarie8

ADB Practice Exam

60 terms

zimmerja

Other sets by this creator

OCI Operations (1Z0-1067-19)

75 terms

cdnguyen34

unseen

31 terms

cdnguyen34

ME 3370 Chapter 20

19 terms

cdnguyen34

Liberty, Equality, Power: Chapter 29

25 terms

cdnguyen34

Verified questions

earth science

**Explain** how Pluto differs from the outer planets of the solar system.

Verified answer

physics

Consider a similar plot for rocks ejected from Mars. Where would this plot intercept the $x$ axis? A. The plot for Mars would intercept the $x$ axis at $5.0 \mathrm{~km} / \mathrm{s}$. B. The plot for Mars would intercept the $x$ axis at $16.2 \mathrm{~km} / \mathrm{s}$. C. The plot for Mars would intercept the $x$ axis at $11.2 \mathrm{~km} / \mathrm{s}$. D. The plot for Mars would not intercept the $x$ axis.

Verified answer

physics

Which effect proves more conclusively that an object is charged, attraction to or repulsion from another object? Explain.

Verified answer

physics

Imagine a cavity at temperature T. Show that $\mathcal{c}_{v}$, the specific heat of the enclosed radiation, is given by $\left(32 \pi^{5} k V / 15\right)(k T / h c)^{3}$. Explain why $\mathcal{c}_{v}$ does not have an upper limit in this case whereas it does for solids.

Verified answer

Recommended textbook solutions

Fundamentals of Database Systems

7th EditionRamez Elmasri, Shamkant B. Navathe

687 solutions

Information Technology Project Management: Providing Measurable Organizational Value

5th EditionJack T. Marchewka

346 solutions

Computer Organization and Design MIPS Edition: The Hardware/Software Interface

5th EditionDavid A. Patterson, John L. Hennessy

220 solutions

Information Technology Project Management: Providing Measurable Organizational Value

5th EditionJack T. Marchewka

346 solutions

Other Quizlet sets

A&P Ch. 26 Urinary System

103 terms

shaun_david_lee

Formative Quiz NVI

88 terms

lauren_belloffPlus

Psychology-Chapter 12

96 terms

mmosharraf

각론0410 국어_3강, 미술_1강

15 terms

baeksunsunsangsang

How can I access data from autonomous JSON database?

What are three methods to load data into the autonomous database?

What are the 3 key capabilities of the autonomous database?

Which are the three types of autonomous database you can deploy?