In SAS Data Integration Studio, which tree in the desktop is used to organize jobs, libraries, and tables into a folder hierarchy that mirrors the SAS Folders metadata structure?
Overview
Question · Easy
Which SAS server is the central authority that stores definitions of libraries, tables, jobs, and users used by SAS Data Integration Studio?
Where does a developer register a new SAS library so that SAS Data Integration Studio can use it?
Creating Metadata Source Target
Tech Exam Prep Podcast
Listen on Spotify
Podcast
A team uses SAS Data Integration Studio with change management enabled. What is the effect of checking out a job from the project repository?
Question · Medium
You need to register an existing physical SAS data set as a metadata table so it can be used as a source in jobs. Which DI Studio feature is the correct tool?
When registering a delimited external file as a source, what kind of metadata object does SAS Data Integration Studio create to describe the file's structure?
Which engine should be selected on a metadata-defined library that points at an Oracle database that DI Studio jobs will read from and write to?
A column on a registered source table is shown as numeric length 8 with format DATE9. and informat DATE9.. What does this tell you?
Which option is the most reliable way to populate column metadata for a source table that already exists physically?
You define a target table that does not yet exist in the database. When the job runs for the first time, what controls whether DI Studio creates the physical table?
Creating Metadata Target Jobs
What is the purpose of a permanent (versus work) target table in a DI Studio job?
In a DI Studio job, what does the green check mark icon on a transformation indicate after you run the job?
Which DI Studio transformation joins two or more tables using SQL and lets you choose inner, left, right, or full outer join in a graphical join editor?
Transformations
A developer wants to combine three input tables that have identical column structures into one output table. Which transformation is the best fit?
Which DI Studio transformation is purpose-built for replacing codes with descriptions or enriching rows from a small reference table, and supports caching the lookup table in memory?
Which SQL set operator combines two result sets and removes duplicate rows?
In the SQL Join transformation, where do you typically push a row filter so that the database (not SAS) filters the rows when SAS/ACCESS supports pass-through?
Question · Hard
Which transformation routes rows from one input to multiple outputs based on conditional expressions you define?
Which transformation rejects rows that fail user-defined rules and routes them to an error table while sending valid rows to the main output?
Which transformation should you choose to convert text values like 'NY', 'N.Y.', and 'New York' into a consistent canonical form using DataFlux/SAS Data Quality definitions?
Which DataFlux concept is used by the Match Codes transformation to detect that 'IBM' and 'I.B.M.' refer to the same entity?
Which transformation lets you transpose rows into columns or columns into rows for reporting purposes?
What is the main reason to use the Sort transformation immediately before a SQL Join when both inputs are large and the database does not support pass-through?
How does the Extract transformation differ from a SQL Join with a single input?
Which transformation lets a developer paste arbitrary SAS code directly into a node and treat it like any other transformation in the job flow?
What is a generated transformation in SAS Data Integration Studio?
Generated Transformations
Which substitution token is replaced at run time with the libref.member name of an input table inside a generated transformation's source code template?
When designing a generated transformation, what does adding a 'Prompt' (an option) to the wizard accomplish?
What is the recommended way to share a generated transformation with other DI Studio users in the same metadata environment?
Which loader is the most flexible loader for SAS targets and supports Append, Replace (drop and re-create or truncate-insert), and Update load techniques?
Tables And Table Loader
Which Table Loader load technique drops the existing target table and re-creates it from scratch each run?
Why is 'Replace - Truncate and load' often preferred over 'Replace - Drop table, re-create, and load' for a relational target with permissions and indexes?
Which Table Loader option, when enabled for a relational DBMS target, sends rows in large batches using the database's native bulk-load utility?
Which Update/Insert option in the Table Loader controls the matching column(s) used to decide whether a row is updated or inserted?
Which transformation implements Slowly Changing Dimensions (SCD) Type 2, including a surrogate key, valid-from / valid-to dates, and current-record flag?
In SCD Type 1 loading, what happens when the source row has a changed attribute compared with the matching dimension row?
What is the primary characteristic of Slowly Changing Dimension Type 3?
Which DI Studio transformation creates and assigns a stable surrogate key to dimension rows that lack one?
What is in-database processing in SAS Data Integration Studio?
In Database Processing
Which two SAS/ACCESS LIBNAME options together help maximize implicit pass-through of SQL to the DBMS?
What is the difference between implicit and explicit pass-through SQL when using SAS/ACCESS?
When two tables in a SQL Join transformation come from different SAS/ACCESS engines (for example, Oracle and Teradata), what happens to implicit pass-through?
Which DI Studio menu action makes a job runnable on a SAS Workspace Server outside of DI Studio (for example, from a scheduler or a batch shell)?
Deploying Jobs
When a job is deployed for scheduling, what is the typical scheduling tool integrated through SAS Management Console's Schedule Manager?
What is the difference between Deploy as Stored Process and Deploy for Scheduling?
Which return-code-based DI Studio feature can be used to run a recovery transformation only when the upstream transformation fails?
Which DI Studio capability shows the upstream sources, downstream targets, and the chain of transformations a particular column or table flows through?
Loading more…