OAC exam Questions with Complete

OAC exam Questions with Complete Solutions How can you register and use Oracle machine learning models? Select TWO Correct Answers

• Oracle Autonomous Data Warehouse
• Object Storage
• Oracle Functions
• Oracle Database - Correct Answers ✅A and D

As an Enterprise Admin, you need to create a connection for data modeler. What are the details required? Select TWO Correct Answers

• TNS Descriptor
• Client Credentials
• Connect As and Password
• Service name - Correct Answers ✅A and C

As an Enterprise Admin, you need to create a connection for data set. What are the details required? Select TWO Correct Answers

• TNS Descriptor
• Client Credentials
• Connect As and Password
• Service name - Correct Answers ✅B and D 1 / 3

OAC exam Questions with Complete Solutions Which connection type should you use for Pixel Perfect reports?

• HTML connection
• ODBC connection
• JDBC connection
• JNDI connection - Correct Answers ✅D

(D is a better choice than option C) Which machine learning algorithm should you use to prevent frauds for banks?

• Anomaly detection
• Regression
• Classification
• Clustering - Correct Answers ✅A

Which data preparation action should you use to create new columns based on the value of the measure?

• Filtering
• Binning
• Sorting
• Masking - Correct Answers ✅B. creates a new column

based on the value of the measure eg. assign temperature values into two bin categories for <= 70 and >=70 2 / 3

OAC exam Questions with Complete Solutions Which database function can be used to pass through expressions to get advanced calculations?

• Math Functions
• String Functions
• Evaluate Function
• Aggregate Functions - Correct Answers ✅C. is the only

database function Which OAC Edition can build data models, reports and analytic dashboards?A.Enterprise Edition

• Professional Edition
• Basis Edition
• Developer Edition - Correct Answers ✅A. has more

features than Professional. Enterprise will always be the answer unless cost is involved What does Dimension table comprise of?

• Measures
• Dimension Foreign keys
• Business Entity Description
• Only PII Attributes - Correct Answers ✅C.
• Fact tables and dimension tables hold the columns that

store the data for the model.

• / 3