SAS DI Intermediate Quiz
SAS DI Quiz : This SAS DI Intermediate Quiz contains set of 60 SAS DI Quiz which will help to clear any exam which is designed for Intermediate.
1) Which one of the following programs contains a syntax error?
- proc sql;
- select product.*, cost.unitcost, sales.quantity from product p, cost c, sales s
- where p.item = c.item and p.item = s.item;
- quit;
- proc sql;
- select product.*, cost.unitcost, sales.quantity from product, cost, sales
- where product.item = cost.item and product.item = sales.item;
- quit;
- proc sql;
- select p.*, unitcost, s.quantity
- from product as p, cost as c, sales as s where p.item = item and
- item = s.item;
- quit;
- proc sql;
- select p.*, c.unitcost, s.quantity from product, cost, sales
- where product.item = cost.item and product.item = sales.item;
- quit;
2) Can we use SAS functions within the macro facility ?
- Not possible
- Yes,by using the %SYSFUNC macro function.
- Yes by using do loop
- yes,with macro defination
3) How do we resolve a macro variable within single quotation marks?
- Use CALL EXECUTE
- Use the %STR and %UNQUOTE
- Can’t be resolved
- use %let
4) Which statement is true regarding the SAS My Folder metadata location?
- The My Folder location is a valid place to share content.
- Every user with a SAS metadata identity has a My Folder location.
- The My Folder location is a temporary work location.
- The My Folder location is only available to the user it belongs to.
5) Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which statement is true?
- The physical table(s) selectedare copied to the application server specified in the library.
- The physical table(s) selectedare copied to the SAS Folders location specified in the wizard.
- Metadata for the physical table(s) selected is stored on the application server specified in the library
- Metadata for the physical table(s) selected is stored in the SAS Folders location specified in the wizard
6) Registering metadata for an ODBC data source involves registering:
- A library that will use a SAS/ACCESS engine to a specific database
- only an ODBC data source definition
- A server definition that points to the ODBC data source and a library accessing this server definition
- A table pointing directly to the ODBC data source
7) SAS Data Integration Studio is dependent on which administration functions?
- Setting up of SAS Information Map environment.
- Setting up of SAS Web and SAS Portal environments.
- Setting up of SAS Application Servers.
- Setting up of SAS Libraries definitions.
8) Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which
statement is true?
- The physical table(s) selected are copied to the application server specified in the library.
- The physical table(s) selected are copied to the SAS Folders location specified in the wizard.
- Metadata for the physical table(s) selected is stored on the application server specified in the library.
- Metadata for the physical table(s) selected is stored in the SAS Folders location specified in the wizar
9) 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?
- SAS Data Integration Studio
- SAS Enterprise Guide
- SAS Job Deployment Studio
- SAS Management Console
10) The Platform Process Manager server is part of the Platform Suite for SAS. Which statement is FALSE regarding the Platform Process Manager server?
- The server enables you to schedule jobs using a variety of recurrence criteria and dependencies on other jobs, time events, or file events.
- The server enables you to schedule jobs using a variety of recurrence criteria but does NOT allow you to specify any type of dependencies.
- The Flow Manager application (part of the Platform Suite for SAS) can be used to manage already scheduled
- Metadata for the Platform Process Manager server must be defined and must include the network address or host name of a machine as well as the port number for the server.
11) Which statement regarding scheduling SAS Data Integration Studio jobs is true?
- To schedule a job flow you must first use SAS Management Console to deploy the job for scheduling.
- To schedule the job on the Platform Process Manager you require a dependency generator.
- Multiple job flows can be scheduled to a deployment directory.
- To schedule a job flow in SAS Management console you must first deploy the job for scheduling using SAS Data Integration Studio.
12) Which statement defines the characteristics of a SAS Stored Process?
- SAS metadata that describes how to collect and store data sources.
- A document that stores the steps and locations for building a data mart.
- A SAS program that is stored on the server and described by metadata.
- A user written SAS PROC step.
13) In SAS Data Integration Studio, an index can be specified/defined in which location?
- the Indexes tab in the properties of a Table Loader transformation
- the Indexes tab in the properties of a table metadata object
- the Indexes tab in the properties for any transformation
- the Indexes tab in the properties of a job metadata object
14) Which statement is FALSE regarding foreign keys?
- A foreign key is one or more columns that are associated with a primary key or unique key in another
- A table can have zero or more foreign keys.
- A foreign key cannot exist without an associated primary or unique key.
- A table can have only one foreign key define
15) Assume that SAS Data Integration Studio Table Loader is being used in a job. The load style selected is Update/Insert. Which statement is true regarding theAssume that SAS Data Integration Studio? Table Loader is being used in a job. The load style select
- From the source table, matching rows are updated in the target table and new rows are added.
- From the source table, matching rows AND new rows are added, but the original matching row in the target table is marked as inactive.
- From the source table, matching rows are skipped, and new rows are added.
- A or C, depending on further options chosen.
16) The DICTIONARY.MACROS table stores information about which of the following?
- user defined macro variables only
- system defined macro variables only
- both user and system defined macro variables
- macros stored in the autocall macro library only
17) The following SAS program is submitted:
%let a = cat;
%macro animal(a = frog);
%let a = bird;
%mend;
%animal(a = pig)
%put a is &a;
Which one of the following is written to the SAS log?
- a is &a
- a is cat
- a is pig
- a is bird
18) The following SAS program is submitted:
%let value = .5;
%let add = 5;
%let newval = %eval(&value = &add);
Which one of the following is the resulting value of the macro variable NEWVAL?
- 5
- 5
- .5 + 5
- null
19) The following SAS program is submitted:
%let name = Patel’s Restaurant;
Which one of the following statements avoids problems associated with the unbalanced quotation mark?
- %let name = Patel%’s Restaurant;
- %let name = %str(Patel’s Restaurant);
- %let name = Patel%str(‘)s Restaurant;
- %let name = %str(Patel%’s Restaurant);
20) Which of the following is true about SAS automatic macro variables?
- They are always read only.
- All can have their value changed by a user.
- Some can have the value changed by a user.
- They can only be used inside of a macro definition.
21) Within SAS Data Integration Studio, how many inputs and outputs can be defined for a Generated
transformation?
- A transformation can have zero or more inputs and exactly one output.
- A transformation needs at least one input and at least one output.
- A transformation can have zero or more inputs and zero or more outputs.
- A transformation needs at least one input and exactly one output.
22) How can you test the interaction of the options of a SAS Data Integration Studio Generated
transformation?
- The transformation has to be used within a job to interactively test the options with the Test Prompt button in the Options window from the properties of the transformation within the job editor.
- The options can be tested after finalizing and saving the transformation with the Test Prompt item on the Tools menu.
- The options can be tested only after adding all options that are assigned to the source code with the Test Prompt button in the Options window of the New Transformation wizard.
- The options can be tested at any time after adding them to the transformation with the Test Prompt button in the Options window of the New Transformation wizar
23) Within SAS Data Integration Studio, how is the internal code of a SAS Code transformation assigned to
its options?
- SAS macro variables
- columns of SAS datasets
- SAS formats
- SAS macro calls
24) A user needs to find out who has the SAS Data Integration Studio job “Create Tables” checked out. What
action should the user perform?
- They need to select the “Properties” menu option and then the “Advanced” tab for the SAS Data Integration Studio job “Create Tables” within Data Integration studio.
- They need to select the History menu option for the SAS Data Integration Studio job “Create Tables” once it has been checked in.
- They need to select the History menu option for the SAS Data Integration Studio job “Create Tables”.
- They are not able to find out who has the SAS Data Integration Studio job “Create Tables” in checked out status because they are not an administrator.
25) Choose location of following designer tab task:
Select and manipulate an object that
displays in the Diagram tab.
- Navigate pane
- SQL Clauses pane
- Tables pane
- Properties pane
26) Choose location of following designer tab task:
Add SQL clauses to the flow shown
on the Diagram tab.
- Navigate pane
- SQL Clauses pane
- Tables pane
- Properties pane
27) Choose location of following designer tab task:
Review the list of columns in the
source table and the target table.
Note that you can specify alphabetic
display of the columns by selecting
Display columns in alphabetical
order.
- Navigate pane
- SQL Clauses pane
- Tables pane
- Properties pane
28) Choose location of following designer tab task:
Display and update the main
properties of an object that is
selected on the Diagram tab. The
title of this pane changes to match
the object selected in the Navigate
pane
- Navigate pane
- SQL Clauses pane
- Tables pane
- Properties pane
29) Find the debugging keyword for the join algorithm:table name
- sqxsort
- sqxjm
- sqxjhsh
- sqxrc
30) Find the debugging keyword for the join algorithm:hash join
- sqxsort
- sqxjm
- Not avilable
- sqxrc
31) Find the debugging keyword for the join algorithm:sort-merge join
- sqxsort
- sqxjm
- sqxjhsh
- sqxrc
32) Maintains a limited history of changes using multiple columns for selected variables.
- Type 1 SCD
- Type 2 SCD
- Type 3 SCD
- SQL join
33) No history of data changes
- Type 1 SCD
- Type 2 SCD
- Type 3 SCD
- SQL join
34) Full history of data changes
- Type 1 SCD
- Type 2 SCD
- Type 3 SCD
- SQL join
35) When writing postcode in the Precode and Postcode tab of the Transpose transformation in SAS Data Integration Studio, which symbol allows you to reference the transformation output table regardless of the actual physical name for that target table?
- &syslast
- syslast
- &target
- %target
36) Which statement best describes a deployment directory as used in the Schedule Manager in SAS
Management Console?
- A folder or directory location on a server where the SAS code from a deployed SAS Data integration Studio job is stored.
- A location in the metadata repository where job flows are deployed.
- A location in the SAS Management console job directory storing the metadata for jobs that can be added to job
- A SAS Folder in the Schedule Manager plug-in within SAS Management Console containing listings of all flows organized by server type.
37) In SAS Data Integration Studio, which component allows the definition of job flows with dependencies
between different jobs?
- the deployment wizard of SAS Data Integration Studio
- the Scheduling Manager plug-in in SAS Management Console
- the Scheduling Server
- the SAS DATA Step Batch Server
38) Which batch server is queried to retrieve the command needed to run traditional .SAS programs having
DATA and PROC steps?
- SAS Java Batch Server
- SAS DATA Step Batch Server
- SAS Generic Batch Server
- SAS PROC Step Batch Server
39) In SAS Data Integration Studio, primary keys, foreign keys and unique keys can be specified/defined in
which location?
- the Keys tab in the properties of a Table Loader transformation
- the Keys tab in the properties for any transformation
- the Keys tab in the properties of a table metadata object
- the Keys tab in the properties of a job metadata object
40) When using the Table Loader transformation in SAS Data Integration Studio to update an existing table
containing indexes or constraints, which statement is true?
- You can control the removal and/or creation of indexes and constraints in the target table only if you are using a Load style other than Replace.
- You can control the removal and/or creation of indexes and constraints in the target table for all Load
- If using the Append to Existing load style, indexes and constraints can be added but not removed.
- For the Update/Insert load style it is possible to remove indexes not required for the Update/Insert processing, but no indexes can be adde
41) Assume that SAS Data Integration Studio Table Loader is being used in a job. The load style selected is
Append to Existing. Which statement is true regardingAssume that SAS Data Integration Studio? Table
Loader is being used in a job. The load style selec
- It generates PROC APPEND code.
- It generates PROC SQL code.
- It generates either PROC SQL code or PROC APPEND code depending on further option choices.
- It generates DATA STEP APPEND code.
42) Choose correct description for the technique –
Directly enter
an expression
into an
Expression
field
- Double-click in the field in which you want to enter the expression. A cursor displays in the field. (The button disappears.) Enter your expression into the field. For example, to write today’s date to every row in a column, you can enter the expres Right-click in an Expression column. Then, click Advanced in the pop-up menu to access the Expression window.
- Use the Expression Builder to create an expression. Then, click OK to save the expression, close the Expression window, and display the exp Select the Price source column and the DiscountedPrice target column.
- Right-click either selected variable, and select Expression from the popup Then, select Advanced to access the Expression window.
- Use the Expression Builder to create an e Select the source columns and target column to be used in the mapping. For example, you can use the values of the Price and Discount columns in the source in an expression. Then, the result can be written to thenDiscountedPrice column in the target.
43) Choose correct description for the technique –
Create
expressions
that use no
source
columns
- Double-click in the field in which you want to enter the expression. A cursor displays in the field. (The button disappears.) Enter your expression into the field. For example, to write today’s date to every row in a column, you can enter the expres Right-click in an Expression column. Then, click Advanced in the pop-up menu to access the Expression window.
- Use the Expression Builder to create an expression. Then, click OK to save the expression, close the Expression window, and display the exp Select the Price source column and the DiscountedPrice target column.
- Right-click either selected variable, and select Expression from the popup Then, select Advanced to access the Expression window.
- Use the Expression Builder to create an e Select the source columns and target column to be used in the mapping. For example, you can use the values of the Price and Discount columns in the source in an expression. Then, the result can be written to the DiscountedPrice column in the target.
44) Choose correct description for the technique –
Create
expressions
that use a
single source
column
- Double-click in the field in which you want to enter the expression. A cursor displays in the field. (The button disappears.) Enter your expression into the field. For example, to write today’s date to every row in a column, you can enter the expres Right-click in an Expression column. Then, click Advanced in the pop-up menu to access the Expression window.
- Use the Expression Builder to create an expression. Then, click OK to save the expression, close the Expression window, and display the exp Select the Price source column and the DiscountedPrice target column.
- Right-click either selected variable, and select Expression from the popup Then, select Advanced to access the Expression window.
- Use the Expression Builder to create an e Select the source columns and target column to be used in the mapping. For example, you can use the values of the Price and Discount columns in the source in an expression. Then, the result can be written to the DiscountedPrice column in the target.
45) Choose correct description for the technique –
Create
expressions
that use two or
more source
columns
- Double-click in the field in which you want to enter the expression. Acursor displays in the field. (The button disappears.) Enter your expression into the field. For example, to write today’s date to every row in a column, you can enter the expres Right-click in an Expression column. Then, click Advanced in the pop-up menu to access the Expression window.
- Use the Expression Builder to create an expression. Then, click OK to save the expression, close the Expression window, and display the exp
- Select the Price source column and the DiscountedPrice target column. Right-click either selected variable, and select Expression from the popup Then, select Advanced to access the Expression window.
- Use the Expression Builder to create an e Select the source columns and target column to be used in the mapping. For example, you can use the values of the Price and Discount columns in the source in an expression. Then, the result can be written to the DiscountedPrice column in the target.
46) Identify the sort enhancement technique from the below description:
Pre-sorting in relational databases might outperform sorting
that is based on SAS. Use options of the SAS Data
Integration Studio Extract transformation to generate an
ORDER BY clause in
- Direct sort utility files to fast storage devices
- Distribute sort utility files across multiple devices
- Pre-sort explicitly on the most common sort key
- Use relational database sort engines to pre-sort tables without data order issues
47)
Identify the sort enhancement technique from the below description:
SAS Data Integration Studio might arrange a table in sort
order, one or multiple times. For large tables in which sort
order is required multiple times, look for a common sort
order. Use
- Direct sort utility files to fast storage devices
- Distribute sort utility files across multiple devices
- Pre-sort explicitly on the most common sort key
- Use relational database sort engines to pre-sort tables without data order issues
48) Identify the sort enhancement technique from the below description:
Distribute SORT procedure utility files across multiple fast,
less-utilized devices. Direct the SORT procedure utility file
of each job to a different device. Use the WORK invocation
opti
- Direct sort utility files to fast storage devices
- Distribute sort utility files across multiple devices
- Pre-sort explicitly on the most common sort key
- Use relational database sort engines to pre-sort tables without data order issues
49) Identify the sort enhancement technique from the below description:
Because sorting is so I/O intensive, it is important to start
with only the rows and columns that are needed for the sort.
The SORT procedure WORK files and the output file are
dependent
- Direct sort utility files to fast storage devices
- Distribute sort utility files across multiple devices
- Pre-sort explicitly on the most common sort key
- Size input data
50) In SAS Data Integration Studio, which statement is FALSE regarding status handling?
- When a job is executed in SAS Data Integration Studio, a return code for each transformation in the job is captured in a macro variable. The return code for the job is set to the least successful transformation in the SAS Data Integration Studio ena
- If status handling has been defined for a transformation or the job, a macro definition (and a call to it) will be added to the generated code to check for the specified condition(s).
- Only one Condition/Action pair can be defined for a single transformation or for a job.
- The available Condition/Action pairs for transformations and jobs will vary – that is, different Condition/Action pairs may exist for the SQL Join transformation versus the Table Loader
51) After creating a stored process from a SAS Data Integration Studio job, how can you test the stored
process to make sure it runs correctly?
- Execute the stored process in SAS Data Integration Studio.
- Execute the stored process in SAS Management Console.
- Execute the stored process using the SAS Add-In for Microsoft Office or SAS Enterprise Guide.
- Execute the stored process using SAS Display Manager’s Stored Process Test window.
52) The following SAS program is submitted:
%macro test(var);
%let jobs = BLACKSMITH WORDSMITH SWORDSMITH;
%let type = %index(&jobs,&var);
%mend;
%test(SMITH)
Which one of the following is the resulting value of the macro variable TYPE?
- 0
- 3
- 6
- null
53) You can specify the server status messages that are encountered in a SAS Data
Integration Studio session by using the –MessageLevel level_value option. Valid
values for level_value are
- FINE
- FIND
- INDEX
- MSGLEVEL
54) Method for Specifying Metadata for
A set of table metadata in Common Warehouse
Metamodel (CWM) format or in a format that is
supported by a SAS Metadata Bridge.
- Select File -> Import -> Metadata from the menu bar
- Select an appropriate destination folder in the tree view, and then select File -> Import -> SAS Package from the menu bar
- Select File -> Register Tables from the menu bar
- Select File -> New -> External File -> Delimited from the menu bar
55) Defination of Fork transforamtion
- Marks the beginning of the iterative processing sequence in an iterative job.
- Marks the end of the iterative processing sequence in an iterative job
- Marks the end of a portion of a SAS job that was running in parallel with another portion of that job. Any code between the Fork transformation and the Fork End transformation is executed in one SAS session.
- Marks the beginning of a separate session that allows a portion of a SAS job to be run in parallel along with another piece of SAS code.
56) Defination of Fork End transforamtion
- Marks the beginning of the iterative processing sequence in an iterative job.
- Marks the end of the iterative processing sequence in an iterative job
- Marks the end of a portion of a SAS job that was running in parallel with another portion of that job. Any code between the Fork transformation and the Fork End transformation is executed in one SAS session.
- Marks the beginning of a separate session that allows a portion of a SAS job to be run in parallel along with another piece of SAS code.
57) Defination of Loop End transforamtion
- Marks the beginning of the iterative processing sequence in an iterative job.
- Marks the end of the iterative processing sequence in an iterative job
- Marks the end of a portion of a SAS job that was running in parallel with another portion of that job. Any code between the Fork transformation and the Fork End transformation is executed in one SAS session.
- Marks the beginning of a separate session that allows a portion of a SAS job to be run in parallel along with another piece of SAS code.
58) Defination of Wait For Completion transformation
- Provides logic to allow any part or all parts of a Fork job to complete before moving on to the next processing step. Inputs are typically an output table from the Fork transformation.
- Provides status-handling logic at a desired point in the process flow diagram for a job Can be inserted between existing transformations and removed later without affecting the mappings in the original process flow.
- Marks the beginning of a conditional process in a job
- Marks the end of a conditional process in a job
59) Defination of SCD Type
1 Loader
- Enables you to load a dimension table using type 1 updates. Type 1 updates insert new rows, update existing rows, and generate surrogate key values in a dimension table without maintaining a history of data changes. Each business key is represented by a s
- Loads source data into a dimension table, detects changes between source and target rows, updates change tracking columns, and applies generated key values. This transformation implements slowly changing dimensions
- Loads a target, adds generated whole number values to a surrogate key column,and sorts and saves the source based on the values in the business key column or columns
- Selects multiple sets of rows from one source and writes each set of rows to a different target. Typically used to create two or more subsets of a source. Can also be used to create two or more copies of a source.
60) Defination of SCD Type
2 Loader
- Enables you to load a dimension table using type 1 updates. Type 1 updates insert new rows, update existing rows, and generate surrogate key values in a dimension table without maintaining a history of data changes. Each business key is represented by a s
- Loads source data into a dimension table, detects changes between source and target rows, updates change tracking columns, and applies generated key values. This transformation implements slowly changing dimensions
- Loads a target, adds generated whole number values to a surrogate key column, and sorts and saves the source based on the values in the business key column or columns
- Selects multiple sets of rows from one source and writes each set of rows to a different target. Typically used to create two or more subsets of a source. Can also be used to create two or more copies of a source.
61) Defination of Surrogate
Key
Generator
- Enables you to load a dimension table using type 1 updates. Type 1 updates insert new rows, update existing rows, and generate surrogate key values in a dimension table without maintaining a history of data changes. Each business key is represented by a s
- Loads source data into a dimension table, detects changes between source and target rows, updates change tracking columns, and applies generated key values.This transformation implements slowly changing dimensions
- Loads a target, adds generated whole number values to a surrogate key column, and sorts and saves the source based on the values in the business key column or columns
- Selects multiple sets of rows from one source and writes each set of rows to a different target. Typically used to create two or more subsets of a source. Can also be used to create two or more copies of a source.
62) Defination of Apply Lookup
Standardization
- Enables you to select and apply DataFlux schemes that standardize the format, casing, and spelling of character columns in a source table.
- 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
- Enables you to select and execute a DataFlux job that is stored on a DataFlux Data Management Server. You can execute DataFlux DataManagement Studio data jobs, process jobs, and profiles. You can also execute Architect jobs that were created with DataFlu
- 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