Try Free Oracle 1Z0-1096-23 Updated Questions & Answers

Question 1

You are using Oracle Machine Learning with Autonomous Database for the first time. After creating an Autonomous Database, what is the next step that you have to perform?

AConnect to the Database

BCreate an OML user

CCreate an ML notebook

DCreate a compartment

Correct answer: B

https://docs.oracle.com/en/cloud/paas/autonomous-database/oml-tour/

Question 2

Which step is not required to be performed by an administrator when adding a new user to Oracle Machine Learning (OML) Notebooks?

AProvide the user with Autonomous Database client wallet for remote credentials.

BCreate an OML username and password for the user in the Oracle Machine Learning User Management interface.

CAdd the user's name and email ID in the Oracle Machine Learning User Management interface.

DIssue grant commands on tables from other schemas to allow access from shared note-books.

Correct answer: A

The step that is not required to be performed by an administrator when adding a new user to Oracle Machine Learning Notebooks is providing the user with Autonomous Database client wallet for remote credentials.

The client wallet is only needed for remote access to the database using tools such as SQL Developer or Python. For accessing Oracle Machine Learning Notebooks, the user only needs an OML username and password, which are created by the administrator in the Oracle Machine Learning User Management interface

Question 3

Examine the SQL command: SQL> SELECT CUST_MARITAL_STATUS,MEDIAN(CUST_CREDIT_LIMIT) FROM SH.CUSTOMERS GROUP BY CUST_MARITAL_STATUS; Which statement is true about running this command where the table has columns cust_maritax._status3 (VARCHAR2) and cust_credit_limit (number) with 100k rows of non-null data?

AIt will return a customer's marital status and credit limit grouped by marital status

BIt will return an error.

CIt will return the marital status and credit limit of each customer.

DIt will return the median value of customer credit limit grouped by marital status.

Correct answer: D

Running this command will return the median value of customer credit limit grouped by marital status2.

The MEDIAN function is an aggregate function that returns the middle value of a numeric column for each group or partition.If the number of values is even, it returns the average of the two middle values2.

The GROUP BY clause is used to divide the rows of a table into groups that have the same values in the specified columns.The aggregate functions are applied to each group separately and the result is returned for each group3.

Question 4

Which output formats are supported by the SET SQLFORMAT command? (Choose three.)

ATXT

BHTML
(Correct)

CJSON

DCSV

Correct answer: C, D

https://docs.oracle.com/en/database/oracle/machine-learning/oml-notebooks/omlug/output-formats-supported-set-sqlformat.html

Question 5

When managing Machine Learning models using the OML AutoML UI, what are the three actions that can be performed on Oracle Machine Learning (OML) models from within OML AutoML UI? (Choose three.)

ACreate a notebook with auto-generated OML4Py code from an OML in-database mod-el to allow for further model tweaking and batch scoring.

BDeploy an OML in-database model to a REST endpoint.

CReview the model statistics associated with the experiment of an ONNX-format (Open Neural Networks Exchange) model.

DReview the model statistics associated with the experiment of an OML in-database model.

EReview the model statistics associated with the experiment of an ONNX-format image classification model.

Correct answer: A, B, D

When managing machine learning models using the OML AutoML UI, three actions that can be performed on Oracle Machine Learning (OML) models from within OML AutoML UI are:

Create a notebook with auto-generated OML4Py code from an OML in-database model to allow for further model tweaking and batch scoring.This feature enables users to export the selected model as a notebook that contains the OML4Py code to reproduce the model building process and perform additional tasks such as model evaluation, scoring, or deployment1.

Deploy an OML in-database model to a REST endpoint.This feature enables users to deploy the selected model as a RESTful web service that can be accessed by external applications or tools for real-time scoring or predictions2.

Review the model statistics associated with the experiment of an OML in-database model.This feature enables users to view the details of the model such as the algorithm name, hyperparameters, performance metrics, feature importance, and confusion matrix3.

1Z0-1096-23 Exam Dumps and Practice Questions

Most Recent Oracle 1Z0-1096-23 Exam Dumps

Actual Oracle 1Z0-1096-23 Exam Questions

Unlock all Oracle 1Z0-1096-23 questions