Want To Improve Your Business Intelligence? Take This MSBI Quiz

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Akshay Mishra
Akshay Mishra, Business Intelligence
Akshya, a dedicated Business Intelligence enthusiast, leverages 8 years of experience to drive data-driven decision-making with passion and expertise.
Quizzes Created: 2 | Total Attempts: 8,281
| Attempts: 5,542
SettingsSettings
Please wait...
  • 1/61 Questions

    How many Data Flow Tasks can a package run in parallel?

    • Total Tasks=Number of processors of machine+2
    • Total task=100
    • Total task=10
    • Total task=6
Please wait...
About This Quiz

MSBI stands for Microsoft Business Intelligence. This powerful suite is composed of tools which helps in providing best solutions for Business Intelligence and Data Mining Queries. This tool uses Visual studio along with SQL server.
Want To Improve Your Business Intelligence? Take This MSBI Quiz

Want To Improve Your Business Intelligence? Take This MSBI Quiz - Quiz

Quiz Preview

  • 2. 

    What is break point in ssis?

    • Break point is stopping point in code

    • Helps in the transformation of data

    • Helps in the extraction of data

    • None of the above

    Correct Answer
    A. Break point is stopping point in code
    Explanation
    A breakpoint in SSIS is a stopping point in the code where the execution of the package is paused. It allows developers to pause the execution at a specific point in order to examine the values of variables, check the flow of data, and debug any issues in the package. By setting breakpoints, developers can effectively troubleshoot and analyze the behavior of the package during runtime.

    Rate this question:

  • 3. 

    When using an Execute SQL task the developer must ensure that the order of the parameters within the query must be the same as the order in which the parameters appear in the Query. 

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When using an Execute SQL task, the order of the parameters within the query must be the same as the order in which the parameters appear in the Query. This is because the query is executed based on the order of the parameters, and if they are not in the correct order, the query may not produce the expected results or may fail altogether. Therefore, it is important for the developer to ensure that the parameters are arranged correctly in both the query and the task to ensure the proper execution of the SQL statement.

    Rate this question:

  • 4. 

    Which container is not visible from the IDE? 

    • Sequence Container

    • For Loop Container

    • For Each Loop Container

    • Task Host Container

    Correct Answer
    A. Task Host Container
    Explanation
    The Task Host Container is not visible from the IDE. The Task Host Container is responsible for hosting and executing tasks within the SSIS package, but it is not directly visible or accessible from the IDE. This container is used to manage the execution of tasks and does not contain any tasks or control flow elements itself.

    Rate this question:

  • 5. 

    Define Index?

    • Predefined pointers to data page

    • Primary key

    • Foreign Key

    • None

    Correct Answer
    A. Predefined pointers to data page
    Explanation
    Index is a predefined data structure that contains pointers to the data pages in a database. These pointers help in efficient retrieval of data by providing quick access to the desired information. By using indexes, the database system can locate the required data without scanning the entire database, resulting in improved performance and reduced query execution time. Therefore, the correct answer is "Predefined pointers to data page".

    Rate this question:

  • 6. 

    The total Number of container tasks available in SSIS is

    • 2

    • 4

    • 1

    • 3

    Correct Answer
    A. 4
    Explanation
    The correct answer is 4 because SSIS (SQL Server Integration Services) allows the creation and management of container tasks, which are used to group and organize other tasks. These container tasks can be used to control the flow of data and operations within a package. The question asks for the total number of container tasks available in SSIS, and the correct answer is 4.

    Rate this question:

  • 7. 

    Dimension and cube processing can be scheduled using SSIS

    • True

    • False

    Correct Answer
    A. True
    Explanation
    SSIS (SQL Server Integration Services) is a powerful ETL (Extract, Transform, Load) tool used for data integration and processing. It provides various components and tasks that allow scheduling and automating data workflows. With SSIS, dimension and cube processing can be scheduled by configuring appropriate tasks and workflows in the SSIS package. This allows for efficient and automated processing of dimensions and cubes in a data warehouse or OLAP environment. Therefore, the statement that dimension and cube processing can be scheduled using SSIS is true.

    Rate this question:

  • 8. 

    What Is BCP?

    • Bulk copy program.

    • Business continuity program

    • Both

    • None

    Correct Answer
    A. Bulk copy program.
    Explanation
    The correct answer is "Bulk copy program." BCP stands for Bulk copy program, which is a tool used to transfer large amounts of data between databases. It is commonly used for data migration or data loading purposes. The other options, "Business continuity program" and "Both" are incorrect as they do not accurately define what BCP stands for.

    Rate this question:

  • 9. 

    Which tasks run data flows to extract data, apply column level transformations, and load data? 

    • Data Flow Tasks

    • Data Preparation Tasks

    • Workflow Tasks

    • SQL Server tasks

    Correct Answer
    A. Data Flow Tasks
    Explanation
    Data Flow Tasks are responsible for running data flows to extract data, apply column level transformations, and load data. These tasks allow users to define the flow of data from various sources, apply transformations to the data, and then load it into the desired destination. This can include tasks such as extracting data from databases or files, applying transformations like filtering or aggregating, and finally loading the transformed data into a target database or file.

    Rate this question:

  • 10. 

    What are types of components available in Data flow task?

    • Container

    • Source

    • Destination

    • Transformation

    Correct Answer(s)
    A. Source
    A. Destination
    A. Transformation
    Explanation
    The question is asking about the types of components available in a Data Flow task. The correct answer is "Source, Destination, Transformation." In a Data Flow task, a source component is used to retrieve data from a specific data source, a destination component is used to write data to a specific destination, and a transformation component is used to modify or manipulate the data as it flows through the task. These three types of components are essential for building data integration and ETL (Extract, Transform, Load) processes.

    Rate this question:

  • 11. 

    Which of the following show flow of data from the corresponding sources to the referred destinations

    • control flow

    • data flow

    • Transformation

    • None of these

    Correct Answer
    A. data flow
    Explanation
    The correct answer is "data flow" because data flow refers to the movement of data from one source to a specific destination. It involves the transfer of data between different components or systems, ensuring that the data is processed and delivered to the intended recipients. Control flow, on the other hand, refers to the order in which instructions are executed within a program or system. Transformation may involve modifying or converting data, but it does not necessarily involve the movement of data from one source to a destination. Therefore, the answer "data flow" best represents the flow of data from sources to destinations.

    Rate this question:

  • 12. 

    The column in a table is set to read only then can we create a new column using derived column?

    • True

    • False

    Correct Answer
    A. True
    Explanation
    If a column in a table is set to read-only, it means that it cannot be modified directly. However, creating a new column using a derived column is still possible. Derived columns are calculated based on the values of other columns, so they do not directly modify the read-only column. Therefore, it is true that we can create a new column using derived columns even if the original column is set to read-only.

    Rate this question:

  • 13. 

    You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com. In order to specify the XML configuration during package development, you should apply the configuration to the deployed package. Which is the correct answer? 

    • You should utilize the Publish utility.

    • You should utilize the default command line utility.

    • You should utilize the exec command line utility.

    • You should utilize the DTEXEC command line utility.

    Correct Answer
    A. You should utilize the DTEXEC command line utility.
    Explanation
    The DTEXEC command line utility is used to execute SSIS packages and allows for the specification of XML configuration during package development. This utility provides a way to pass configuration values to the package at runtime, allowing for flexibility and customization. Utilizing the DTEXEC command line utility is the correct approach for specifying XML configuration in this scenario.

    Rate this question:

  • 14. 

    How you can notify the staff members about package failure?

    • Send Mail Task

    • Notification from SQL Agent

    • Can’t send notification automatically

    Correct Answer(s)
    A. Send Mail Task
    A. Notification from SQL Agent
    Explanation
    The correct answer is "Send Mail Task." This is because the Send Mail Task allows you to send an email notification to the staff members about a package failure. The Notification from SQL Agent is not a suitable option as it is mentioned that it cannot send notifications automatically.

    Rate this question:

  • 15. 

    What are the options to avoid changes to the package by an unknown user?

    • EncryptAllWithPassword

    • Encrypt

    • EncryptWithPwd

    • EnablePassword

    Correct Answer
    A. EncryptAllWithPassword
    Explanation
    To avoid changes to the package by an unknown user, the option "EncryptAllWithPassword" is the correct answer. This option suggests encrypting the entire package with a password, ensuring that only authorized users with the password can make changes to the package. This provides an added layer of security and prevents unauthorized access or modifications by unknown users.

    Rate this question:

  • 16. 

    How many types of ssis connection managers are there?

    • 4

    • 5

    • 19

    • 6

    Correct Answer
    A. 19
  • 17. 

    What conditions can be given to preceednce constraints?

    • Constraint

    • Expression

    • All of the above

    • None of the above

    Correct Answer
    A. All of the above
    Explanation
    Precedence constraints can be given various conditions depending on the specific requirements of the task. These conditions can be expressed through constraints, expressions, or a combination of both. Therefore, "All of the above" is the correct answer as it encompasses all possible conditions that can be given to precedence constraints.

    Rate this question:

  • 18. 

    How to execute a bat/cmd files from SSIS tasks?

    • Execute Package Task

    • Execute Process Task

    • Execute SQL Task

    • None of the listed options

    Correct Answer
    A. Execute Process Task
    Explanation
    The correct answer is Execute Process Task. This task allows you to execute a batch file or a command file from within SSIS. It provides options to specify the file path, arguments, and working directory for the file to be executed. This task is commonly used when you need to run external processes or scripts as part of your SSIS package.

    Rate this question:

  • 19. 

    Merge join works as 

    • Left right full

    • Self right outer

    • Inner left full

    • Right outer join

    Correct Answer
    A. Inner left full
    Explanation
    Merge join works as an inner join that returns only the matching rows from both the left and right tables. It combines the rows from both tables based on the specified join condition, discarding any unmatched rows. The result set includes all columns from both tables.

    Rate this question:

  • 20. 

    You are creating a SQL Server 2008 Integration Services (SSIS) package which gets information from a FTP server through utilizing many FTP tasks and operate information through utilizing many Execute SQL tasks for Company.com. After the package downloads the files, you should make sure that you could set the package to restart. In order to solve the problem, which is the correct answer?

    • You should set the HTTP tasks to hold transactions Log.

    • You should set the Execute SQL store procedure to hold transactions Log.

    • You should transfer the half HTTP job to a sequence container.

    • You should set the package to utilize a checkpoint.

    Correct Answer
    A. You should set the package to utilize a checkpoint.
    Explanation
    The correct answer is to set the package to utilize a checkpoint. A checkpoint allows the package to restart from the point of failure, ensuring that any completed tasks are not repeated. This is important in this scenario because the package is downloading files from an FTP server and operating on the information using Execute SQL tasks. If the package fails during this process, utilizing a checkpoint will allow it to resume from where it left off, preventing duplicate downloads or SQL operations.

    Rate this question:

  • 21. 

    Which of the following BI technique can predict value for a specific data item attribute?

    • Predictive modeling

    • Modeling

    • Predictive value

    • Association

    Correct Answer
    A. Predictive modeling
    Explanation
    Predictive modeling is a business intelligence technique that uses historical data and statistical algorithms to make predictions about future outcomes. It can analyze patterns and relationships within the data to forecast values for specific data item attributes. By training the model on past data, it can make accurate predictions about future values, allowing businesses to make informed decisions and plan accordingly. This technique is widely used in various industries, such as finance, marketing, and healthcare, to predict customer behavior, sales trends, and disease outbreaks, among other things.

    Rate this question:

  • 22. 

    You are creating a SQL Server 2008 Integration Services (SSIS) package on a SQL Server 2008 database for Company.com. In order to develop a failure recovery plan that is published for a SQL Server. Which is the correct answer?

    • You should back up the master database.

    • You should back up the local database.

    • You should back up the system database.

    • You should back up the systemdb databse.

    Correct Answer
    A. You should back up the master database.
    Explanation
    The master database in SQL Server 2008 contains the system configuration information and metadata for all other databases on the server. It is crucial to back up the master database in order to ensure that the server can be recovered in case of a failure. Backing up the local database, system database, or systemdb database alone would not be sufficient for a complete failure recovery plan.

    Rate this question:

  • 23. 

    Default Isolation level in SSIS?

    • Read Uncommitted

    • Read Committed

    • Serializable

    • Snapshot

    Correct Answer
    A. Serializable
    Explanation
    The default isolation level in SSIS is Serializable. This means that transactions are executed in a way that ensures data consistency by preventing other transactions from accessing the data until the current transaction is completed. This ensures that the data remains unchanged and consistent during the transaction process.

    Rate this question:

  • 24. 

    You work as a senior database developer at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment. You are running a training exercise for Microsoft SQL Server 2012 junior developers. You are discussing the ValidateExternalMetaData property for a data flow. Which of the following represents the data type for this property? 

    • Integer

    • IDTSExternalMetadataColumn100

    • String

    • Boolean

    Correct Answer
    A. Boolean
    Explanation
    The ValidateExternalMetaData property for a data flow in Microsoft SQL Server 2012 is of the data type Boolean. This means that the property can have a value of either true or false, indicating whether or not the external metadata should be validated.

    Rate this question:

  • 25. 

    What are the different types of containers in SSIS

    • Foreach Loop Container

    • For Loop Container

    • Sequence Container

    • Task Host Container

    Correct Answer(s)
    A. Foreach Loop Container
    A. For Loop Container
    A. Sequence Container
    A. Task Host Container
    Explanation
    The correct answer is a list of different types of containers in SSIS. These containers are used to group and organize tasks in an SSIS package. The Foreach Loop Container is used to iterate over a collection, such as files in a folder. The For Loop Container is used to repeat a set of tasks a specified number of times. The Sequence Container is used to group tasks together and define their execution order. The Task Host Container is a placeholder container used to host individual tasks.

    Rate this question:

  • 26. 

    You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow. Every source database is belongs to a different server and based on a SELECT statement which utilizes an ORDER BY clause. The data flow is listed below: You get error message below when you connect the paths from the two sources "Data Flow Task: The input is not sorted. The 'input "Merge Join Left Input" (80)' must be sorted." You should make sure that data from every search is contained in every row in the data flow. In order to solve the problem, which is the correct answer? 

    • You should increase a Lookup transformation for some data flows.

    • You should increase a Lookup transformation for every data flow.

    • You should refresh the sorting properties in each source component.

    • You should choose a default transformation

    Correct Answer
    A. You should refresh the sorting properties in each source component.
    Explanation
    In order to solve the error message "The input is not sorted" and ensure that data from every source is contained in every row in the data flow, the correct answer is to refresh the sorting properties in each source component. This means that the ORDER BY clause in the SELECT statement should be properly configured and applied in each source component to ensure that the data is sorted correctly before it is merged in the data flow.

    Rate this question:

  • 27. 

    You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment. You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing the use of Slowly Changing Dimension Transformation Outputs. One of the output options causes Derived Column transformations to create columns for the expired row and the current row indicators. Which option is the output that causes this?

    • Inferred Member Updates Output

    • Historical Attributes Inserts Output

    • Fixed Attribute Output

    • Changing Attributes Updates Output

    Correct Answer
    A. Historical Attributes Inserts Output
    Explanation
    The output option that causes Derived Column transformations to create columns for the expired row and the current row indicators is the Historical Attributes Inserts Output. This option is used when there are changes in historical attributes and it inserts new rows with the updated attributes, while also keeping the expired rows with indicators to distinguish them from the current rows.

    Rate this question:

  • 28. 

    In the event of an Execute SQL task failing, changes made by all of the Execute SQL tasks is rolled back.To do that which of the following is the value that must be set for the TransactionOption property of the package?

    • NotSupported

    • Supported

    • Required

    • NotRequired

    Correct Answer
    A. Required
    Explanation
    If the TransactionOption property of the package is set to "Required", it means that the package requires a transaction to be started. In the event of an Execute SQL task failing, the changes made by all of the Execute SQL tasks will be rolled back, ensuring that the database remains in a consistent state.

    Rate this question:

  • 29. 

    OLEDB connection manager supports 

    • MySql

    • Oracle

    • DB2

    • Sql Server

    • Teradata

    Correct Answer(s)
    A. MySql
    A. Oracle
    A. DB2
    A. Sql Server
    A. Teradata
    Explanation
    The OLEDB connection manager supports various database systems, including MySql, Oracle, DB2, Sql Server, and Teradata. This means that it can establish connections and interact with these databases using the OLEDB technology.

    Rate this question:

  • 30. 

    You need to control the execution behavior of the package by manipulating the SuccessValue of the task, When can this manipulation can  take affect?

    • FailTaskIfReturnCodeIsNotSuccessValue

    • None of the listed options

    • ReturnErrorCode

    • FailTaskCodeIsNotSuccessValue

    Correct Answer
    A. FailTaskIfReturnCodeIsNotSuccessValue
    Explanation
    The manipulation of the SuccessValue can take effect when the task fails to return the success value. In this case, the task will fail if the return code is not equal to the SuccessValue.

    Rate this question:

  • 31. 

    You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server table on Server A. The package includes a data flow and is executed on ServerB. The destination table has its own identity column. The destination data load has the following requirements:   ÂŸ1. The identity values from the source table must be used.Ÿ2. Default constraints on the destination table must be ignored.Ÿ3. Batch size must be 100,000 rows.   You need to add a destination and configure it to meet the requirements. Which destination should you use? 

    • SQL Server Destination

    • OLE DB Destination with Fast Load

    • ADO NET Destination without Bulk Insert

    • OLE DB Destination without Fast Load

    Correct Answer
    A. OLE DB Destination with Fast Load
    Explanation
    The OLE DB Destination with Fast Load should be used because it allows for the use of identity values from the source table, ignores default constraints on the destination table, and has the ability to load data in batches of 100,000 rows.

    Rate this question:

  • 32. 

    You want to run the subsequent container in the Control flow task only if the preceding container with execute sql task sets a variable with a appropriate value, what type of evaluation option is required?

    • Expression

    • Constraint OR Expression

    • Constraint AND Expression

    • All of the listed options

    • Constraint

    Correct Answer
    A. Constraint AND Expression
    Explanation
    The correct answer is "Constraint AND Expression". In order for the subsequent container to run only if the preceding container sets a variable with an appropriate value, both a constraint and an expression need to be used. The constraint will ensure that the subsequent container is only executed if the condition is met, and the expression will evaluate the value of the variable to determine if it is appropriate.

    Rate this question:

  • 33. 

    You are in the process of creating a SQL Server Integration Services (SSIS) project. You have created an initial package that is configured to include a connection manager that was created at the package level. The connection manager is used to access a flat file.Subsequent to creating more packages within the project, you change the package ConnectionManager in the initial package to a project Connection Manager.Which of the following is a reason for doing so?

    • It allows all packages in the project to access the flat file.

    • It only allows the initial package in the project to access the flat file.

    • It only allows the additional packages in the project to access the flat file.

    • It prevents all packages in the project from accessing the flat file.

    Correct Answer
    A. It allows all packages in the project to access the flat file.
    Explanation
    By changing the package ConnectionManager to a project Connection Manager, all packages in the project are able to access the flat file. This means that any new packages created within the project will be able to use the same connection manager to access the flat file without the need to create a new one. This promotes reusability and consistency across the project, as all packages can now share the same connection manager and access the flat file in a standardized manner.

    Rate this question:

  • 34. 

    Which options can be used to group/ungroup components?

    • Control Flow Tasks

    • Data Flow Tasks

    • Event Handlers

    • Maintenence Tasks

    Correct Answer
    A. Control Flow Tasks
    Explanation
    Control Flow Tasks can be used to group/ungroup components in a system. Control Flow Tasks are used to define the workflow and sequence of tasks in an SSIS package. They allow for the logical grouping and ordering of components, making it easier to manage and maintain the package. By using Control Flow Tasks, components can be grouped together and executed in a specific order, ensuring that the package runs smoothly and efficiently.

    Rate this question:

  • 35. 

    What Other sources can be downloaded in Microsoft website?

    • Orcale

    • Teradata

    • SAPBI

    • My sql

    Correct Answer(s)
    A. Orcale
    A. Teradata
    A. SAPBI
    A. My sql
  • 36. 

    You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment. You are hosting a training exercise for Microsoft SQL Server 2012 administrators. You are currently discussing Multicast transformation. Which of the following is TRUE with regards to Multicast transformation?

    • It prevents a package from creating logical copies of data.

    • It allows a package to create logical copies of data.

    • It distributes its input to one or more outputs.

    • It distributes its input to a single output.

    Correct Answer(s)
    A. It allows a package to create logical copies of data.
    A. It distributes its input to one or more outputs.
    Explanation
    The Multicast transformation in Microsoft SQL Server 2012 allows a package to create logical copies of data and also distributes its input to one or more outputs. This means that the Multicast transformation can be used to split the data flow into multiple paths, allowing for parallel processing or routing the data to different destinations.

    Rate this question:

  • 37. 

    What do you understand by design limitation in SSIS package?

    • Making use of parallelism

    • Not making use of parallelism

    • Package uses few single-threaded tasks.

    • None of the mentioned

    Correct Answer
    A. Not making use of parallelism
    Explanation
    The design limitation in an SSIS package refers to the constraint of not utilizing parallelism. This means that the package is not designed to execute multiple tasks simultaneously, but rather relies on a single-threaded approach. This limitation can impact the performance and efficiency of the package, as it may not be able to take advantage of the available system resources and execute tasks concurrently.

    Rate this question:

  • 38. 

    You have recently created an SQL Server Integration Services (SSIS) project catalog that contains two Environments. A single Environment Variable, named ConnectionString, of type string is specified by each environment. The project also has a project Connection Manager configured to link up with the data warehouse.You have been instructed to make sure that deployed packages are executed using any of the specified Environments.Which of the following suitably describes an Environment Variable?

    • An environment variable specifies the data that will be used by a package.

    • An environment variable can be used to manage Integration Services objects in the catalog.

    • An environment variable defines a literal value that can be assigned to a parameter during package execution.

    • An environment variable allows you to use folders to organize your projects and environments

    Correct Answer
    A. An environment variable defines a literal value that can be assigned to a parameter during package execution.
    Explanation
    An environment variable defines a literal value that can be assigned to a parameter during package execution. This means that the variable can hold a specific value that can be used within the package at runtime. It allows for flexibility and customization, as different values can be assigned to the variable depending on the specific execution scenario. This helps in managing and configuring the package to use different values based on the environment it is being executed in.

    Rate this question:

  • 39. 

    You develop a series of SQL Server 2008 Integration Services (SSIS) packages. There are dependencies among the packages. You need to configure the packages. Which configuration type should you use? 

    • Parent package variable

    • Registry entry

    • Environment variable

    • XML configuration file

    Correct Answer
    A. XML configuration file
    Explanation
    To configure the dependencies among the SQL Server 2008 Integration Services (SSIS) packages, using an XML configuration file would be the most suitable option. XML configuration files allow you to store and manage package configurations separately from the packages themselves. This provides flexibility in modifying the configurations without having to modify the packages directly. Additionally, XML configuration files can be easily shared and applied to multiple packages, making it an efficient method for managing dependencies among the packages.

    Rate this question:

  • 40. 

    Which of the following is not a feature of SQL Server 2008 R2 Enterprise? 

    • Hot-add CPU

    • Hot-add RAM

    • Database partitioning

    • In memory database

    Correct Answer
    A. In memory database
    Explanation
    SQL Server 2008 R2 Enterprise does not have the feature of an in-memory database. In-memory databases are a feature introduced in later versions of SQL Server, such as SQL Server 2014 and SQL Server 2016. This feature allows for faster data processing by storing data in memory rather than on disk. However, in SQL Server 2008 R2 Enterprise, this feature is not available.

    Rate this question:

  • 41. 

    How many components are present in SSIS Toolbox? 

    • 7

    • 6

    • 5

    • 4

    Correct Answer
    A. 4
    Explanation
    There are 4 components present in the SSIS Toolbox.

    Rate this question:

  • 42. 

    You administer an instance of a SQL Server 2008 server. The server is used to execute SQL Server 2008 Integration Services (SSIS) packages. You need to ensure that the server executes only correctly signed packages.   What should you do?

    • Set the package protection level on all packages to DontSaveSensitive.

    • Set the BlockedSignatureStates registry entry to Block invalid and untrusted signatures and unsigned packages

    • Set the package protection level on all packages to EncryptSensitiveWithPassword.

    • Set the BlockedSignatureStates registry entry to NoAdministrativeRestriction

    Correct Answer
    A. Set the BlockedSignatureStates registry entry to Block invalid and untrusted signatures and unsigned packages
    Explanation
    Setting the BlockedSignatureStates registry entry to "Block invalid and untrusted signatures and unsigned packages" will ensure that the server executes only correctly signed packages. This setting will block any packages that have invalid or untrusted signatures, as well as unsigned packages. By enforcing this restriction, the server will only execute packages that have been properly signed and verified, ensuring the integrity and security of the execution process.

    Rate this question:

  • 43. 

    You design a SQL Server 2008 Integration Services (SSIS) package. The package assigns a value to a variable by using a Script task. When the package executes successfully, the value of the variable is not updated. You need to modify the package so that the Script task can assign the value of the variable. What should you do? 

    • Modify the variable scope to the package.

    • Modify the RaiseChangedEvent property of the variable.

    • Modify the EvaluateAsExpression property of the variable.

    • Modify the variable scope to the script task.

    Correct Answer
    A. Modify the variable scope to the package.
    Explanation
    The correct answer is to modify the variable scope to the package. By doing this, the variable will be accessible throughout the entire package, including the Script task. This will allow the Script task to assign a value to the variable and update its value successfully.

    Rate this question:

  • 44. 

    If you need to create a sequence number for input records, which transformation will you use?

    • Script component

    • Derived column

    • Row Count

    • None

    Correct Answer
    A. Script component
    Explanation
    The Script component is the correct answer because it allows you to write custom code in various programming languages, such as C# or VB.NET, to perform complex transformations on input records. With the Script component, you can create a sequence number for each input record by implementing logic to increment a counter variable for each record processed. This provides the flexibility to generate a unique sequence number based on specific requirements or business rules. The Derived column transformation is used to create new columns based on expressions or calculations, but it does not provide the capability to generate a sequence number. The Row Count transformation simply counts the number of rows passing through it and does not generate a sequence number.

    Rate this question:

  • 45. 

    We can insert record in Lookup Table by using Lookup Transformation

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement is false because a Lookup Transformation is used to retrieve data from a source based on a matching condition, not to insert records into a lookup table.

    Rate this question:

  • 46. 

    What are different ways to execute your SSIS Package?

    • By using BIDS/ SSDT

    • DtExecUI

    • Dtexec.exe

    • SQL Server Agent Job

    • Run SSIS Package Programmatically

    • Windows Scheduler or Any third party Scheduler

    Correct Answer(s)
    A. By using BIDS/ SSDT
    A. DtExecUI
    A. Dtexec.exe
    A. SQL Server Agent Job
    A. Run SSIS Package Programmatically
    A. Windows Scheduler or Any third party Scheduler
    Explanation
    The different ways to execute an SSIS Package include using BIDS/SSDT, DtExecUI, Dtexec.exe, SQL Server Agent Job, running the package programmatically, and using Windows Scheduler or any third-party scheduler. These methods provide flexibility in executing the SSIS Package based on the specific requirements and environment.

    Rate this question:

  • 47. 

    What are the main component of SSIS (project-architecture)?

    • SSIS service

    • SSIS runtime engine & runtime executables

    • SSIS dataflow engine & dataflow components

    • SSIS clients

    • All the above

    Correct Answer(s)
    A. SSIS service
    A. SSIS runtime engine & runtime executables
    A. SSIS dataflow engine & dataflow components
    Explanation
    The correct answer is "All the above." The main components of SSIS project architecture include the SSIS service, SSIS runtime engine and runtime executables, SSIS dataflow engine and dataflow components, and SSIS clients.

    Rate this question:

  • 48. 

    Which of the following is TRUE with regards to the Fuzzy Lookup similarity threshold setting?

    • Increasing the threshold can improve the speed of matching.

    • Increasing the threshold can deteriorate the speed of matching

    • The nearer the value is to 1, the nearer the resemblance of the lookup value to the source value must be to qualify as a match

    • The nearer the value is to 1, the further the resemblance of the lookup value to the source value must be to qualify as a match.

    Correct Answer(s)
    A. Increasing the threshold can improve the speed of matching.
    A. The nearer the value is to 1, the nearer the resemblance of the lookup value to the source value must be to qualify as a match
    Explanation
    Increasing the threshold can improve the speed of matching because a higher threshold allows for a broader range of similarity between the lookup value and the source value to qualify as a match. This means that the algorithm does not have to spend as much time and resources comparing and evaluating potential matches. Additionally, the statement that "the nearer the value is to 1, the nearer the resemblance of the lookup value to the source value must be to qualify as a match" further supports the idea that increasing the threshold allows for a looser definition of similarity, which can lead to faster matching.

    Rate this question:

  • 49. 

    You are creating a SQL Server 2008 Integration Services (SSIS) instance for Company.com. The package is listed below: You should make sure that you create a parameter which includes important information that is only useful to the Data Flow Task and the Execute SQL Task and so on. Which is the correct answer? 

    • You should develop the parameter at the default scope.

    • You should develop the parameter at the Control Flow Job scope.

    • You should develop the parameter at the Running SQL Job scope.

    • You should develop the parameter at the Sequence Container scope.

    Correct Answer
    A. You should develop the parameter at the Sequence Container scope.

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, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 05, 2016
    Quiz Created by
    Akshay Mishra
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.