HOME    CONTACT US    FAQ          MY ACCOUNT   LOGIN   REGISTER  
You are here : ››› ››› ›››
Exam Rate (A00-203) 12 users reviews.
Sas Warehouse Development Specialist Concepts ( A00-203 )
Exam : A00-203
To download the latest most up-to-date Q & A of this exam please click on the download button or contact us for further details
Pages:  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30   
Previous Question             Question   15  /  65            Next Question   

After deploying the warehouse on a UNIX system, jobs accessing the SAS dataset named
SALES are performing poorly. The dataset SALES is stored in the file /disk1/sales.sas7bdat and
is 3Gb in size. Which of the following methods can be used to most accurately measure the I/O
read performance?
A. "options fullstimer; libname in '/disk1'; data_NULL_;
set in.sales(drop=_all_); run;"
B. "timex cat /disk1/sales.sas7bdat > /dev/null"
C. "timex cp /disk1/sales.sas7bdat /disk1/foo" and divide the time by 2
D. "timex mv /disk1/sales.sas7bdat /disk1/foo" and divide the time by 2
 


View Answer  |  Hide Answer  |  Download Exam PDF  |  Take Another Exam
Previous Question         Question   16  /  65        Next Question
Question Is not available in this preview
Available for regestered users only

Which of the following helps to reduce the I/O for a procedure that requires every row of a SAS
table to be processed?
A. Indexing the SAS table
B. Using the SQL procedure
C. Partitioning the SAS table
D. Compressing the SAS data set
 
 


View Answer  |  Hide Answer  |  Download Exam PDF  |  Take Another Exam
Previous Question         Question   17  /  65        Next Question   
Question Is not available in this preview
Available for regestered users only

You are an employee of Company.com. Study the exhibit carefully to view a diagram that
displays a data warehouse environment:
Which of the following describes the optimal method to join a transformed DB2 table with an
Oracle table and load the result set to the data warehouse using SAS ETL Server and its
components?
Exhibit:
A. Generate code with SAS ETL Studio which:
connects to Company2 from Company1, transforms the DB2 data on Company1, downloads
the Oracle data using the DOWNLOAD procedure to Company1, joins those result sets on
Company1, downloads the joined data using the DOWNLOAD procedure to Company2, and
populates the target data warehouse table.
B. Generate code with SAS ETL Studio which:
connects to Company2 from Company1, transforms the DB2 data on Company1, extracts the
Oracle data from Company2 using Remote Library Services, joins those result sets on
Company1, and loads the target data warehouse table with the joined data using Remote
Library Services to Company2.
C. Generate code with SAS ETL Studio which:
connects to Company1 from Company2, transforms the DB2 data on host1, downloads the
result set using the DOWNLOAD procedure, extracts the ORACLE data on Company2, joins
those result sets on Company2, and populates the target data warehouse table.
D. Generate code with SAS ETL Studio which:
connects to Company1 from Company2, downloads the DB2 data using Remote Library
Services, transforms the downloaded data on Company2, extracts the ORACLE data on
Company2, joins those result sets on Company2, and populates the target data warehouse
table.
 


View Answer  |  Hide Answer  |  Download Exam PDF  |  Take Another Exam
Exam Features
Success Guaranteed
Instant Download
24/7 Customer Support
Lowest price guaranteed


  
Facebook
See also
Most Popular Exams
(A00-211) SAS Base Programming for SAS (r) 9
(A00-212) SAS Advanced Programming for SAS 9
(A00-260) SAS Data Integration Development
(A00-250) SAS Platform Administration for SAS9
(A00-281) Clinical Trials Programming Using SAS 9 Accelerated Version
(A00-270) SAS BI Content Development
(A00-201) sas base programming exam
(A00-280) SAS Certified Clinical Trials Programmer Using SAS 9
(A00-211_V2) SAS Base Programming for SAS (r) 9
(A00-202) Advanced programming
(A01-250) SAS Platform Administration
(A00-260_V2) SAS Data Integration Development
(A00-204) SAS Warehouse Architect Concepts
(A00-206) SAS Warehouse Technology Exam
(A00-205) SAS Webaf Server-Side Application Development
(A00-203) Sas Warehouse Development Specialist Concepts
All Related Exams
Exam NameCode
sas base programming exam (A00-201)
Advanced programming (A00-202)
Sas Warehouse Development Specialist Concepts (A00-203)
SAS Warehouse Architect Concepts (A00-204)
SAS Webaf Server-Side Application Development (A00-205)
SAS Warehouse Technology Exam (A00-206)
SAS Base Programming for SAS (r) 9 (A00-211)
SAS Advanced Programming for SAS 9 (A00-212)
SAS Platform Administration for SAS9 (A00-250)
SAS Data Integration Development (A00-260)
SAS BI Content Development (A00-270)
SAS Certified Clinical Trials Programmer Using SAS 9 (A00-280)
Clinical Trials Programming Using SAS 9 Accelerated Version (A00-281)
SAS Platform Administration (A01-250)
SAS Base Programming for SAS (r) 9 (A00-211_V2)
SAS Data Integration Development (A00-260_V2)
SAS Advanced Programming (A00-212_V2)
SAS Advanced Programming Exam (A00-202_V2)
SAS Statistical Business Analysis SAS9: Regression and Model (A00-240)
Clinical Trials Programming Using SAS 9 (A00-280_v2)