Customer Support
100% Secure Payments
After Payment
On Time Pass In Exam
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.
Libname myhdp Hadoop server=myserver user=myuser;
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