Exam 1Z0-1041-23: Oracle 2023 Analytics Professional

Which two steps you should perform to create pixel perfect reports with BI publisher?. Generate a sample set of data that can be configuring and testing the report and save it to a folder in presentation catalog. Create connections to sources some of which include oracle 10g/11g.Oracle BI server , JDBC and my sql server 2005/2008. Test the connection between BI publisher and configured sources by using oracle fusion middleware control. Define a data model to set the business view of the data. Join data sets and create custom measures.

Which is supported source for registering and using Machine Learning models?. Oracle Cloud Object Storage. Oracle Data Science. Autonomous Data Warehouse. Mongo Database. SQL server.

Your model requires hierarchy with year, quarter, month, week and day levels the order date dimension has only the total and detail levels. You need to add more levels. Which option contains the mandatory entries required in each hierarchy level for the order date dimension?. Level name, key column, display column. Top level name, Key column, low level name. Hierarchy name, display name, level name. Key column,details column, Hierarchy Name.

What is the typical relationship between levels in a dimension hierarchy going from top to bottom?. Many-to-Many. Zero cardinality. One-to-many. Multiple.

You are BI administrator oracle analytics cloud(OAC) and you want to provide a user with access to create and manage data models. Which application role should you grant to the user?. DV content author. BI data model author. BI content author. BU consumer. BI data manager.

Your client has created new custom map layer how can this map layer be exposed in a project?. Create new project add a map visualization change the layer property to new click upload select the json file to upload. Navigate to console. Click maps. From the map layers tab. upload the geojson file. Create a new project add a map visualization change the layer property to new click upload select the geojson file to upload. Navigate to console. Click maps. On the map layers tab. upload the xml file.

You are creating a data model for sales order and do not have the time dimension table created in the database. You decide to use the time dimension creation feature of Oracle Analytics Cloud. What are the tasks performed by the time dimensions wizard on execution?. The time dimension wizard creates the time dimension table in the database, loads ,time data and creates the time dimension data model. The time dimension wizard creates the time dimension table in the database and load time data. The time dimension wizard creates the time dimension table in the database, loads , time data and creates the time dimension and hierarchy in the data model. The time dimension wizard generates the DDL query for the time dimension table and inserts SQL for data load which you need to run on your respective database schema.

What is the use of Evaluate function in Oracle Analytics Cloud(OAC)?. It is used in machine learning process to evaluate and score a model. It directs OAC to preprocesses and cache the function results. It directs the order in which functions are evaluated within a calculation. It offloads calculation workloads directly in the underlying database.

Data flow can take one or more data sets and integrate them to produce curated sets of data. After applying all the joins, transformations and filters. You need to save the data. What are the two options to save the data in data flow?. All Rows. Spreadsheet. Data set storage. Database connection.

You have two data sets >> Country(ID, Country_Code,Country_Name) >> Revenue(Rev_ID,Country_Code,Sales_Person_ID,Year,Revenue_Amount) Year has been marked as an attribute. You added both the data sets to Data Flow. You also added a step to save the data sets to data storage. What are two steps to create a data sets that you can use for analyzing country revenues over time?. Keep matching rows on both data sets and match country_code column on both the data sets. Apply the default aggregation on year. Keep matching rows on both data sets and match the ID column. Apply the default aggregation on Revenue_Amount.

You have created a line chart visualization of revenue data at the day level. The chart displays the last 365 days of data. What would you do to create a prediction of revenue for the next 90 days?. Add a relative timeline for the next 3months. Add a trend line and change the method value to Polynomial. Add a trend line and change the method value to Exponential. Add a forecast and change the period value to 90. Add a forecast and change the period value to 3.

You have added a forecast to your visualization. Which three models are available for calculating forecast?. ETS. ARENA. SEASONAL ARENA. Seasonal ARIMA. Seasonal ETS. ARIMA.

What does a trend line highlight in Oracle Analytics Cloud?. A general pattern or direction of data when viewed in relation to a time series. A line representing the median values of a measure. A general pattern or direction of data when viewed relation to other dimensions. A line representing the average values of a measure.

Which type of report is an example of the bursting feature in pixel perfect reporting?. Ad hoc reporting. Customized regional marketing reports. Interactive data exploration. Bar codes. Government PDF forms.

You have a historical sales data set, Which you use to train a model in Oracle Analytics Cloud(OAC). Your products have an attribute named Profitability, which has one of the three values: high, medium, low. This is the property you set as the target. Which train data step is required to train a model in OAC?. Train clustering. Train text prediction. Train multi-classifier. Train multi-value. Train numeric prediction. Train Binary-Classifier.

You have created a machine learning model and investigated how accurate it is. How should you use it in Oracle Analytics Cloud(OAC)?. Connect to the model as a new project. Create data flow with a cumulative value prediction. Create a custom calculation based on a related formula. Use a data flow with an Apply model step and save as a new data set. Use a data flow with a commit model step and save as a new data set.

How should you use a machine learning model within a canvas of an oracle analytics cloud project. Create a custom calculation. Create a scenario using the required model. Use machine learning model visualization. Create a data sequence.

Which three could improve the results from Natual Language Query(NLQ) with Oracle Day By Day?. Pre caching NLQ metadata search elements. Acronyms. Synonyms. Exposing a limited number of data sets for day by day NLQ. Curating the exposed data sets by removing duplicate or unnecessary attributes.

Which two maps use an API key to add as Map Background?. Google map. Tiled web map. WMS map. Baidu map. Oracle map.

You need to curate data for country dimension and dependent Sales Fact that store country sales data. How do you design the data flow and load data for these two separate data sets in data storage?. Create a single data flow that loads the data to the country data storage in the first step then loads the data to the sales data storage in the second step. Create two separate data flows for the Country and Sales data sets. Then Create a sequence where data flow for country is called first followed by the data flow for country. Create two separate data flows for the Country and Sales data sets. Then Create a sequence where the data flow for country is called first followed by the data flow for sales. Create two separate data flows for the Country and Sales data sets. Then Create a sequence where the data flow for sales is called first followed by the data flow for Country.

Which two statements are true about data wrangling?. It is used to perform some lightweight transformation within the data visualization UI,. In data wrangling, transformations available are dependent on the data type. It is used to train and test the machine learning model. It is used to curate data sets that can be used for complex visualization.