Explore topic-wise MCQs in Testing Subject.

This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.

1.

You work as a database administrator at Abc.com. Your duties include managing a SQL Server 2008 Analysis Services (SSAS) sample. The SSAS sample includes a database that is used by members of the Sales group. You create a new role named Northern Region using {[Product]. [Place]. [Place]. [Northern]} allowed permission configuration. You assign the Sales group to the Northern Region role. You need to ensure that the users are able to browse data in the Northern Region role. What should you do?

A. You should consider enabling the Visual Totals check box.
B. You should consider adding the TESTID = Northern Region; parameter to the connection string.
C. You should consider adding the Roles= Northern Region; parameter to the connection string.
D. You should consider adding the User ID = Northern Region; parameter to the connection string.
Answer» D. You should consider adding the User ID = Northern Region; parameter to the connection string.
Discussion
2.

You work as a database administrator at Abc.com. Your duties include managing a SQL Server 2008 Analysis Services (SSAS) project. You need to include a parent-child hierarchy for the dimension. The child key feature is named CKUser and the parent key feature is named CKManager. As the root member you need to ensure that the top user is included. What should you do?

A. You should set the IsAggregatable property of CKUser to true.
B. You should set the IsNotAggregatable property of CKUser to false.
C. You should set the IsNotAggregatable property of CKManager to default.
D. You should set the IsAggregatable property of CKManager to false.
Answer» E.
Discussion
3.

You work as a database administrator for Abc.com. Your duties include managing a SQL Server 2008 Analysis Services (SSAS) instance for Abc.com. You need to deploy a data mining structure that contains the Microsoft Clustering mining model from Scalable K-Means to Non-scalable K-Means.What should you do?

A. You should modify the MODELLING_CARDINALITY property.
B. You should modify the CLUSTERING_METHOD property.
C. You should modify the INDEXDEFRAG property.
D. You should modify the MSDB SHRINKFILE property.
Answer» C. You should modify the INDEXDEFRAG property.
Discussion
4.

You work as a database administrator for Abc.com. You are in the process of developing a model of data mining by using the SQL Server 2008 Analysis Services (SSAS). In order to develop a structure you use the listed Data Mining Extensions (DMX) code:CREATE MINING STRUCTURE [Abc] ([User Key] LONG KEY,[Total Age] LONG DISCRETIZED (Automatic,20),[Abc] LONG DISCRETE,[Distance] TEXT DISCRETE,[Monthly Income] DOUBLE CONTINUOUS) You need to develop the mining model that will use the above structure and in addition also use Microsoft algorithm. What should you do?

A. You should consider inserting the following code: ALTER MINING STRUCTURE [Abc] ADD MINING MODEL [Decision Tree] ([User Key], [Total Age], [Abc] PREDICT, [Distance], [Monthly Income])
B. You should consider inserting the following code: INSERT INTO [Decision Tree] ([User Key], [Abc], [Monthly Income]) OPENQUERY ([Abc],Select [User Key], [Abc], [Monthly Income])
C. You should consider inserting the following code: SELECT * FROM [Decision Tree] USING [Microsoft_Decision_Trees] FROM [Decision Tree]]
D. You should consider inserting the following code
Answer» B. You should consider inserting the following code: INSERT INTO [Decision Tree] ([User Key], [Abc], [Monthly Income]) OPENQUERY ([Abc],Select [User Key], [Abc], [Monthly Income])
Discussion
5.

You work as a database administrator for Abc.com. You are using a Business Intelligence Development Studio (BIDS) project for a data mining structure. You want to change the settings on the Chart tab. What will the result be?

A. It will result in the trend in the lift chart staying unchanged and the trend in the profit chart is displayed.
B. It will result in the trend in the lift chart staying unchanged and the trend in the profit chart is modified.
C. It will result in the trend in the lift chart staying unchanged and the trend in the profit chart is changed.
D. It will result in the trend in the lift chart changing and the trend in the profit chart being updated.
Answer» D. It will result in the trend in the lift chart changing and the trend in the profit chart being updated.
Discussion
6.

You work as a database administrator for Abc.com. Your duties include managing a SQL Server 2008 Analysis Services (SSAS) project for Abc.com. You need to scrutinize different data mining theories. You have to modify the design of the data mining structure to test. You decide to add the ordered content type columns in the data mining model as well as the underlying case table. You need to ensure that the Data Mining Viewer is suitable for modification in the data mining structure as well as the data mining model technology. What should you do?

A. You should consider selecting ProcessFull.
B. You should consider selecting INDEXDEFRAG in Data Mining Viewer.
C. You should consider selecting SHRINKFILE in Data Mining Viewer.
D. You should consider selecting VIEWDELETE in Data Mining Viewer.
Answer» B. You should consider selecting INDEXDEFRAG in Data Mining Viewer.
Discussion
7.

You work as a database administrator for Abc.com. You are currently creating a SQL Server 2008 Analysis Services (SSAS) solution for Abc.com. Your solution contains a data source view (DSV) that owns a table named CKUsers. The CKUsers table contains a field named UserKey and a field named ManagerKey. The ManagerKey references the manager of the Abc.com user. You need to create a relationship between the users and their managers in the DSV. What should you do?

A. You should consider developing a View that makes use of UserKey and ManagerKey.
B. You should consider developing a Measure that makes use of a relationship with UserKey as the source column and ManagerKey as the destination column.
C. You should consider developing a Query that makes use of a relationship with UserKey as the source column and ManagerKey as the destination column.
D. You should consider developing a relationship as the source column and UserKey as the destination column using the ManagerKey.
Answer» E.
Discussion
8.

You work as a database administrator for Abc.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) project for Abc.com. CubeA has a time dimension named CKTime that has an attribute named Month and a fact table named FactUsersTable. You need to include different hierarchies in the CKTime dimension. What should you do?

A. You should consider designing three dimension usage relationships between the CKTime dimension as well as the FactUsersTable fact table.
B. You should consider designing a single dimension usage relationship between the CKTime dimension as well as the FactUsersTable fact table by identifying a one-to-one relationship.
C. You should consider designing two dimension usage relationships between the CKTime dimension as well as the FactUsersTable fact table by identifying a regular relationship.
D. You should consider designing two dimension usage relationships between the CKTime dimension as well as the FactUsersTable fact table by identifying a many-to-many relationship.
Answer» D. You should consider designing two dimension usage relationships between the CKTime dimension as well as the FactUsersTable fact table by identifying a many-to-many relationship.
Discussion
9.

You work as a database administrator for Abc.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) project for Abc.com. You create a cube that uses a dimension named DimCKUsers. The dimension has a property named User. Abc.com also hosts a Microsoft SQL Server 2008 Reporting Services (SSRS) project that includes a report on a user. You need to determine a way to browse the data. What should you do?

A. You should consider setting up a URL action on the User feature.
B. You should consider setting up a DataSet action on the User feature.
C. You should consider setting up a DataTable action on the DimCKUsers dimension.
D. You should consider setting up a Drillthrough action on the DimCKUsers dimension.
Answer» B. You should consider setting up a DataSet action on the User feature.
Discussion
10.

Which of the following places is considered a Jain Siddha Kshetra on account of its association with Parsvanatha ?

A. Champa
B. Pava
C. Sammed Sikhar
D. Urjayanta
Answer» D. Urjayanta
Discussion
11.

You work as a database administrator for Abc.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) database. You are in the process of creating a new measure group in a cube. Abc.com has an application that keeps the partitions on the production copy of the cube. You need to obtain the cube definition on the production server while ensuring that you do not overwrite any existed partitions. What should you do?

A. You should consider using the Deployment Wizard in conjunction with the proper selection.
B. You should consider using a SQL Server 2008 Integration Services (SSIS) package Thereafter the processing selection should be set to Do Process.
C. You should consider using the SQL Server Analysis Services Data source component in Microsoft SQL Server Integration Services (SSIS).
D. You should consider using the DBCC SHRINKFILE. Thereafter the processing selection should be set to Do Process.
Answer» B. You should consider using a SQL Server 2008 Integration Services (SSIS) package Thereafter the processing selection should be set to Do Process.
Discussion
12.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package on a development server named ABCDB03. The SSIS package obtains data that will be inserted in a database named CKProducts from a remote SQL Server 2008 database server named TESKING-DB01. The data is published to the MSDB database on a production server named ABC-DB02. You should make sure that only users belonging to the appropriate database role are able to change and run the package. What should you do?

A. You should assign the users to the db_system role.
B. You should assign the users to a pre-defined security role.
C. You should assign the users to a common database role in the default database.
D. You should assign the users to a common database role in the MSDB database.
Answer» E.
Discussion
13.

You work as a database administrator for Abc.com. You are in the process of creating a SQL Server 2008 Analysis Services (SSAS) solution for Abc.com. The SSAS solution includes a time dimension named CKTime which includes a hierarchy named Year-By-Day. The solution also contains a measure group named CKMeasure. You own a measure named Quantity from CKMeasure. You need to develop a calculated member in order to show the Quantity measure in the previous time period for the current level of the Year-By-Day hierarchy. What should you do?

A. You should use [CKMeasures].[Quantity],OPENINGPERIOD([CKTime].[Year-By- Day].FirstSibling.Level)) as a calculated member.
B. You should use ([CKMeasures].[Quantity],LASTPERIODS(0,[CKTime].[Year- By- Day].PrevMember)) as a calculated member.
C. You should use ([CKMeasures].[Quantity],LASTPERIODS(1,[CKTime].[Year- By- Day].PrevMember)) as a calculated member.
D. You should use ([CKMeasures].[Quantity],[CKTime].[Year-By- Day].NextSibling) as a calculated member.
Answer» D. You should use ([CKMeasures].[Quantity],[CKTime].[Year-By- Day].NextSibling) as a calculated member.
Discussion
14.

You work as a database administrator for Abc.com. You are currently creating a SQL Server 2008 Analysis Services (SSAS) method for Abc.com. The solution contains a dimension named CKProducts and a time dimension named CKTimer. Abc has a fact table that has a field named Quantity. You need to develop a measure named CKQuantity from the Quantity field order to display the number of products for certain times. What should you do?

A. The AggregationFunction property of CKQuantity should be set to Total.
B. The AggregationFunction property of CKQuantity should be set to Predict.
C. The AggregationFunction property of CKQuantity should be set to LastNonEmpty.
D. The AggregationFunction property of CKQuantity should be set to FirstEmpty.
Answer» D. The AggregationFunction property of CKQuantity should be set to FirstEmpty.
Discussion
15.

You work as a database administrator at Abc.com. The Abc.com network contains a production database server named ABC-DB01. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package. The SSIS package is stored in a folder on ABC-DB01. All Abc.com users must be able to view the package but must not be able to view the attribute values. You need to ensure that the attribute values are protected by password. What should you do?

A. You should make use of a batch file that runs the dtutil program in order to set the PackageProtectionLevel property to EncryptSensitiveWithPassword on the SSIS package.
B. You should make use of a batch file that runs the dtutil program in order to set the PackageProtectionLevel property to SaveSensitive on the SSIS package.
C. You should make use of the SSIS package designer in order to set the PackageProtectionLevel property to EncryptAllWithPassword on the SSIS package.
D. You should make use of the SSIS package designer in order to set the PackageProtectionLevel property to EncryptSensitiveWithUserKey on the SSIS package.
Answer» B. You should make use of a batch file that runs the dtutil program in order to set the PackageProtectionLevel property to SaveSensitive on the SSIS package.
Discussion
16.

You work as a database administrator at Abc.com. The Abc.com network contains a production database server named ABC-DB01. You have recently created a SQL Server 2008 Integration Services (SSIS) instance that you tested in a local development environment. You deploy the SSIS instance to ABC- DB01. You need to ensure that the protection level for users is configured when they run the package. What should you do?

A. You should use the EncryptPartWithUserKey option.
B. You should use the EncryptSensitiveWithLoginName option.
C. You should use the SaveSensitive option.
D. You should use the EncryptAllWithUserKey option.
Answer» E.
Discussion
17.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package. The SSIS package gets data from a FTP server by using numerous FTP tasks. The package also manages data using various Execute SQL tasks. You need to make sure that the package is set to restart after the package downloaded the files. What should you do?

A. You should consider configuring the HTTP tasks to hold transactions Log.
B. You should consider configuring the a store procedure to hold transactions Log.
C. You should consider transferring the half HTTP job to a sequence container.
D. You should consider configuring the package to use a checkpoint.
Answer» E.
Discussion
18.

Separating the mesosphere from the stratosphere is transition zone called-

A. Mesopause
B. Stratopause
C. Isothermal Layer
D. None of these
Answer» C. Isothermal Layer
Discussion
19.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. The SSIS package references packages in a SQL Server 2008 sample. You want to publish the SSIS package to another SSIS sample which reserves its packages in a common directory. What should you do?

A. You should consider running the dtutil command for the package.
B. You should consider running the taskrun.exe command for the package.
C. You should consider running the dtexeall command for the package.
D. You should consider running the default command for the package.
Answer» B. You should consider running the taskrun.exe command for the package.
Discussion
20.

Where was Mahavir Swami born ?

A. Kundagram
B. Pataliputra
C. Magadh
D. Vaishali
Answer» B. Pataliputra
Discussion
21.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. You make use of local development environment in order to check the package. You then publish the package to the file system on a production server named ABC-DB02. However, Abc.com users inform you that they are unable to access the package. You need to ensure that Abc.com users are able to access and run the package. What should you do?

A. You should use the SaveSensitive option.
B. You should use the ServerStorage option.
C. You should use the EncryptAllWithPassword option.
D. You should use the EncryptPartWithUserKey option.5)You should use the EncryptSensitiveWithLoginName option.
Answer» D. You should use the EncryptPartWithUserKey option.5)You should use the EncryptSensitiveWithLoginName option.
Discussion
22.

You work as a database administrator at Abc.com. Abc.com network contains a development database server named ABC-DB06 and a production database server named TESCKLING-DB01. You are creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. You include ABC-DB06 in the SSIS package. You publish the package to ABCDB06 but discover that you are not able to move the data between ABC-DB06 and ABC-DB01. You receive the following error message:The package could not link to ABC-DB06.You need to modify the package to reference the ABC-DB06 when it is implemented. What should you do?

A. You need to change the features of the package in order to use the DontSaveSensitive package protection level.
B. You need to change the features of the package in order to use the store procedure.
C. You need to select the Connection Manager check box on the Connection Managers tab of the Execute Package utility and then change the connection string.
D. You need to add to the expression on the Flat File Connection manager prior to modifying the connection string.
Answer» D. You need to add to the expression on the Flat File Connection manager prior to modifying the connection string.
Discussion
23.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) instance for Abc.com. The SSIS instance uses a default connection manager to connect to a component. You develop an XML configuration file to provide the required authentication information for your report. However, you receive an error message stating that you are unable to log in successfully to the package. You need to ensure that the package is able to run normally. What should you do?

A. You should consider modifying the XML configuration file.
B. You should consider using direct XML settings.
C. You should consider executing the package as the component on the same server.
D. You should consider using a .REG file that contains all log entries.
Answer» B. You should consider using direct XML settings.
Discussion
24.

You work as a database administrator at Abc.com. You are responsible for managing a SQL Server 2008 server instance. Abc.com makes use of The SSIS instance to run several SQL Server 2008 Integration Services (SSIS) packages. To ensure Abc.com productivity, you need to ensure that the database server runs normally. What should you do?

A. You should consider configuring the package protection level to EncryptPartWithPassword.
B. You should consider configuring package protection level to SaveSensitive.
C. You should consider configuring package protection level to EncryptSensitiveWithLoginName.
D. You should consider configuring the BlockedSignatureStates registry entries to Block unsafe, untrusted signs as well as unsigned instances.
Answer» E.
Discussion
25.

Current which flow from lower latitudes to higher latitudes are -

A. Cool current
B. Upwelling current
C. Tidal current
D. Warm Current
Answer» E.
Discussion
26.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. You want to specify the XML configuration for the package. What should you do?

A. You should use the Publish utility.
B. You should use the default command line utility.
C. You should use the subscriptions tab.
D. You should use the DTEXEC command line utility.
Answer» E.
Discussion
27.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) sample. The SSIS sample includes a number of data flows. You want to use Business Intelligence Development Studio to control the data that passes through each path in the data flow. However, you need to ensure that the data flow logic is not affected.What should you do?

A. You should use the Data Viewer tool.
B. You should use the Process Control tool.
C. You should use the Web service.
D. You should use the Fuzzy Grouping tool.
Answer» B. You should use the Process Control tool.
Discussion
28.

Periodic movement of the sea water is known as-

A. Tides
B. Waves
C. Current
D. Tsunami
Answer» B. Waves
Discussion
29.

You work as a database administrator at Abc.com. You are responsible for creating a SQL Server 2008 Integration Services (SSIS) instance. The SSIS instance contains a Data Flow task that reproduces millions of rows for Abc.com. The data flow checks for a match against a reference table that contains of 50,000 rows, including every row that will be used during the data flow. You need to ensure that the data flow runs in the least amount of time.What should you do?

A. You should consider selecting a Lookup transformation in conjunction with the half cache option.
B. You should consider selecting a Lookup transformation in conjunction with the Full cache option.
C. You should consider selecting a default Lookup transformation in conjunction with a Data Conversion transformation.
D. You should consider selecting a Lookup transformation in conjunction with the Default cache option.
Answer» C. You should consider selecting a default Lookup transformation in conjunction with a Data Conversion transformation.
Discussion
30.

Which if the following is a cool current-

A. North equatiorial current
B. Brazilian current
C. Kuroshio current
D. Humboldt current
Answer» E.
Discussion
31.

You work as a database administrator at Abc.com. You are responsible for managing a SQL Server 2008 Integration Services (SSIS) instance using Business Intelligence Development Studio. Abc.com makes use of a Common Data Flow component in the package that implement normally. You want to add a sample of the Common Data Flow component. However, the component does not appear in the toolbox. You need to add the Common Data Flow component to the toolbox. What should you do?

A. You should consider placing a copy of the assembly in the proper folder.
B. You should consider adding the assembly to the default Assembly Cache.
C. You should consider using the SYSTEM32 utility to recompile the assembly.
D. You should consider using the Assembly Registration Utility to recompile the assembly.
Answer» B. You should consider adding the assembly to the default Assembly Cache.
Discussion
32.

Which of the following is a warm current ?

A. Gulf stream
B. Humboldt current
C. Peruvian current
D. Benguela current
Answer» B. Humboldt current
Discussion
33.

Where was the third Buddhist Council held ?

A. Vatsa
B. Pataliputra
C. Kosambi
D. Kashmir
Answer» C. Kosambi
Discussion
34.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. The SSIS package must contain six Data Flow tasks and three Control Flow tasks. What should you do?

A. You should consider creating two Control Flow tasks and one Data Flow task on a container. Then the TransactionOption property of the container should be set to Supported.
B. You should consider creating two Control Flow tasks and one Data Flow task on a container. Then the TransactionOption property of the container should be set to NotSupported.
C. You should consider creating two Control Flow tasks and one Data Flow task on a container. Then the TransactionOption property of the container should be set to Required.
D. You should consider creating two Control Flow tasks and one Data Flow task on a container. Then the TransactionOption property of the container should be set to RequiredNew.
Answer» D. You should consider creating two Control Flow tasks and one Data Flow task on a container. Then the TransactionOption property of the container should be set to RequiredNew.
Discussion
35.

The coastline formed by the submergence of mountain ridges running parallel to the coast is known as

A. Dalmation coast
B. Ria coast
C. Fiord coast
D. Half coast
Answer» B. Ria coast
Discussion
36.

A submarine mountain rising more than 1000 meters above the ocean floor is known as-

A. Sea mount
B. abyssal hill
C. guyots
D. submarine ridge
Answer» B. abyssal hill
Discussion
37.

You work as a database administrator at Abc.com. The Abc.com network contains a SQL Server 2008 database server named ABC-DB01. You decide to create a SQL Server 2008 Integration Services (SSIS) package on ABCDB01. You need to develop a recovery plan for ABC-DB01. What should you do?

A. You should consider backing up the master database.
B. You should consider backing up the local database.
C. You should consider backing up the ownerdb database.
D. You should consider backing up the systemdb database.
Answer» B. You should consider backing up the local database.
Discussion
38.

You work as a database administrator at Abc.com. The Abc.com network contains 15 SQL Server 2008 database servers. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package that has to be interpolated on all 15 database servers. However, you are unable to access the file system of the servers. You thus need to modify the package setting attributes while the package is running. What should you do?

A. You should create an XML configuration file. Then you should select the XML configuration type in the SSIS Package Configurations Organizer.
B. You should create a batch file that makes use of the dtutil utility program in order to set the package configuration properties while the package deploys into production.
C. You should create a SQL Server Configuration type using the SSIS Package Configuration Wizard. Then you should select a centralized Microsoft SQL Server in order to store the package configuration.
D. You should create a Web services that will contain the data task flow that will store the entries for the configuration properties in the SSIS Package Configurations.
Answer» D. You should create a Web services that will contain the data task flow that will store the entries for the configuration properties in the SSIS Package Configurations.
Discussion
39.

The largest reserves of fresh water on the Earth s surface in-

A. North America
B. South America
C. Russia
D. Africa
Answer» B. South America
Discussion
40.

You work as a database administrator at Abc.com. You are currently creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. You decide to make use of the SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 failover cluster. You create a complex package which takes a considerable amount of processing time. You need to ensure that package can be restored if it runs while a failover is occurring. What should you do?

A. You should consider running a restore procedure in the package prior to restarting the package when a failover occurs.
B. You should consider adding the SSIS service to the SQL Server cluster resource group.
C. You should consider running checkpoints in the package prior to restarting the package when a failover occurs.
D. You should consider running the dtutil tools in the package prior to restarting the package when a failover occurs.
Answer» D. You should consider running the dtutil tools in the package prior to restarting the package when a failover occurs.
Discussion
41.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) instance that includes the following components:* An OnError method* A data flow job that is included in a For Loop container* A Flat File result component that uses a Flat File connection controller. You want to log error data from an expression that contains the package version to a Word file whenever an error occurs. What should you do?

A. You should consider using the VersionGUID variable.
B. You should consider using the GUID variable.
C. You should consider using the RunnerID variable.
D. You should consider using the USERID variable.
Answer» B. You should consider using the GUID variable.
Discussion
42.

Chinese traveller Hiuen Tsang studied at the University of-

A. Taxila
B. Vikramshila
C. Magadh
D. Nalanda
Answer» E.
Discussion
43.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow. The SSIS data flow obtains data from two databases that are hosted on two separate SQL Server 2008 database servers. Each source is based on a SELECT statement that includes an ORDER BY clause. However, you receive the following error message 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 need to ensure that the data from every query is contained in every row in the data flow. You thus need to determine a way to accomplish this. What should you do?

A. You should add a Lookup Transformation for each data flow.
B. You should add a Lookup Data Conversion for each data flow.
C. You should refresh the sorting properties in each source component.
D. You should add a Data Viewer object to the Data Flow.
Answer» D. You should add a Data Viewer object to the Data Flow.
Discussion
44.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow that adds the data from a source query to a result table for Abc.com. You want to add the rows that are included in the destination table. What should you do? (Choose all that apply)

A. You should consider using a Data Conversion Transformation and a Lookup Transformation.
B. You should consider using a Character Map Transformation and a Term Extraction Transformation.
C. You should consider using a Merge Join Transformation and a Lookup Transformation.
D. You should consider using a Data Mining Query Transformation and a Term Extraction Transformation.5)You should consider using a Character Map Transformation and a Data Mining Query Transformation.
Answer» D. You should consider using a Data Mining Query Transformation and a Term Extraction Transformation.5)You should consider using a Character Map Transformation and a Data Mining Query Transformation.
Discussion
45.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow. The SSIS data flow will transfer data to a SQL Server 2008 database named CKProducts. You want to ensure that the data flow refreshes the existing data in CKProducts with the data in the data flow. What should you do?

A. You should use the OLE DB Destination.
B. You should use the SQL Server Destination.
C. You should use a Data Conversion Transformation.
D. You should use the Fuzzy Grouping Transformation.
Answer» C. You should use a Data Conversion Transformation.
Discussion
46.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. The SSIS package must contain a Data Flow task with a Fuzzy Grouping transformation that creates data. You received instructions to debug the SSIS package. To this end you need to browse the output data of the Fuzzy Grouping transformation in order to check on the constraints currently on the Fuzzy Grouping transformation. What should you do?

A. You should consider adding a Data Viewer object to the Data Flow task.
B. You should consider adding a DBCC SHRINKFILE to the Data Flow task.
C. You should consider adding a web service to the Data Flow task.
D. You should consider adding a Transactions log to the Data Flow task.
Answer» B. You should consider adding a DBCC SHRINKFILE to the Data Flow task.
Discussion
47.

Which of the following is a continental shelf sea-

A. North sea
B. Arabian sea
C. Red sea
D. Mediterranean sea
Answer» D. Mediterranean sea
Discussion
48.

The challenger rise is located in -

A. The Pacific ocean
B. The Indian ocean
C. The Atlantic Ocean
D. The Arctic Ocean
Answer» D. The Arctic Ocean
Discussion
49.

Which of the following oceans does not have a north south submarine ridge ?

A. Indian ocean
B. Atlantic ocean
C. Arctic ocean
D. Pacific Ocean
Answer» E.
Discussion
50.

The portion of the earths surface covered with water is roughly -

A. one-fourth
B. one - half
C. Two - third
D. Three - ffith
Answer» D. Three - ffith
Discussion