A00-221  :  SAS Big Data Programming and Loading

Below are 5 Demo sample Q&A that matches with real A00-276 exam, once payment is done full .PDF will be uploaded

Question No. 1

Which Proc Sql statement returns the contents of the cars Hive Table to SAS?

A) Select * from connection to hadoop (select * from cars)

B) Select * from  (select * from cars) using hadoop

C) execute (select * from cars) by hadoop

D) Select * from  (select * from cars) by hadoop

Answer: A

Question No. 2

Refer to the following SAS Program.

• Proc SQL;
• connect to hadoop (server=myserver user=myuser);
• execute (create table test_table (mycolumn string)) by hadoop;
• execute (insert into test_table values ('1')) by hadoop;
• Quit;

Libname myhdp Hadoop server=myserver user=myuser;

• data work.test_table;
• set myhdp.test_table;
• Run;

Which statement best describes the mycolumn variable in the SAS dataset work.test_table?

A)The SAS variable mycolumn will contain no data because INSERT statements cannot be used with Hive Tables.

B) SAS will recognize that the columns contain a number and assign numeric type to the mycolumn variable.

C) SASFMT table properties will be generated for the column and it will have a length of 1 character in the SAS dataset.

D) the SAS variable mycolun will have a length of 32,767.

Answer: A

Question No. 3

A SAS Programmer is working with data stored in Hadoop.

Complete the options statement below so that the log will display the HiveQL code generated by SAS/Access.

OPTIONS _________ = ',,,d' _____________ = saslog nostsuffix;

Enter your answers in the spaces above. Case is ignored and standard SAS syntax rules apply.

Answer:  SASTRACE    SASTRACELOC

Question No. 4

Which Data step statement will SAS translate into HiveQL equivalent that Hive can execute?

A) select

B) Merge

C) If

D) Where

Answer: D

Question No. 5

Consider the following code:

Filename haddata Hadoop "/user/mydir/data.csv";

Data work.commonwords;

Infile Haddata dlm=",";

Input x $ y;

Run;

How will the processing Occur?

A) The Data step is translated into a HiveQL query that is processed in parallel by Hadoop. The results are then returned to the SAS Session.

B) The data is read in parallel from HDFS, delivered to the SAS session, and processed sequentially by the SAS data step.

C) The data is read in parallel from HDFS, delivered to the SAS session, and processed in parallel by the SAS Data Step.

D) The Data step is translated into a Mapreduce  process that is executed in parallel by Hadoop. The results are then returned to the SAS Session.

Answer: B

Write a review for A00-221