Dovetail Phase 2 (all Topics)

221 Questions

Settings
Please wait...
Computer Software Quizzes & Trivia

.


Questions and Answers
  • 1. 
    Block indexes for multiple columns produces
    • A. 

      Blocks

    • B. 

      Clusters

    • C. 

      Multidimensional Clusters

    • D. 

      None

  • 2. 
    Database partition is known as
    • A. 

      Leaf

    • B. 

      Node

    • C. 

      Root

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

      True

    • B. 

      False

  • 4. 
    What does page cleaner do?
    • A. 

      Data from the buffer pool is written to the disk

    • B. 

      No Buffer

    • C. 

      Data from the buffer pool is written to the page

  • 5. 
    What is meant by pre-fetching?           
    • A. 

      Fetching data from hard disk to buffer pool

    • B. 

      Fetching data from page to buffer pool

    • C. 

      None

  • 6. 
    Statistics update is done 
    • A. 

      Once a week

    • B. 

      Depending on frequency of table updates.

    • C. 

      Once a Month

  • 7. 
    A database partition is not given complete control of Hardware resource  
    • A. 

      In Logical Partition

    • B. 

      In Primary Partition

    • C. 

      In Secondary Partition

  • 8. 
    Which is true?
    • A. 

      Database partition consists its own data, index, config files and transaction logs

    • B. 

      Database partition consists its own data, index, config files except transaction logs

    • C. 

      Database partition consists its own data, index and transaction logs except config files

  • 9. 
    MPP –
    • A. 

      Massively Parallel Processing

    • B. 

      Maximum Parallel Processing

    • C. 

      Minimum Parallel Processing

    • D. 

      Marginal Parallel Processing

  • 10. 
    Large updates and transactions are not suitable for
    • A. 

      Block index

    • B. 

      B+ tree index

    • C. 

      Clustered index

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

      2

    • B. 

      4

    • C. 

      No restriction

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

      True

    • B. 

      False

  • 13. 
    Different table spaces have different page sizes
    • A. 

      True

    • B. 

      False

  • 14. 
    If Num_oicleaners is 0,then _____ are started
    • A. 

      No page cleaners

    • B. 

      Page Cleaners

    • C. 

      None

  • 15. 
    Effects of locking –    
    • A. 

      Improves concurrency

    • B. 

      Degrades performance

    • C. 

      Degrades concurrency

    • D. 

      Improves performance

  • 16. 
    What is ASLheapsz?
    • A. 

      It is the Communication buffer between the local application and its associated Agent.

    • B. 

      Error Agent

    • C. 

      Local Error Handler

  • 17. 
    True for Chngpgs_thresh:
    • A. 

      For heavy update transactions, decrease this value below default.

    • B. 

      Percentage of changed pages in Buffer pool at which the asynchronous page cleaners will be started, if they are not currently active.

    • C. 

      For heavy update transactions, increase this value below default.

  • 18. 
    Multi Dimensional Clusters are  Beneficial For
    • A. 

      OLAP

    • B. 

      MOLAP

    • C. 

      ROLAP

    • D. 

      None

  • 19. 
    SMS-
    • A. 

      Allocates space on demand

    • B. 

      The File Manager of operating system allocates and manages space

    • C. 

      System Managed Space

  • 20. 
    A container is not a
    • A. 

      Raw device

    • B. 

      Directory

    • C. 

      File

    • D. 

      Memory

  • 21. 
    • A. 

      Increase this value if there is a problem with lock escalation.

    • B. 

      Memory that holds information about locks held by all applications concurrently connected to the database

    • C. 

      Decrease this value if there is a problem with lock escalation.

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

      32 KB

    • B. 

      16 KB

    • C. 

      8 KB

    • D. 

      4 KB

  • 23. 
    Not a DB2 licence method
    • A. 

      CPU

    • B. 

      User

    • C. 

      Memory

  • 24. 
    If the user wants particular attribute to be displayed in the report o/p, include the attribute in
    • A. 

      None

    • B. 

      Browse form

    • C. 

      Report display form

    • D. 

      Report layout form

  • 25. 
    • A. 

      A hierarchy can be used as a drill path

    • B. 

      The destination is shown as part of the other.

    • C. 

      A hierarchy cannot be used as a drill path

    • D. 

      The Source is shown as part of the other.

  • 26. 
    Row level math calculation and virtual attributes is possible with 
    • A. 

      Consolidation

    • B. 

      Constraint

    • C. 

      None

  • 27. 
    If you want to filter on more than one attribute you will use
    • A. 

      Joint element list

    • B. 

      Element list

    • C. 

      Joint filter

  • 28. 
    Report view mode
    • A. 

      Grid

    • B. 

      Graph

    • C. 

      SQL

    • D. 

      Grid graph mode

  • 29. 
    Derives metrics can be used in other reports 
    • A. 

      True

    • B. 

      False

  • 30. 
    Level prompt –
    • A. 

      Dimensionality of a metrics

    • B. 

      dimensionality of a Columns

    • C. 

      None

  • 31. 
    More than one ID column 
    • A. 

      Compound attribute

    • B. 

      Multiple attribute

    • C. 

      Common Attribute

  • 32. 
    Default level of metrics –
    • A. 

      Report Level

    • B. 

      Visual Level

    • C. 

      Page Level

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

      Locked

    • B. 

      Limited

    • C. 

      Entry point

    • D. 

      Filtered

  • 34. 
    Schema updation can be done by
    • A. 

      Stop and start microstatergy intelligence server

    • B. 

      Disconnect and reconnect to the project source

    • C. 

      All

    • D. 

      Manually update the schema

  • 35. 
    Formula automatically got updated fact column by which metrics
    • A. 

      Nested

    • B. 

      Smart

    • C. 

      Derived

    • D. 

      Compound

  • 36. 
    Which of the following is responsible for MOLAP functionality of microstatergy – 
    • A. 

      Analytical engine

    • B. 

      DB Engine

    • C. 

      DataMart

  • 37. 
    Which mapping stores the project information – 
    • A. 

      Metadata mapping

    • B. 

      Data mapping

    • C. 

      Transaction Mapping

  • 38. 
    Metric level – group set to NONE is not applicable for 
    • A. 

      Transformation.

    • B. 

      Transaction

    • C. 

      Duplication

  • 39. 
    OLAP services
    • A. 

      Report objects

    • B. 

      Derived metrics

    • C. 

      View filters

    • D. 

      None

  • 40. 
    Default drill path –
    • A. 

      System Hierarchy

    • B. 

      Data Hierarchy

  • 41. 
    Grouping of attributes which can be displayed, ordered, unordered –
    • A. 

      Hierarchy

    • B. 

      Drillers

    • C. 

      Sequential

  • 42. 
    OLAP services
    • A. 

      Report objects

    • B. 

      View filters

    • C. 

      Derived metrics

    • D. 

      All

  • 43. 
    Types of prompts 
    • A. 

      Level prompt

    • B. 

      Object prompt

    • C. 

      Value prompt

    • D. 

      Filter definition prompt

  • 44. 
    Output of hash file - 
    • A. 

      Not sorted.

    • B. 

      Sorted

  • 45. 
    Implicit facts or attributes are 
    • A. 

      Virtual facts or attributes.

    • B. 

      Constant facts or attributes.

    • C. 

      None

  • 46. 
    Updating the schema is nessary when there is a change in 
    • A. 

      Fact

    • B. 

      Attributes

    • C. 

      Both the facts and attributes

    • D. 

      None

  • 47. 
    Schema objects are  
    • A. 

      Facts, Attributes

    • B. 

      Hierarchies

    • C. 

      Transformation

    • D. 

      Partition mapping

    • E. 

      All

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

      View filter

    • B. 

      True Filter

    • C. 

      All Types

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

      2

    • B. 

      4

    • C. 

      3

    • D. 

      1

  • 50. 
    Types of partition mapping?
    • A. 

      Server Level Partitioning

    • B. 

      Application Level Partitioning

    • C. 

      Both

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

      True

    • B. 

      False

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

      True

    • B. 

      False

  • 53. 
    In a hashed file, if you add a duplicate column to a key column. 
    • A. 

      Latest row is retained.

    • B. 

      First row is retained.

    • C. 

      No row is retained.

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

      2

    • B. 

      5

    • C. 

      7

    • D. 

      No Limit

  • 55. 
    Can we use fact directly in to the report?
    • A. 

      True

    • B. 

      False

  • 56. 
    What feature in MicroStrategy allows a user to have attributes and metrics as part of the report definition but not as part of the final report display?
    • A. 

      Report Object

    • B. 

      MS Object

    • C. 

      Metrices

  • 57. 
    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. 

      Filter Display Forms

    • B. 

      Browse Display Forms

    • C. 

      Report Display Forms

  • 58. 
    Avg(Sum(Fact1) {~+, month+}) {~+, quarter+} is an example of 
    • A. 

      Simple Metric

    • B. 

      Compound Metric

    • C. 

      Nested Metric

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

      Tranformation

    • B. 

      Accumulation

    • C. 

      Restoration

  • 60. 
     A filter qualification can combine
    • A. 

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

    • B. 

      Attribute qualification, metric qualification and relationship filter only

    • C. 

      Attribute qualification and report as filter only

    • D. 

      Attribute qualification and metric qualification only

  • 61. 
    Update schema, updates the information stored in _________
    • A. 

      Analytical Engine

    • B. 

      Data warehouse database

    • C. 

      Warehouse catalog

    • D. 

      Metadata database

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

      Table based transformation

    • B. 

      Expression based transformation

    • C. 

      Both

  • 63. 
    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. 

      Relationship filter qualification

    • C. 

      Metric qualification

    • D. 

      Attribute form qualification

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

      True

    • B. 

      False

  • 65. 
    The user has a report with “Year” and “Expenditure” displayed.  The user wants to see the monthly expenditure for each year and decides to drill from “Year” to “Month”.  But the user wants to see both “Year” and “Month” in the report after drilling.  What is the option to be used during drilling to achieve the desired behavior?
    • A. 

      Keep the parent while drilling

    • B. 

      Keep The child while Drilling

  • 66. 
    This type of filter gets applied to the report when the SQL is generated and executed against the warehouse
    • A. 

      View Filter

    • B. 

      Report Filter

    • C. 

      Visual Filter

  • 67. 
    Two types of hierarchies available in MicroStrategy are –  
    • A. 

      System hierarchy and User hierarchy

    • B. 

      System hierarchy and Project hierarchy

    • C. 

      Project hierarchy and User hierarchy

    • D. 

      System hierarchy and Project hierarchy

  • 68. 
    Microstrategy is a _______ tool
    • A. 

      ROLAP

    • B. 

      MOLAP

    • C. 

      OLAP

    • D. 

      None

  • 69. 
    What are the formatting properties applicable to fact objects in a report?
    • A. 

      Font/color of header/value formatting

    • B. 

      Border formatting

    • C. 

      Positional formatting

    • D. 

      None of the above

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

      Ds directory

    • B. 

      D:

    • C. 

      C:

    • D. 

      None

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

      True

    • B. 

      False

  • 72. 
    What is true about stage hash files?
    • A. 

      Data files will be scanned using hash algorithms, overflow files in sequential manner

    • B. 

      Data files sequentially and overflow files using hash algorithm

    • C. 

      Both sequentially

    • D. 

      Both using hash algorithm

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

      True

    • B. 

      False

  • 74. 
    Grant permission can be given by?
    • A. 

      Ds Manager

    • B. 

      Ds administrator

    • C. 

      User

    • D. 

      Developer

  • 75. 
    A project source can have how many projects?
    • A. 

      1

    • B. 

      5

    • C. 

      2

    • D. 

      Many

  • 76. 
    What is the default connection timed out in data stage?
    • A. 

      86400

    • B. 

      10000

    • C. 

      Never

    • D. 

      84600

  • 77. 
    Default administrator in UNIX is
    • A. 

      Adm

    • B. 

      Sysadm

    • C. 

      Root

    • D. 

      Dsadm

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

      Abort

    • B. 

      Compiled

    • C. 

      Reset

    • D. 

      None

  • 79. 
    Transformer can be created without an input link?
    • A. 

      True

    • B. 

      False

  • 80. 
    Number of input links for a transformer
    • A. 

      Streamed input link

    • B. 

      Input link

    • C. 

      Same as that of the output link

    • D. 

      None

  • 81. 
    DS server in UNIX can be started by
    • A. 

      DSSTART

    • B. 

      ../univ

    • C. 

      ./univ

    • D. 

      None

  • 82. 
     How will a default user be notified while login in ds administrator?
    • A. 

      Dsadmin

    • B. 

      Root

    • C. 

      Sysadmin

    • D. 

      None

  • 83. 
    From where to import DS jobs?
    • A. 

      Database, flatfiles (if it is type of inputs)

    • B. 

      Datastage designer(if it is interface)

    • C. 

      ERP applications,mainframe datasets (if it is type of inputs)

    • D. 

      None

  • 84. 
    Cmd to invoke administrator?
    • A. 

      Dsadmin

    • B. 

      ../admin

    • C. 

      ./dsadmin

    • D. 

      None

  • 85. 
    UNIX command to run a datastage job
    • A. 

      Ds job

    • B. 

      Ds/job

    • C. 

      None

  • 86. 
    • A. 

      User privileges

    • B. 

      Environmental variables can be set Size of cache can be changed

    • C. 

      Security level created at project The project components, along with the project can be exported.

    • D. 

      Viewing project list Adding and deleting projects

  • 87. 
    Role of DS Manager
    • A. 

      Creating and moving projects

    • B. 

      Creating a new object

    • C. 

      Exporting or importing the repository components

    • D. 

      Usage analysis

  • 88. 
    Role of DS Director
    • A. 

      Validate, schedule, run, and monitor datastage server jobs and parallel jobs.

    • B. 

      Logs can be viewed Logs can be printed

    • C. 

      Time elapsed can be seen

    • D. 

      Jobs can be reset

  • 89. 
    % tracing of ETL and the Ideal percentage of rejected rows in ETL shoul be
    • A. 

      0.02

    • B. 

      0

    • C. 

      None

    • D. 

      0.04

  • 90. 
    Which symbol is used in defining the parameter in datastage?
    • A. 

      #

    • B. 

      $

    • C. 

      @

    • D. 

      &

  • 91. 
    Change logs or histories are needed for
    • A. 

      Access restriction

    • B. 

      When base source is deleted

    • C. 

      Both

    • D. 

      None

  • 92. 
    Data stage job consists of
    • A. 

      Links

    • B. 

      Stages

    • C. 

      Both

    • D. 

      None

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

      Compound key

    • B. 

      Composite key

    • C. 

      Dual key

    • D. 

      Multiple key

  • 94. 
    • A. 

      The iconv program converts text from one encoding to another encoding.

    • B. 

      Iconv −f ISO−8859−1 −t UTF−8

    • C. 

      Converts the user input into the data stage internal format.

    • D. 

      None

  • 95. 
    OCI =>
    • A. 

      Oracle Call Interface

    • B. 

      Oracle Client Interface.

    • C. 

      Both

    • D. 

      None

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

      Not compiled state

    • B. 

      Aborted state

    • C. 

      State while exported

    • D. 

      None

  • 97. 
    Export file format in DS is 
    • A. 

      DSX

    • B. 

      XML

    • C. 

      Both

    • D. 

      None

  • 98. 
    True about active and passive stage?
    • A. 

      Aggregator and Transformer are active stage.

    • B. 

      ODBC, Universe, ORACLE, Hashed file and Sequential file, Inter-Process are Passive stage

    • C. 

      Both

    • D. 

      None

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

      Universe

    • B. 

      Oracle

    • C. 

      Sysbase

    • D. 

      Mssql Sever

  • 100. 
    Order of executionin ds
    • A. 

      Stage variable-> Constraints-> Derivations

    • B. 

      Stage variable->Derivations-> Constraints

    • C. 

      Derivations-> Constraints->Stage variable

    • D. 

      None

  • 101. 
    DataStage is a
    • A. 

      Reporting Tool

    • B. 

      ETL tool

    • C. 

      Analysis Tool

    • D. 

      MetadataTool

  • 102. 
    • A. 

      Are important for virtual collections

    • B. 

      Allows metadata created by one user to be used by another.

    • C. 

      Mapping of elements from one schema to another

    • D. 

      Less granularity to more granularity mapping is very complex

    • E. 

      Are expected to act as a whole entity like a single search engine

    • F. 

      Are labors intensive to develop and maintain

  • 103. 
    Metadata creation tools
    • A. 

      Templates

    • B. 

      Conversion Tools

    • C. 

      Extraction Tools

    • D. 

      Mark-up Tools

  • 104. 
    Concerns about Metadata
    • A. 

      It is too expensive and time consuming

    • B. 

      It is too complicated

    • C. 

      It is subjective and depends on content

    • D. 

      There is no end to metadata

  • 105. 
    Metadata uses and needs
    • A. 

      Is the key to ensuring that resources will survive and continue to be accessible into the future

    • B. 

      Share resources across users and various tools and Helps to bridge semantic gaps

    • C. 

      Speeds up and enriches searching of resources and Provides additional information to users of the data it describes

    • D. 

      All of these

  • 106. 
    Types of BI Metada
    • A. 

      OLAP Metadata

    • B. 

      Reporting Metadata

    • C. 

      Data Mining Metadata

    • D. 

      DW Metadata

  • 107. 
    Types of DW Metadata
    • A. 

      Back Room

    • B. 

      Front Room

    • C. 

      Source System

    • D. 

      Data Staging

    • E. 

      RDBMS

  • 108. 
    What should happen if two sources merge together?
    • A. 

      Metadata must merge together

    • B. 

      Metadata must not merge together

    • C. 

      Duplication

    • D. 

      None

  • 109. 
    • A. 

      It is a database or flat file.

    • B. 

      Modify rules with change in source data patterns

    • C. 

      Add new but similar rules without changing code

    • D. 

      Reuse and standardize rules with multiple processes handling similar data

  • 110. 
    Metadata storage formats
    • A. 

      Human readable format (XML)

    • B. 

      Non-human readable format (Binary)

    • C. 

      Both

    • D. 

      None

  • 111. 
    Internal storage causes high redundancy 
    • A. 

      True

    • B. 

      False

  • 112. 
    Optimized storage or space utilization can be achieved in 
    • A. 

      Non-human readable format.

    • B. 

      Human Readable format

    • C. 

      Both

    • D. 

      None

  • 113. 
    What are the standards defined for metadata(Choose 2)
    • A. 

      ANSI X3.528

    • B. 

      ISO/IEC 11179

    • C. 

      ANSI X3.825

    • D. 

      ANSI X3.285

    • E. 

      ISO/IEC 11197

  • 114. 
    Is training required for creating a metadata?  
    • A. 

      Yes

    • B. 

      No

  • 115. 
    Which tool extracts data from textual source​?
    • A. 

      Conversion

    • B. 

      Mark-Up

    • C. 

      Extraction

    • D. 

      None

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

      Content

    • B. 

      Mutability

    • C. 

      Logical function

    • D. 

      Transformation

    • E. 

      Partition mapping

  • 117. 
    Front room metadata
    • A. 

      Queries for the report

    • B. 

      Report definition

    • C. 

      Both

    • D. 

      None

  • 118. 
    A good metadata must
    • A. 

      Use standard terminologies

    • B. 

      Mandatory elements must not be missed

    • C. 

      Support archiving

    • D. 

      All

  • 119. 
    Metadata is
    • A. 

      Ontology when hierarchically arranged.

    • B. 

      data about data.

    • C. 

      Both

    • D. 

      None

  • 120. 
    When creating database or users, specifying its parent is necessary
    • A. 

      True

    • B. 

      False

  • 121. 
    ODS  is fora) Tactical decisionsb) Strategically decisionc) Takes less time than DWd) Subset of DW
    • A. 

      A is correct

    • B. 

      B is correct

    • C. 

      A ,c are correct

    • D. 

      A, c, d are correct

  • 122. 
    Is market basket analysis is a BI & DW solution? 
    • A. 

      True

    • B. 

      False

  • 123. 
    A fact table in the centre surrounded by dimension tables which are again split up into further dimension tables is called as
    • A. 

      Star schema

    • B. 

      Snowflake schema

    • C. 

      None

    • D. 

      Both

  • 124. 
    The frequency of data count is obtained is
    • A. 

      Data profiling

    • B. 

      Data cleansing

    • C. 

      Data management

    • D. 

      Data parsing

  • 125. 
     Data cleansing rules
    • A. 

      Audit Data

    • B. 

      Filter Data

    • C. 

      Correct Data

    • D. 

      All

  • 126. 
    Converting non standard data into standardized format is taken care by which module – 
    • A. 

      Converter

    • B. 

      Replicator

    • C. 

      Transformer

    • D. 

      None

  • 127. 
    Which module is used for parsing name and address fields –
    • A. 

      Customer Data Parser.

    • B. 

      Client Data Parser.

    • C. 

      Both

    • D. 

      None

  • 128. 
    How is trillium invoked in datastage?
    • A. 

      Advanced external procedure.

    • B. 

      Advance Internal Procedure

    • C. 

      Both

    • D. 

      None

  • 129. 
    • A. 

      Data Profiling > Data Discovery Data Monitoring Data Governance

    • B. 

      Data Quality > Data Cleansing and Standardization De-duplication and Identifying Relationship Address Verification

    • C. 

      Data Enrichment > Postal Certifications Latitude or longitude for precise location Append information from outside source

    • D. 

      All

  • 130. 
    Trillium source
    • A. 

      Flat files, fixd width

    • B. 

      Flat file ,comma separated

    • C. 

      Odbc conn

    • D. 

      All

  • 131. 
    Trillium server process requires –
    • A. 

      Input Structure(DLL file)

    • B. 

      Output structure (DLL file)

    • C. 

      Parameter file (PAR file)

    • D. 

      All

  • 132. 
    The rules of cleansing are embedded in
    • A. 

      Trillium’s parameter file (PAR).

    • B. 

      Trillium’s Input Str file (DLL).

    • C. 

      Trillium’s Output Str file (DLL).

    • D. 

      All

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

      C

    • B. 

      Perl

    • C. 

      UNIX Shell Scripting

    • D. 

      Java

  • 134. 
    Household matching is for
    • A. 

      Business

    • B. 

      Product

    • C. 

      Customer

    • D. 

      None of the above

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

      Data Profiling Tools

    • B. 

      Data Quality Tools

    • C. 

      Metadata Tools

    • D. 

      All

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

      Delete the original values since they consume space

    • B. 

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

    • C. 

      Keep the original values in trail tables

    • D. 

      All

  • 137. 
    • A. 

      Trillium from Harte-Hanks

    • B. 

      FirstLogic from BusinessObjects

    • C. 

      Quality Stage from IBM

    • D. 

      Informatica Data Quality from Informatica

    • E. 

      DfPower from data flux

    • F. 

      Cleanse Data from Data Binders

    • G. 

      All

  • 138. 
    Which is incorrect?
    • A. 

      ESB - Enterprise Service Bus

    • B. 

      SOA - Service oriented Architecture

    • C. 

      NCOA - National Change of Address (update the change of address)

    • D. 

      DSA- Data Source Architecture

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

      Data profiling

    • B. 

      Data cleansing

    • C. 

      Data enrichment

    • D. 

      All

  • 140. 
    Data identification and de-duplication processes are in-built in the 
    • A. 

      Data entry or middleware applications

    • B. 

      Front room applications

    • C. 

      Both

    • D. 

      None

  • 141. 
    Master data store -
    • A. 

      Unique entries for all application

    • B. 

      Unique entries for organization

    • C. 

      DS activities

    • D. 

      Compile jobs or validate and then run jobs

  • 142. 
    Master data store forms the source of 
    • A. 

      Dimensional data for the data warehouse.

    • B. 

      Relational data for the data warehouse.

    • C. 

      Organizational data for the data warehouse.

    • D. 

      All

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

      Data – deduplication

    • B. 

      Cleansing

    • C. 

      Enrichment

    • D. 

      None

  • 144. 
    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

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

      Accuracy

    • B. 

      Consistency

    • C. 

      Integrity

    • D. 

      Volume

  • 146. 
    • A. 

      Will affect the performance of the ETL

    • B. 

      Will affect the performance of the Reporting.

    • C. 

      Will make ETL process to takes a longer time

    • D. 

      Affects concurrency and performance.

  • 147. 
    Which of the following is correct?
    • A. 

      Only US has a detailed address level

    • B. 

      No countries have detailed address level

    • C. 

      All countries have detailed address level

    • D. 

      Some countries have detailed address level

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

      Meta stage

    • B. 

      Quality Stage

    • C. 

      Profile Stage

    • D. 

      Analysis stage

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

      First Logic

    • B. 

      Trillium

    • C. 

      Data Stage

    • D. 

      DfPower

  • 150. 
    MDM is build 
    • A. 

      before ETL process and before building the data warehouse.

    • B. 

      After ETL process and before building the data warehouse.

    • C. 

      Before building the data warehouse.

    • D. 

      After ETL process

  • 151. 
    The MDM services helps in 
    • A. 

      Creation

    • B. 

      Validatio

    • C. 

      Updation

    • D. 

      Deletion

    • E. 

      All

  • 152. 
    Which one is false?
    • A. 

      Data masking and mask pattern analysis are used in string substitution.

    • B. 

      Postal department contains Residential address.

    • C. 

      Global data router is used to scan specific address.

    • D. 

      Router is to determine the country to which the addresses belong.

    • E. 

      Only USA has detailed address level

    • F. 

      Evaluate data quality before building a fully fledged data ware house.

  • 153. 
    Select the true statements.
    • A. 

      Customer matching is done with Fuzzy and intelligent logic.

    • B. 

      Data quality involves avoid overheads in preparing the DW.

    • C. 

      Tracing involves audit trails between deleted and surviving customers.

    • D. 

      Data quality audit provides traceability between original and corrected values.

    • E. 

      Valid Mobile Number: 99ABC45821

    • F. 

      Valid Email Id: abc&xyz:com

  • 154. 
    Select the false statement?
    • A. 

      Customer merging is matching the best attribute into the surviving records.

    • B. 

      Merging the basic attributes from duplicate records.

    • C. 

      MDM is maintained at organizational level.

    • D. 

      None

  • 155. 
    Which is false?
    • A. 

      Small pagesize suits OLTP environment

    • B. 

      Large pagesize suits DW environment

    • C. 

      Pagesize does not impact performance

    • D. 

      Pagesize is variable between tablespaces

  • 156. 
    Which of the following does not require a statistics update after the operation?
    • A. 

      New table loaded with large amount of data

    • B. 

      New index created on an existing table

    • C. 

      Table backup

    • D. 

      Reorganization

  • 157. 
    Which feature of LOAD makes it faster than IMPORT or SQL INSERT?
    • A. 

      Writing formatted data pages directly to hard disk

    • B. 

      LOAD is not faster than IMPORT

    • C. 

      Reading from flat file

    • D. 

      Loading without intermediate commit

  • 158. 
    Client requests are serviced by
    • A. 

      Coordinator threads

    • B. 

      Coordinator agents

    • C. 

      Client agents

    • D. 

      Client threads

  • 159. 
    Cluster of SMP is
    • A. 

      SMPP

    • B. 

      SSMP

    • C. 

      MPP

    • D. 

      SMPP

  • 160. 
    • A. 

      Adhoc activity

    • B. 

      Regularly scheduled activity

    • C. 

      None of listed options

    • D. 

      Monitored activity

  • 161. 
    OR clauses and OUTER joins
    • A. 

      Have no impact on performance

    • B. 

      Increase performance

    • C. 

      Decrease performance

    • D. 

      Are not valid functionalities in DB2

  • 162. 
    Customer Data Management (CDM) applies the principles of
    • A. 

      None of the listed options

    • B. 

      CRM

    • C. 

      MDM

    • D. 

      Datawarehousing

  • 163. 
    The number of rows to be transferred in one call between Datastage and Oracle before they are written is called
    • A. 

      Transaction size

    • B. 

      Array size

    • C. 

      Session isolation

    • D. 

      Session size

  • 164. 
    Which of the following logging strategies allow roll-forward recovery?
    • A. 

      None of the listed options

    • B. 

      Log Retention logging

    • C. 

      Both circular and log retention logging

    • D. 

      Circular logging

  • 165. 
    A datastage project can be created in
    • A. 

      Workflow manager

    • B. 

      Datastage designer

    • C. 

      Datastage director

    • D. 

      Datastage administrator

  • 166. 
    Which of the following options use database statistics?
    • A. 

      Database partitions

    • B. 

      Query builder

    • C. 

      Query compiler

    • D. 

      Query client

  • 167. 
    DBAs can control the physical location of the table on the disks in
    • A. 

      DMS

    • B. 

      None of the listed options

    • C. 

      SMS

    • D. 

      Both SMS and DMS

  • 168. 
    There is an option “Generate report” in DataStage Designer.
    • A. 

      True

    • B. 

      False

  • 169. 
    Master Data Repository is an ideal source for
    • A. 

      Dimension elements

    • B. 

      Transaction elements

    • C. 

      None of the listed options

    • D. 

      All OLTP data

  • 170. 
    An MDM solution is successful:
    1. If all master data element touch points are integrated to master data store
    2. If master data store is integrated to DW
    3. If MDM solution is implemented with a package solution
    4. None of the listed options
     
    • A. 

      3

    • B. 

      4

    • C. 

      1

    • D. 

      2

  • 171. 
    Command to stop Datastage server on UNIX is
    • A. 

      Ds –stop dssvr

    • B. 

      Ds –admin stop

    • C. 

      /uv –admin –stop

    • D. 

      Uv –stop

  • 172. 
    Thresholds can be applied to
    • A. 

      Filter

    • B. 

      Metric

    • C. 

      Consolidation

    • D. 

      Attribute

    • E. 

      Report

  • 173. 
    Not a valid type of locking
    • A. 

      Block level

    • B. 

      Table level

    • C. 

      Extent level

    • D. 

      Row level

  • 174. 
    “Statistics can be collected anytime”What is true about this statement? 
    • A. 

      No, since it can be done only when database is created

    • B. 

      Yes, because it helps performance

    • C. 

      None of the listed options

    • D. 

      No, since it impacts performance

  • 175. 
    To change license details, the user must have which of the following roles?
    • A. 

      Production manager

    • B. 

      Developer

    • C. 

      All of listed options

    • D. 

      Operator

  • 176. 
    Most important component of reject data capture
    • A. 

      Notifying source system automatically about the rejected data

    • B. 

      Capturing reject data in original format

    • C. 

      Capturing reason for rejection

    • D. 

      All of the listed options

  • 177. 
    Terminology used to describe augmenting of entities with data from third party sources
    • A. 

      Third Party Enrichment

    • B. 

      Matching

    • C. 

      Enrichment

    • D. 

      Cleansing

  • 178. 
    Different types of drilling
    • A. 

      Drill down the hierarchy

    • B. 

      Drill up the hierarchy (up, down, across, template)

    • C. 

      Both

    • D. 

      None

  • 179. 
    Viewing desktop report is possible in which of the following office tools?
    • A. 

      MS Word

    • B. 

      MS Excel

    • C. 

      MS PowerPoint

    • D. 

      All of the listed options

  • 180. 
    Difference between the job status ‘Finished’ and ‘Finished(see log)’?
    • A. 

      In the latter case, the job ends with warnings

    • B. 

      In the latter case, the job finished with warnings and in the former case there are rejected rows

    • C. 

      In the latter case there are rejected rows

    • D. 

      None of the listed options

  • 181. 
    Which of the following statements is true?
    • A. 

      More than one unique index can be created for a table

    • B. 

      More than one column can be included in a unique index

    • C. 

      It is not mandatory to define primary key constraint for a unique index

    • D. 

      All of the listed options

  • 182. 
    What is meant by Rebalancing of extents?
    • A. 

      None of the listed options

    • B. 

      Moving extents between container

    • C. 

      Resizing containers

    • D. 

      Resizing extents

  • 183. 
    • A. 

      You have to create location specific metadata systems and will have another metadata system that is centrally located

    • B. 

      You have to create metadata at each location and merge them periodically

    • C. 

      None of the listed options

    • D. 

      You have to create a central registry and maintain it

  • 184. 
    Maximum number of tables that can be loaded in single fastload job is
    • A. 

      1

    • B. 

      3

    • C. 

      5

    • D. 

      2

  • 185. 
    Metric formula can be reused by saving them as
    • A. 

      Nested formula

    • B. 

      Row Formula

    • C. 

      Column Formula

    • D. 

      Base formula

  • 186. 
    What is GIGO? 
    • A. 

      Garbage In Garbage Out

    • B. 

      Goal In Goal Out

    • C. 

      Gated In Gated Out

    • D. 

      Gigabytes I/p Gigabytes o/p

  • 187. 
    Duplicate data matching is a function of
    • A. 

      Data Quality

    • B. 

      Data Profiling

    • C. 

      ETL tool

    • D. 

      Database tool

  • 188. 
    Metadata stored internally allows efficient searching
    • A. 

      True

    • B. 

      False

  • 189. 
    Which of the following is true?
    • A. 

      Tables can span across tablespace and tablespaces cannot have more than one table

    • B. 

      Tables can span across tablespaces

    • C. 

      Tablespaces cannot have more than one table

    • D. 

      None of the above listed options

  • 190. 
    In DataStage, system variables are prefixed with
    • A. 

      @

    • B. 

      $

    • C. 

      %

    • D. 

      &

  • 191. 
    Which of the following tables provides data of an attribute ID and description columns?
    • A. 

      Partition mapping table

    • B. 

      Aggregate table

    • C. 

      Lookup table

    • D. 

      Fact table

  • 192. 
    • A. 

      When base resource is deleted

    • B. 

      When access restrictions are enabled

    • C. 

      When base resource changes

    • D. 

      When resources are merged

  • 193. 
    Which of the following types of mapping allows the engine to perform joins on dissimilar column names?
    • A. 

      Implicit expression

    • B. 

      Derived expression

    • C. 

      Simple expression

    • D. 

      Heterogeneous mapping

  • 194. 
    A table in a RDBMS must have which of the following options?
    • A. 

      Atleast 1 Row

    • B. 

      Atleast 1 Column

    • C. 

      Atleast 1 Row and 1 Column

    • D. 

      A table in a RDBMS cannot be empty

  • 195. 
    A Data warehouse:
    • A. 

      Is used to take strategic decisions

    • B. 

      Is used to take tactical decisions

    • C. 

      Is used for making day-to-day decisions

    • D. 

      Does not deal with historical data

  • 196. 
    What is the technology used to match entities like “Bill” as short for “William” and “CNN” as an abbreviation for “Cable News Network”?
    • A. 

      Name Match

    • B. 

      Fuzzy Match

    • C. 

      Spelling Match

    • D. 

      Like Match

  • 197. 
    • A. 

      They should use different methods of collecting metadata based on their needs and then use crosswalks

    • B. 

      They should make sure that they use one central Metadata System and work on it

    • C. 

      They should use compatible methods of collecting metadata

    • D. 

      They should follow a common standard

  • 198. 
    Which among the following is not a public object?
    • A. 

      Transformation

    • B. 

      Metric

    • C. 

      Consolidation

    • D. 

      Filter

  • 199. 
    Default file format for datastage components to be exported is
    • A. 

      .xml

    • B. 

      .dsx

    • C. 

      .xls

    • D. 

      .txt

  • 200. 
    Various components of a transformation are
    • A. 

      Member Attributes

    • B. 

      Member Tables

    • C. 

      Member Expressions

    • D. 

      Mapping Type

  • 201. 
    Data Masking and Mask Pattern analysis are employed in
    • A. 

      Substituting String Pattern

    • B. 

      Frequency pattern

    • C. 

      Field Comparioson

    • D. 

      String Search

  • 202. 
    A single object prompt can store both Matrix and Attribute?
    • A. 

      True

    • B. 

      False

  • 203. 
    Which of the following allows data stored in DW at on level to reported at an unrelated level.
    • A. 

      Fact level Extension

    • B. 

      Heterogeneous Mapping

    • C. 

      Derived Fact

    • D. 

      Simple fact

  • 204. 
    With respect to datamart, Source Descriptive Information are
    • A. 

      Data Dictionary

    • B. 

      Update Frequency

    • C. 

      Access Method

    • D. 

      PDM

  • 205. 
    Parameter for individual database are stored in which  config file
    • A. 

      SQLDBCONF

    • B. 

      DBINSTPROF

    • C. 

      Db2systm

    • D. 

      Sqldb

  • 206. 
    During job run in the designer, the green link indicates
    • A. 

      Success

    • B. 

      Failure

    • C. 

      Error

    • D. 

      None

  • 207. 
    Query against xml data is called
    • A. 

      XML-Query

    • B. 

      XQuery

    • C. 

      XSQL

    • D. 

      XML

  • 208. 
    Page cleaner process is 
    • A. 

      Asynchronous

    • B. 

      Synchronous

    • C. 

      Optional

    • D. 

      Non-configurable

  • 209. 
    Which table used to resolve many to many relationship between attributes
    • A. 

      Aggregate Tables

    • B. 

      LookUp Table

    • C. 

      Fact table

    • D. 

      Relate Table

  • 210. 
    If lookup store details of one attribute then it is called as
    • A. 

      Normalized

    • B. 

      Denormalized

    • C. 

      None of the above

    • D. 

      Report

  • 211. 
    • A. 

      To provide exact date and time when the cleansing operation has happened

    • B. 

      To allow reporting on data quality

    • C. 

      To provide traceability on the cleansed value to the original value sent by the source

    • D. 

      None of the above listed options

  • 212. 
    “You can have multiple jobs with the same name”. Which of the following options is true about the above statement?
    • A. 

      Yes, it is possible in case of PX jobs

    • B. 

      It is not possible in case of server jobs

    • C. 

      Not possible

    • D. 

      Yes, if they exist in different category

  • 213. 
    Which among the following is not a part of Geocoding?
    • A. 

      Adding 5+4 Zip code format

    • B. 

      Adding Latitude / Longitude information

    • C. 

      Providing a code value for referencing the geographical location with respect to North Pole

    • D. 

      Adding Census information

  • 214. 
    The number of rows that are written to the database before they are committed is called
    • A. 

      Transaction size

    • B. 

      Array Size

    • C. 

      Session Isolation

    • D. 

      None

  • 215. 
    True about consolidation
    • A. 

      Elements of the same attribute

    • B. 

      Attribute elements from different levels

    • C. 

      Existing consolidation elements

    • D. 

      Elements from any other consolidation in the project

    • E. 

      Elements from unrelated attributes

  • 216. 
    Which is not possible in Load Operation?
    • A. 

      Specifying the commit interval

    • B. 

      Accepts formatted data

    • C. 

      Writes directly to harddisk

    • D. 

      None

  • 217. 
    Details of locks held by transactions that are recorded in buffer pool area is called 
    • A. 

      Detaillocks

    • B. 

      Locklist

    • C. 

      Listlocks

    • D. 

      Lockdetails

  • 218. 
    Which index is Physically ordered
    • A. 

      Block Index

    • B. 

      Cluster Index

    • C. 

      Tree Index

    • D. 

      All

  • 219. 
    Non-aggregatable metrics are created using  
    • A. 

      Beginning fact option

    • B. 

      Beginning lookup option

    • C. 

      Ending fact option

    • D. 

      Ending lookup option

  • 220. 
    DSN for ODBC Stage in DataStage​
    • A. 

      Should be created in client

    • B. 

      Should be created in both client and server

    • C. 

      Should be created in server

    • D. 

      Not required