MSBI 2008 Evaluation Test
-
1. What is the difference between UNION and UNION ALL?
-
A. Union selects only unique row (data) from all queries and Union all selects all rows from all queries.
-
B. Union selects row (data) from all queries and Union all selects all rows from all queries.
-
C. Union selects only unique row (data) from all queries and Union all selects rows from all queries.
-
D. Union selects row (data) from all queries and Union all selects rows from all queries.
-
The MSBI 2008 Evaluation Test assesses knowledge in Microsoft Business Intelligence (MSBI), focusing on database concepts like normalization, joins, and stored procedures. It evaluates understanding of data management techniques and tools, essential for professionals in data-driven roles.
- 2.
1. Define Row Number function?
-
To generate sequence number.
-
To generate sequence number based on order by column.
-
To generate number.
-
None.
Correct Answer
A. To generate sequence number based on order by column.Explanation
The correct answer is "To generate sequence number based on order by column." The ROW_NUMBER function is used to assign a unique sequential number to each row in a result set, based on the specified order by column. This function is commonly used in scenarios where you need to rank or order the rows in a query result.Rate this question:
-
- 3.
1. What is Normalization? Types of normalization?
-
Join the tables
-
Move the data into tables.
-
Split the table to reduce duplicates and it has five types.
-
None
Correct Answer
A. Split the table to reduce duplicates and it has five types.Explanation
Normalization is the process of organizing data in a database to eliminate redundancy and improve data integrity. It involves splitting a table into multiple smaller tables to reduce duplicates and ensure each table represents a single entity or concept. This helps in reducing data anomalies and improves the efficiency of data storage and retrieval. There are five types of normalization, namely First Normal Form (1NF), Second Normal Form (2NF), Third Normal Form (3NF), Boyce-Codd Normal Form (BCNF), and Fourth Normal Form (4NF).Rate this question:
-
- 4.
1. What are different types of joins?
-
Inner, outer, self join.
-
Equi join and cross join.
-
Right outer join.
-
All above.
Correct Answer
A. All above.Explanation
The correct answer is "All above" because there are indeed different types of joins in SQL, including inner join, outer join, self join, equi join, cross join, and right outer join. Each type of join serves a different purpose and is used to combine data from multiple tables based on specified conditions.Rate this question:
-
- 5.
1. What are the advantages of using stored procedure?
-
A. Pre executable program.
-
B. We can get the data.
-
C. Security.
-
D. It is similar to function.
Correct Answer
A. A. Pre executable program.Explanation
Stored procedures are advantageous because they allow for pre-execution of a program. This means that the procedure can be compiled and optimized before it is executed, leading to improved performance. Additionally, stored procedures can be reused, reducing the need to rewrite code. They also enhance security by allowing access to the database through the procedure rather than directly. Finally, stored procedures are similar to functions in that they can return values and be used in other queries or procedures.Rate this question:
-
- 6.
1. What is BCP?
-
A. Bulk copy program.
-
B. Business continuity program.
-
C. A and B.
-
D. None.
Correct Answer
A. A. Bulk copy program.Explanation
The correct answer is "a. Bulk copy program." BCP stands for Bulk copy program, which is a utility used to copy large amounts of data between SQL Server instances or databases. It is commonly used for tasks such as importing/exporting data, creating backups, and transferring data between different servers. It is not related to business continuity programs or any other options mentioned in the question.Rate this question:
-
- 7.
1. Define Index?
-
A. Predefined pointers to data page.
-
B. It is primary key.
-
C. It is foreign key.
-
D. None.
Correct Answer
A. A. Predefined pointers to data page.Explanation
The correct answer is "a. Predefined pointers to data page." In a database, an index is a data structure that improves the speed of data retrieval operations on a database table. It does this by creating a copy of a portion of the table's data and storing it in a separate structure. This separate structure contains pointers to the actual data pages, allowing for faster access and retrieval of specific data. Therefore, an index can be defined as predefined pointers to data pages.Rate this question:
-
- 8.
1. What command do we use to rename db, table, and column?
-
A. Invoke command
-
B. Commit
-
C. Rename
-
D. None.
Correct Answer
A. C. RenameExplanation
The correct answer is c. Rename. We use the rename command to change the names of a database, table, or column. This command allows us to easily update the names without losing any data or making any other changes to the structure or content of the database.Rate this question:
-
- 9.
1. Define having clause?
-
A. It is similar to where but must use group by clause.
-
B. It is equal to where clause.
-
C. None.
-
D. It is equal to from clause.
Correct Answer
A. A. It is similar to where but must use group by clause.Explanation
The having clause is used in SQL to filter the results of a query based on conditions that involve aggregate functions. It is similar to the where clause, but it can only be used in conjunction with the group by clause. The having clause allows you to specify conditions that apply to groups of rows, rather than individual rows. This is useful when you want to filter the results based on the result of an aggregate function, such as finding groups with a certain sum or count.Rate this question:
-
- 10.
1. What are the basic functions system databases?
-
A. To create functions.
-
B. To create stored procedure.
-
C. To maintain metadata information.
-
D. None.
Correct Answer
A. C. To maintain metadata information.Explanation
System databases in a database management system (DBMS) are responsible for maintaining metadata information. Metadata includes information about the structure and organization of the database, such as tables, columns, indexes, and relationships. System databases store this information and allow the DBMS to access and manage it efficiently. The functions of creating functions and stored procedures are typically performed by user databases, not system databases. Therefore, the correct answer is c. To maintain metadata information.Rate this question:
-
- 11.
1. Explain ETL process?
-
A. Extract, Translation, Loading.
-
B. Extract, Transformation , Loading
-
C. Both a and b.
-
D. None.
Correct Answer
A. B. Extract, Transformation , LoadingExplanation
The correct answer is b. Extract, Transformation, Loading. The ETL process involves extracting data from various sources, transforming it to fit the desired format or structure, and loading it into a target system or database. Extraction involves retrieving data from different sources such as databases, files, or APIs. Transformation involves cleaning, filtering, and manipulating the data to ensure its quality and consistency. Loading involves transferring the transformed data into the target system or database for further analysis or reporting.Rate this question:
-
- 12.
1. Difference between for loop and for each loop container?
-
A. For loop based on conditions and for each loop based on objects collections.
-
B. For loop based on objects collections and for each loop based on objects collections.
-
C. None.
-
D. Both a and b.
Correct Answer
A. A. For loop based on conditions and for each loop based on objects collections.Explanation
The correct answer is a. For loop based on conditions and for each loop based on objects collections. This answer correctly identifies the key difference between a for loop and a for each loop. A for loop is based on conditions and can be used to iterate over a collection of objects based on specific conditions. On the other hand, a for each loop is based on object collections and is used to iterate over all the objects in a collection without the need for conditions.Rate this question:
-
- 13.
1. What does a control flow do?
-
A. To control workflow.
-
B. To control events.
-
C. To control data flows.
-
D. To control lookup.
Correct Answer
A. A. To control workflow.Explanation
A control flow is a sequence of steps or instructions that determines the order in which tasks or events are executed. It provides a way to control the flow of execution in a program or system, ensuring that certain actions are performed in a specific order. In this context, controlling workflow means managing the sequence of tasks and events to ensure that they are executed correctly and efficiently.Rate this question:
-
- 14.
1. Explain event handlers?
-
A. To handle data validations.
-
B. To handle errors.
-
C. To handle events.
-
D. None.
Correct Answer
A. C. To handle events.Explanation
Event handlers are functions or methods that are used to respond to specific events that occur in a program. They are responsible for handling and processing these events, which can include user actions, system notifications, or other occurrences. Event handlers are used to execute code or perform specific tasks when a particular event is triggered. In this context, the correct answer is c. To handle events, as event handlers are specifically designed to handle events and their associated actions.Rate this question:
-
- 15.
1. SSIS 2008 configuration types?
-
A. Five.
-
B. Four.
-
C. Three.
-
D. One.
Correct Answer
A. A. Five. -
- 16.
1. Define Lookup transformation?
-
A. Used as reference table.
-
B. Used as master table.
-
C. Used as fact table
-
D. None.
Correct Answer
A. A. Used as reference table.Explanation
A Lookup transformation is used as a reference table. It is used to look up data from a source table based on a key column and retrieve matching values from the reference table. This allows for data enrichment and validation in data integration processes.Rate this question:
-
- 17.
1. Define synchronous transformations?
-
A. Input rows count and Output rows count are same.
-
B. Input rows count and Output rows count are not same.
-
C. None.
-
D. Input rows count and Output rows count are different.
Correct Answer
A. A. Input rows count and Output rows count are same.Explanation
Synchronous transformations refer to transformations in which the number of input rows and output rows remain the same. This means that for every input row, there is exactly one corresponding output row.Rate this question:
-
- 18.
1. How to rename file using SSIS tasks?
-
A. Using lookup.
-
B. Using Data flow.
-
C. Using File system task.
-
D. None.
Correct Answer
A. C. Using File system task.Explanation
The correct answer is c. Using File system task. The File system task in SSIS allows users to perform various operations on files, including renaming them. This task provides options to specify the source file path and the new file name, allowing for easy renaming of files within an SSIS package.Rate this question:
-
- 19.
1. What does mean by data auditing?
-
A. To maintain data load statistics in ETL process.
-
B. To know the errors.
-
C. To know the Primary keys.
-
D. None.
Correct Answer
A. A. To maintain data load statistics in ETL process.Explanation
Data auditing refers to the process of examining and analyzing data to ensure its accuracy, integrity, and compliance with established standards and regulations. In the context of the given options, option a is the correct answer because it states that data auditing is done to maintain data load statistics in the ETL (Extract, Transform, Load) process. This means that data auditing is performed to track and monitor the success and efficiency of data loading operations in the ETL process, helping to identify any issues or errors that may occur during the data loading process.Rate this question:
-
- 20.
1. How many container tasks available in SSIS?
-
A. One.
-
B. Two.
-
C. Three.
-
D. Four.
Correct Answer
A. D. Four.Explanation
There are four container tasks available in SSIS. These container tasks are used to group and organize other tasks and control their execution. The four container tasks are: Sequence Container, For Loop Container, Foreach Loop Container, and the Task Host Container.Rate this question:
-
- 21.
1. Define role play dimensions?
-
A. One dimension used multiple times in the cube.
-
B. One dimension used in different cubes.
-
C. Shared across cubes.
-
D. None.
Correct Answer
A. A. One dimension used multiple times in the cube.Explanation
The correct answer is "a. One dimension used multiple times in the cube." This means that in a role play dimension, a single dimension is used multiple times within the same cube. This allows for different perspectives or scenarios to be analyzed within the same dimensional structure.Rate this question:
-
- 22.
1. Define dimension usage in SSAS Cube?
-
A. To maintain cube data size.
-
B. To know the relationships between dimensions and fact.
-
C. To build business logic.
-
D. None.
Correct Answer
A. B. To know the relationships between dimensions and fact.Explanation
Dimension usage in SSAS Cube is used to define the relationships between dimensions and facts. This helps in determining how the dimensions are related to each other and how they are related to the fact table. By defining dimension usage, we can specify which dimensions are related to each measure group and how they are related, such as whether it is a one-to-one or a one-to-many relationship. This information is crucial for correctly aggregating and analyzing the data in the cube.Rate this question:
-
- 23.
1. MDX stands?
-
A. Memory, Distribution, extensions.
-
B. Memory, dimension, expressions.
-
C. Multi, dimension, expressions.
-
D. None
Correct Answer
A. C. Multi, dimension, expressions.Explanation
MDX stands for Multi-Dimensional Expressions. It is a query language used for retrieving data from multidimensional databases. MDX allows users to define calculations, create custom aggregations, and perform complex analysis on data stored in OLAP cubes. It is commonly used in conjunction with Microsoft SQL Server Analysis Services and other OLAP systems.Rate this question:
-
- 24.
1. DSV stands?
-
A. Data source View.
-
B. It is view.
-
C. It has relationships and metadata.
-
D. All above.
Correct Answer
A. D. All above.Explanation
The correct answer is d. All above. This means that DSV stands for all the options mentioned in the question - Data source View, It is view, and It has relationships and metadata. This suggests that DSV is a versatile term that encompasses multiple meanings and functions within the given context.Rate this question:
-
- 25.
1. How many types of actions available in the Cube?
-
A. One.
-
B. Two.
-
C. Three.
-
D. None.
Correct Answer
A. C. Three.Explanation
The correct answer is c. Three. The question asks about the number of types of actions available in the Cube. The options provided are one, two, three, and none. Since the correct answer is c, it means that there are three types of actions available in the Cube.Rate this question:
-
- 26.
1. What do you understand by dynamic named set (SSAS 2008)?
-
A. To create dynamic set of members.
-
B. To create set of members.
-
C. None.
-
D. Both a and b.
Correct Answer
A. A. To create dynamic set of members.Explanation
Dynamic named sets in SSAS 2008 are used to create sets of members that are dynamically determined based on certain criteria or conditions. These sets can be created using MDX expressions and can be used in queries or calculations to provide flexible and dynamic results. This allows for more advanced and customized analysis of data in multidimensional models.Rate this question:
-
- 27.
1. How many types of dimension are possible in SSAS?
-
A. Four.
-
B. Five.
-
C. Six.
-
D. Seven.
Correct Answer
A. C. Six.Explanation
There are six types of dimensions possible in SSAS. These include regular dimensions, referenced dimensions, role-playing dimensions, parent-child dimensions, fact dimensions, and many-to-many dimensions.Rate this question:
-
- 28.
1. In which scenario, you would like to go for materializing dimension?
-
A. To increase speed.
-
B. To decrease memory size.
-
C. Both.
-
D. None.
Correct Answer
A. A. To increase speed.Explanation
Materializing dimensions refers to the process of creating physical copies of dimension tables in a data warehouse. This is done to improve query performance by reducing the need for joins and aggregations. By materializing dimensions, the data can be accessed more quickly, resulting in faster query response times. Therefore, the correct answer is "a. To increase speed."Rate this question:
-
- 29.
1. What are different storage mode options?
-
A. MOLAP, HOLAP and ROLAP.
-
B. Process modes.
-
C. Process options.
-
D. None.
Correct Answer
A. A. MOLAP, HOLAP and ROLAP.Explanation
The correct answer is a. MOLAP, HOLAP and ROLAP. MOLAP stands for Multidimensional Online Analytical Processing, HOLAP stands for Hybrid Online Analytical Processing, and ROLAP stands for Relational Online Analytical Processing. These are different storage modes or options used in data warehousing and business intelligence systems. MOLAP stores data in a multidimensional format, HOLAP combines multidimensional and relational storage, and ROLAP stores data in a relational database. These storage modes offer different advantages and trade-offs in terms of query performance, storage efficiency, and flexibility.Rate this question:
-
- 30.
1. What are the options to deploy SSAS cube in production?
-
A. Using BIDS.
-
B. Using SSMS.
-
C. Using XMLA.
-
D. All the above.
Correct Answer
A. D. All the above.Explanation
The correct answer is "d. All the above." This means that all the options mentioned (Using BIDS, Using SSMS, and Using XMLA) can be used to deploy an SSAS cube in production. BIDS (Business Intelligence Development Studio) is a development environment for creating SSAS cubes and can also be used to deploy them. SSMS (SQL Server Management Studio) is a management tool for SQL Server and can be used to deploy SSAS cubes as well. XMLA (XML for Analysis) is a standard language for managing and manipulating analytical data and can also be used for deploying SSAS cubes.Rate this question:
-
- 31.
1. Describe Reporting Lifecycle?
-
A. Reports and reports models.
-
B. Report authoring, Management, Delivery.
-
C. Both.
-
D. None.
Correct Answer
A. B. Report authoring, Management, Delivery.Explanation
The correct answer is b. Report authoring, Management, Delivery. The reporting lifecycle refers to the process of creating, managing, and delivering reports. Report authoring involves designing and creating the report, including selecting data sources, defining report structure, and adding visualizations. Report management involves organizing and storing reports, as well as controlling access and permissions. Report delivery involves distributing the reports to the intended audience, whether it be through email, a web portal, or other means. This answer accurately describes the different stages of the reporting lifecycle.Rate this question:
-
- 32.
1. What can SQL Server Reporting Services do?
-
A. To create files.
-
B. To create tables.
-
C. To create Reports.
-
D. None.
Correct Answer
A. C. To create Reports.Explanation
SQL Server Reporting Services is a powerful tool that allows users to create and generate reports from various data sources. It provides a wide range of features and functionalities to design, format, and distribute reports in different formats such as PDF, Excel, and Word. With SQL Server Reporting Services, users can create interactive and visually appealing reports that can be customized according to their specific requirements. Additionally, it also offers options for data visualization, data exploration, and data analysis, making it a comprehensive solution for reporting and analytics needs.Rate this question:
-
- 33.
1. Define reporting processing?
-
A. Report data processing.
-
B. Report rendering process.
-
C. Report delivery process.
-
D. All the above.
Correct Answer
A. D. All the above.Explanation
The correct answer is d. All the above. This means that reporting processing includes report data processing, report rendering process, and report delivery process. In other words, reporting processing involves the entire process of handling and managing data, creating and formatting reports, and delivering them to the intended recipients.Rate this question:
-
- 34.
1. How many default rending options are available in SSRS2008?
-
A. Four.
-
B. Five.
-
C. Two.
-
D. One.
Correct Answer
A. A. Four.Explanation
There are four default rendering options available in SSRS2008.Rate this question:
-
- 35.
1. What is the usage of Report Builder?
-
A. To create reports.
-
B. To create reports for users.
-
C. Business users create reports.
-
D. None.
Correct Answer
A. C. Business users create reports.Explanation
The correct answer is c. Business users create reports. This answer suggests that the main purpose of Report Builder is to allow business users to create reports. The other options are not as specific and do not mention the involvement of business users.Rate this question:
-
- 36.
1. Explain report model in SSRS 2008?
-
A. Model used by Report Builder.
-
B. Model used by reports.
-
C. Both.
-
D. None.
Correct Answer
A. A. Model used by Report Builder.Explanation
The correct answer is "a. Model used by Report Builder." The report model in SSRS 2008 refers to the data model that is used by the Report Builder tool. This model defines the structure and relationships of the data that can be used in creating reports. It allows users to easily access and manipulate data without needing to have in-depth knowledge of the underlying data sources. The report model acts as a middle layer between the data sources and the reports, providing a simplified and user-friendly interface for report creation.Rate this question:
-
- 37.
1. How many architecture components of SSRS 2008?
-
A. Five.
-
B. Six.
-
C. Seven.
-
D. None.
Correct Answer
A. B. Six.Explanation
SSRS 2008 has six architecture components. These components include the Report Server, Report Manager, Report Designer, Report Builder, Report Server Database, and Data Sources. Each component plays a specific role in the functioning of SSRS 2008, such as creating, managing, and delivering reports.Rate this question:
-
- 38.
1. Explain on SSRS2008 Reporting Items?
-
A. Tablix,Chart,List
-
B. Sub Report.
-
C. Both A and B.
-
D. None.
Correct Answer
A. C. Both A and B.Explanation
The correct answer is c. Both A and B. In SSRS2008, the reporting items include Tablix, Chart, and List, which are options A. Sub Report is also a reporting item in SSRS2008, which is option B. Therefore, the correct answer is option C, as both A and B are correct.Rate this question:
-
- 39.
1. What does mean by nested datasets?
-
A. Used datasets with in dataset.
-
B. A dataset.
-
C. None.
-
D. A table.
Correct Answer
A. A. Used datasets with in dataset.Explanation
Nested datasets refer to the use of datasets within another dataset. This means that one dataset is contained or embedded within another dataset. This can be useful for organizing and structuring data in a hierarchical manner. It allows for the grouping of related data together and can make it easier to access and analyze the data.Rate this question:
-
- 40.
1. How many command line utilities of SSRS2008?
-
A. Three.
-
B. Four.
-
C. One.
-
D. None.
Correct Answer
A. A. Three.Explanation
The correct answer is a. Three. This means that there are three command line utilities in SSRS2008.Rate this question:
-
Quiz Review Timeline (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Dec 21, 2010Quiz Created by
Mytestquiz123
Back to top