# Do You Know How To Do Business?

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Cvktech
C
Cvktech
Community Contributor
Quizzes Created: 11 | Total Attempts: 41,864
Questions: 20 | Attempts: 1,340

Settings

Anyone can start a business, but to successfully maintain the one, you need to be street smart as well as book smart. Do you think you would be an asset to the business you want to work in based on the amount of knowledge you have on businesses and how to achieve their goals and objectives? Take up the quiz below and find out how much you know about it. !

• 1.

### Define Lookup transformation?

• A.

Used as reference table.

• B.

Used as master table.

• C.

Used as fact table

• D.

None.

A. Used as reference table.
Explanation
The Lookup transformation is used as a reference table in data integration processes. It allows mapping of incoming data with existing data in the reference table based on a specified key. This transformation helps in enriching or validating the incoming data by retrieving additional information from the reference table. It is commonly used to perform lookups and perform operations such as updating, inserting, or deleting records based on the lookup results.

Rate this question:

• 2.

### 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.

Input rows count and Output rows count are different.

• D.

None.

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 the transformation does not alter the number of rows in the data.

Rate this question:

• 3.

### How to rename file using SSIS tasks?

• A.

Using lookup.

• B.

Using Data flow.

• C.

• D.

None.

Explanation
The correct answer is "Using File system task." The File system task in SSIS allows users to perform operations on files and directories, including renaming files. This task provides a simple and efficient way to rename files within an SSIS package without the need for complex scripting or coding. By selecting the File system task, users can specify the source file path and the new file name, allowing for easy renaming of files during the execution of the SSIS package.

Rate this question:

• 4.

### 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

A. To maintain data load statistics in ETL process.
Explanation
Data auditing refers to the process of maintaining and tracking data load statistics in the ETL (Extract, Transform, Load) process. It involves recording and analyzing information about the data being loaded, such as the number of records processed, the time taken for each step, and any errors encountered. This helps in monitoring the data flow, identifying bottlenecks, and ensuring the accuracy and completeness of the data being loaded into the target system. By auditing the data load statistics, organizations can gain insights into the efficiency and effectiveness of their ETL processes and make necessary improvements.

Rate this question:

• 5.

### How many container tasks available in SSIS?

• A.

One.

• B.

Two.

• C.

Three.

• D.

Four.

D. Four.
Explanation
The correct answer is four because SSIS (SQL Server Integration Services) allows users to create and manage multiple container tasks. These container tasks include the Sequence Container, For Loop Container, For Each Loop Container, and the Execute Package Task. Each of these container tasks serves a different purpose and can be used to organize and control the flow of data and operations within an SSIS package.

Rate this question:

• 6.

### 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.

A. One dimension used multiple times in the cube.
Explanation
This answer suggests that in role play dimensions, one dimension is used multiple times in the cube. This means that the same dimension is repeated and used in different ways within the role play scenario. It could imply that different aspects of the dimension are explored or that the dimension plays a crucial role in multiple parts of the role play.

Rate this question:

• 7.

### Define dimension usage in SSAS Cube?

• A.

To maintain cube data size.

• B.

To know the relationships between dimensions and fact.

• C.

• D.

None.

B. To know the relationships between dimensions and fact.
Explanation
Dimension usage in SSAS Cube refers to the process of defining how dimensions are related to the fact table in the cube. By specifying the relationships between dimensions and the fact table, it enables the cube to accurately analyze and aggregate data based on these relationships. This information is crucial for performing multidimensional analysis and generating meaningful insights from the data stored in the cube.

Rate this question:

• 8.

### MDX stands?

• A.

Memory, Distribution, extensions.

• B.

Memory, dimension, expressions.

• C.

Multi, dimension, expressions.

• D.

None

C. Multi, dimension, expressions.
Explanation
MDX stands for Multi-Dimensional Expressions. It is a query language used to retrieve and manipulate data from multidimensional databases, such as OLAP cubes. MDX allows users to perform complex calculations and aggregations across multiple dimensions of data.

Rate this question:

• 9.

### DSV stands?

• A.

Data source View.

• B.

It is view.

• C.

• D.

All above.

D. All above.
Explanation
The correct answer is "All above" because DSV stands for Data Source View, which is a view that contains relationships and metadata. Therefore, all the statements mentioned in the options are true about DSV.

Rate this question:

• 10.

### How many types of actions available in the Cube?

• A.

One.

• B.

Two.

• C.

Three.

• D.

None.

C. Three.
Explanation
The correct answer is three because there are three types of actions available in the Cube.

Rate this question:

• 11.

### What do you understand by dynamic named set (SSAS 2008)?

• A.

To create dynamic set of members.

• B.

To create set of members.

• C.

Both a and b.

• D.

None

A. To create dynamic set of members.
Explanation
A dynamic named set in SSAS 2008 is used to create a set of members that can change dynamically based on certain criteria or conditions. This allows for flexibility in analyzing data as the set of members can be updated automatically as the data changes. It is different from a regular set of members, which is static and does not change unless manually updated. Therefore, the correct answer is to create a dynamic set of members.

Rate this question:

• 12.

### In which scenario, you would like to go for materializing dimension?

• A.

To increase speed.

• B.

To decrease memory size.

• C.

Both.

• D.

None

A. To increase speed.
Explanation
Materializing dimensions involves creating physical tables or structures to store pre-aggregated data, which can significantly improve query performance and speed. By materializing dimensions, the data can be accessed directly without the need for complex calculations or joins, resulting in faster data retrieval. This approach is particularly useful when dealing with large datasets or complex queries that require frequent access to aggregated data. It does not directly affect memory size but can indirectly contribute to reducing memory usage by minimizing the need for on-the-fly calculations.

Rate this question:

• 13.

### What are different storage mode options?

• A.

MOLAP, HOLAP and ROLAP.

• B.

Process modes.

• C.

Process options.

• D.

None.

A. MOLAP, HOLAP and ROLAP.
Explanation
The different storage mode options in this context are MOLAP, HOLAP, and ROLAP. MOLAP stands for Multidimensional Online Analytical Processing, which stores data in a multidimensional cube format, allowing for fast query performance. HOLAP, or Hybrid Online Analytical Processing, combines the benefits of both MOLAP and ROLAP (Relational Online Analytical Processing) by storing some data in a cube format and other data in a relational database. ROLAP stores data in a relational database, providing flexibility but potentially slower query performance.

Rate this question:

• 14.

### What are the options to deploy SSAS cube in production?

• A.

Using BIDS.

• B.

Using SSMS.

• C.

Using XMLA.

• D.

All the above.

D. All the above.
Explanation
The correct answer is "All the above" because all the options mentioned (Using BIDS, Using SSMS, Using XMLA) are valid methods to deploy SSAS cubes in a production environment. BIDS (Business Intelligence Development Studio) is a visual studio tool used for creating and deploying SSAS cubes. SSMS (SQL Server Management Studio) can also be used to deploy SSAS cubes by connecting to the Analysis Services instance and deploying the cube. XMLA (XML for Analysis) is a language used for managing and deploying SSAS cubes, and it can be used to deploy cubes as well.

Rate this question:

• 15.

### What can SQL Server Reporting Services do?

• A.

To create files.

• B.

To create tables.

• C.

To create Reports.

• D.

None.

C. To create Reports.
Explanation
SQL Server Reporting Services (SSRS) is a powerful tool that allows users to create, manage, and deliver reports. With SSRS, users can design and generate reports from various data sources, such as SQL Server databases, Excel spreadsheets, or SharePoint lists. These reports can include tables, charts, graphs, and other visual elements to present data in a meaningful way. SSRS also provides features for scheduling and automating report generation and distribution. Overall, SSRS is primarily used for creating reports and is not designed specifically for creating files or tables.

Rate this question:

• 16.

### What is the usage of Report Builder?

• A.

To create reports.

• B.

To create reports for users.

• C.

• D.

None

Explanation
The correct answer is "Business users create reports." This option suggests that the usage of Report Builder is specifically for business users to create reports. It implies that other types of users may not have access to or utilize this tool for report creation.

Rate this question:

• 17.

### Explain report model in SSRS 2008?

• A.

Model used by Report Builder.

• B.

Model used by reports.

• C.

Both.

• D.

None

A. Model used by Report Builder.
Explanation
The correct answer is "Model used by Report Builder." In SSRS 2008, a report model is used by Report Builder, which is a tool for creating ad-hoc reports. The report model provides a semantic layer that allows users to easily access and analyze data without needing to have knowledge of the underlying data structure. It simplifies the report creation process by providing pre-defined data sets and relationships, making it easier for non-technical users to create reports.

Rate this question:

• 18.

### How many architecture components of SSRS 2008?

• A.

Five.

• B.

Six.

• C.

Seven.

• D.

None.

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 Report Server Configuration Manager. Each of these components plays a crucial role in the overall functioning of SSRS 2008.

Rate this question:

• 19.

### Explain on SSRS2008 Reporting Items?

• A.

Tablix,Chart,List

• B.

Sub Report.

• C.

Both A and B.

• D.

None

C. Both A and B.
Explanation
The correct answer is "Both A and B." This means that SSRS2008 Reporting Items include Tablix, Chart, List, and Sub Report. Tablix is a combination of a table and a matrix, allowing for flexible data representation. Charts are used to visually represent data in various formats such as bar charts, pie charts, and line charts. Lists are used to display data in a tabular format. Sub Reports are used to embed one report within another report, allowing for modular and reusable reporting components.

Rate this question:

• 20.

### How many command line utilities of SSRS2008?

• A.

Three.

• B.

Four.

• C.

One.

• D.

None

A. Three.
Explanation
The correct answer is three because SSRS2008 (SQL Server Reporting Services 2008) has three command line utilities. These utilities are rsconfig.exe, rskeymgmt.exe, and rs.exe. rsconfig.exe is used for configuring the report server, rskeymgmt.exe is used for managing encryption keys, and rs.exe is used for scripting and automating report server operations.

Rate this question:

Related Topics