1z0-1096-23 Exam Dumps - Oracle Machine Learning using Autonomous Database 2023 Associate

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

Explanation

https://docs.oracle.com/en/database/oracle/machine-learning/oml4sql/21/mlsql/oracle-machine-learning-sql-guide.pdf

Explanation

https://docs.oracle.com/en/database/oracle/machine-learning/oml-notebooks/omlug/get-started-jobs.html#GUID-DAE3D097-2EB5-4345-88F5-B4780EFD634A

• Oracle Machine Learning algorithms are suitable for various use cases that involve data analysis, prediction, classification, clustering, association, and feature extraction56.
• Three use cases that are suitable for Oracle Machine Learning algorithms are:

Explanation

Oracle Machine Learning Notebooks is an Apache Zeppelin-based collaborative web-based inter-face that provides a development environment to create machine learning notebooks where you can perform data exploration and visualizations, data preparation and machine learning. https://docs.oracle.com/en/database/oracle/machine-learning/oml-notebooks/omlug/get-started-oracle-machine-learning.html

Explanation

About Data Loading: Autonomous Database provides the following loading options: You can load data using Oracle Database Actions. You can load data using Oracle Database tools and Oracle or other 3rd party data integration tools. On transaction processing systems you traditionally ingest data through routine transactions or with DML operations. In general you load data from files local to your client computer or from files stored in a cloud-based object store. To load data from files in the cloud, use either Oracle Database Actions or use the Autonomous Database PL/SQL package DBMS_CLOUD to load files from the cloud. For the fastest data loading experience Oracle recommends uploading the source files to a cloud-based object store, such as Oracle Cloud Infrastructure Object Storage, before loading the data into your database. Oracle provides support for loading files that are located locally in your data center, but when using this method of data loading you should factor in the transmission speeds across the Internet which may be significantly slower. For more information on Oracle Cloud Infrastructure Object Storage, see Putting Data into Object Storage and Overview of Object Storage. Note: If you are not using ADMIN user, ensure the user has the necessary privileges for the operations the user needs to perform. See Manage User Privileges on Autonomous Database - Connecting with a Client Tool for more information.

Explanation

https://docs.oracle.com/en/database/oracle/machine-learning/oml-notebooks/omlug/notebooks.html

• The reason why a user with Developer permission is unable to create a job on an existing notebook that is shared is that the user requires the Create Job role1.
• The Create Job role is a database role that grants the privilege to create and manage jobs on Oracle Machine Learning Notebooks. This role is not granted by default to any user, including the ADMIN user. An administrator needs to explicitly grant this role to users who need to create jobs1