SAS DI Quiz

Posted on: | By: – Comments Off

SAS DI Beginner Quiz

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



1) Which one of the following should be avoided when creating and using an SQL
procedure view?
 

  1. using a HAVING clause
  2. using summary functions
  3. referencing a view multiple times in the same program
  4. creating views on tables whose structures remain constant

Answer : C

 
 
2) Which SQL procedure program deletes rows from the data set CLASS?

  1. proc sql;
  2. alter from class delete where age < (select stop_age from threshold); quit;
  3. proc sql; delete from class where age < (select stop_age from threshold); quit;
  4. proc sql; modify table class delete where age < (select stop_age from threshold); quit;
  5. proc sql;
  6. select * from class delete where age < (select stop_age from threshold); quit;

Answer : B

 
 
3) Which of the following is true about a noncorrelated subquery in SAS?

  1. The outer query executes before the subquery.
  2. The subquery executes once before the outer query.
  3. The subquery creates a data set in the WORK library.
  4. The subquery can reference tables in the FROM clause in the outer query.

Answer : B

 
 
4) Which products are needed on the local host in order to access data from an MS Access Database using an ODBC Data Source name?

  1. SAS/ACCESS interface to DSN
  2. SAS/ACCESS interface to MDB
  3. SAS/ACCESS interface to PC Files
  4. SAS/ACCESS interface to ODBC

Answer : D

 
 
5)
Which statement is true regarding external files?
 

  1. External file objects are accessed with SAS INFILE and FILE statements.
  2. External files contain only one record per line.
  3. External files can be used as input but not as outputs
  4. in SAS Data Integration Studio jobs.
  5. SAS can only work with Blank, Comma, Semicolon and Tab as delimiters in external files.

Answer : A

 
 
6) Within SAS Data Integration Studio’s SQL Join transformation, the option to turn on debug is located in which Properties pane?

  1. Select Properties
  2. Create Properties
  3. SQL Join Properties
  4. Job Properties

Answer : C

 
 
7) Within SAS Data Integration Studio’s Table Loader transformation, which load style choice does NOT exist?

  1. Delete where
  2. Append to Existing
  3. Replace
  4. Update/Insert

Answer : A

 
 
8) In SAS Data Integration Studio, a business key can be defined in the properties of which transformation?

  1. Data Validation
  2. SQL Join
  3. Lookup
  4. SCD Type 2 Loader

Answer : D

 
 
9) Which statement is true regarding connection profiles used with the SAS platform applications?

  1. Each SAS platform application must have its own connection profile.
  3. Connection profiles are stored on the server machine.
  4. Connection profiles are stored on the machine where the SAS application is installed.
  5. All SAS platform applications share
  6. one connection profile.

Answer : C

 
 
10) Which statement regarding pre-assigned libraries is true?

  1. Pre-assigned libraries reduce the initialization time for a workspace server.
  2. Pre-assigned libraries always connect to an RDBMS at server initialization.
  3. Pre-assigned libraries always connect to a base SAS library at server initialization.
  4. Pre-assigned libraries do not have to be identical across all SAS client applications.

Answer : C




 
11) Can we use Data step variables in a %if-%then statement ?

  1. No,Data step variables cannot be used in %if-%then statements.
  2. yes,with macro defination
  3. Yes,some varibles can be used.
  4. Yes by using do loop

Answer : A

 
 
12) Which SAS applications can be used to create data sources for reporting and analysis using the SAS platform applications?

  1. SAS Enterprise Guide
  2. SAS Information Delivery Portal
  3. SAS Web Report Viewer
  4. SAS Web Report Studio

Answer : A

 
 
13) Which statement is true regarding roles?

  1. Only groups can be members of roles.
  2. Only users can be members of groups or roles.
  3. You must use roles to control access to application features.
  4. You must use roles to control access to data sources and reporting content.

Answer : C

 
 
14) You want to register an external file with the following structure: first line contains Customer First and Last Name second line is address1 third line is address 2  fourth line contains the phone number What action should you take to read this file?

  1. Use the New User Written External File wizard.
  2. Use the New Fixed Width External File wizard.
  3. Use the New Delimited External File wizard.
  4. Use the New COBOL Copybook wizar

Answer : A

 
 
15) The ability to deploy a SAS Data Integration Studio job as a Web service or a SAS Stored Process requires additional set up that is performed in which client application

  1. SAS Data Integration Studio
  2. SAS Enterprise Guide
  3. SAS Job Deployment Studio
  4. SAS Management Console

Answer : D

 
 
16) Within SAS Data Integration Studio, which one of the following is NOT an option available from the File-> New menu choice under External File grouping?

  1. Delimited
  2. Fixed Width
  3. User Written
  4. COBOL Copybook

Answer : D

 
 
17) Which statement correctly defines a System DSN?

  1. Not specific to an individual user. Anyone with permission to access the data source can use it.
  2. Specific to an individual user. It is available only to the user who creates it.
  3. Not specific to an individual user. It can be shared among users even though it is created locally
  4. Specific to an individual user. But it can be shared among users.

Answer : A

 
 
18) You want to create a table containing all customers from Italy. Assume that global customer orderinformation is available in a single table. Identify the SAS Data Integration Studio transformation that will help you perform the task easily.

  1. Append
  2. Extract
  3. Lookup
  4. Mining Results

Answer : B

 
 
19) When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a
change is detected?

  1. the old record is deleted and the changed record is added
  2. the old record is updated with the new values from the changed record
  3. the old record is flagged and the changed record is added
  4. the old record is merged with the changed record

Answer : C

 
 
20) A fact table is populated by using which transformation in SAS Data Integration Studio?

  1. SCD Type 2 Loader
  2. Data Validation
  3. Lookup
  4. DataFlux IS Job

Answer : C




 
21) In SAS Data Integration Studio, surrogate and retained key values are:

  1. generated by the Lookup transformation
  2. copied from source tables into dimension tables
  3. generated by the SCD Type 2 Loader transformation
  4. copied from dimension tables into source tables

Answer : C

 
 
22) In SAS Data Integration Studio, source table records and dimension table records are combined for output
using which transformation?

  1. Data Validation
  2. Lookup
  3. DataFlux IS Job
  4. Table Loader

Answer : B

 
 
23) The SAS Data Integration Studio SCD Type 2 Loader transformation performs which of the following?

  1. Loads source table records into a standardization table.
  2. Loads dimension table records into a fact table.
  3. Loads source table records into a dimension table.
  4. Loads fact table records into a multi-threaded table.

Answer : C

 
 
24) How can you make a SAS Data Integration Studio Generated transformation option required?

  1. The name of the option has to start with _REQUIRED.
  2. The type of the column has to be defined as Required Data source column.
  3. The option can be marked as Requires a non-blank value.
  4. It is not possible to make an option require

Answer : C

 
 
25) Within SAS Data Integration Studio’s Table Loader transformation, which load style choice does NOT exist?

  1. Delete where
  2. Append to Existing
  3. Replace
  4. Update/Insert

Answer : A

 
 
26) In SAS Data Integration Studio, a business key can be defined in the properties of which transformation?

  1. Data Validation
  2. SQL Join
  3. Lookup
  4. SCD Type 2 Loader

Answer : D

 
 
27) Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which
statement is true?

  1. The physical table(s) selectedare copied to the application server specified in the library.
  2. The physical table(s) selectedare copied to the SAS Folders location specified in the wizard.
  3. Metadata for the physical table(s) selected is stored on the application server specified in the library.
  4. Metadata for the physical table(s) selected is stored in the SAS Folders location specified in the wizar

Answer : D

 
 
28) The UPDATE statement is not supported by Hadoop (Hive), HAWQ, Impala, LASR, PI,
or SASHDAT engines, so they cannot be used as target tables in the following
transformations:

  1. SCD Type 1
  2. Append
  3. Merge
  4. Extract

Answer : A

 
 
29) The Loop transformation has been enhanced so that you can create a single job with how many loops

  1. Three loops
  2. One loop only
  3. two loops
  4. Up to 42 loops

Answer : C

 
 
30) Defination of SAS Workspace Server

  1. Submits stored processes for execution by a SAS session. Stored processes are SAS programs that are stored and can be executed by client
  2. Executes SAS code,reads and writes
  3. 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 : B




 
31) Defination of SAS Stored Process Server

  1. Submits stored processes for execution by a SAS session. Stored processes are SAS programs that are stored and can be executed by client
  2. Executes SAS code,reads and writes
  3. 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 : A

 
 
32) Defination of SAS SAS/CONNECT Server

  1. Submits stored processes for execution by a SAS session. Stored processes are SAS programs that are stored and can be executed by client
  2. Executes SAS code,reads and writes
  3. 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 : C

 
 
33) Defination of SAS SAS/SHARE Server

  1. Submits stored processes for execution by a SAS session. Stored processes are SAS programs that are stored and can be executed by client
  2. Executes SAS code,reads and writes
  3. 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. Enables concurrent access of server libraries from multiple users

Answer : D

 
 
34) Method for Specifying Metadata for A set of table metadata exported from SAS Data Integration Studio as a SAS Package File
 

  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 : B

 
 
35) Method for Specifying Metadata for
A table that is specified in a comma-delimited file or in another external file
 

  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 : D

 
 
36) Select correct Propagation Path Option for “To Targets”

  1. From Sources
    • From Beginning
    • From End
  2. To Sources
    • To Beginning
    • To End
  3. From Targets
    • From Beginning
    • From End
  4. To Targets
    • To Beginning
    • To End

Answer : A

 
 
37) Select correct Propagation Path Option for “From Targets ”

  1. From Sources
    • From Beginning
    • From End
  2. To Sources
    • To Beginning
    • To End
  3. From Targets
    • From Beginning
    • From End
  4. To Targets
    • To Beginning
    • To End

Answer : B

 
 
38) Select correct Propagation Path Option for “To Sources”

  1. From Sources
    • From Beginning
    • From End
  2. To Sources
    • To Beginning
    • To End
  3. From Targets
    • From Beginning
    • From End
  4. To Targets
    • To Beginning
    • To End

Answer : C

 
 
39) Select correct Propagation Path Option for “From Sources”

  1. From Sources
    • From Beginning
    • From End
  2. To Sources
    • To Beginning
    • To End
  3. From Targets
    • From Beginning
    • From End
  4. To Targets
    • To Beginning
    • To End

Answer : D

 
 
40) Given the following SAS data set ONE: ONE
CATEGORY AGE SALARY BONUS
——
M 28 200 20
M 25 100 10
M 28 300 10
M 33 300 30
F 18 100 50
F 25 200 10
F 35 400 50
The following SQL program is submitted:
proc sql;
create table two as select distinct age from o

  1. 3
  2. 4
  3. 5
  4. 6

Answer : A




 
41) The following SAS program is submitted:
proc contents data = testdata.one;
run;
Which one of the following SQL statements produces similar information about the column attributes as the above CONTENTS procedure?
 

  1. proc sql; show testdatone; quit;
  2. proc sql; describe testdata.one; quit;
  3. proc sql; show table testdata.one; quit;
  4. proc sql; describe table testdata.one; quit;

Answer : D

 
 
42) The following SAS program is submitted: proc append data = M base = F; run; Which
SQL procedure program will produce the same results?

  1. proc sql; insert into F select * from M; quit;
  2. proc sql ; select * from F outer union corr select * from M; quit;
  3. proc sql ; create table F as select * from F intersect select * from M; quit;
  4. proc sql ; create table F as select * from F intersect corr select * from M; quit;

Answer : A

 
 
43) Which SAS Data Integration Studio reports, generated as external files, can be stored as document objects within metadata?

  1. only job reports
  2. only table reports
  3. both job reports and table reports
  4. No reports can be stored as document objects.

Answer : C

 
 
44) When opening a registered SAS data file into a Microsoft Excel Worksheet, a user has the option to sort the data.
Which application performs the sort and where does the sort occur?
 

  1. SAS performs the sort on the server.
  2. SAS performs the sort on the local machine.
  3. Excel performs the sort on the server.
  4. Excel performs the sort on the local machine.

Answer : A

 
 
45) How do we resolve error messages when
output that was generated with the
MPRINT system option looks fine?

  1. Use the %UNQUOTE function.
  2. Use CALL EXECUTE.
  3. Use CALL SYMPUT
  4. use %let

Answer : A

 
 
46) Which of the following is NOT a feature of SAS Data Integration Studio’s Data Validation transformation?

  1. The Data Validation transformation can generate match codes to provide de-duplication capabilities.
  2. The Data Validation transformation can perform missing-value detection and invalid-value validation in a single pass of the data.
  3. The Data Validation transformation provides de-duplication capabilities.
  4. The Data Validation transformation provides error-condition handling.

Answer : A

 
 
47) The SAS Data Integration Studio SCD Type 2 Loader transformation can do which of the following?

  1. generate cpu statistics
  2. generate a datetime value
  3. generates cluster numbers
  4. generates standardization values

Answer : B

 
 
48) Which action is performed by the Lookup transformation in SAS Data Integration Studio?

  1. combines rows from multiple tables into a single row
  2. combines rows from multiple tables into multiple rows
  3. validates that values are unique
  4. validates that values are not null

Answer : A

 
 
49) In SAS Data Integration Studio, where must the columns included in a business key exist?

  1. in the source and standardization tables
  2. in the source and dimension tables
  3. in the target and fact tables
  4. in the source, dimension and standardization tables

Answer : B

 
 
50) In SAS Data Integration Studio, the SCD Type 2 Loader transformation will do which of the following?

  1. find row matches using the business key
  2. find row matches using generated cluster numbers
  3. find non-standard values using a generated key
  4. find non-standard values using a business key

Answer : A




 
51) In SAS Data Integration Studio, the default values for generated surrogate and retained keys contain
which type of values?

  1. datetime values
  2. alpha-numeric values
  3. binary values
  4. integer values

Answer : D

 
 
52) Which of the following servers is NOT a part of the platform for SAS Business Analytics server tier?

  1. SAS Metadata Server
  2. SAS Workspace Server
  3. SAS/CONNECT Server
  4. SAS Content Server

Answer : D

 
 
53) Which products are needed on the local host in order to access data from an MS Access Database using an ODBC Data Source name?

  1. SAS/ACCESS interface to DSN
  2. SAS/ACCESS interface to MDB
  3. SAS/ACCESS interface to PC Files
  4. SAS/ACCESS interface to ODBC

Answer : D

 
 
54) Which statement is true regarding external files?

  1. External file objects are accessed with SAS INFILE and FILE statements.
  2. External files contain only one record per line.
  3. External files can be used as input but not as outputs in SAS Data Integration Studio jobs.
  4. SAS can only work with Blank, Comma, Semicolon and Tab as delimiters in external files.

Answer : A

 
 
55) Within SAS Data Integration Studio’s SQL Join transformation, the option to turn on debug is located in which Properties pane?

  1. Select Properties
  2. Create Properties
  3. SQL Join Properties
  4. Job Properties

Answer : C

 
 
56) Which SAS Data Integration Studio reports, generated as external files, can be stored as document objects within metadata?

  1. only job reports
  2. only table reports
  3. both job reports and table reports
  4. No reports can be stored as document objects

Answer : C

 
 
57) You want to create a job to extract only the rows that contain information about female employees from a table that contains information about both male and female employees. The new table should have observations in ascending order of age. Where would y

  1. Where tab and Group By tab
  2. Where tab and Order By tab
  3. Where tab and Parameters tab
  4. Group By tab and Parameters tab

Answer : B

 
 
58) You want to create a job that checks conditions for your data before that data is loaded into a data warehouse. The job should be able to detect error conditions such as missing data or duplicate data and take appropriate actions like registering error co

  1. Data Transfer
  2. Data Validation
  3. Data Quality
  4. Data Extract

Answer : B

 
 
59) When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can be selected
to check for changed data?

  1. business key columns
  2. Type 1 columns
  3. generated columns
  4. non-key columns

Answer : D

 
 
60) Defination of SAS SAS Scalable Performance Data (SPD) Server

  1. Provides parallel processing for large SAS data stores; provides a comprehensive security infrastructure, backup and restore utilities, and sophisticated administrative and tuning options.
  2. Executes SAS code,reads and writes
  3. 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. Enables concurrent access of server libraries from multiple users

Answer : A

 
 
61) Defination of Loop transforamtion

  1. Marks the beginning of the iterative processing sequence in an iterative job.
  2. Marks the end of the iterative processing sequence in an iterative job
  3. Marks the end of a portion of a SAS job that was running in parallel with another
  4. portion of that job. Any code between the Fork transformation and the Fork End
  5. transformation is executed in one SAS session.
  7. Marks the beginning of a separate session that allows a portion of a SAS job to
  8. be run in parallel along with another piece of SAS code.

Answer : A

 
 
62) maintains multiple records for each business key in the dimension table. The latest
entry is the current entry for that business key. Other rows comprise the historical
record of data changes. New entries create new current rows.

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

Answer : B

 
 
63) limited history of data changes

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

Answer : C




 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz