2024年最新のOracle 1z0-1096-23試験問題には73問があります
無料で使える1z0-1096-23別格な問題集をダウンロード2024年01月14日に更新された73問があります
Oracle 1z0-1096-23 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
質問 # 13
What are three key features of Oracle Machine Learning Notebooks? (Choose three.)
- A. They enable job scheduling of notebooks on a recurring schedule.
- B. They provide a collaborative notebook interface on Oracle Autonomous Database.
- C. They support SQL, PL/SQL, JavaScript, and PHP scripting languages.
- D. They enable access to in database implementation of machine learning algorithms.
- E. They support integration with Oracle Data Miner-ID
正解：A、B、D
解説：
Explanation
https://docs.oracle.com/en/database/oracle/machine-learning/oml-notebooks/
質問 # 14
An OML AutoML UI Experiment is a work unit that minimally contains the definition of which three options?
(Choose three.)
- A. Parameters
- B. Prediction Target
- C. Algorithm
- D. Prediction Type
- E. Data Source
正解：B、D、E
解説：
Explanation
https://docs.oracle.com/en/database/oracle/machine-learning/oml-automl-ui/amlui/create-experiment.html
質問 # 15
Which option would you use to load data from Object Storage into an Oracle Autonomous Database?
- A. Oracle SQL Developer Web
- B. SQL*Loader
- C. Expdp
- D. DBMS_Cloud package
正解：D
解説：
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.
質問 # 16
For which two types of notebooks can you schedule a job? (Choose two.)
- A. Notebooks shared with you
- B. Notebooks under Personal templates
- C. Notebooks owned by you
- D. Notebooks under Shared templates
正解：A、C
解説：
Explanation
About Workspace Permission Types: Oracle Machine Learning allows three types of permissions. Depending on the permission type, you can allow the user to view or perform different tasks in your workspace, projects, and notebooks. The three types of permissions are listed in the following table along with the actions that are allowed. Permission Types || Actions based on permission > Manager: * Project: Create, update, delete. * Workspace: View only. * Notebooks: Create, update, run, delete, and schedule jobs. > Developer: * Project:
View only. * Workspace: View only. * Notebooks: Cre-ate, update, run, and delete notebooks that a developer creates only. * Jobs: View and run jobs of shared notebooks only. A developer cannot create jobs for notebooks that are shared. > Viewer: * Project: View only. * Workspace: View only. * Notebooks: View only. * Jobs: View jobs and job runs of shared notebooks only.
質問 # 17
Examine the command: %script SET SQLFORMAT ANSICONSOLE What is the output of a query if this SQLFORMAT is set?
- A. It formats the output columns to return ANSI characters.
- B. It formats output columns with fixed-width columns with data enclosed in double quotation marks.
- C. It formats and resizes the output columns to the width of the data to save space.
- D. It formats the output columns to Add ANSI characters as the delimiter string.
正解：C
解説：
Explanation
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/omlug/output-formats-supported-set-sq
質問 # 18
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 among others. Which three algorithms can you use to produce such a model with Oracle Machine Learning? (Choose three.)
- A. Support Vector Machine (Regression)
- B. Generalized Linear Model (Classification)
- C. Explicit Semantic Analysis
- D. Neural Networks (Regression)
- E. One-Class Support Vector Machine
- F. Generalized Linear Model (Regression)
正解：A、D、F
解説：
Explanation
https://learn.oracle.com/ols/course/using-oracle-machine-learning-with-autonomous-database/35644/98086/1493 This is from Oracle Course : Using Oracle Machine Learning with Autonomous Database Regression is a supervised learning technique used when the output attribute is a continuous numerical value, for example, the price of a property based on the attributes of the property and its locality, the humidity of an area, and so on.
Here is a list of all the algorithms offered by Oracle Machine Learning. Unsupervised learning does not involve direct control from the developer. In terms of defining an output attribute, the output attribute is a dependent attribute. And as there is no output attribute in unsupervised learning, there is no distinction between dependent and independent attributes.
質問 # 19
Which four actions would typically be performed during the data preparation step for analyzing data with Oracle Machine Learning?
- A. building a machine learning model
- B. missing value replacement
- C. performing feature engineering, such as creating derived variables
- D. numeric data normalization
- E. binning of numeric data
- F. data collection from various sources
正解：B、C、D、E
解説：
* The data preparation step for analyzing data with Oracle Machine Learning involves various actions to transform the raw data into a suitable format for machine learning algorithms45.
* Some of the actions that would typically be performed during the data preparation step are:
* Numeric data normalization: This is a technique for reducing the range of numerical data by mapping them to a standard scale, such as 0 to 1. Normalization can improve the performance and stability of some machine learning algorithms5.
* Missing value replacement: This is a technique for handling missing or null values in the data, which can cause errors or bias in some machine learning algorithms. Missing values can be replaced by various methods, such as mean, median, mode, or a constant value4.
* Performing feature engineering, such as creating derived variables: This is a technique for creating new features from existing ones or combining them in meaningful ways. Feature engineering can enhance the predictive power and interpretability of machine learning models4.
* Binning of numeric data: This is a technique for reducing the cardinality of continuous and discrete data by grouping related values together in bins. Binning can improve resource utilization and model build response time without significant loss in model quality. Binning can also strengthen the relationship between attributes and improve model quality5
質問 # 20
Which is a FALSE statement regarding Oracle Machine Learning (OML)?
- A. OML offerings need a separate data visualization tool for creating visualization.
- B. OML provides scalable statistical functions though OML4Py and OML4R.
- C. OML provides integration with open source Python and R statistical analysis functions.
- D. OML provides univariate and multivariate statistics.
正解：A
解説：
* A false statement regarding Oracle Machine Learning (OML) is that OML offerings need a separate data visualization tool for creating visualization56.
* OML does not need a separate data visualization tool for creating visualization because it provides various options for visualizing data and models within its offerings. For example, OML Notebooks support interactive charts and graphs using Plotly and Matplotlib libraries for Python and R.
OML SQL also supports native SQL functions for creating histograms, scatter plots, box plots, and more
質問 # 21
Which output formats are supported by the SET SQLFORMAT command? (Choose three.)
- A. TXT
- B. HTML
(Correct) - C. JSON
- D. CSV
正解：C、D
解説：
Explanation
https://docs.oracle.com/en/database/oracle/machine-learning/oml-notebooks/omlug/output-formats-supported-set
質問 # 22
Which two can be performed by an Administrator in Oracle Machine Learning Notebooks? (Choose two.)
- A. View notebooks in read-only mode
- B. Manage any notebook
- C. Reassign user workspace
- D. Run noteboooks
正解：A、C
解説：
Explanation
https://docs.oracle.com/en/database/oracle/machine-learning/oml-notebooks/omlug/administer-oracle-machine-le
質問 # 23
Which category of machine learning algorithms does One-Class SVM fall under?
- A. Anomaly Detection
- B. Regression
- C. Classification
- D. Clustering
正解：A
解説：
Explanation
https://docs.oracle.com/en/database/oracle/machine-learning/oml4sql/21/mlsql/oracle-machine-learning-sql-guid
質問 # 24
Which three are supervised machine learning algorithms? (Choose three.)
- A. Support Vector Machines
- B. Linear Regression
- C. K-means clustering
- D. Random Forest
- E. Association rule
正解：A、B、D
解説：
Explanation
https://docs.oracle.com/en/database/oracle/machine-learning/oml4py/1/mlpug/about-machine-learning-algorithm
質問 # 25
Which three actions can be performed by an Administrator in Oracle Machine Learning (OML) Notebooks?
(Choose three.)
- A. Reassign workspaces to users.
- B. Create, run and delete notebooks.
- C. Create and run jobs.
- D. View notebooks.
- E. Create, edit and delete OML users.
正解：A、D、E
解説：
Explanation
https://docs.oracle.com/en/database/oracle/machine-learning/oml-notebooks/omlug/administer-oracle-machine-le
* View notebooks. An Administrator can view notebooks in their own workspace or in workspaces where they have collaboration rights. However, an Administrator cannot run or modify notebooks1.
* Reassign workspaces to users. An Administrator can reassign workspaces from one user to another user in the User Data page. This can be useful when a user leaves the organization or changes roles2.
* Create, edit and delete OML users. An Administrator can create new OML user accounts and passwords, edit existing OML user information, and delete OML users in the User Management interface.
質問 # 26
Which step is not required to be performed by an administrator when adding a new user to Oracle Machine Learning (OML) Notebooks?
- A. Create an OML username and password for the user in the Oracle Machine Learning User Management interface.
- B. Add the user's name and email ID in the Oracle Machine Learning User Management interface.
- C. Provide the user with Autonomous Database client wallet for remote credentials.
- D. Issue grant commands on tables from other schemas to allow access from shared note-books.
正解：C
解説：
* 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
質問 # 27
You want to analyze the spike in sales during weekends in India (Saturday and Sunday) and also perform a similar analysis for weekends in Dubai (Friday and Saturday). You will be re-using these notebooks in similar situations over time. You do not want to share them with other users. Which template should you use?
- A. Shared
- B. Public
- C. Personal
- D. Example
正解：C
解説：
Explanation
https://learn.oracle.com/ols/course/using-oracle-machine-learning-with-autonomous-database/35644/98086/1493
質問 # 28
To navigate to a specific notebook provided by another user, which is the correct workflow?
- A. Change project > Change workspace > Open notebook
- B. Change user > Open notebook > Create project
- C. Select workspace > Select project > List notebooks > Open notebook
- D. Create user > Change workspace > Open notebook
正解：C
解説：
Explanation
https://apexapps.oracle.com/pls/apex/dbpm/r/livelabs/view-workshop?wid=891&clear=180&session=109742845
質問 # 29
Which of the following is not type of a workspace permission that can be granted to other us-ers?
- A. Manager
- B. Viewer
- C. Developer
- D. Contributor
正解：D
解説：
* Contributor is not a type of workspace permission that can be granted to other users in Oracle Machine Learning Notebooks1.
* The types of workspace permissions that can be granted to other users are Manager, Developer, and Viewer1.
* Manager is a user role that allows users to perform all the tasks of a Developer as well as manage other users' workspaces and permissions1.
* Developer is a user role that allows users to create and run notebooks, run SQL statements, create SQL scripts, run Python scripts, create jobs to schedule and run notebooks, use example template notebooks, create and run AutoML experiments, and deploy models1.
* Viewer is a user role that allows users to view notebooks but not run or modify them1
質問 # 30
Which three types of templates are available in Oracle Machine Learning Notebooks? (Choose three.)
- A. Example templates
- B. Custom templates
- C. Personal templates
- D. Public templates
- E. Shared templates
正解：A、C、E
解説：
Explanation
https://docs.oracle.com/en/database/oracle/machine-learning/oml-notebooks/omlug/use-library-collaborate-users
質問 # 31
Which two types of permissions allow you tables and run any script on an owner's account? (Choose two.)
- A. Manager
- B. Developer
- C. Guest
- D. Viewer
正解：A、B
解説：
Explanation
Grant Workspace Permissions You can collaborate with other users in Oracle Machine Learning by granting permissions to access your workspace. Your workspace contains your projects and note-books. By granting different types of permissions such as Manager, Developer, and Viewer, you can allow another user to view your workspace and perform different tasks in your projects and note-books such as edit, create, update, delete, run, view notebooks and so on. For more information about the permission types, see About Workspace Permission Types. Caution: If you grant the per-mission type Manager or Developer, then the user can also drop tables, create tables, and run any scripts at any time on your account. The user with Viewer permission type can only view your note-books, and is not authorized to run or make any changes to your notebooks
質問 # 32
......
Oracle 1z0-1096-23試験実践テスト問題：https://www.goshiken.com/Oracle/1z0-1096-23-mondaishu.html
最新の認定試験1z0-1096-23問題集-実践テスト問題：https://drive.google.com/open?id=1Khk97qXmRI-fxF2Xr_HlVHQ2aj1hQWtI