1096-21 Oracle Machine Learning Specialist

A supermarket needs to segment its customers based on their purchasing pattern. Which machine learning technique should you use to achieve this?. Clustering. Regression. Association Rules. Anomaly Detection.

Which two components support in-database automatic machine learning (AutoML) functionality?. OML4SQL. OML4Py. OML4R. OML Services. OML AutoML UI. Oracle Data Miner.

You want to segment your customer data for groups to build supervised models. What should you use to achieve this?. Regression. Classification. Feature Selection. Clustering.

When managing models using the Model Repository screen from the OML AutoML UI, what are the four operations a user can do to models and model deployments?. Change the deployment date of a previously deployed OML in-database model. Delete an existing OML in-database model. Change the namespace of a previously deployed OML in-database model. Deploy an existing Oracle Machine Learning in-database model as a REST endpoint in OML Services. Change the owner of a previously deployed OML in-database model. Undeploy a previously deployed OML in-database model.

How can you share a notebook with multiple developers for a collaborative effort with notebook editing?. You create different notebooks, edit separately and merge later. You can share notebooks if you have viewer permission. Notebooks cannot be shared for collaborating with other users. You can share notebooks if you have Developer permissions.

Which three tasks can be performed by an Oracle Machine Learning user with the Developer role?. Create and run scratchpads. Create other OML users. Transfer OML workspace to other users. Edit Example templates. Share notebooks. Create and run OML notebooks.

Which three are unsupervised machine learning algorithms?. Naïve Bayes. K-means clustering. Logistical regression. Association Rule. Random forest. Principal component analysis.

Two users at different locations are collaborating on a project by editing the same notebook. Which type of notebook should they use for collaboration?. Shared Notebook. Example Notebook. Personal Notebook. Public Notebook.

Which three data sources can be immediately used for model building in Oracle Machine Learning?. Oracle Database External Tables. JSON Files. CSV Files. Oracle Database Views. Oracle Database Tables.

Which is a FALSE statement regarding OML?. OML offerings need a separate data visualization tool for creating visualizations. OML provides univariate and multivariate statistics. OML provides integration with open source Python and R statistical analysis functions. OML provides scalable statistical functions through OML4Py and OML4R.

Which three types of templates are available in Oracle Machine Learning Notebooks?. Personal Templates. Public Templates. Example Templates. Shared Templates. Custom Templates.

Which three actions can be performed by an Administrator in Oracle Machine Learning (OML) notebooks?. Reassign workspaces to users. Create, edit and delete OML users. View notebooks. Create, run and delete notebooks. Create and run jobs.

You want to predict which customers are likely to increase spending if given an additional credit card. Your task is to build a model using demographic and aggregated credit card data for customers who have used similar cards in the past. Which machine learning technique should you use to achieve this?. Classification. Regression. Feature extraction. Attribute Importance.

Which task is NOT required by an Administrator when adding new user to Oracle Machine Learning Notebooks?. Issue grant command on the database to allow access to the tables associated with the user’s Oracle Machine Learning Notebooks. Create an OML username and password for the user in the Oracle Machine Learning Management User Interface. Add the user’s full name and email ID in the Oracle Machine Learning Management User Interface. Provide the user with an Autonomous Data Warehouse client wallet for remote authentication.

Which three types of forms are available in Oracle Machine Learning Notebooks?. Text input form. Select form. List form. Checkbox form. Radio form.

Which statement is FALSE about Oracle Machine Learning Notebooks?. When visualizing a 1 million row database data using the built-in Zeppelin visualizers, OML will by default display the results on the entire table. You can set the output format in SQL paragraphs of a notebook. You can share notebooks with Import/Export operations. Within the notebook paragraphs you can switch between data views of tables, pie charts, bar charts, line plots, and scatter plots.

You are tasked with building a predictive model that can estimate the price of houses, based on attributes like number of rooms, square-footage (size), location, neighborhood attributes, year built, etc. among others. Which three algorithms can you use to produce such a model with OML?. Generalized Linear Model (Regression). Support Vector Machine (Regression). Explicit Semantic Analysis. One-Class Support Vector Machine. Generalized Linear Model (Classification). Neural networks (Regression).

Which four statements are true about Oracle Machine Learning on Oracle Autonomous Database?. It includes parallelized in-database algorithms. It provides a development environment to build models and score data. It enables data analytics, data discovery, and data visualizations. It is deployed with Oracle Data Miner. It provides an interface to monitor a database. It provides a collaborative web-based notebook interface.

You have created a workspace in Oracle Machine Learning Notebooks and want to share it with collaborators by granting permissions to access your workspace. You want to enable other users to run and modify your notebooks but do not want to provide the ability to schedule jobs that run your notebooks. Which permission type should be granted to this user?. Viewer. Editor. Manager. Developer.

Examine the command: %script SET SQLFORMAT ANSICONSOLE What is the output of a query if this sqlformat is set?. It formats the output columns with fixed-widths columns with data enclosed in double quotation marks. It formats the output columns to return ANSI characters. It formats and resized the output columns to the width of the data to save space. It formats the output columns to add ANSI characters as the delimiter string.

In which of these use cases are Oracle Machine Learning algorithms suitable?. Customer segmentation. Graph analytics. Speech recognition. Medical outcome analysis. Anomaly and fraud detection.

You are creating a job that should run a notebook every hour. You want to make sure that the job does not run repeatedly if there are more than five consecutive failures to run the job. Which option should you set while creating the job?. Minimum Failure Allowed. Maximum Number of Runs. Maximum Failure Allowed. Timeout in Minutes.

Given the steps: 1. Create Oracle Machine Learning User 2. Create projects 3. Create workspaces 4. Create Notebooks 5. Run SQL Scripts Which two steps are out of order when working with Oracle Machine learning? (Choose two.). Create Oracle Machine Learning User. Create workspaces. Create Notebooks. Run SQL Scripts. Create projects.

Which three statements are true about unsupervised machine learning?. There is no previously known result to guide the algorithm in building the model. It uses unlabeled data. It analyzes cases where the target value is already known. It can be used as a preliminary step for supervised algorithms.

Which two statements are true about supervised machine learning?. There is no previously known result to guide the algorithm in building the model. It does not specify a target, it can be applied to a population of interest. It is used to extract meaningful insights from raw data to improve data operational efficiency. It generally results in predictive models. The learning process is directed by a previously known dependent attribute or target.

Which two Oracle Cloud services are integrated with Oracle Machine Learning?. Oracle Stream Analytics. Oracle Analytics Cloud. Oracle Autonomous Database. Oracle GoldenGate.

Which technology is used by OML Notebooks which enables teams to collaborate to build, assess, and deploy machine learning models?. Kaggle. Jupyter Notebooks. Apache Zeppelin. Google Colab.

A banking company wants to segment its customers based on credit card usage and identify homogeneous groups on which it can build supervised models. Which machine learning function should the company use?. Classification. Clustering. Anomaly Detection. Regression.

Which role can create a new user account and user credentials for Oracle Machine Learning in the User Management interface?. Administrator. Architect. Tester. Developer.

Which extensions can be imported by Oracle Machine Learning Notebooks? Select two correct answers. HTML. JSON. TXT. IPYNB.

Predicting stock market index values based on macro economic changes is an example of what machine learning scenario?. Ranking. Clustering. Anomaly Detection. Regression.

Which of the following are unsupervised machine learning algorithms? Select TWO correct answers. Support Vector Machines. Independent Component Analysis. Linear Regression. Association rules.

What are the characteristics of unsupervised machine learning models? Select two correct answers. It works on labeled data. It works on unlabeled data. The learning process is directed by a previously known dependent attribute or target. Can be used for descriptive purposes.

What is the correct sequence for the phases of the ML process?. Deploy, prepare data, develop models, evaluate, analyze data. Analyze data, prepare data, develop models, evaluate, deploy. Analyze data, prepare data, evaluate, develop models, deploy. Prepare data, analyze data, evaluate, develop models, deploy.

Which notebook template should you save such that only your account can view or use the notebook?. Shared. Private. Confidential. Personal.

Which notebook template can list the pre-populated Oracle Machine Learning notebook templates?. Shared. Sample. Example. Personal.

Which notebook template should you save such that other users can view and create notebooks from the template that they can run and edit?. Shared. Private. Confidential. Personal.

Which of the following are characteristics of the Classification Algorithm?. It is a data mining function that discovers the probability of the co-occurrence of items. It is a data mining function that assigns items in a collection to target classes. The goal of classification is to identify cases that are unusual within data. The goal of classification is to accurately predict the target class for each case in the data.

You are working on notebooks and want to configure the maximum amount of time a job should be allowed to run. Which of these is appropriate while creating the job?. Minimum Number of Runs. Maximum Number of Runs. Maximum Failures Allowed. Timeout in Minutes.

Which of the following are correct steps that comprise a machine learning workflow automated by AutoML?. Algorithm selection, adaptive sampling, feature selection, model tuning. Algorithm selection, model tuning, adaptive sampling, feature selection. Adaptive sampling, algorithm selection, model tuning, feature selection. Feature selection, adaptive sampling, algorithm selection, model tuning.

What are the salient features of Oracle Machine Learning Notebooks with Autonomous Database?. Voice modulation among singers and artists. Allows collaboration among data scientists, developers, business users. Notebook style application designed for Python users and provides interactive data analysis. Leverages the scalability and performance of Oracle Platform and its Cloud services.

How can you register and use Oracle Machine Learning models? Select TWO correct answers. Oracle Autonomous Data Warehouse. Object Storage. Oracle Functions. Oracle Database.

Which type of template can list the notebooks that you have created?. Personal. Example. Shared. Private.

Which directive in the input section of the paragraph should you use to call PL/SQL interpreter and run PL/SQL scripts?. %sql. %script. %md. %python.

Which of these are the roles and responsibilities of an administrator?. Run notebooks. Read notebooks. Create jobs to schedule notebooks. Reassign user workspace.

In which output is an Oracle Machine Learning Notebooks notebook saved or exported?. XML. Custom binary format. CSV. JSON.

When managing Machine Learning models using the OML AutoML UI, what are three actions that can be performed on Oracle Machine Learning models from within OML AutoML UI?. Review the model statistics associated with the experiment of an ONNX-format image classification model. Review the model statistics associated with the experiment of an OML in-database model. Create a notebook with auto-generated OML4Py code from an OML in-database model to allow for further model tweaking and batch scoring. Review the model statistics associated with the experiment of an ONNX-format (Open Neural Networks Exchange). Deploy an OML in-database model to a REST endpoint.

Which three OML Notebooks capabilities are enabled when an OML user is created with the OML_DEVELOPER role?. Create and execute OML Notebooks. Transfer OML workspace to other users. Save scripts to the Python script repository. Share notebooks with other OML users.

Which three statements are true about Oracle Machine Learning Notebooks?. It provides a web-based interface for data analysis. It is used to manage and monitor database objects. It is used for data preparation and exploration. It is used to create low-code applications. It is used to access machine leaning algorithms.

You have created a notebook and want to run the notebook on a periodic schedule. How should you achieve this?. You need to contact the database administrator to configure the notebook to run at a particular time. You can create a job and schedule it to run a specific notebook. You cannot run the notebook on the scheduled time. You have to login as the admin user and schedule a job to run the notebook.

You have developed a notebook in an ADB and you need to share the notebook with your colleague to run on a different ADB instance. How should you enable your colleague to work with this notebook?. Export the notebook in json format and have your colleague import this notebook. Save the notebook as a shared template. Save the notebook in csv format and have your colleague import this notebook. Make the notebook public.

Which two are required by an administrator while adding a new user to OML Notebooks?. ADB Name. User's name and email. Wallet information to connect to ADB. Privileges to be provided. OML username and password.

What are the key features of Oracle Machine Learning in Autonomous Database?. Helps in logical separation of resources. Built-in AutoML provides automated algorithms. Creates a private connection between on premises customers and OCI. Simplifies the creation of ML models like data preparation, model building, evaluation, and deployment.

Which algorithm can help you build models which can predict parameters like mortgage rates, temperature, or distance? Select two correct answers. Feature selection. XGBoost Regression. Row Importance. Neural Networks.

Which user permissions can delete jobs to run your notebooks?. Viewer. Manager. Tester. Developer.

What are the business scenarios where Machine Learning can be implemented?. Voice modulation. Image classification. Customer segmentation. E-wallet automation.

Which three SQL commands are restricted in an Autonomous Database?. Alter table. Create table. Alter tablespace. Create tablespace. Alter profile.

Which four actions would typically be performed during the data preparation step for analyzing data with OML?. Performing feature engineering, such as creating derived variables. Binning of numeric data. Missing value replacement. Data collection from various sources. Numeric data normalization. Building a machine learning model.

Which two statements are true about Classification algorithms?. They predict numeric values along a continuum. They extract rules using unsupervised learning. They assign cases to target categories. They require known outcomes to guide the learning process.

Which type of user has access to the OML User Management Interface?. Administrator. Guest. Developer. Manager.

Which statement is FALSE about OML Notebooks?. The administrator is not authorized to run notebooks. You must have the Administrator role to access the OML User Management Interface. You must have the Administrator role to access the compute resources page. An existing database user cannot be added as an OML user using the User Management Interface.

When running which type of code must you use %script in Oracle Machine Learning Notebooks?. PL/SQL script. JSON script. JavaScript. SQL script.

Which category of machine learning algorithms does One-Class SVM fall under?. Classification. Regression. Anomaly Detection. Clustering.

What is the formula for accuracy of a model?. Accuracy = (FP+FN)/(TP+TN+FP+FN). Accuracy = (TP+TN+FP+FN)/(FP+FN). Accuracy = (TP+TN)/(TP+TN+FP+FN). Accuracy = (TP+TN+FP+FN)/(TP+TN).

Which is the most time-consuming phase of the OML AutoML UI process?. Hyperparameter tuning. Feature Selection. Adaptative Sampling. Algorithm Selection.

Which machine learning algorithm allows the system to identify patterns within data sets on its own?. Semi-supervised learning. Supervised learning. Unsupervised learning. Reinforcement learning.

Examine the steps: 1. Adaptive Sampling 2. Feature Selection 3. Algorithm Selection 4. Tuned Model 5. Hyperparameter Tuning 6. Collect Dataset Identify the correct order of steps for the OML AutoML UI pipeline. 6,3,1,2,5,4. 2,1,4,3,5,6. 6,1,3,2,4,5. 4,3,2,1,5,6.

Which three data input options are available using Forms in Oracle Machine Learning Notebooks?. image input. Checkbox multi-selection. Radio button select. Select from list. Text input.

Which three services can be used to access Oracle Machine Learning Notebooks?. Autonomous Dedicated Infrastructure. Autonomous Transaction Processing. Oracle Application Express. Autonomous Data Warehouse. Autonomous JSON Database.

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?. Create a compartment. Create an ML notebook. Connect to the Database. Create an OML user.

What is the definition of Recall?. Harmonic mean of the data. Proportion of actual positives that are correctly classified. Proportion of predicted positives that are correctly classified. Evaluation of a binary classifier. Proportion of correctly classified cases.

Which three tasks can you perform using Jobs in an OML notebook?. Duplicate jobs. Create jobs. Run jobs. Kill jobs. Stop jobs.

Which option would you use to load data from Object Storage into an Oracle Autonomous Database?. Expdp. SQL*Loader. Oracle SQL Developer Web. DBMS_Cloud Package.

Which three are true about Oracle Machine Learning Notebooks?. It can be used for data cleansing. It can be used for data analysis. It can be used for data visualization. It supports languages such as C, C++, Java, SQL, and Python.

Which two statements are true about OML AutoML UI?. Provides Classification Prediction Type for numeric data and Regression Prediction Type for non-numeric data. An Experiment returns a single machine learning model, on successful execution. When creating a notebook from an experiment-produced Model, the top algorithm in the Leader Board is automatically selected and converted to OML4Py code. Automates key modeling steps such as algorithm selection, feature selection, and hyperparameter tuning. An Experiment can be run with two possible options: Faster Results or Better Accuracy.

Which step in the AutoML pipeline involves reducing the size of the large data set into a smaller data set that adequately represents the original?. Hyperparameter tuning. Algorithm Selection. Feature Selection. Adaptative Sampling. Model Selection.

A user with the developer permission is trying to create a job on an existing notebook that is shared. However, the user is unable to do so. What is the reason?. The specified job already exists. A developer cannot create jobs for notebooks that are shared. The user requires the Create Job role. The notebook contains code with syntax errors, which need to be corrected first.

Which two Python Libraries are used for visualization?. Matplotlib. Cycler. Pands. Scipy. Pytz.

To navigate to a specific notebook provided by another user, which is the correct workflow?. Change project > Change workspace > Open notebook. Select workspace > Select project > List notebooks > Open notebook. Create user > Change workspace > Open notebook. Change user > Open notebook > Create project.

Which two can be performed by an Administrator in Oracle Machine Learning Notebooks?. View notebooks in read-only mode. Run notebooks. Reassign user workspace. Manage any notebook.

Which is NOT a supervised learning algorithm?. Stepwise Linear Regression. Hierarchal K-Means. Naïve Bayes. Decision Tree. Support Vector Machine.

Which type of machine learning categorizes data points with the help of a target attribute?. Dimensionality Reduction. Regression. Classification. Clustering.