Importing Data - Basic Understanding

20 Questions | Total Attempts: 32

SettingsSettingsSettings
Data Quizzes & Trivia

Questions and Answers
  • 1. 
    1. Which of the following data can be imported in to SAS (select all correct answers)                          
    • A. 

      Text file

    • B. 

      Excel file

    • C. 

      Csv file

    • D. 

      Avi file

  • 2. 
    2. What is ETL
    • A. 

      Editing, Tabulating and Loading

    • B. 

      Extraction, Transformation and Loading

    • C. 

      Editing, Transforming and Learning

  • 3. 
    Which of the following tools are used for ETL operations in the Industry?    (select all correct answers)
    • A. 

      SAS

    • B. 

      Informatica

    • C. 

      .Net

    • D. 

      Java

  • 4. 
    Teradata files can be accessed using SAS without importing in to SAS
    • A. 

      True

    • B. 

      False

  • 5. 
    What is SAS
    • A. 

      Statistical Analysis System

    • B. 

      Statistical Analytical System

    • C. 

      It is a company name

  • 6. 
    What following SAS products will be used for accessing external files? (select all correct answers)                          
    • A. 

      SAS Acess to Teradata

    • B. 

      SAS Access to Oracle

    • C. 

      SAS Access to PC Files

    • D. 

      SAS Enterprise Guide

    • E. 

      SAS Enterprise Miner

  • 7. 
    What following procedures can be used for importing raw data into SAS (select all correct answers)
    • A. 

      Data Step

    • B. 

      Proc Sql

    • C. 

      Proc Import

    • D. 

      Proc Univariate

  • 8. 
    In datastep both infile and input statements are necessary for data imports in all situations
    • A. 

      True

    • B. 

      False

  • 9. 
    Data class;    input name $ dept $ Service;    datalines; Robort Mrkt 10 Mary Financ 15 ; run; What is the outcome of the above code
    • A. 

      Error

    • B. 

      Sas dataset with two rows and three coloumns

    • C. 

      Sas dataset with two coloumns and three rows

  • 10. 
    Excel file can be imported into SAS if only SAS Base product is installed
    • A. 

      True

    • B. 

      False

  • 11. 
    Following operations can be performed with SAS Base Product (select all correct answers)
    • A. 

      Data Step

    • B. 

      Macros

    • C. 

      Proc SQL

    • D. 

      Proc t test

  • 12. 
    Data Warehouse is populated from operational systems using ETL Process
    • A. 

      True

    • B. 

      False

  • 13. 
    Which of the following terms are associated with Data Warehousing (select all correct answers)                          
    • A. 

      Staging Area

    • B. 

      Data Update

    • C. 

      Star Schema

    • D. 

      Top Down

  • 14. 
    Following is/are data sources for Data Mart (select all correct answers)                          
    • A. 

      Data Warehouse

    • B. 

      External Files

    • C. 

      Operational Data

  • 15. 
    Metadata is information on
  • 16. 
    Which of the following is a relational database (select all correct answers)
    • A. 

      Teradata

    • B. 

      Excel

    • C. 

      SAS

    • D. 

      MySql

    • E. 

      DB2

    • F. 

      SqlServer

  • 17. 
    Following terms are associated with  relational databases (select all correct answers)
    • A. 

      Primary Key

    • B. 

      Foreign Key

    • C. 

      Unique id

  • 18. 
    Expand DBA
Back to Top Back to top