Tuesday, February 22, 2022

1Z0-1041-21 Oracle Cloud Platform Enterprise Analytics 2021 Specialist Part 1



How can you can register and use Oracle machine learning models?

Select TWO correct answers.

A.      Oracle Autonomous Data Warehouse

B.      Oracle Database

C.      Object Storage

D.      Oracle Functions

Answer

A,B

As an Enterprise Admin, you need to create a connection for data modeler. What are the details required?

Select TWO correct answers.

A.      TNS Descriptor

B.      Client Credentials

C.      Connect As and Password

D.      Service Name

Answer

A,C

Which connection type should you use for Pixel Perfect reports?

A.      HTML connection

B.      JNDI connection

C.      ODBC connection

D.      JDBC connection

Answer

B

Which machine learning algorithm should you use to prevent frauds for banks?

A.      Anomaly detection

B.      Regression

C.      Classification

D.      Clustering

Answer

A

Which data preparation action should you use to create new columns based on the value of the measure?

A.      Filtering

B.      Binning

C.      Sorting

D.      Masking

Answer

B

Which database function can be used to pass through expressions to get advanced calculations?

A.      Math Function

B.      String Functions

C.      Evaluate Function

D.      Aggregate Functions

Answer

C

Which Oracle Analytics Cloud Edition can build data models, reports, and analytic dashboards?

A.      Enterprise Edition

B.      Professional Edition

C.      Basic Edition

D.      Developer Edition

Answer

A

What does Dimension table comprise of?

A.      Measures

B.      Dimension Foreign keys

C.      Business Entity Description

D.      Only PII Attributes

Answer

C

With regard to dimensional designs, what are the types of schemas?

Select TWO correct answers.

A.      Moon Schema

B.      Star Schema

C.      Snowflake Schema

D.      Snowmobile Schema

Answer

B,C

Which application role should you grant to an user in Oracle Analytics Cloud such that the user can load data?

Select TWO correct answers.

A.      BI Dataload Author

B.      BI Service Administrator

C.      BI Data Model Author

D.      DV Consumer

Answer

A,B

A data analyst added cluster statistics to a Scatter Diagram. What does it will help to achieve?

A.      Combination of similar and different data point groups

B.      Will achieve nothing

C.      Similarity in data points groups

D.      Differentiate between data points groups

Answer

C

Which application role should you grant to an user in Oracle Analytics Cloud such that the user can create and manage data models using Data Modeler?

Select TWO correct answers.

A.      BI Data Model Author

B.      BI Service Administrator

C.      DV Consumer

D.      BI Dataload Author

Answer

A,B

What does Create Date-Time Dimension wizard automates?

A.      Creation of fact table

B.      Integration with autonomous database for ML models

C.      Creation of time dimension hierarchies and attributes

D.      Rollback to previous database state

Answer

C

How can you evaluate the accuracy of predictive machine learning models in Oracle Analytics?

A.      Properly tune the machine learning model

B.      Use a data flow and enable Lift and Gain Charts

C.      Run the model with different ML algorithm and choose the best one

D.      Re-create the model from the scratch

Answer

B

As a data analyst, you have the historical grades of students of an University.

Which data train step should you use if you want to segment the grade of students into two values : Fail or Pass?

A.      Train Numeric Prediction

B.      Train Binary-Classifier

C.      Train Clustering

D.      Train Multi-Classifier

Answer

B

What does Fact table comprise of?

Select TWO correct answers

A.      Measures

B.      Dimension Foreign keys

C.      Business Entity Description

D.      Only PII Attributes

Answer

A,B

Which type of context values can a data action pass in Oracle Analytics Publisher Reports?

A.      URL Parameters

B.      Inline Parameters

C.      Visualization Parameters

D.      Conditional Parameters

Answer

A

How can you reduce the amount of data shown in canvas, project or visualization?

A.      Masking

B.      Sort

C.      Filters

D.      Duplicating

Answer

C

What should be the file extension for custom map layer which should be uploaded from Map Layers Tab?

A.      HTML

B.      XML

C.      GeoJSON

D.      CSV

Answer

C

How can you automatically create best visualization on the canvas based on a set of data elements?

Select TWO answers.

A.      Click the magic wand button from the Data Panel toolbar

B.      Drag data elements from the Data Panel and drop them directly onto the canvas

C.      Right-click data elements on the Data Panel and click Create Best Visualization

D.      Rename the canvas with suffix "_BestVisualization" to see the results

Answer

B,C

With regard to Oracle BI Presentation Catalog, which of the statements are CORRECT?

Select TWO answers.

A.      Items that you save to My Folders appear to everyone

B.      Items that you save to Shared Folders can be viewed by all users with BI Consumer privileges

C.      With BI Consumer privileges, you can also view the items that other users have saved in Shared Folders

D.      Items that other users save to My Folders can appear to you

Answer

B,C

Which statements are correct about Canvas Layout and Properties Visualization?

Select TWO answers.

A.      You can add a new canvas to the project by using Canvas tabs bar

B.      Legend's location cannot be customized in a workbook

C.      You can copy a visual by visiting Visualization Menu and right-clicking the canvas and then selecting Edit

D.      You can delete a canvas by left-clicking on canvas tab

Answer

A,C

Which app can learn what you're interested in, when and where you're interested in it based on your searches for business data?

A.      Oracle E-Business Suite (EBS)

B.      Oracle Mobile Hub

C.      Oracle Analytics Day by Day

D.      Oracle Cares

Answer

C

As a data analyst, how can you recognize patterns and trends in your data set?

A.      Oracle Analytics Day by Day

B.      Filters

C.      Explain Functionality

D.      Autonomous Database with Machine Learning

Answer

C

You want to share a workbook that contains a story with users who have read-only permissions and story's Full Interactivity field is set to on. How can you achieve this?

A.      Share the story on social media

B.      Oracle Analytics Day by Day

C.      Export to common formats such as PDF

D.      Change Full Interactivity field to Off

Answer

C

Which of the steps is correct when creating an Oracle Applications Connection?

A.      Create Connection -> Oracle Applications -> Connection Details -> Oracle Fusion Applications URL

B.      Create Connection -> Connection Details -> Oracle Fusion Applications URL

C.      Create Connection -> Oracle Applications -> Connection Details -> Oracle BI EE URL

D.      Create Connection -> Oracle Applications -> Connection Details -> Oracle Transactional Business Intelligence URL

Answer

A

Which filter should you use if you want to display revenue amount for lIT departments which are less than $100,000?

Select TWO correct answers.

A.      List filters

B.      Range filters

C.      Expression filters

D.      Date filters

Answer

B,C

As an Enterprise Admin, you need to create a connection for data set. What are the details required?

Select TWO correct answers.

A.      TNS Descriptor

B.      Client Credentials

C.      Service Name

D.      Connect As and Password

Answer

B,C

What are the features available in Overview Tab of Dimension Table?

Select TWO correct answers.

A.      Aggregation

B.      Time dimension

C.      Edit the hierarchies and levels

D.      Hide unwanted columns

Answer

B,C

What are the features of Oracle Analytics Cloud?

Select TWO correct answers.

A.      Allows customers to connect directly to their Oracle Cloud Infrastructure

B.      Provides a complete set of tools for deriving and sharing data insights

C.      Analysts can ingest, profile, and cleanse data using a variety of algorithms

D.      Helps to store secrets such as encryption keys and passwords

Answer

B,C

 

If you have any problem so download the file to click on "Download".

Download

I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim
E-mail : s.m.sahal789@gmail.com
Thank you.

0 comments:

Post a Comment

If you have any doubts, please let me know. I will help you.