Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

1Z0-449 by Oracle - Page 1 | ExamCademy

Mode Selection

Sort:

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 3 • Questions 1-25 of 69

1 2 3

→

Know a question that should be here? Contribute to this exam

You need to place the results of a PigLatin script into an HDFS output directory.
What is the correct syntax in Apache Pig?

A update hdfs set D as ‘./output’;
B store D into ‘./output’;
C place D into ‘./output’;
D write D as ‘./output’;
E hdfsstore D into ‘./output’;

Your customers security team needs to understand how the Oracle Loader for Hadoop Connector writes data to the Oracle database.
Which service performs the actual writing?

A OLH agent
B reduce tasks
C write tasks
D map tasks
E NameNode

Your customer needs to manage configuration information on the Big Data Appliance.
Which service would you choose?

A SparkPlug
B ApacheManager
C Zookeeper
D Hive Server
E JobMonitor

You are helping your customer troubleshoot the use of the Oracle Loader for Hadoop Connector in online mode. You have performed steps 1, 2, 4, and 5.
STEP 1: Connect to the Oracle database and create a target table.
STEP 2: Log in to the Hadoop cluster (or client).

STEP 3: Missing step -
STEP 4: Create a shell script to run the OLH job.
STEP 5: Run the OLH job.
What step is missing between step 2 and step 4?

A Diagnose the job failure and correct the error.
B Copy the table metadata to the Hadoop system.
C Create an XML configuration file.
D Query the table to check the data.
E Create an OLH metadata file.

The hdfs_stream script is used by the Oracle SQL Connector for HDFS to perform a specific task to access data.
What is the purpose of this script?

A It is the preprocessor script for the Impala table.
B It is the preprocessor script for the HDFS external table.
C It is the streaming script that creates a database directory.
D It is the preprocessor script for the Oracle partitioned table.
E It defines the jar file that points to the directory where Hive is installed.

How should you encrypt the Hadoop data that sits on disk?

A Enable Transparent Data Encryption by using the Mammoth utility.
B Enable HDFS Transparent Encryption by using bdacli on a Kerberos-secured cluster.
C Enable HDFS Transparent Encryption on a non-Kerberos secured cluster.
D Enable Audit Vault and Database Firewall for Hadoop by using the Mammoth utility.

What two things does the Big Data SQL push down to the storage cell on the Big Data Appliance? (Choose two.)

A Transparent Data Encrypted data
B the column selection of data from individual Hadoop nodes
C WHERE clause evaluations
D PL/SQL evaluation
E Business Intelligence queries from connected Exalytics servers

You want to set up access control lists on your NameNode in your Big Data Appliance. However, when you try to do so, you get an error stating "the NameNode disallows creation of ACLs."
What is the cause of the error?

A During the Big Data Appliance setup, Cloudera's ACLSecurity product was not installed.
B Access control lists are set up on the DataNode and HadoopNode, not the NameNode.
C During the Big Data Appliance setup, the Oracle Audit Vault product was not installed.
D dfs.namenode.acls.enabled must be set to true in the NameNode configuration.

Your customer has an older starter rack Big Data Appliance (BDA) that was purchased in 2013. The customer would like to know what the options are for growing the storage footprint of its server.
Which two options are valid for expanding the customers BDA footprint? (Choose two.)

A Elastically expand the footprint by adding additional high capacity nodes.
B Elastically expand the footprint by adding additional Big Data Oracle Database Servers.
C Elastically expand the footprint by adding additional Big Data Storage Servers.
D Racks manufactured before 2014 are no longer eligible for expansion.
E Upgrade to a full 18-node Big Data Appliance.

Question Image

What are three correct results of executing the preceding query? (Choose three.)

A Values longer than 100 characters for the DESCRIPTION column are truncated.
B ORDER_LINE_ITEM_COUNT in the HDFS file matches ITEM_CNT in the external table.
C ITEM_CNT in the HDFS file matches ORDER_LINE_ITEM_COUNT in the external table.
D Errors in the data for CUST_NUM or ORDER_NUM set the value to INVALID_NUM.
E Errors in the data for CUST_NUM or ORDER_NUM set the value to 0000000000.
F Values longer than 100 characters for any column are truncated.

What does the following line do in Apache Pig?
products = LOAD /user/oracle/products AS (prod_id, item);

A The products table is loaded by using data pump with prod_id and item.
B The LOAD table is populated with prod_id and item.
C The contents of /user/oracle/products are loaded as tuples and aliased to products.
D The contents of /user/oracle/products are dumped to the screen.

What is the output of the following six commands when they are executed by using the Oracle XML Extensions for Hive in the Oracle XQuery for Hadoop
Connector?

$ echo "xxx" > src.txt
$ hive --auxpath $OXH_HOME/hive/lib -i $OXH_HOME/hive/init.sql
hive> CREATE TABLE src (dummy STRING);
hive> LOAD DATA LOCAL INPATH 'src.txt' OVERWRITE INTO TABLE src;
hive> SELECT * FROM src;

OK -
xxx
6. hive> SELECT xml_query ("x/y", "<x><y>123</y><z>456</z></x>") FROM src;

A xyz
B 123
C 456
D xxx
E x/y

The NoSQL KVStore experiences a node failure. One of the replicas is promoted to primary.
How will the NoSQL client that accesses the store know that there has been a change in the architecture?

A The KVLite utility updates the NoSQL client with the status of the master and replica.
B KVStoreConfig sends the status of the master and replica to the NoSQL client.
C The NoSQL admin agent updates the NoSQL client with the status of the master and replica.
D The Shard State Table (SST) contains information about each shard and the master and replica status for the shard.

Your customer is experiencing significant degradation in the performance of Hive queries. The customer wants to continue using SQL as the main query language for the HDFS store.
Which option can the customer use to improve performance?

A native MapReduce Java programs
B Impala
C HiveFastQL
D Apache Grunt