Oracle Certification Practice Exam - Part 1

How can you can register and use Oracle machine learning models? Select TWO correct answer.

• Autonomous Data Warehouse

• Oracle Storage

• Oracle Functions

• Oracle Database

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

• TNS Descriptor

• Client Credentials

• Connect As and Password

• Service Name

Which connection type is recommended for Pixel Perfect reports?

• JNDI Connection

• JDBC Connection

• ODBC Connection

• HTML Connection

Which machine learning algorithm should you use to prevent frauds for banks?

• Classification

• Clustering

• Anomaly Detection

• Regression

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

• Filtering

• Sorting

• Binning

• Masking

Which database function can be used to pass through expression to get advanced calculation?

• Math Function

• Aggregate Function

• String Function

• Evaluate Function

Which Oracle Analytics Cloud Edition can build data model, reports and analytic dashboard?

• Enterprise Edition

• Developer Edition

• Basic Edition

• Professional Edition

What does Dimensional table comprise of?

• Measures

• Dimension Foreign keys

• Business Entity Description

• Only PII Attributes

With regard to dimensional designs, what are the types of schemas? Select TWO correct answers.

• Moon Schema

• Star Schema

• Snowflake Schema

• Snowmobile Schema

Which application role should you grant to an user in Oracle Analytics Cloud such that the user can load data? Select TWO correct answers.

• BI Data Model Author

• BI Service Administrator

• BI Data Load Author

• DV Consumer