1.
Block indexes for multiple columns produces
Correct Answer
C. Multidimensional Clusters
Explanation
Block indexes for multiple columns produce Multidimensional Clusters. Multidimensional Clusters are used to optimize queries that involve multiple columns by organizing the data in a way that allows for efficient retrieval based on different combinations of column values. This type of index is particularly useful for queries that involve range queries or queries that have multiple filter conditions. By using multidimensional clustering, the database can quickly locate and retrieve the required data, improving query performance.
2.
Database partition is known as
Correct Answer
B. Node
Explanation
In a database, partitioning refers to the process of dividing a large database into smaller, more manageable parts called partitions. Each partition is then stored on a separate storage device or server. In this context, a "node" refers to a unit or component in a distributed database system that stores and manages a partition of the database. Therefore, the correct answer is "Node" because it represents a partition in a database.
3.
Block indexes are preferable for high cardinality columns.
Correct Answer
B. False
Explanation
Block indexes are not preferable for high cardinality columns. Block indexes are most effective for low cardinality columns, where there are a limited number of distinct values. High cardinality columns, on the other hand, have a large number of distinct values, making block indexes less efficient. In such cases, other types of indexes, such as B-tree indexes, are more suitable for optimizing query performance.
4.
What does page cleaner do?
Correct Answer
A. Data from the buffer pool is written to the disk
Explanation
The page cleaner is responsible for writing data from the buffer pool to the disk. The buffer pool is a cache that holds frequently accessed data, and the page cleaner ensures that any changes made to this data are persisted to the disk. This process helps to prevent data loss in the event of a system failure or shutdown. By regularly writing the buffered data to the disk, the page cleaner helps to maintain data integrity and ensure that the most up-to-date information is stored persistently.
5.
What is meant by pre-fetching?
Correct Answer
A. Fetching data from hard disk to buffer pool
Explanation
Pre-fetching refers to the process of retrieving data from the hard disk and storing it in the buffer pool before it is actually needed. This is done in order to improve performance by reducing the time it takes to access the data when it is required. By pre-fetching data from the hard disk to the buffer pool, the system can anticipate future data needs and have it readily available, minimizing the delay in retrieving it from the slower hard disk.
6.
Statistics update is done
Correct Answer(s)
A. Once a week
B. Depending on frequency of table updates.
Explanation
The statistics update is done once a week, but the frequency may vary depending on how often the table is updated. This means that if the table is updated more frequently, the statistics will also be updated more often to ensure accurate and up-to-date information.
7.
A database partition is not given complete control of Hardware resource
Correct Answer
A. In Logical Partition
Explanation
A database partition is not given complete control of hardware resources in a logical partition. In a logical partition, the hardware resources are shared among multiple partitions, including the database partition. This means that the database partition does not have exclusive control over the hardware resources and may have to compete with other partitions for their usage. This can impact the performance and efficiency of the database partition as it may not be able to utilize the hardware resources to their full potential.
8.
Which is true?
Correct Answer
A. Database partition consists its own data, index, config files and transaction logs
Explanation
A database partition is a division of a database into separate parts for the purpose of improving performance, scalability, and availability. Each partition contains its own data, index, config files, and transaction logs. This allows for better organization and management of the database, as well as faster access to the data.
9.
MPP –
Correct Answer
A. Massively Parallel Processing
Explanation
Massively Parallel Processing (MPP) refers to a computing architecture that uses multiple processors to perform tasks simultaneously. It allows for the efficient processing of large amounts of data by dividing the workload into smaller tasks that can be executed in parallel. This approach significantly speeds up data processing and analysis, making it suitable for applications that require high-performance computing and handling big data. Therefore, the given answer, Massively Parallel Processing, accurately describes the concept and its significance in computing.
10.
Large updates and transactions are not suitable for
Correct Answer(s)
A. Block index
C. Clustered index
Explanation
Large updates and transactions are not suitable for block index and clustered index.
Block index is a data structure used in databases to organize and efficiently access blocks of data. It is not ideal for large updates and transactions because it requires a lot of disk I/O operations to update the index, which can be time-consuming and inefficient.
Clustered index is a type of index that determines the physical order of data in a table. It is not suitable for large updates and transactions because it requires rearranging the data on disk to maintain the physical order, which can be costly in terms of time and resources.
Therefore, both block index and clustered index are not recommended for handling large updates and transactions.
11.
The No. of CPUs used in DB2 Enterprise edition
Correct Answer
C. No restriction
Explanation
The DB2 Enterprise edition does not have any restriction on the number of CPUs that can be used. This means that there is no limit or maximum number of CPUs specified for this edition. Users can utilize as many CPUs as they require for their specific needs and workload without any limitations.
12.
Tablespace span across containers and tables can span across tablespaces
Correct Answer
A. True
Explanation
This statement is true because tablespaces in a database can span across multiple containers, which are physical storage units. This allows for better organization and allocation of storage space. Additionally, tables within a database can also span across multiple tablespaces, providing flexibility in managing and distributing data within the database.
13.
Different table spaces have different page sizes
Correct Answer
A. True
Explanation
In a database, a tablespace is a logical storage unit that contains tables, indexes, and other database objects. Each tablespace can have its own page size, which determines the size of the data blocks used to store data within the tablespace. This allows for flexibility in managing different types of data and optimizing storage efficiency. Therefore, it is true that different table spaces can have different page sizes.
14.
If Num_oicleaners is 0,then _____ are started
Correct Answer
A. No page cleaners
Explanation
If the variable Num_oicleaners is equal to 0, it means that there are no page cleaners available. Therefore, no page cleaners will be started.
15.
Effects of locking –
Correct Answer(s)
A. Improves concurrency
B. Degrades performance
Explanation
Locking is a mechanism used to control access to shared resources in a concurrent environment. When multiple threads or processes try to access the same resource simultaneously, locking ensures that only one thread or process can access it at a time, preventing data corruption or inconsistency. This improves concurrency by allowing multiple threads to execute concurrently without interfering with each other. However, the process of acquiring and releasing locks introduces overhead, which can degrade performance. Therefore, while locking improves concurrency, it can also have a negative impact on performance.
16.
What is ASLheapsz?
Correct Answer
A. It is the Communication buffer between the local application and its associated Agent.
Explanation
ASLheapsz refers to the communication buffer that facilitates the exchange of information between a local application and its associated Agent. This buffer allows for seamless communication, enabling the local application to send and receive data to and from the Agent. It plays a crucial role in ensuring smooth and efficient communication between the two entities.
17.
True for Chngpgs_thresh:
Correct Answer(s)
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.
Explanation
This answer is correct because it accurately explains that for heavy update transactions, the value of Chngpgs_thresh should be decreased below the default value. This is because heavy update transactions tend to result in a higher percentage of changed pages in the buffer pool. By decreasing the Chngpgs_thresh value, the asynchronous page cleaners will be started at a lower threshold, ensuring that the buffer pool is cleaned more frequently and efficiently.
18.
Multi Dimensional Clusters are Beneficial For
Correct Answer
A. OLAP
Explanation
Multi Dimensional Clusters are beneficial for OLAP (Online Analytical Processing). OLAP involves analyzing large volumes of data from multiple dimensions, such as time, geography, and product. Multi-dimensional clusters help in organizing and structuring this data in a way that allows for efficient and fast retrieval of information. By grouping similar data points together based on their attributes, multi-dimensional clusters enable OLAP systems to perform complex queries and aggregations more quickly, improving the overall performance and responsiveness of the analytical process.
19.
SMS-
Correct Answer(s)
A. Allocates space on demand
C. System Managed Space
Explanation
The given correct answer suggests that SMS (System Managed Space) is responsible for allocating space on demand. It implies that the File Manager of the operating system is in charge of managing and allocating space as needed. This system manages the space efficiently, ensuring that it is allocated and utilized optimally.
20.
A container is not a
Correct Answer
D. Memory
Explanation
A container is not considered a memory. Memory refers to the physical or virtual storage space where data and instructions are stored for processing by a computer system. A container, on the other hand, is a software unit that encapsulates and isolates applications and their dependencies, providing a consistent and portable environment for running them. While containers may utilize memory resources, they are not synonymous with memory itself.
21.
Locklist
Correct Answer(s)
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
Explanation
The locklist is the memory that holds information about locks held by all applications concurrently connected to the database. If there is a problem with lock escalation, increasing the locklist value can help address the issue. This allows for more locks to be held in memory, reducing the need for lock escalation. On the other hand, decreasing the locklist value can exacerbate lock escalation problems as there may not be enough memory to hold all the necessary lock information.
22.
Default page size in DB2?
Correct Answer
D. 4 KB
Explanation
The default page size in DB2 is 4 KB. This means that the database system allocates storage in units of 4 KB for storing data and indexes. This page size is commonly used because it strikes a balance between efficient storage and performance. Larger page sizes can reduce the overhead of managing storage, but they may also result in wasted space if the data being stored is smaller than the page size. Smaller page sizes can be more efficient for small amounts of data, but they may also increase the overhead of managing storage.
23.
Not a DB2 licence method
Correct Answer
C. Memory
Explanation
The given options CPU and User are not related to licensing methods in DB2. Memory, on the other hand, can be a relevant factor when it comes to licensing as it determines the amount of data that can be stored and processed in the database. Therefore, Memory is not a DB2 license method.
24.
If the user wants particular attribute to be displayed in the report o/p, include the attribute in
Correct Answer
C. Report display form
Explanation
The attribute that the user wants to be displayed in the report output should be included in the Report display form. This form is specifically designed to display the attributes that will be included in the report output. By including the attribute in this form, the user ensures that it will be visible in the final report.
25.
True about Drill across?
Correct Answer(s)
A. A hierarchy can be used as a drill path
B. The destination is shown as part of the other.
Explanation
Drill across refers to the ability to navigate from one level of detail to another within a hierarchy. This means that a hierarchy can indeed be used as a drill path. Additionally, when drilling across, the destination is shown as part of the other. Therefore, the answer "A hierarchy can be used as a drill path, The destination is shown as part of the other" is correct.
26.
Row level math calculation and virtual attributes is possible with
Correct Answer
A. Consolidation
Explanation
Consolidation allows for row level math calculations and virtual attributes. It is a process of combining data from multiple sources into a single, unified view. This means that calculations can be performed on individual rows of data and virtual attributes can be created to represent derived values. Consolidation is commonly used in financial reporting and analysis, where data from different departments or subsidiaries needs to be aggregated and analyzed together.
27.
If you want to filter on more than one attribute you will use
Correct Answer
A. Joint element list
Explanation
The correct answer is "Joint element list" because when you want to filter on more than one attribute, you need to combine or join the elements from multiple lists into a single list. This joint element list will contain all the elements that satisfy the filtering conditions for each attribute.
28.
Report view mode
Correct Answer(s)
A. Grid
B. GrapH
C. SQL
D. Grid grapH mode
Explanation
The given correct answer lists the different view modes available in a report. These modes include Grid, Graph, SQL, and Grid graph mode. Grid mode displays the data in a tabular format, Graph mode represents the data visually using charts and graphs, SQL mode allows users to write custom SQL queries, and Grid graph mode combines both the tabular and visual representations of the data.
29.
Derives metrics can be used in other reports
Correct Answer
B. False
Explanation
Derives metrics cannot be used in other reports. These metrics are calculated based on other metrics and are specific to the report they are generated for. They cannot be transferred or used in other reports as they are not standalone metrics. Therefore, the given answer "False" is correct.
30.
Level prompt –
Correct Answer
A. Dimensionality of a metrics
Explanation
The dimensionality of a metrics refers to the number of dimensions or variables that are used to measure or analyze a particular metric. It indicates the complexity or richness of the metric. A higher dimensionality means that more variables are considered, resulting in a more comprehensive analysis. On the other hand, a lower dimensionality implies a simpler analysis with fewer variables. The dimensionality of a metrics is important in determining the accuracy and reliability of the analysis conducted using that metric.
31.
More than one ID column
Correct Answer
A. Compound attribute
Explanation
A compound attribute refers to a single attribute that consists of multiple sub-attributes. In this case, the attribute being referred to is an ID column, and it is stated that there is more than one ID column. This suggests that the ID column is composed of multiple sub-attributes, making it a compound attribute.
32.
Default level of metrics –
Correct Answer
A. Report Level
Explanation
The default level of metrics is set at the Report Level. This means that when you create a report, the metrics included in that report will be displayed at the report level by default. This allows you to view and analyze the metrics in the context of the entire report.
33.
Types of actions in hierarchy display
Correct Answer(s)
A. Locked
B. Limited
C. Entry point
D. Filtered
Explanation
The given answer lists the types of actions in a hierarchy display. "Locked" refers to actions that are completely restricted and cannot be accessed or modified. "Limited" indicates actions that have some restrictions or limitations in terms of usage or availability. "Entry point" refers to actions that serve as the starting point or gateway to access other actions or features. "Filtered" implies that certain actions are displayed or made available based on specific filters or criteria.
34.
Schema updation can be done by
Correct Answer
C. All
Explanation
The correct answer is "All". This means that schema updation can be done by any of the mentioned methods, including stopping and starting the microstrategy intelligence server, disconnecting and reconnecting to the project source, and manually updating the schema.
35.
Formula automatically got updated fact column by which metrics
Correct Answer
B. Smart
Explanation
The correct answer is "Smart" because the term "Smart" is commonly used to describe formulas or functions that automatically update or recalculate values based on changes in other cells or data. In this context, the formula is likely designed to update the fact column with metrics based on certain conditions or calculations. The other options (Nested, Derived, and Compound) do not specifically imply this automatic updating behavior.
36.
Which of the following is responsible for MOLAP functionality of microstatergy –
Correct Answer
A. Analytical engine
Explanation
The analytical engine is responsible for the MOLAP (Multidimensional Online Analytical Processing) functionality of MicroStrategy. MOLAP is a type of database technology that enables fast and efficient analysis of large amounts of data. The analytical engine within MicroStrategy processes and organizes data in a multidimensional format, allowing users to easily navigate and analyze data from different perspectives. This engine performs calculations, aggregations, and other operations necessary for generating reports and visualizations in MOLAP cubes. It plays a crucial role in providing users with a powerful and interactive analytical experience within the MicroStrategy platform.
37.
Which mapping stores the project information –
Correct Answer
A. Metadata mapping
Explanation
Metadata mapping is the mapping that stores project information. Metadata refers to the data that provides information about other data, in this case, it includes information about the project. This mapping is responsible for organizing and managing the metadata of the project, such as project name, description, version, and other relevant details. By using metadata mapping, project information can be easily accessed and utilized for various purposes, such as project management, documentation, and analysis.
38.
Metric level – group set to NONE is not applicable for
Correct Answer
A. Transformation.
Explanation
The given question states that the metric level with the group set to NONE is not applicable for Transformation. This suggests that the metric level and group set to NONE can be applicable for Transaction and Duplication. Therefore, the correct answer is Transformation.
39.
OLAP services
Correct Answer(s)
A. Report objects
B. Derived metrics
C. View filters
Explanation
The correct answer includes three options: report objects, derived metrics, and view filters. These are all components or features commonly found in OLAP services. Report objects refer to the various elements that can be included in a report, such as tables, charts, and graphs. Derived metrics are calculated measures that are derived from existing data in the OLAP cube. View filters allow users to apply specific filters to the data being viewed in order to focus on specific subsets of information. Therefore, all three options are relevant to OLAP services.
40.
Default drill path –
Correct Answer
A. System Hierarchy
Explanation
The correct answer is System Hierarchy because the term "default drill path" refers to the predefined path or sequence followed when navigating through a system or data hierarchy. In this context, the System Hierarchy refers to the hierarchical structure of the system, which is the default path followed when drilling down or navigating through different levels of the system. It is the primary hierarchy that determines the organization and relationship between different components or levels within the system.
41.
Grouping of attributes which can be displayed, ordered, unordered –
Correct Answer
A. Hierarchy
42.
OLAP services
Correct Answer
D. All
Explanation
The correct answer is "All" because all of the mentioned options (report objects, view filters, derived metrics) are part of OLAP services. OLAP services are used for analyzing multidimensional data and these components are essential for performing various operations and calculations on the data. Therefore, selecting "All" implies that all of these components are included in OLAP services.
43.
Types of prompts
Correct Answer(s)
A. Level prompt
B. Object prompt
C. Value prompt
D. Filter definition prompt
Explanation
The given answer lists the different types of prompts. A level prompt is used to select a level or hierarchy in a system. An object prompt allows the selection of specific objects or entities. A value prompt allows the input of a specific value or range. A filter definition prompt is used to define filters or conditions for data retrieval.
44.
Output of hash file -
Correct Answer
A. Not sorted.
Explanation
The output of the hash file is "Not sorted" because it does not follow any specific order or arrangement. A hash file is typically used for quick data retrieval and does not guarantee any particular order of the stored data. Therefore, the output is not sorted and can be accessed randomly.
45.
Implicit facts or attributes are
Correct Answer(s)
A. Virtual facts or attributes.
B. Constant facts or attributes.
Explanation
Implicit facts or attributes are facts or attributes that are not explicitly stated but can be inferred or assumed based on other information. They are not directly mentioned but can be understood or deduced from the context or other explicit facts. Therefore, implicit facts or attributes can be considered as virtual or constant, as they exist but are not explicitly mentioned or stated.
46.
Updating the schema is nessary when there is a change in
Correct Answer
C. Both the facts and attributes
Explanation
When there is a change in both the facts and attributes of a schema, updating the schema becomes necessary. A schema is a blueprint or structure that defines the organization and relationships of data in a database. Facts are the actual data stored in the database, while attributes are the characteristics or properties of the data. If either the facts or attributes change, the schema needs to be updated to reflect these changes and ensure the integrity and consistency of the data.
47.
Schema objects are
Correct Answer
E. All
Explanation
The correct answer is "All". This means that schema objects include all of the options listed: facts, attributes, hierarchies, transformation, and partition mapping. In database management, a schema is a logical container for organizing and grouping related database objects. These objects can include tables, views, indexes, procedures, and more. So, all of these options are valid examples of schema objects.
48.
In which type of filter the SQL is not changed?
Correct Answer
A. View filter
Explanation
A view filter in SQL is a filter applied to a view, which is a virtual table created from the result of a query. When a view filter is applied, the SQL query itself remains unchanged. Instead, the filter is applied to the result set of the query, allowing for selective retrieval of data from the view. Therefore, in a view filter, the SQL is not changed.
49.
In two tier architecture, how many ODBC connections are there?
Correct Answer
A. 2
Explanation
In a two-tier architecture, there are two ODBC connections. This architecture consists of a client and a server, where the client directly communicates with the server. The first ODBC connection is established between the client application and the database server, allowing the client to send queries and retrieve data. The second ODBC connection is between the database server and the database itself, enabling the server to execute the queries and retrieve the requested data. Therefore, there are two ODBC connections in a two-tier architecture.
50.
Types of partition mapping?
Correct Answer
C. Both
Explanation
The correct answer is "Both" because there are two types of partition mapping: server level partitioning and application level partitioning. Server level partitioning involves dividing data across multiple servers or nodes, while application level partitioning involves dividing data within a single server or node. Therefore, both types of partition mapping are valid and can be used depending on the specific requirements and architecture of the system.