Dt pH II Practice 1

95 Questions

Settings
Practice Test Quizzes & Trivia

.


Questions and Answers
  • 1. 
    Data when processed becomes Information
    • A. 

      True

    • B. 

      False

  • 2. 
    The best practice in data quality is 
    • A. 

      Fixing data quality issues in ETL

    • B. 

      Fixing data quality issues in ODS

    • C. 

      Fixing data quality issues in Source

    • D. 

      Fixing data quality issues in DW

  • 3. 
    Evaluate data quality before building a fully fledged data ware house
    • A. 

      True

    • B. 

      False

  • 4. 
    Data quality does not refer to
    • A. 

      Volume

    • B. 

      Accuracy

    • C. 

      Consistency

    • D. 

      Integrity

  • 5. 
    Which is not a data quality tool?
    • A. 

      Quality stage

    • B. 

      Trillium

    • C. 

      Data Stage

    • D. 

      All the options

  • 6. 
    Rule repository contains Databases or Flat Files
    • A. 

      True

    • B. 

      False

  • 7. 
    Which are the following is not an IBM product?
    • A. 

      Meta stage

    • B. 

      Quality Stage

    • C. 

      Profile Stage

    • D. 

      Analysis stage

  • 8. 
    Data quality audit provides traceability between original and corrected values.
    • A. 

      True

    • B. 

      False

  • 9. 
    Bad quality data affects concurrency and performance.
    • A. 

      True

    • B. 

      False

  • 10. 
    Tracing involves audit trails between deleted and surviving customers
    • A. 

      True

    • B. 

      False

  • 11. 
    Survivorship is a concept used in 
    • A. 

      Data de-duplication

    • B. 

      Cleansing

    • C. 

      Enrichment

    • D. 

      None

  • 12. 
    Data masking and mask pattern analysis are used in substituting string patterns
    • A. 

      True

    • B. 

      False

  • 13. 
    Customer merging is matching the best attribute into the surviving records from duplicate records
    • A. 

      True

    • B. 

      False

  • 14. 
    Customer matching is done with Fuzzy and intelligent logic.
    • A. 

      True

    • B. 

      False

  • 15. 
    Data quality (MDM) involves avoiding overheads while preparing the DW.
    • A. 

      True

    • B. 

      False

  • 16. 
    During which of the operations data is not modified
    • A. 

      Data profiling

    • B. 

      Data cleansing

    • C. 

      Data enrichment

    • D. 

      None

  • 17. 
    MDM is maintained at organizational level
    • A. 

      True

    • B. 

      False

  • 18. 
    During the de-duplication process
    • A. 

      Delete the original values since they consume space

    • B. 

      Keep the original values in trail tables

    • C. 

      Do not disturb the original values and place the new values in new tables

    • D. 

      None

  • 19. 
    Data cleansing and standardization will be taken care by
    • A. 

      Data Profiling Tools

    • B. 

      Data Quality Tools

    • C. 

      Metadata Tools

    • D. 

      ETL Tool

  • 20. 
    What is the language used in a data quality tool?
    • A. 

      C

    • B. 

      JAVA

    • C. 

      C#

    • D. 

      COBOL

  • 21. 
    Household matching is for 
    • A. 

      Business

    • B. 

      Product

    • C. 

      Customer

    • D. 

      None of the above.

  • 22. 
    Trillium server process requires 
    • A. 

      Input Structure(DLL file)

    • B. 

      Output structure (DLL file)

    • C. 

      Parameter file (PAR file)

  • 23. 
    The rules of cleansing are embedded in Trillium’s 
    • A. 

      Parameter file (PAR).

    • B. 

      Output structure (DLL file)

    • C. 

      Input structure (DLL file)

  • 24. 
    Trillium source 
    • A. 

      Flat files, fixed width

    • B. 

      Flat file ,comma separated

    • C. 

      ODBC connection

    • D. 

      All

  • 25. 
    Basic Functionalities of Trillium
    • A. 

      Data Profiling

    • B. 

      Data Quality

    • C. 

      Data Enrichment

    • D. 

      Data Volume

  • 26. 
    The frequency of data count is obtained in
    • A. 

      Data profiling

    • B. 

      Data cleansing

    • C. 

      Data management

  • 27. 
    Clean up will not effect on by which phase
    • A. 

      Acquisition

    • B. 

      Application

    • C. 

      Cleanup

    • D. 

      None

  • 28. 
    Reason for poor quality of data
    • A. 

      Careless / Inaccurate data entry

    • B. 

      No stringent rules or processes followed to validate the data entry

    • C. 

      Lack of Master Data Management strategy

  • 29. 
    Steps avoid poor quality data
    • A. 

      Set stringent rules in validation process; if not, then in ETL process

    • B. 

      De-duplication

    • C. 

      Provide feedback about quality of data to source and ask source to correct and resend them

  • 30. 
    Data cleansing and standardization will be taken care by
    • A. 

      Data Quality Tools

    • B. 

      Data Profiling Tools

    • C. 

      Metadata Tools

  • 31. 
    During which of the operations data is not modified
    • A. 

      Data profiling

    • B. 

      Data cleansing

    • C. 

      Data enrichment

  • 32. 
    Which tool extracts data from textual sources
    • A. 

      Conversion

    • B. 

      Mark-Up

    • C. 

      Extraction

  • 33. 
    Metadata can be classified based on 
    • A. 

      Content

    • B. 

      Mutability

    • C. 

      Logical function

    • D. 

      Transformation

    • E. 

      Partition mapping

  • 34. 
    What are the standards defined for metadata
    • A. 

      ANSI X3.528

    • B. 

      ISO/IEC 11179

    • C. 

      ISO/IEC 11197

    • D. 

      ANSI X3.825

    • E. 

      ANSI X3.285

  • 35. 
    Metadata storage formats
    • A. 

      Human readable format (XML)

    • B. 

      Non-human readable format (Binary)

    • C. 

      Pdf

    • D. 

      Text

  • 36. 
    Metadata should be maintained even when 
    • A. 

      Base resource changes

    • B. 

      If two sources merges together

    • C. 

      Base source is deleted

  • 37. 
    Types of DW Metadata
    • A. 

      Back Room

    • B. 

      Front Room

    • C. 

      Source System

    • D. 

      Data Staging

    • E. 

      RDBMS

  • 38. 
    Types of BI Metadata
    • A. 

      A. OLAP Metadata

    • B. 

      B. Reporting Metadata

    • C. 

      C. Data Mining Metadata

  • 39. 
    Metadata creation tools
    • A. 

      Templates

    • B. 

      Mark-Up tools

    • C. 

      Extraction tool

    • D. 

      Conversion tool

  • 40. 
    Crosswalk allows metadata created by one user to be used by another
    • A. 

      True

    • B. 

      False

  • 41. 
    DataStage is an ETL tool
    • A. 

      True

    • B. 

      False

  • 42. 
    Order of execution in Datastage is
    • A. 

      Stage variable then Constraints then Derivations

    • B. 

      Derivations then Stage variable then Constraints

    • C. 

      Constraints then Derivations then Stage variable

  • 43. 
    Which of the following database is used in DS repository?
    • A. 

      Universe

    • B. 

      Oracle

    • C. 

      Sybase

    • D. 

      MS-SQL Sever

  • 44. 
    Which client tool is used to schedule, run and validate the job?
    • A. 

      DataStage Director

    • B. 

      DataStage Manager

    • C. 

      DataStage Administrator

    • D. 

      DataStage Manager Roles

  • 45. 
    Which client tool is used to create or move the projects in Datastage?
    • A. 

      DataStage Designer

    • B. 

      DataStage Director

    • C. 

      DataStage Manager

    • D. 

      DataStage Administrator

  • 46. 
    Which client tool is used to import and export components? 
    • A. 

      DS Manager

    • B. 

      DataStage Director

    • C. 

      DataStage Designer

    • D. 

      DataStage Administrator

  • 47. 
    Cache size can be changed in DS Administrator
    • A. 

      True

    • B. 

      False

  • 48. 
    When we import a job, the job will be in which state?
    • A. 

      State while exported

    • B. 

      Aborted state

    • C. 

      Not compiled state

  • 49. 
    If a primary key uses multiple columns to identify a record then it is known as compound key
    • A. 

      True

    • B. 

      False

  • 50. 
    Which symbol is used in defining the parameter in DataStage? 
    • A. 

      $

    • B. 

      #

    • C. 

      @

    • D. 

      &&

  • 51. 
    In which of the following stages a job cannot be run?
    • A. 

      Abort

    • B. 

      Compiled

    • C. 

      Compiled

  • 52. 
    What is the default connection timed out time in DataStage?
    • A. 

      86400

    • B. 

      10000

    • C. 

      84600

    • D. 

      Never

  • 53. 
    Default administrator in UNIX is 
    • A. 

      Root

    • B. 

      Sysadm

    • C. 

      Dsadm

    • D. 

      Adm

  • 54. 
    Where can you see the CPU utilization in DataStage?
    • A. 

      DataStage Designer

    • B. 

      DataStage Director

    • C. 

      DataStage Administrator

    • D. 

      DataStage Manager

  • 55. 
    Grant permission can be given by
    • A. 

      DataStage Manager

    • B. 

      DataStage Administrator

    • C. 

      DataStage Director

    • D. 

      DataStage Designer

  • 56. 
    Can multiple selections possible in DataStage? 
    • A. 

      Not Possible

    • B. 

      Yes Possible

  • 57. 
    Fast export is used to export all the data 
    • A. 

      True

    • B. 

      False

  • 58. 
    Where do log file exists ?
    • A. 

      DataStage Director

    • B. 

      DataStage Manager

    • C. 

      DataStage Administrator

    • D. 

      DataStage Designer

  • 59. 
    MicroStrategy is a 
    • A. 

      ROLAP tool

    • B. 

      OLAP Tool

  • 60. 
    If a user would want to list the top 10 revenue values by region what type of filter is to be used?
    • A. 

      Attribute element list qualification

    • B. 

      Attribute form qualification

    • C. 

      Metric qualification

    • D. 

      Relationship filter qualification

  • 61. 
    A filter qualification can combine
    • A. 

      Attribute qualification and metric qualification only

    • B. 

      Attribute qualification and report as filter only

    • C. 

      Attribute qualification, report as filter and relationship filter only

    • D. 

      Attribute qualification, metric qualification and relationship filter only

    • E. 

      Attribute qualification, metric qualification, report as filter and relationship in any combination

  • 62. 
    Which option in the metric editor allows the user to calculate a metric 6 months prior to the supplied month value?
    • A. 

      Compound Metric

    • B. 

      Conditional Metric

    • C. 

      Transformation Metric

    • D. 

      Adaptive Metric

  • 63. 
    How to make a percentage calculation (a/b) metric automatically calculate average in place of sum for sub-totals when the sub-totals specified at the report level is sum.
    • A. 

      Smart Metrics

    • B. 

      Transformation Metrics

    • C. 

      Level Metric

    • D. 

      Compound Metric

  • 64. 
    Reports can run with only attributes on the template (and no metrics).
    • A. 

      True

    • B. 

      False

  • 65. 
    The transformation information is stored in a table as part of the warehouse in
    • A. 

      Expression based transformation

    • B. 

      Table based transformation

    • C. 

      Both the options

    • D. 

      None of the options

  • 66. 
    Update schema, updates the information stored in
    • A. 

      Metadata database

    • B. 

      Warehouse catalog

    • C. 

      Analytical Engine

    • D. 

      Data warehouse database

  • 67. 
    Updating schema is required, when we do changes in __________________
    • A. 

      Attributes

    • B. 

      Facts

    • C. 

      Hierarchies

    • D. 

      All the options

  • 68. 
    The default sort for an attribute can be set in the attribute definition itself.
    • A. 

      True

    • B. 

      False

  • 69. 
    When the attribute forms are included in the following category, the attribute elements corresponding to the selected form will be displayed in the data explorer or in the element list selection while creation of filters.
    • A. 

      Report Display Forms

    • B. 

      Browse Display Forms

    • C. 

      Filter Display Forms

    • D. 

      Both Report Display Forms and Browse Display Forms

    • E. 

      Both Report Display Forms and Filter Display Forms

  • 70. 
    We can  use fact directly into the report.
    • A. 

      True

    • B. 

      False

  • 71. 
    The maximum number of attributes that can be set as parent to another attribute is
    • A. 

      No Limit

    • B. 

      One

    • C. 

      Two

    • D. 

      Three

  • 72. 
    An expression combining two different fact columns in a table (ex – sales – discount) can be set as a fact expression  
    • A. 

      True

    • B. 

      False

  • 73. 
    A fact can have different expressions based on the table against which it is evaluated.  
    • A. 

      True

    • B. 

      False

  • 74. 
    In two tier architecture, how many ODBC connections are there? 
    • A. 

      2

    • B. 

      5

    • C. 

      1

    • D. 

      No such rules

  • 75. 
    In which type of filter the SQL is not changed?
    • A. 

      View filter

    • B. 

      Report filter

  • 76. 
    Schema objects are
    • A. 

      Facts

    • B. 

      Tables

    • C. 

      Transformations

    • D. 

      Partition mappings

    • E. 

      Attributes

    • F. 

      Hierarchies

    • G. 

      Function and operastors

  • 77. 
    Output of hash file  sorted
    • A. 

      True

    • B. 

      False

  • 78. 
    Report view mode in microstrategy
    • A. 

      Grid

    • B. 

      Graph

    • C. 

      SQL

    • D. 

      Grid graph mode

  • 79. 
    If the user wants particular attribute to be displayed in the report output, include the attribute in 
    • A. 

      Report display form

    • B. 

      Report layout form

    • C. 

      Browse form

    • D. 

      None

  • 80. 
    Formula automatically gets updated in fact column by which metrics
    • A. 

      A) Nested Metrics

    • B. 

      Compound Metrics

    • C. 

      Smart Metrics

    • D. 

      Derived Metrics

  • 81. 
    Types of actions in hierarchy display
    • A. 

      Locked

    • B. 

      Limited

    • C. 

      Entry point

    • D. 

      Filtered

    • E. 

      All the options

  • 82. 
    Default page size in DB2?
    • A. 

      4 KB

    • B. 

      2 KB

    • C. 

      8 KB

    • D. 

      16 KB

  • 83. 
    A container is not a
    • A. 

      File

    • B. 

      Directory

    • C. 

      Raw device

    • D. 

      Memory

  • 84. 
    The No. of CPUs used in DB2 Enterprise edition
    • A. 

      2 CPU

    • B. 

      4 CPU

    • C. 

      18 CPU

    • D. 

      No Limit

  • 85. 
    Tablespace span across containers and tables can span across tablespaces
    • A. 

      True

    • B. 

      False

  • 86. 
    Different tablespaces have different page sizes
    • A. 

      True

    • B. 

      False

  • 87. 
    Effects of locking 
    • A. 

      Improves concurrency

    • B. 

      Degrades performance

    • C. 

      Increase Performances

    • D. 

      Degrades concurrency

  • 88. 
    Not a DB2 license method
    • A. 

      User

    • B. 

      CPU

    • C. 

      Memory

  • 89. 
    Database partition is known as 
    • A. 

      Node

    • B. 

      Leaf

    • C. 

      Root

  • 90. 
    Block indexes for multiple columns produces
    • A. 

      Multidimensional Clusters

    • B. 

      Clusters

    • C. 

      Blocks

  • 91. 
    Block indexes are preferable for high cardinality columns.
    • A. 

      True

    • B. 

      False

  • 92. 
    Fetching data from hard disk to buffer pool is known as pre-fatching
    • A. 

      True

    • B. 

      False

  • 93. 
    Hierarchies in microstrategy are
    • A. 

      System Hierarchy

    • B. 

      User Hierarchy

    • C. 

      None