Question No. 61
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support. According to the requirement of the company CIO, you are using Business Intelligence Development Studio to edit a SQL Server 2008 Integration Services (SSIS) package.
A custom data flow component is used by the package which runs successfully.
You try to add another instance of the custom data flow component to the package, but you find that the data flow component does not appear in the toolbox or in the Choose Toolbox Items dialog box.
You have to solve this problem. So what should you do to successfully add the custom data flow component to the toolbox?
A. You should use the REGSVR32 utility to register the assembly by using
B. You should copy the assembly to the appropriate folder
C. The assembly should be added to the Global Assembly Cache
D. You should use the Assembly Registration utility (REGASM.EXE) to register the assembly
Answer: B
Question No. 62
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.
Now you receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to you.
You use SQL Server 2008 Reporting Services (SSRS) to create a project.
Data from a SQL Server 2005 Analysis Services database will be displayed by the report.
According to the requirement of the company CIO, you must make sure that member properties and extended properties are displayed by the report.
So what should you do?
A. The SQL Server Analysis Services data source should be used.
B. The SQL Server data source should be used
C. The OLE DB for SQL Server data source should be used.
D. The OLE DB for the Analysis Services 8.0 data source should be used
Answer: A
Question No. 63
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?
A. Parent package variable
B. Registry entry
C. Environment variable
D. XML configuration file
Answer: D
Question No. 64
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server2008.
To meet the business development, you create a SQL Server 2008 Analysis Server (SSAS) solution with a measure group contained.
The measure group named Meatruth has a single partition. Now you are asked to not only make sure you have all aggregations that are part of the measure group stored in a multidimensional format, but also make sure the queries that use the measure group always refer to the newest edition of the source detail data. So what action should you perform to achieve that goal?
A. You should set the ProactiveCaching property of the partition to scheduled multidimensional online analytical processing (MOLAP).
B. You should set the ProactiveCaching property of the partition to real-time multidimensional online analytical processing (MOLAP)
C. You should set the ProactiveCaching property of the partition to real-time hybrid online analytical processing (HOLAP).
D. You should set the ProactiveCaching property of the partition to real-time relational online analytical processing (ROLAP)
E. You should set the ProactiveCaching property of the partition to automatic multidimensional online analytical processing (MOLAP).
Answer: C
Question No. 65
You are running a SQL Server 2008 Analysis Services (SSAS) solution which contains data mining extensions (DMX) to search a data mining model for Company.com.
In order to search a Clerk Walker data mining model in a Decision Tree data mining structure, the codes are listed below:
11 SELECT 12 [Decision Tree].[Clerk Walker] AS Buyer 13 FROM 14 [Decision Tree]
16 (SELECT 28 AS [Age], 17 '2-5 Miles' AS [Commute Distance], 18 '1' AS [House Owner Flag], 19 1 AS [Number Cars Owned], 20 2 AS [Total Children]) AS t
In the data mining structure, you should make sure that the input columns map to the columns.
Which is the correct answer?
A. You should utilize NATURAL PREDICTION JOIN
B. You should utilize LEFT JOIN
C. You should utilize OUTER JOIN
D. You should utilize RIGHT JOIN
Answer: A
Question No. 66
You are creating a SQL Server 2008 Integration Services (SSIS) instance which contains a Data Flow task which reproduces some million rows for Company.com.
The data flow asks a match against a reference table which includes 50,000 rows including every row would be utilized during the data flow in the reference table.
You should make sure that the data flow runs least time.
Which is the correct answer?
A. You should choose a Lookup transformation along with the half cache option
B. You should choose a Lookup transformation along with the Full cache option
C. You should choose a default Lookup transformation
D. You should choose a Lookup transformation along with the Default cache option
Answer: B
Question No. 67
You create a SQL Server 2008 Analysis Services (SSAS) solution.
You add a data source view (DSV) to the solution. The DSV has a table named Employee that includes the following columns:
-EmployeeKey -ManagerKey
The ManagerKey column references the manager of the employees.
You need to define the relationship between the employees and their manager in the DSV.
What should you do?
A. Create a Named Calculation that uses EmployeeKey and ManagerKey
B. Create a relationship by using EmployeeKey as the source column and ManagerKey as the destination column.
C. Create a Named Query that uses a relationship with EmployeeKey as the source column and ManagerKey as the destination column.
D. Create a relationship by using ManagerKey as the source column and EmployeeKey as the destination column.
Answer: D
Question No. 68
You are developing a SQL Server 2008 Analysis Services (SSAS) method which owns a date dimension called DateTester along with a rule called CalendarTester for Company.com.
The CalendarTester rule owns levels for the Year, Quarter, Month, and Date properties.
You should make sure that you could develop a called setTester that connects with the first eight months of the year 2008.
Which is the correct answer?
A. You should use the expression below:
[ Yr-Qtr-Mth].[Year], [DimTime].[Yr-Qtr-Mth].[Month].[August 2008])
B. You should use the expression below:
[ yr-day].[Month], [DimTime].[Yr-Qtr-Mth].[Month].[ August 2008])
C. You should use the expression below:
[yr-day]. [Month],8, [DimTime].[ yr-day].[Month].[ August 2008])
D. You should use the expression below:
[ yr-day].[Year],8, [DimTime].[ yr-day].[Month].[ August 2008])
Answer: A
Question No. 69
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server2008.
You are in charge of a SQL Server 2008 Reporting Services (SSRS) instance.
Accidentally, you find that 1000 reports are deployed on the SSRS instance by a developer, so your manager asks you to find a solution to prevent these reports from deploying on the SSRS instance so that it can be restored to its initial status.
What should you do to make the instance return to its initial status?
A. You should restore the Report Server database to make the instance return to its initial status
B. You should restore the Report Server Temporary database to make the instance return to its initial status
C. You should restore the master database to make the instance return to its initial status
D. You should restore the MSDB database to make the instance return to its initial status
Answer: A
Question No. 70
You are creating a SQL Server 2008 Integration Services (SSIS) instance for Company.com.
The package displays job listed below:
-You should operate multiple files through utilizing a For Each Loop container.
-You should get the files' content to a table through utilizing a Data Flow task.
-Through utilizing an Execute SQL task, you should Log the results of the state into a table
-You should make sure that the Execute SQL task only could not run in one transaction.
Which is the correct answer? (Select more than one)
A. You should set the TransactionOption property to RequiredNew in the package.
B. You should set the TransactionOption property to Supported in the package.
C. You should set the TransactionOption property to Required in the package.
D. You should set the TransactionOption property to None in the package.
E. You should set the TransactionOption property to NotSupported in the Execute SQL task.
F. You should set the TransactionOption property to Supported in the Execute SQL task.
Answer: CE
Question No. 71
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.
Now you are in charge of a SQL Server 2008 Analysis Services (SSAS) database. Now you get an e-mail from your company CIO, according to his requirement, he wants the data in a partition to be refreshed every two hours.
He has assigned this task to you. You have to implement the incremental processing strategy.
Of the following options, which XML for Analysis (XMLA) command should you choose?
A. You should choose ProcessFull
B. You should choose ProcessIndex
C. You should choose ProcessAdd.
D. You should choose ProcessData
Answer: C
Question No. 72
You maintain a SQL Server 2008 Reporting Services (SSRS) database server.
The instance contains a large number of reports that take a long time to execute. The reports contain multiple execution snapshots.
You have a new production server along with SSRS installed.
You need to migrate the reports and their snapshots to the production server in the minimum amount of time.
What should you do?
A. Use the rs.exe utility.
B. Use the rskeymgmt.exe utility.
C. Deploy the solutions by using Business Intelligence Development Studio (BIDS).
D. Copy the Report Server databases to the production server. Configure the server by using the Reporting Services Configuration tool.
Answer: D
Question No. 73
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server2008 Analysis Services (SSAS) solution.
To meet the business development, a dimension named DimSales is created with an Amount attribute, and then it is used in a cube structure.
Now you are assigned a task to make sure that aggregations have no relationship with the Amount attribute.
What action should you perform to accomplish this task?
A. The MembersWithData property of the Amount attribute should be set to False to accomplish this task.
B. The IsAggregatable property of the Amount attribute should be set to False to accomplish this task.
C. The AttributeHierarchyEnabled property of the Amount attribute should be set to False to accomplish this task.
D. The MembersWithData property of the Amount attribute should be set to NonLeafDataHidden to accomplish this task
E. The GroupingBehavior property of the Amount attribute should be set to DiscourageGrouping to accomplish this task.
Answer: C
Question No. 74
You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a table named Orders that contains the following columns:
. OrderKey
. Shipper
. OrderAmount
You create a dimension named DimOrders from the Orders table. You set the OrderKey as a key column and the Shipper column as an attribute. You create a measure group named FactOrders from the Orders table.
You need to create a dimension relationship to ensure that the OrderAmount column can be aggregated by the Shipper column.
What should you do?
A. Set the relationship between the DimOrders dimension and the FactOrders measure group to No Relationship.
B. Create a fact dimension relationship between the DimOrders dimension and the FactOrders measure group.
C. Create a regular dimension relationship between the DimOrders dimension and the FactOrders measure group. Set the Granularity attribute to Shipper and the measure group columns to OrderAmount.
D. Create a regular dimension relationship between the DimOrders dimension and the FactOrders measure group. Set the Granularity attribute to OrderKey and the measure group columns to OrderAmount.
Answer: B
Question No. 75
You are using the technology of Business Intelligence Development Studio (BIDS) project for data mining structure.
You want to change the settings on the Chart tab.
What will the result be?
A. The trends in the lift chart will keep the same and the trends in the profit chart will show.
B. The trends in the lift chart will keep the same but the trends in the profit chart will modify.
C. The trends in the lift chart will keep the same but the trends in the profit chart will change.
D. The trends in the lift chart will not remain the same but the trends in the profit chart will update.
Answer: C
