Testpassport professional provide Convergence+ CT0-101 the newest Q&A, completely covers CT0-101 test original topic. With our complete Convergence+ resources, you will minimize your Convergence+ cost and be ready to pass your CT0-101 tests on Your First Try, 100% Money Back Guarantee included!
PDF: http://pdf.testpassport.com/CT0-101.pdf
SW: http://demo.testpassport.com/CT0-101.zip
1. The following SAS program is submitted: proc datasets lib = testdata; modify one; label num =
'Number'; format num 4.; quit; Which SQL procedure program produces the same results?
A.proc sql; modify table testdata.one set num format = 4. label = 'Number'; quit;
B.proc sql; alter table testdata.one modify num format = 4. label = 'Number'; quit;
C.proc sql; modify table testdata.one alter num format = 4. label = 'Number'; quit;
D.proc sql; alter table testdata.one set num format = 4. label = 'Number'; quit;
Answer: B
2. What does the DICTIONARY.MACROS table store?
A.information about user defined macro variables only
B.information about system defined macro variables only
C.information about both user and system defined macro variables
D.information about macros stored in the autocall macro library only
Answer: C
3. The following SAS program is submitted: %let lib = %upcase(sasuser); proc sql; select nvar from
dictionary.tables where libname = "&lib"; quit; Several SAS data sets exist in the SASUSER library. What
is generated as output?
A.a report showing the numeric columns in each table in SASUSER
B.a report showing the number of columns in each table in SASUSER
C.a report showing the names of the columns in each table in SASUSER
D.a report showing the number of numeric columns in each table in SASUSER
Answer: B