Developer Quiz - Data Integration Studio (di Studio) SAS 9.2

10 Questions
Data Quizzes & Trivia
Sample Question

The dimension tables and fact tables are refreshed during each batch load

True

False

Number of Questions:

More Options
Please wait...
Questions and Answers
  • 1. 
    The dimension tables and fact tables are refreshed during each batch load
    • A. 

      True

    • B. 

      False

  • 2. 
    A fact table can only have measures but can also have degenerate dimensions in some instances
    • A. 

      True

    • B. 

      False

  • 3. 
    SAS DI Studio is a windows client
    • A. 

      True

    • B. 

      False

  • 4. 
    Any given SAS Application server can have multiple physical workspace servers
    • A. 

      True

    • B. 

      False

  • 5. 
    A generated transformation can have zero or more input and zero or more output
    • A. 

      True

    • B. 

      False

  • 6. 
    Which one of the following is not a slowly changing dimension transformation?
    • A. 

      SCD Type 2 Loader

    • B. 

      Fact Table Lookup

    • C. 

      Surrogate Key Generator

    • D. 

      Apply Lookup Standardization

  • 7. 
    The business key column is found in the following table(s)
    • A. 

      Dimension Tables

    • B. 

      Fact Tables

    • C. 

      Standardization Table

    • D. 

      A and C

  • 8. 
    Which of the following combinations are under server tier?
    • A. 

      Workspace Server & Stored Process Server

    • B. 

      Workspace Server & WebDav Server

    • C. 

      WebDav Server & Stored Process Server

    • D. 

      None of the above

  • 9. 
    A Look-up transformation is not used for:
    • A. 

      Validate unique values

    • B. 

      Validate missing values

    • C. 

      Access rows from multiple tables and load single table

    • D. 

      Access rows from multiple tables and load multiple rows

  • 10. 
    Which of the following is not an option provided by the SAS DI studio when reading external files?
    • A. 

      Delimited

    • B. 

      Fixed

    • C. 

      User Written

    • D. 

      COBOL copy books