SAS DI Quiz

Posted on: | By: – Comments Off

SAS DI Expert Quiz

SAS DI Quiz : This SAS DI Expert Quiz contains set of 60 SAS DI Quiz which will help to clear any exam which is designed for Expert.



1) Which one of the following displays the definition of a stored SQL procedure view in the
SAS log?
 

  1. ECHOVIEW option
  2. EXPANDVIEW option
  3. VALIDATE VIEW statement
  4. DESCRIBE VIEW statement

Answer : D

 
 
2) Which SQL procedure clause allows for dynamically assigning a library when creating an SQL procedure view?

  1. FROM
  2. USING
  3. CONNECT
  4. LIBNAME

Answer : B

 
 
3) Which of the following is true about the DICTIONARY.TABLES table?

  1. It can be edited in the SAS viewtable window.
  2. New rows and columns can be inserted directly into DICTIONARY.TABLES.
  3. It contains information about all the SAS data sets in the current SAS session.
  4. It can be directly referenced by both the SQL procedure and the SAS DATA step.

Answer : C

 
 
4) Which SAS Management Console plug-in is used to define metadata for channels?

  1. Configuration Manager plug-in
  2. Schedule Manager plug-in
  3. Foundation Services Manager plug-in
  4. Publishing Framework plug-in

Answer : D

 
 
5) Which of the following is NOT defined as part of the New Library Wizard?

  1. The type of library
  2. The metadata name for the library
  3. The location of the library
  4. the metadata for the library tables

Answer : D

 
 
6) Within SAS Data Integration Studio, which type of expression can be created using the Expression Builder window in the Where tab of SAS Extract transformation? 1) a SAS expression 2) an SQL expression 3) an XML expression 4) a constant

  1. 1 and 2 only
  2. 1 and 3 only
  3. 1, 2 and 4 only
  4. 1, 2, 3, and 4

Answer : C

 
 
7) Which statement is true regarding SAS packages created in SAS Data Integration Studio?

  1. SAS packages are used to import and export SAS applications.
  2. SAS packages are used to import and export stand-alone SAS programs.
  3. SAS packages are used to import and export third-party metadata.
  4. SAS packages are used to import and export SAS metadata.

Answer : D

 
 
8) Which action is required for enabling performance statistics on the executing SAS Workspace Server?

  1. Define a logfile for output.
  2. Define Collect Diagnostics for the SAS Data Integration Studio jo
  3. Define Collect Runtime statistics for the SAS Data Integration Studio job.
  4. Enable the logging facility of the SAS Workspace Server.

Answer : D

 
 
9) When using SAS Data Integration Studio’s SQL Join transformation, which SQL join type can be
constructed as either an implicit or an explicit join?

  1. Union
  2. Full
  3. Inner
  4. Cross

Answer : C

 
 
10) Which definition cannot be imported using a SAS Metadata Bridge?

  1. Server definition
  2. Library definition
  3. Table definition
  4. Column Definition

Answer : A




 
11) The following SAS program is submitted: %macro check(num = 4); %let result = %sysevalf(&num + 0.5); %put result is &result; %mend; %check(num=10) What is written to the SAS log?
 

  1. result is 0
  2. result is 10
  3. result is 10.5
  4. result is 10 + 0.5

Answer : C

 
 
12) The macro variable STATEMENT should resolve to: proc print data = sashelp.class; Which of the following statements successfully creates this result?

  1. %let statement = proc print data = sashelp.class;;
  2. %let statement = proc print data = sashelp.class;;
  3. %let statement = %bquote(proc print data = sashelp.class;);
  4. use call symput

Answer : C

 
 
13) 1.The following program is submitted.
data WORK.TEST;
input Name $ Age;
datalines;
John +35
;
run;
Which values are stored in the output data set?

  1. Name Age
  2. —————-
  3. John    35

 

  1. Name Age
  2. —————
  3. John    (missing value)

 

  1. Name Age
  2. —————————
  3. (missing value) (missing value)

 

  1. The DATA step fails
  2. execution due to data errors.

Answer : A

 
 
14) The SAS platform application that can surface the different types of business and analytic content such as
information maps, stored processes, and reports on the web browser is:

  1. SAS Information Delivery Portal
  2. SAS Information Map Studio
  3. SAS Web Report Studio
  4. SAS OLAP Cube Studio

Answer : A

 
 
15) The purpose of change management in SAS Data Integration Studio is to manage:

  1. metadata objects across metadata servers
  2. metadata objects within a logged on user’s personal folder
  3. metadata objects within a metadata server
  4. metadata objects within a logged on user’s Checkouts Tree

Answer : C

 
 
16) A SAS administrator has performed the “Clear Projects” action to remove the lock on a SAS Data
Integration Studio job called “Create Tables” that some user has checked out in their project repository.
What will be the outcome of this action on the user’s

  1. It will become empty and all new and checked out metadata objects will revert to the not checked out
  2. It will only contain the new metadata objects. All checked out metadata objects will revert to the not checked out state.
  3. It will become empty and the DI job called “Create Tables” will no longer be in a checked out state.
  4. It will become empty and will not be accessible until the administrator grants permissions for it to be used again.

Answer : C

 
 
17) detects differences between matching rows in specified columns in two tables.
Outputs include changed, new, unchanged, and missing records tables. These outputs
can be used as the basis for performing Type 1 or Type 2 updates in a dimension
table.
 

  1. Compare Tables
  2. Lookup
  3. Key Effective Date
  4. Surrogate Key Generator

Answer : A

 
 
18) updates dimension tables based on changes to the business key, when change
detection is unnecessary

  1. Compare Tables
  2. Lookup
  3. Key Effective Date
  4. Surrogate Key Generator

Answer : C

 
 
19) Given the following SAS program:
proc sql;
select product, type, sum(sales) as revenue from one
group by product, type;
quit;
Which one of the following clauses should be added to the program to sort the output by
PRODUCT and decreasing REVENUE?
 

  1. order by 1, 3
  2. order by 1, 3 desc
  3. orderby product, revenue desc
  4. order by product, desc revenue

Answer : B

 
 
20) Assume that a SAS Data Integration Studio job is populating a table, and the table has metadata
definitions for two simple indexes. Which of the following is NOT a valid location for viewing which
columns are indexed?

  1. the Load Technique tab in the Table Loader transformation properties window
  2. the Indexes tab in the table properties window
  3. the Columns tab in the table properties window
  4. the Columns tab in the Details panel of the open job, with the table selected in the job flow

Answer : A




 
21) How do you enable performance statistics for a SAS Data Integration Studio job?

  1. Define Collect Runtime Statistics on the SAS Data Integration Studio job.
  2. Define Collect Table Statistics on the SAS Data Integration Studio jo
  3. Define Collect Diagnostics on the SAS Data Integration Studio job.
  4. Define Collect Table Statistics on the SAS Data Integration Studio options.

Answer : A

 
 
22) Within SAS Data Integration Studio’s SQL Join transformation, the Validate Expression button is located
in:

  1. a Where clause definition
  2. an Expression Builder window
  3. a field Expression definition
  4. a Subquery definition

Answer : B

 
 
23) In SAS Data Integration Studio, which output format is supported for the default “out-of-the-box” job
report?

  1. HTML
  2. PDF
  3. RTF
  4. XML

Answer : A

 
 
24) At the start of a new SAS session, the following program is submitted: %macro one;
data _null_; call symput(‘proc’, ‘means’);
run; proc &proc data = sashelp.class;
run; %mend; %one() What is the result?
 

  1. The macro variable PROC is stored in the local symbol table.
  2. The macro variable PROC is stored in the global symbol table.
  3. The macro variable PROC is stored in the SAS catalog WORK.SASMACR.
  4. The program fails to execute because PROC is a reserved wor

Answer : B

 
 
25) The following SAS program is submitted: options mstored sasmstore =
sasuser; %macro output / store source; %if &syslast =_NULL_ %then %do; %put No data set; %end; %else %do; proc print data = &syslast; run; %end; %mend; Which program accesses the source p

  1. %display output;
  2. %output / source;
  3. %copy output / source;
  4. options mprint; %output

Answer : C

 
 
26) The following SAS program is submitted: %let value = 9; %let add = 5; %let newval= %eval(&value / &add); What is the value of the macro variable NEWVAL?

  1. 1
  2. 2
  3. 8
  4. null

Answer : A

 
 
27) The following SAS program is submitted
data Work.EmployeeCount
set Work.Employees;
retain Count;
Count = Count +1;
run;
Which statement is false regarding the Count variable.

  1. The value of the Count variable is retained across data step iterations.
  2. The value of the Count variable is initialized to missing for the first time.
  3. At the end of the data step the value of Count will be missing for all the records of Work.Employees
  4. At the end of the data step the Count variable gives the total number records for work.employees

Answer : B

 
 
28) How to set propagation direction for the control of Global level

  1. Select one of the following directions in the Propagation Direction group box: From beginning to end From end to beginning
  2. Select one of the following directions in the drop-down menu: From Beginning to End From End to Beginning
  3. Select one of the following directions in the pop-up menu: To Beginning To End
  4. Not applicable

Answer : A

 
 
29) How to set propagation direction for the control of Job level

  1. Select one of the following directions in the Propagation Direction group box: From beginning to end From end to beginning
  2. Select one of the followingdirections in the drop-down menu: From Beginning to End From End to Beginning
  3. Select one of the following directions in the pop-up menu:To Beginning To End
  4. Not applicable

Answer : B

 
 
30) How to set propagation direction for the control of Process flow level

  1. Select one of the following directions in the Propagation Direction group box: From beginning to end From end to beginning
  2. Select one of the following directions in the drop-down menu: From Beginning to End From End to Beginning
  3. Select one of the following directions in the pop-up menu: To Beginning To End
  4. Not applicable

Answer : C




 
31) How to set propagation direction for the control of Transformation level

  1. Select one of the following directions in the Propagation Direction group box: From beginning to end From end to beginning
  2. Select one of the following directions in the drop-down menu: From Beginning to End From End to Beginning
  3. Select one of the following directions in the pop-up menu: To BeginningTo End
  4. Not applicable

Answer : D

 
 
32) Identify the sort enhancement technique from the below description:
Use the WORK invocation option, the UTILLOC
invocation option, or both options to direct SORT procedure
utility files to fast, less-utilized storage devices. Some
procedure utility files

  1. Direct sort utility files to fast storage devices
  2. Distribute sort utility files across multiple devices
  3. Pre-sort explicitly on the most common sort key
  4. Use relational database sort engines to pre-sort tables without data order issues

Answer : A

 
 
33) Find the debugging keyword for the join algorithm:sort step
 

  1. sqxsort
  2. sort
  3. sortsqx
  4. sqxrc

Answer : A

 
 
34) overwrites specified columns in dimension tables without retaining a history of
changes

  1. Type 1 SCD
  2. Type 2 SCD
  3. Type 3 SCD
  4. SQL join

Answer : A

 
 
35) loads source data into fact tables and loads foreign keys from dimension tables, with
configurable exception handling.  The process accesses dimension tables by
using hash objects for optimal performance.

  1. Compare Tables
  2. Lookup
  3. Key Effective Date
  4. Surrogate Key Generator

Answer : B

 
 
36) generates unique key numbers for dimension tables in a manner that is similar but
less feature-rich than the SCD Type 2 Loader transformation.

  1. Compare Tables
  2. Lookup
  3. Key Effective Date
  4. Surrogate Key Generator

Answer : D

 
 
37) Which one of the following SAS integrity constraint types ensures that a specific set or range of values are the only values in a variable?

  1. CHECK
  2. UNIQUE
  3. FORMAT
  4. DISTINCT

Answer : A

 
 
38) The following are values of the variable STYLE from the SAS data set
SASUSER.HOUSES: SASUSERS.HOUSES OBS STYLE
——————–
1 RANCH
2 SPLIT
3 CONDO
4 TWOSTORY
5 RANCH
6 SPLIT
7 SPLIT
The following SAS program is submitted:
proc sql noprint;
select

  1. CONDO RANCH SPLIT TWOSTORY
  2. RANCH SPLIT CONDO TWOSTORY
  3. CONDO RANCH RANCH SPLIT SPLIT SPLIT TWOSTORY
  4. RANCH SPLIT CONDO TWOSTORY RANCH SPLIT SPLIT

Answer : A

 
 
39) When using the Table Loader transformation to load an existing target table that contains one or more
indexes in SAS Data Integration Studio, which statement is true?

  1. Indexes are removed when the Table Loader executes and must be re-created using the Table Structure
  2. Indexes are automatically preserved when the Table Loader executes.
  3. Indexes are removed at the beginning of the load process and must be re-created in a subsequent job
  4. Indexes can be removed or preserved at the beginning of the process depending on options chosen. Additional table loader options specify whether to re-create the index at the end of the process.

Answer : D

 
 
40) When exporting a SAS package file using SAS Data Integration Studio, where can it be saved?

  1. in metadata
  2. on any machine that SAS Data Integration Studio can write to
  3. in a SAS catalog
  4. only on the machine where SAS Data Integration Studio is running

Answer : B




 
41) The following SAS program is submitted: %macro print(dsn = sashelp.class, var1, var2 = name); proc print data = &dsn; var &var1 &var2; run; %mend; %print(dsn = sashelp.prdsale, age name, var2 =height) What i s the result?

  1. The value of the macro variable VAR1 is age.
  2. The value of the macro variable VAR1 is null.
  3. The value of the macro variable VAR1 is age name.
  4. The macro variable VAR1 has no value; the macro failed to compile.

Answer : D

 
 
42) The following SAS program is submitted: %macro cols1; name age; %mend; %macro cols2; height weight; %mend; proc print data = sashelp.class; run; Which VAR statement successfully completes the program and produces a report?

  1. var %cols2 %cols1;
  2. var height %cols1;
  3. var %cols1 height;
  4. var %cols1 %cols2 height;

Answer : B

 
 
43) Which statement best describes the DataFlux Integration Server?

  1. An application server that executes service requests based on Simple Object Access Protocol (SOAP) to call dfPower Architect or dfPower Profile jobs.
  2. A plug-in to SAS Data Integration Studio allowing you to design jobs specialized for data cleansing
  3. An application interface that allows you to build dfPower Architect and dfPower Profile jobs specialized for data cleansing operations.
  4. A third party server defined in the SAS metadata repository that allows you to build flows integrating multiple jobs and establishing job dependencies within the flow.

Answer : A

 
 
44) Defination of SAS
SAS Grid
Server

  1. Submits stored processes for execution by a SAS session.
  2. Stored processes are SAS programs that are stored and can be executed by client
  3. Executes SAS code,reads and writes Submits generated SAS code to machines that are remote from the default SAS Application Server; can also be used for interactive access to remote libraries.
  4. Supports a compute grid that can execute grid-enabled jobs that are created in SAS Data Integration

Answer : D

 
 
45) Method for Specifying Metadata for
One or more SAS tables or database management
system tables (DBMS) tables that exist in
physical storage.
 

  1. Select File -> Import -> Metadata from the menu bar
  2. Select an appropriate destination folder in the tree view, and then select File -> Import -> SAS Package from the menu bar
  3. Select File -> Register Tables from the menu bar
  4. Select File -> New -> External File -> Delimited from the menu bar

Answer : C

 
 
46) Defination of Create Match
Code
 

  1. Enables you to select and apply DataFlux schemes that standardize the format, casing, and spelling of character columns in a source table.
  2. Enables you to analyze source data and generate match codes based on common information shared by clusters of records. Comparing match codes instead of actual data enables you to identify records that are in fact the same entity, despite minor variations
  3. Enables you to select and execute a DataFlux job that is stored on a DataFlux Data Management Server. You can execute DataFlux Data Management Studio data jobs, process jobs, and profiles. You can also execute Architect jobs that were created with DataFlu
  4. Enables you to select and execute a data job that has been configured as a real-time service and deployed to a DataFlux Data Management Server

Answer : B

 
 
47) Defination of DataFlux Batch Job
 

  1. Enables you to select and apply DataFlux schemes that standardize the format, casing, and spelling of character columns in a source table.
  2. Enables you to analyze source data and generate match codes based on common information shared by clusters of records. Comparing match codes instead of actual data enables you to identify records that are in fact the same entity, despite minor variations
  3. Enables you to select and execute a DataFlux job that is stored on a DataFlux Data Management Server. You can execute DataFlux Data Management Studio data jobs, process jobs, and profiles. You can also execute Architect jobs that were created with DataFlu
  4. Enables you to select and execute a data job that has been configured as a real-time service and deployed to a DataFlux Data Management Server

Answer : C

 
 
48) Defination of DataFlux Data Service

  1. Enables you to select and apply DataFlux schemes that standardize the format, casing, and spelling of character columns in a source table.
  2. Enables you to analyze source data and generate match codes based on common information shared by clusters of records. Comparing match codes instead of actual data enables you to identify records that are in fact the same entity, despite minor variations
  3. Enables you to select and execute a DataFlux job that is stored on a DataFlux Data Management Server. You can execute DataFlux Data Management Studio data jobs, process jobs, and profiles. You can also execute Architect jobs that were created with DataFlu
  4. Enables you to select and execute a data job that has been configured as a real-time service and deployed to a DataFlux Data Management Server

Answer : D

 
 
49) Defination of Standardize with Definition

  1. Enables you to select and apply DataFlux standardization definitions to elements within a text string. For example, you might want to change all instances of “Mister” to “Mr.” but only when “Mister” is used as a salutation
  2. Enables you to analyze source data and generate match codes based on common information shared by clusters of records. Comparing match codes instead of actual data enables you to identify records that are in fact the same entity, despite minor variations
  3. Enables you to select and execute a DataFlux job that is stored on a DataFlux Data Management Server. You can execute DataFlux Data Management Studio data jobs, process jobs, and profiles. You can also execute Architect jobs that were created with DataFlu
  4. Enables you to select and execute a data job that has been configured as a real-time service and deployed to a DataFlux Data Management Server

Answer : A

 
 
50) Defination of SAS Data in HDFS Loader

  1. Loads a table to the file system (HDFS) on a Hadoop cluster. The source can be a SAS data set or a table in any DBMS supported by SAS. The target is a table in a SAS Data in HDFS Library
  2. Unloads a table from HDFS. The input is a table in a SAS Data in HDFS Library
  3. Loads a table to memory on a SAS LASR Analytic Server. The source can be a SAS data set, a table in any DBMS supported by SAS, or a table in a SAS Data in HDFS Library. The target is an in-memory table in a SAS LASR Analytic Server Library.
  4. Unloads a table from memory on a SAS LASR Analytic Server. The input is an in-memory table in a SAS LASR Analytic Server Library.

Answer : A




 
51) Defination of SAS Data in HDFS Unloader

  1. Loads a table to the file system (HDFS) on a Hadoop cluster. The source can be a SAS data set or a table in any DBMS supported by SAS. The target is a table in a SAS Data in HDFS Library
  2. Unloads a table from HDFS. The input is a table in a SAS Data in HDFS Library
  3. Loads a table to memory on a SAS LASR Analytic Server. The source can be a SAS data set, a table in any DBMS supported by SAS, or a table in a SAS Data in HDFS Library. The target is an in-memory table in a SAS LASR Analytic Server Library.
  4. Unloads a table from memory on a SAS LASR Analytic Server. The input is an in-memory table in a SAS LASR Analytic Server Library.

Answer : B

 
 
52) Defination of SAS LASR Analytic Server Loader

  1. Loads a table to the file system (HDFS) on a Hadoop cluster. The source can be a SAS data set or a table in any DBMS supported by SAS. The target is a table in a SAS Data in HDFS Library
  2. Unloads a table from HDFS. The input is a table in a SAS Data in HDFS Library
  3. Loads a table to memory on a SAS LASR Analytic Server. The source can be a SAS data set, a table in any DBMS supported by SAS, or a table in a SAS Data in HDFS Library. The target is an in-memory table in a SAS LASR Analytic Server Library.
  4. Unloads a table from memory on a SAS LASR Analytic Server. The input is an in-memory table in a SAS LASR Analytic Server Library.

Answer : C

 
 
53) Defination of SAS LASR Analytic Server Unloader

  1. Loads a table to the file system (HDFS) on a Hadoop cluster. The source can be a SAS data set or a table in any DBMS supported by SAS. The target is a table in a SAS Data in HDFS Library
  2. Unloads a table from HDFS. The input is a table in a SAS Data in HDFS Library
  3. Loads a table to memory on a SAS LASR Analytic Server. The source can be a SAS data set, a table in any DBMS supported by SAS, or a table in a SAS Data in HDFS Library. The target is an in-memory table in a SAS LASR Analytic Server Library.
  4. Unloads a table from memory on a SAS LASR Analytic Server. The input is an in-memory table in a SAS LASR Analytic Server Library.

Answer : D

 
 
54) Which of the following one has Stored Process Feature of Version 2.0 stored processes

  1. Compatible with server versions prior to SAS 3 and SAS 9.3 or later servers.
  2. Associated with a specific logical server, which can be a SAS Stored Process Server or a SAS Workspace Server.
  3. Stores source code on the application server
  4. Stores source code either on the application server or in metadata.

Answer : D

 
 
55) Which of the following one has Stored Process Feature of Version 2.0 stored processes

  1. Compatible with server versions prior to SAS 3 and SAS 9.3 or later servers.
  2. Associated with a specific logical server, which can be a SAS Stored Process Server or a SAS Workspace Server.
  3. Allows execution on other application servers or on the specified application server only.
  4. Allows execution on the specified application server only.

Answer : C

 
 
56) Which of the following one has Stored Process Feature of Version 2.0 stored processes

  1. Compatible with server versions prior to SAS 3 and SAS 9.3 or later servers.
  2. Associated with a specific logical server, which can be a SAS Stored Process Server or a SAS Workspace Server.
  3. Data sources and targets can be generic streams or XML streams.
  4. Data sources and targets can be generic streams, XML streams, or data tables.

Answer : D

 
 
57) Which of the following one has Stored Process Feature of Version 2.0 stored processes

  1. Compatible with server versions prior to SAS 3 and SAS 9.3 or later servers.
  2. Associated with a specific logical server, which can be a SAS Stored Process Server or a SAS Workspace Server.
  3. Uses either the stored process server or the workspace server to produce streaming output.
  4. Must use the stored process server to produce streaming output.

Answer : C

 
 
58) Which of the following one has Stored Process Feature of Version 2.0 stored processes

  1. Compatible with server versions prior to SAS 3 and SAS 9.3 or later servers.
  2. Compatible with SAS 9.3 or later servers only.
  3. Data sources and targets can be generic streams or XML streams.
  4. Must use the stored process server to produce streaming output.

Answer : B

 
 
59) Which of the following one has Stored Process Feature of Version 1.0 stored processes

  1. Compatible with server versions prior to SAS 3 and SAS 9.3 or later servers.
  2. Compatible with SAS 9.3 or later servers only.
  3. Data sources and targets can be generic streams, XML streams, or data tables
  4. Uses either the stored process server or the workspace server to produce streaming output.

Answer : A

 
 
60) Which of the following one has Stored Process Feature of Version 1.0 stored processes

  1. Data sources and targets can be generic streams or XML streams.
  2. Compatible with SAS 9.3 or later servers only.
  3. Data sources and targets can be generic streams, XML streams, or data tables
  4. Uses either the stored process server or the workspace server to produce streaming output.

Answer : A

 
 
61) Which of the following one has Stored Process Feature of Version 1.0 stored processes

  1. Stores source code on the application server.
  2. Compatible with SAS 9.3 or later servers only.
  3. Data sources and targets can be generic streams, XML streams, or data tables
  4. Uses either the stored process server or the workspace server to produce streaming output.

Answer : A




 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz