You are running your warehouse using Autonomous Data Warehouse (ADW) service and you noticed that a newly configured batch job is always running in serial even through nothing else is running in the database.
All your jobs are configured to run with parallelism enabled.
What could be the reason for this batch job to run in serial?

• A.The new batch job is connected to LOW consumer group.
• B.The batch job depends on only one table and parallelism cannot be enabled on single-table queries.
• C.The new batch job runs on database tables that are not enable for parallel execution.
• D.Parallelism on the database is controlled by the application, not the database.
• E.The parallelism of batch job depends on the number of ADW databases involved in the query.

Comment: *

Name: *

Email: *

Verification: *

You are designing a two-tier web application in Oracle Cloud Infrastructure (OCI). Your clients want to access the web servers from anywhere, but want to prevent access to the database servers from the Internet.
Which is the recommended way to design the network architecture?

• A.Create public subnets for web servers and private subnets for database servers in your virtual cloud network (VCN), and associate separate internet gateways for each subnet.
• B.Create public subnets for web servers and associate a dynamic routing gateway with that subnet, and a private subnet for database servers with no association to dynamic gateway.
• C.Create public subnets for web servers and private subnets for database servers in your VCN, and associate separate security lists and route tables for each subnet.
• D.Create a single public subnet for your web servers and database servers, and associate only your web servers to internet gateway.

Comment: *

Name: *

Email: *

Verification: *

How can you provide users access to an existing compartment?

• A.by granting users access to a compartment when the compartment is created
• B.by adding users to a group and defining a policy to provide the group access to the compartment
• C.by adding users to a compartment. All users in the compartment will have access to the objects in the compartment.
• D.by granting access directly to the user when the user is created

Comment: *

Name: *

Email: *

Verification: *

Which two options are available within the service console of Autonomous Transaction Processing?

• A.Monitor the health of the database server including CPU, memory and query performance
• B.Configure resource management rules and reset the admin password
• C.Perform a manual backup of the ATP database
• D.Fine tune a long running query using optimizer hints

Correct Answer: A,B

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the Oracle Cloud Infrastructure Object Storage Service? (Choose two.)

• A.It provides higher IOPS than Block Storage.
• B.It can be directly attached or detached from a compute instance.
• C.Data is stored redundantly only in a single AD.
• D.Data is stored redundantly across multiple availability domains (ADs) in a multi-AD region.
• E.It provides strong consistency.

Comment: *

Name: *

Email: *

Verification: *