初心者向けの1z0-1096-23試験 [2023] 問題集でOracleのPDF問題
1z0-1096-23プレミアム試験エンジンPDFをダウンロード
Oracle 1z0-1096-23 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
| トピック 9 |
|
| トピック 10 |
|
質問 # 40
Which two components support in-database automatic machine learning (AutoML) functionality?
- A. OML4Py
- B. OML4R
- C. OML Services
- D. OML4SQL
- E. Oracle Data Miner
- F. OML AutoML UI
正解：A、F
解説：
Explanation
https://blogs.oracle.com/machinelearning/post/introducing-oml-automl-user-interface
https://www.oracle.com/a/tech/docs/technical-resources/oml-technical-brief.pdf
質問 # 41
Which two statements are true about supervised machine learning? (Choose two.)
- A. It generally results in predictive models.
- B. The learning process is directed by a previously known dependent attribute or target.
- C. There is no previously known result to guide the algorithm in building the model.
- D. It does not specify a target, it can be applied to a population of interest.
- E. It is used to extract meaningful insights from raw data to improve data operational efficiency.
正解：A、B
解説：
Explanation
https://docs.oracle.com/cd/F32587_01/dmcon/oracle-machine-learning-sql-concepts.pdf
質問 # 42
Which feature of Oracle Machine Learning Notebooks should you use for data analysis, da-ta discovery, data visualization, and collaboration on Oracle Autonomous Database?
- A. Notebook
- B. Job
- C. Project
- D. Workspace
正解：A
解説：
Explanation
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/create-notebooks-oml.html#GUID-0F489564
質問 # 43
To navigate to a specific notebook provided by another user, which is the correct workflow?
- A. Change user > Open notebook > Create project
- B. Change project > Change workspace > Open notebook
- 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
質問 # 44
Which three types of templates are available in Oracle Machine Learning Notebooks? (Choose three.)
- A. Public templates
- B. Shared templates
- C. Example templates
- D. Personal templates
- E. Custom templates
正解：B、C、D
解説：
Explanation
https://docs.oracle.com/en/database/oracle/machine-learning/oml-notebooks/omlug/use-library-collaborate-users
質問 # 45
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?
- A. It will return the median value of customer credit limit grouped by marital status.
- B. It will return a customer's marital status and credit limit grouped by marital status
- C. It will return an error.
- D. It will return the marital status and credit limit of each customer.
正解：A
解説：
* 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.
質問 # 46
Which option would you use to load data from Object Storage into an Oracle Autonomous Database?
- A. DBMS_Cloud package
- B. Oracle SQL Developer Web
- C. Expdp
- D. SQL*Loader
正解：A
解説：
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.
質問 # 47
Which three are unsupervised machine learning algorithms? (Choose three.)
- A. Logistical Regression
- B. Naive Bayes
- C. Random Forest
- D. Association rule
- E. K-means clustering
- F. Principal Component Analysis
正解：D、E、F
解説：
Explanation
Unsupervised machine learning uses a more independent approach, in which a computer learns to identify complex processes and patterns without a human providing close, constant guidance. Un-supervised machine learning involves training based on data that does not have labels or a specific, defined output. To continue the childhood teaching analogy, unsupervised machine learning is akin to a child learning to identify fruit by observing colors and patterns, rather than memorizing the names with a teacher's help. The child would look for similarities between images and separate them into groups, assigning each group its own new label.
Examples of unsupervised machine learning algorithms include k-means clustering, principal and independent component analysis, and association rules.
質問 # 48
When running which type of code must you use %script in Oracle Machine Learning Note-books?
- A. PL/SQL script
- B. JavaScript
- C. JSON script
- D. SQL script
正解：A
解説：
Explanation
https://docs.oracle.com/en/database/oracle/machine-learning/oml-notebooks/omlug/use-scratchpad.html
質問 # 49
Which two are required by an administrator while adding a new user to Oracle Machine Learning (OML) Notebooks? (Choose two.)
- A. Privileges to be provided
- B. Autonomous Database (ADB) name
- C. Wallet information to connect to ADB
- D. User's name and email ID
- E. OML username and password
正解：D、E
解説：
Explanation
https://docs.oracle.com/en/database/oracle/machine-learning/oml-notebooks/omlug/administer-oracle-machine-le Create User: An administrator creates a new user account and user credentials for Oracle Machine Learning in the User Management interface. Note: You must have the administrator role to access the Oracle Machine Learning User Management interface. To create a user account: Select an Autonomous Da-ta Warehouse instance and on the details page click Service Console. On the Service Console click Administration. Click Manage OML Users to open the Oracle Machine Learning User Administration page. Click Create on the Oracle Machine Learning User Administration page. In the Username field, enter a username for the account.
Using the username, the user will log in to an Oracle Ma-chine Learning instance. Enter a name in the First Name field. Enter a name in the Last Name field. In the Email Address field, enter the email ID of the user.
Select the option Generate password and email account details to user. User will be required to reset the password on first sign in. to auto generate a temporary password and send an email with the account credentials to the user. If you select this option, you need not enter values in the Password and Confirm Password fields; the fields are grayed out. In the Password field, enter a password for the user, if you choose to create a password for the user.This option is disabled if you select the Generate password... option to auto generate a temporary password for the user. In the Confirm Password field, enter a password to confirm the value that you entered in the Password field.By doing so, you create the password for the user. The user can change the password when first logging in. Click Create. This creates a new database user and grants the required privileges to use Oracle Machine Learning.
質問 # 50
What is the correct sequence of function invocations of AutoML API from OML4Py to solve a business problem?
- A. Model selection, Algorithm selection
- B. Model selection, Algorithm selection
- C. Algorithm selection, Feature selection. Model tuning
- D. Model tuning. Algorithm selection. Feature selection
正解：C
解説：
Explanation
https://www.doag.org/formes/pubfiles/13151859/OE-DAC-Oracle-Machine-Learning-Overview-Whats-New-Cu
質問 # 51
You have created an Oracle Machine Learning notebook and want to share it with another collaborator.
However, you do not want to provide the ability to run or modify the notebook in your workspace. Which three options can be used to do this? (Choose three.)
- A. Provide the user Developer permission to your workspace.
- B. Share the notebook as a Shared Oracle Machine Learning Template
- C. Export the notebook and import it into the other user's project
- D. Provide the user Viewer permission to your workspace
正解：B、C、D
解説：
Explanation
https://docs.oracle.com/en/database/oracle/machine-learning/oml-notebooks/omlug/collaborate-oracle-machine-l
質問 # 52
Two users at different locations are collaborating on a project by editing the same notebook. Which type of notebook should they use for collaboration?
- A. Public Notebook
- B. Example notebook
- C. Shared Notebook
- D. Personal Notebook
正解：C
解説：
Explanation
https://docs.oracle.com/en/database/oracle/machine-learning/oml-notebooks/omlug/use-library-collaborate-users Use Templates to Collaborate with Users In the Oracle Machine Learning Templates UI, you can collaborate with other users by sharing your work, publishing your work as reports, and by creating notebooks from tem-plates. You can store your notebooks as templates, share notebooks, and provide sample templates to other users. Note: You can also collaborate with other Oracle Machine Learning Notebook users by providing access to your workspace. The authenticated user can then access the projects in your workspace, and access your notebooks. The access level depends on the permission type granted - Manager, Developer, or Viewer.
For more information about collaboration among users, see
unre-solvable-reference.html#GUID-7079D42F-9308-4BEF-B2F2-E74E49A22A87 Use the Personal Templates Personal Templates lists the notebook templates that you have created. Use the Shared Templates In the Shared Templates, you can share notebook templates with all authenticated users the notebook templates you create from existing notebooks available in Templates. Use the Example Templates The Example Templates page lists the pre-populated Oracle Machine Learning notebook templates. You can view and use these templates to create your notebooks.
質問 # 53
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. Example
- B. Shared
- C. Public
- D. Personal
正解：D
解説：
Explanation
https://learn.oracle.com/ols/course/using-oracle-machine-learning-with-autonomous-database/35644/98086/1493
質問 # 54
Which three types of permissions can be granted to a user to callaborate and access a workspace in Oracle Machine Learning Notebooks?
- A. Manager
- B. Administrator
- C. Developer
- D. Viewer
- E. Guest
正解：A、C、D
解説：
* The three types of permissions that can be granted to a user to collaborate and access a workspace in Oracle Machine Learning Notebooks are Viewer, Manager, and Developer1.
* Viewer is a user role that allows users to view notebooks but not run or modify them1.
* 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.
質問 # 55
Which task is NOT required by an Administrator when adding a new user to Oracle Ma-chine Leamina (OML) Notebooks?
- A. Create an OML username and password for the user in the Oracle Machine Learning Management User Interface.
- B. Add the user's full name and email ID in the Oracle Machine Learning Management User Interface.
- C. Provide the user with an Autonomous Data Warehouse client wallet for remote authentication.
- D. Issue grant commands on the database to allow access to the tables associated with the user's Oracle Machine Learning Notebooks.
正解：C
解説：
* The task that is NOT required by an administrator when adding a new user to Oracle Machine Learning Notebooks is providing the user with an Autonomous Data Warehouse client wallet for remote authentication3.
* 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 interface3.
質問 # 56
Which notebook technology is used for Oracle Machine Learning in Oracle Autonomous Database?
- A. Polynote
- B. Jupyter Notebook
- C. Google Colab
- D. Zeppelin Notebook
正解：D
解説：
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-le
質問 # 57
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?
- A. Manager
- B. Viewer
- C. Designer
- D. Developer
正解：D
解説：
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: Create, 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.
質問 # 58
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?
- A. Attribute Importance
- B. Feature Extraction
- C. Classification
- D. Regression
正解：A
解説：
Explanation
https://docs.oracle.com/en/database/oracle/machine-learning/oml-notebooks/omlug/using-oracle-machine-learnin OML4Py Attribute Importance: Use this template notebook to identify key attributes that have maximum influence over the target attribute. The target attribute in the build data of a supervised model is the attribute that you want to predict. The template builds an Attribute Importance model using the SH schema data.
https://docs.oracle.com/en/database/oracle/machine-learning/oml4py/1/mlpar/ Attribute Importance class oml.ai(model_name=None, model_owner=None, **params) In-database Attribute Importance Model Computes the relative importance of variables (aka attributes or columns) when predicting a target variable (numeric or categorical column). This function exposes the corresponding Oracle Ad-vanced Analytics in-database algorithm. Oracle Advanced Analytics does not support the predic-tion functions for attribute importance. The results of attribute importance are the attributes of the build data ranked according to their predictive influence. The ranking and the measure of im-portance can be used for selecting attributes.
Attributes importance : oml.DataFrame Relative im-portance of predictor variables for predicting a response variable. It includes the following compo-nents: * variable: The name of the predictor variable * importance:
The importance of the predictor variable * rank: The predictor variable rank based on the importance value.
質問 # 59
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.
質問 # 60
......
あなたを合格させるOracle試験には1z0-1096-23試験問題集：https://www.passtest.jp/Oracle/1z0-1096-23-shiken.html
検証済み1z0-1096-23豪華お試しセットリアル試験問題集PDF：https://drive.google.com/open?id=18mDeNOed3YNI9Rr7IPhrzXtHXGNAYVtQ