[2023年11月22日] 最新の1z0-1041-23試験の的確なOracle Cloud Infrastructure 2023 Enterprise Analytics ProfessionalのPDF問題
1z0-1041-23試験問題を練習するならFast2test顕著なOracle Cloud Infrastructure 2023 Enterprise Analytics Professional試験練習問題集
質問 # 43
You want to create a Sales Amount by Month report for a product. The report should display sales amount from all cities in the South region with sales amount more than 1 million USD.
Which two Alters can be applied for Region and Sales Amount
- A. List filter for Region and Range filter for Sales Amount
- B. List filter for Region and List filter for Sales Amount
- C. List filter for Region and Expression filter for Sales Amount
- D. Range filter 'or Region and Date filter for sales Amount
正解：B、D
解説：
Two filters that can be applied for Region and Sales Amount are:
Range filter for Region and Date filter for sales Amount. A range filter allows you to specify a range of values for a column using operators such as greater than, less than, between, or not between. A date filter allows you to specify a date or a date range for a column using operators such as before, after, on, or between. For example, you can use a range filter to select only the South region and a date filter to select only the months with sales amount more than 1 million USD.
List filter for Region and List filter for Sales Amount. A list filter allows you to select one or more values from a list of values for a column using operators such as equals, not equals, in, or not in. For example, you can use a list filter to select only the South region and another list filter to select only the sales amounts that are more than 1 million USD. Reference: [Oracle Analytics Cloud - Data Visualization User's Guide], [Oracle Analytics Cloud - Data Visualization User's Guide]
質問 # 44
You have a global data set for oil princes for a period of time for each country.
However, you need to perform analyses on Asian countries for a period of one month Which two combinations of filters could you use to achieve this?
- A. Expression and Date Range
- B. List and Range
- C. List and Date Range
- D. Date Range and Top Bottom N
- E. Range and Expression
正解：A、C
解説：
To filter a global data set for oil prices for a period of time for each country based on Asian countries and one month period, you can use two combinations of filters:
Expression and Date Range: An expression filter allows you to create a custom filter expression using SQL syntax. You can use an expression filter to specify the condition for Asian countries based on the country column of your data set. A date range filter allows you to filter your data based on a start date and an end date. You can use a date range filter to specify the one month period based on the date column of your data set.
List and Date Range: A list filter allows you to filter your data based on one or more values from a list of values. You can use a list filter to select the Asian countries from the list of values in the country column of your data set. A date range filter allows you to filter your data based on a start date and an end date. You can use a date range filter to specify the one month period based on the date column of your data set. Reference: [Oracle Help Center], [Oracle Help Center], [Oracle Help Center]
質問 # 45
You are creating a Data Model for a sales order and do not have the Time dimension table created in the database.
You decide to use the Time Dimension create feature of Oracle Analytics Cloud (OAC) What are the tasks performed by the Time Dimension wizard execution?
- A. The Time Dimension wizard creates the time dimension table in the database, loads time data, and creates the time dimension in the Data Model.
- B. The Time Dimension wizard creates the Time dimension table in the database, load time data, and create the time dimension and hierarchy in the Data Model.
- C. The Time Dimension wizard creates the Time dimension table in the database and loads time data.
- D. The Time Dimension wizard generated the DDL query for the Time dimension table and inserts SQL for data load, which you need to run on your respective database schema.
正解：B
解説：
The Time Dimension wizard is a feature of Oracle Analytics Cloud that allows you to create a time dimension table in your database without having to write any SQL code. The time dimension table is a table that contains information about time periods, such as year, quarter, month, week, day, hour, and so on. You can use the time dimension table to perform time-based analysis on your data, such as comparing sales across different quarters or calculating year-to-date revenue. The Time Dimension wizard performs three tasks when you execute it:
It creates the time dimension table in your database based on the parameters that you specify, such as the name of the table, the start date and end date of the time range, the level of granularity (such as day or hour), and the format of the date values.
It loads time data into the time dimension table based on the parameters that you specify, such as the number of rows to insert per batch, the commit interval, and the connection details of your database.
It creates the time dimension and hierarchy in your data model based on the parameters that you specify, such as the name of the dimension, the name of the hierarchy, and the levels and attributes of the hierarchy. Reference: [Oracle Help Center], [Oracle Help Center]
質問 # 46
You are building a model that will be used for a sales report.
Which two statements are the about hierarchy and levels?
- A. A hierarchy shows relationships among a group of columns in a fact table.
- B. A hierarchy must have one to many relationships between attributes.
- C. A dimension table must have only one hierarchy.
- D. When defining a level. Key Columns must be the same as Display Columns.
- E. Hierarchies enable drilling in reports.
- F. Each level is based on one or multiple columns.
- G. Skipped levels and unbalanced hierarchies can be enabled for all the dimension tables.
正解：E、F
解説：
Two statements that are true about hierarchy and levels are:
Each level is based on one or multiple columns. A level is a logical grouping of one or more columns that represent a certain granularity or detail of data. For example, a level can be based on a single column, such as Year, or multiple columns, such as Year and Quarter.
Hierarchies enable drilling in reports. A hierarchy is a logical structure that defines the relationships among levels and shows how data can be aggregated or disaggregated from one level to another. For example, a hierarchy can show how Year, Quarter, Month, and Day are related in a time dimension. Hierarchies allow users to drill down or drill up in reports to see different levels of detail or summary of data. Reference: [Oracle Analytics Cloud - Data Visualization User's Guide], [Oracle Analytics Cloud - Data Visualization User's Guide]
質問 # 47
Which version of OBIEE is supported for migration to OAC?
- A. You cannot migrate content from OBIEE to OAC.
- B. OBIEE 12g and later
- C. OBIEE 11.1.X and later
- D. OBIEE 12c
- E. OBIEE 10g
正解：C
解説：
OBIEE 11.1.X and later is the version of OBIEE that is supported for migration to OAC. OBIEE stands for Oracle Business Intelligence Enterprise Edition, which is a comprehensive business intelligence platform that provides a range of analytics capabilities, such as interactive dashboards, ad hoc queries, enterprise reporting, and more. OAC stands for Oracle Analytics Cloud, which is a cloud-based analytics platform that provides similar features as OBIEE, as well as additional features such as data visualization, augmented analytics, machine learning, and more. You can migrate content from OBIEE to OAC using the Oracle BI Migration Tool, which is a command-line utility that allows you to export and import metadata and catalog objects between OBIEE and OAC. The Oracle BI Migration Tool supports migration from OBIEE 11.1.X and later versions to OAC, as these versions are compatible with OAC in terms of data model structure, catalog format, and security model. The other versions of OBIEE, such as OBIEE 12c, OBIEE 12g and later, and OBIEE 10g, are not supported for migration to OAC, as they are either not compatible with OAC or not available. Reference: Oracle Help Center, Oracle Help Center, Oracle Help Center
質問 # 48
The Order page of the Sales dashboard contains a report.
When a user clicks the value of the States column, the report is displayed in the click event drilled down in the same window.
How can you achieve this requirement?
- A. You can set publish page to dashboard in dashboard properties.
- B. You can set the drill in place option in section properties.
- C. It is not possible to open the drill in the report in the same window.
- D. You can set Link - Within the dashboard in report properties.
正解：B
解説：
To display the report in the click event drilled down in the same window, you can set the drill in place option in section properties. This option allows you to replace the original report with the drilled report in the same section of the dashboard page. You can also use breadcrumbs to navigate back to the original report. Reference: Oracle Analytics Cloud - Data Visualization User's Guide, Oracle Analytics Cloud - Data Visualization User's Guide
質問 # 49
Which application role must you grant to the user?
- A. DV Content Author
- B. Bl Dataload Author
- C. Bl Data Model Author
- D. Bl Content Author
正解：A
解説：
DV Content Author is the application role that you must grant to the user who wants to create and edit data visualizations in Oracle Analytics Cloud. Data Visualization is a feature that allows you to explore, analyze, and visualize your data using various types of charts, graphs, maps, and more. You can also apply filters, calculations, aggregations, and other functions to your data. To access Data Visualization, you need to have the DV Content Author role, which gives you the permission to create and edit data sets, projects, and data flows. The other roles, such as BI Content Author, BI Data Model Author, and BI Dataload Author, are not required for Data Visualization, but rather for other features such as Business Intelligence, Data Modeler, and Data Loader. Reference: [Oracle Help Center], [Oracle Help Center]
質問 # 50
Which are two use-cases for Data Flow?
- A. Perform some lightweight transformation within the Project.
- B. Create a custom Python Machine Learning model.
- C. Train and test the Machine Learning model.
- D. To curate data sets that can be used for visualizations.
正解：D
解説：
Data Flow is a feature of Oracle Analytics Cloud that enables you to create and run data flows to transform and enrich your data. You can use Data Flow for various use-cases, such as:
To curate data sets that can be used for visualizations. You can join, filter, aggregate, pivot, and perform other operations on your data sets to prepare them for analysis.
To train and test the Machine Learning model. You can use Data Flow to apply machine learning algorithms to your data and create predictive models. You can also evaluate the performance of your models and compare them with different parameters. Reference: [Oracle Help Center], [Oracle Help Center]
質問 # 51
Which role is required to edit and create a new semantic model in Oracle Analytics Cloud Enterprise Edition?
- A. BI RPD Model Author
- B. BI Content Author
- C. BI Data Load Author
- D. DV Consumer Role
- E. BI Data Model Author
正解：E
解説：
To edit and create a new semantic model in Oracle Analytics Cloud Enterprise Edition, you need to have the BI Data Model Author role. This role allows you to access and use the Data Modeler tool, where you can create and modify semantic models that define the logical structure and relationships of your data sources. You can also use the Data Modeler to create calculations, hierarchies, variables, security filters, and other features for your semantic models. Reference: [Oracle Analytics Cloud - Data Visualization User's Guide], [Oracle Analytics Cloud - Data Visualization User's Guide]
質問 # 52
Which service do you need to subscribe for creating an Oracle Analytics Cloud (OAC) instance?
- A. Oracle Big Data Cloud Storage
- B. Oracle Back Storage
- C. Oracle Analytics Cloud
- D. Oracle Autonomous Database
正解：C
解説：
To create an Oracle Analytics Cloud (OAC) instance, you need to subscribe to the Oracle Analytics Cloud service on Oracle Cloud Infrastructure (OCI). Oracle Analytics Cloud is a comprehensive analytics platform that provides a range of analytics capabilities, such as data visualization, augmented analytics, machine learning, enterprise reporting, and more. You do not need to subscribe to other services such as Oracle Back Storage, Oracle Autonomous Database, or Oracle Big Data Cloud Storage to create an OAC instance, although you can use them as data sources for your analytics projects. Reference: [Oracle Help Center], [Oracle Help Center]
質問 # 53
In which two layers can you use Oracle Analytics Cloud (OAC) to determine which values of a given data set may provide the greatest opportunity due to their outlier qualities?
- A. Use a combination of Max/Min value reference lines.
- B. Modify the color palette to highlight unique values.
- C. Add an outlier visualization to your canvas. This will highlight data points that stand out and may justify further investigation.
- D. Create a box plot visualization of your data set.
正解：C、D
解説：
Oracle Analytics Cloud (OAC) provides various ways to identify and analyze outliers in your data set. Outliers are data points that deviate significantly from the rest of the data and may indicate errors, anomalies, or opportunities. Two layers that you can use to determine which values of a given data set may provide the greatest opportunity due to their outlier qualities are:
Add an outlier visualization to your canvas. This will highlight data points that stand out and may justify further investigation. An outlier visualization is a type of scatter plot that automatically detects and labels outliers in your data using machine learning algorithms. You can use the outlier visualization to explore the characteristics and causes of the outliers and compare them with the normal data points.
Create a box plot visualization of your data set. A box plot is a type of graph that shows the distribution of a numerical variable using quartiles and whiskers. A box plot can also identify outliers as data points that lie beyond the whiskers or outside a certain range. You can use the box plot to see how the outliers affect the overall distribution and variation of your data.
質問 # 54
Which is a supported source for registering and using Machine Learning models7
- A. Autonomous Data Warehouse
- B. SQL Server Oracle Data Science
- C. Oracle Cloud Object Storage
- D. Mongo Database
正解：A
解説：
Autonomous Data Warehouse is a supported source for registering and using machine learning models in Oracle Analytics Cloud. You can use the Register Model step in a data flow to register a machine learning model from Autonomous Data Warehouse and use it in your analyses or visualizations. You can also use the Apply Model step to apply a registered model to a new data set and generate predictions. Reference: Oracle Analytics Cloud - Data Visualization User's Guide, Oracle Analytics Cloud - Data Visualization User's Guide
質問 # 55
What does a fact table use to reference dimension tables?
- A. Foreign key
- B. Dimension attribute
- C. Aggregate type
- D. Master key
- E. Primary key
正解：A
解説：
A fact table uses a foreign key to reference dimension tables in a relational database schema. A fact table is a table that contains numerical measures or facts that are related to a business process or event, such as sales, orders, or transactions. A dimension table is a table that contains descriptive attributes or dimensions that provide context to the facts, such as product, customer, time, or location. A foreign key is a column or a set of columns in a table that refers to the primary key of another table. A primary key is a column or a set of columns in a table that uniquely identifies each row in the table. A foreign key establishes a relationship between the fact table and the dimension tables, and allows you to join them for analysis. The other options, such as dimension attribute, aggregate type, and master key, are not used by a fact table to reference dimension tables. A dimension attribute is a column in a dimension table that contains a specific level or detail of the dimension, such as product name, customer name, or month. An aggregate type is a property of a measure column that specifies how the measure should be aggregated or calculated, such as sum, average, count, or minimum. A master key is not a valid term in relational database schema. Reference: Oracle Help Center, Oracle Help Center
質問 # 56
The Administrator has navigated to the console page and clicked on search index. Which three items can be included in the index?
- A. Shared Folders
- B. Templates
- C. Data Models
- D. User Folders
- E. Content Folder
正解：A、C、D
解説：
User Folders, Shared Folders, and Data Models are three items that can be included in the search index in Oracle Analytics Cloud. The search index is a feature that enables you to quickly find and access the analytics content and resources that you need. You can configure the search index to include or exclude certain types of items from the index, such as folders, data sets, projects, data models, and more. You can include User Folders and Shared Folders in the search index to make them searchable by name, description, or owner. You can also include Data Models in the search index to make them searchable by name, description, owner, or subject area. The other item, Templates, cannot be included in the search index, as this is not a supported type of item for indexing. Reference: [Oracle Help Center], [Oracle Help Center]
質問 # 57
Which two maps use an API key to add as Map Background?
- A. Google Map
- B. Oracle Map
- C. Tiled Web Map
- D. Baidu Map
- E. WMS Map
正解：A、D
解説：
Google Map and Baidu Map are two examples of maps that use an API key to add as map background in Oracle Analytics Cloud. An API key is a unique identifier that allows you to access and use these map services in your projects. You need to obtain an API key from the map provider and configure it in Oracle Analytics Cloud before you can use these maps as background layers. Reference: [Oracle Analytics Cloud - Data Visualization User's Guide], [Oracle Analytics Cloud - Data Visualization User's Guide]
質問 # 58
......
Oracle 1z0-1041-23 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
試験問題と解答は1z0-1041-23学習ガイド問題解答：https://jp.fast2test.com/1z0-1041-23-premium-file.html