Exam 70-445 study material Made available by Testkingprep.com
Free 70-445 Exam Preparation Questions Exam 70-445: TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance
For Latest 70-445 Exam Questions and study guides- visit- http://www.testkingprep.com/70-445.html
Question:1 You are using the technology of Microsoft SQL Server 2005 Analysis Services (SSAS) project, a data mining model that uses the Microsoft Neural Network algorithm, should be included in The SSAS database. In Microsoft SQL Server Management Studio (SSMS),In order to build the Data Mining Extensions (DMX) searches for the database. You use Prediction Query Builder. You should create the search which gets the number of cases in the data mining model and the percentage of the sample cases. Which is the correct answer? A. You should create the PredictAssociation field which utilizes a Prediction Function source. B. You should create the PredictHistogram field that utilizes a Prediction Function source. C. You should create the PredictAssociation field that utilizes the data mining model source. D. You should create the PredictHistogram field that utilizes the data mining model source. Answer: B Question:2 You add a sequence container to a package that contains several tasks, one of which calls a command on a legacy system and another of which??a Data Flow Task??imports data into SQL Server. Even with DTC started and transactions turned on, your sequence container fails before the tasks even run. What is the problem? Click here to input the answer. Answer & Explanation The transactions featured in SSIS use the DTC service. However, not all systems support DTC, and a transaction cannot be forced on a non-compliant system, so the container will fail. You should remove the legacy task from the sequence container that has the transaction. Explanations No more information available Answer: Pending Question:3 You are using the technology of Microsoft SQL Server 2005 Analysis Services (SSAS) project. In order to examine different data mining theories; you should alter the design of the data mining structure to test. In the data mining model and the underlying case table, you add the ordered content type columns. You should make sure that Data Mining Viewer is the good for altering in the data mining structure and the data mining model technology. Which is the correct answer? A. You should select ProcessFull B. You should select INDEXDEFRAG C. You should select SHRINKFILE D. You should select VIEWDELETE Answer: A Question:4 You are using the technology of Microsoft SQL Server 2005 Analysis Services (SSAS) project.For business uniti-s cube,the business unit asks a data mining dimension Through using the Data Mining Wizard,You should create dimension to finish the job below In the cube, show the quantity of measures. Permit the use of the data mining dimension in Data Mining Expressions (DMX) prediction searches. Which is the correct answer? A. You should choose the structure of the data mining. B. You should choose the data mining model. C. You should develop the slice for the source cube for the information D. You should choose the case key from the measure group. E. You should choose the case key form the dimension and the case level column form a measure group. Answer: B, C, E Question:5 Describe the transformations you could use to combine data from two different database tables that
For Latest 70-445 Exam Questions and study guides- visit- http://www.testkingprep.com/70-445.html
exist on two different servers. Click here to input the answer. Answer & Explanation You could use the Merge Join transformation, which combines data sets by joining the rows across a set of common keys. This transformation allows an inner join, a left outer join, or a full outer join. You could also use a Lookup transformation to associate data from two sources. The Lookup can cache a table in memory and, through matching columns, can return new columns to the data flow. Explanations No more information available Answer: Pending Question:6 You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. a data mining structure should be deployed which contains the Microsoft Clustering mining model.From calable KMeans to Non-scalable K-Means. You should alter the attribute of the mining model.Which is the correct answer? A. You should change MODELLING_CARDINALITY B. You should change CLUSTERING_METHOD C. You should change INDEXDEFRAG D. You should change SHRINKFILE Answer: B Question:7 You are using the technology of Microsoft SQL Server 2005 Analysis Services (SSAS) project. Data source should be created listed Products table with a column called ProductCategories_IDTEST ProductCategories table with a called named ID In order to develop the relationship between the two tables. You should configure the NameMatchingCriteria property of the data source view to an option Which is the correct answer? A. You should set Empty B. You should set different name as foreiger key C. You should set different name as destination table name D. You should set same name as destination table name plus primary key name Answer: D Question:8 The Multicast transformation and the Conditional Split transformation both can have multiple outputs. Which transformation would you use if you needed to send rows matching certain conditions out one output and rows matching different conditions out another? Click here to input the answer. Answer & Explanation The Conditional Split transformation lets you define expressions against which the rows from the source are evaluated. For every row, the expressions are evaluated in order, and a row is sent out the first output when the matching expression evaluates to True. Therefore, any single row can go out only one output. With a Multicast transformation, on the other hand, all rows go out every output. Explanations No more information available Answer: Pending Question:9 You are using the technology of Microsoft SQL Server 2005 Analysis Services (SSAS) project.The fact table named FactOrderstest should be included in the project,the table contains columns named Order Amount, Country, and Order Date Key "Select * from FactOrderstest where [Order Date Key]>400 or Country='CHINA'" is created by the first partition for the fact table with the Source property the second partition for the fact table to make sure that accurate results is outpuuted when queried should be created. Which is the correct answer? A. You should develop a partition with the Source property set to "Select * from FactOrderstest
For Latest 70-445 Exam Questions and study guides- visit- http://www.testkingprep.com/70-445.html
where [Order Date Key]<= 400and Countryo' CHINA" B. You should develop a partition with the Source property set to "Select * from FactOrderstest where [Order Date Key]<= 400". C. You should develop a partition with the Source property set to "Select * from FactOrderstest where Countryo'USA'". D. You should develop a partition with the Source property set to "Select * from FactOrderstest where [Order Date Key]>=400and Country!' CHINA "'. Answer: A Question:10 You need to migrate a user-created Microsoft Access database to SQL Server, but the Data Flow toolbox does not contain an Access source adapter. How do you import this data into SQL Server? Click here to input the answer. Answer & Explanation Although it is not listed in the toolbox, Access is one of the many database sources and destinations with which SSIS can work. To extract data from Access, you first need to make a package connection to the Microsoft Jet OLE DB Provider. You can then use the OLE DB Source adapter to select the table or perform a custom query. Explanations No more information available Answer: Pending Question:11 You are using the technology of Microsoft SQL Server 2005 Analysis Services (SSAS) project. The cube should be developed below? A time dimension named TimeTest. A fact table that contains two columns named Order Date KeyTest and Amounts of Orders. A amount of Orders measure increased to a measure group named MeasuresTest. The cube has a dimension usage named Order Date which connects the Order Date Key Test column to the Time dimension. In order to show the cumulative totals of the Number of Orders column for the whole hierarchies ,you should develop the Multidimensional Expressions (MDX) calculation Which is the correct answer? A. You should SUM([Order Date Test].[Calendar Test].CurrentMemberTest.Children.Level,, [Measures Test].[Number of Orders]) B. You should TOTAL( PeriodsToDate([Order Date Test].[Calendar Test].CurrentMember Test.Parent.Level, [Order Date]. [Calendar]. CurrentMembe Test r), [Measures Test].[Number of Orders]) C. You should TOTAL (PeriodsToDate([Order Date Test].[Calendar Test].CurrentMembe Test r.Parent,[Order Date Test].[Calendar Test]. Cu rren tM ember), [Measures Test].[Number of Orders]) D. You should TOTAL ([Order Date Test].[Calendar Test].CurrentMember Test,SUM ([Order Date]. [Calendar]. CurrentMember Test. Children, [Measure Tests].[Number of Orders])) Answer: B Question:12 You are using the technology of Microsoft SQL Server 2005 Analysis Services (SSAS) project. You develop a cube which utilized a dimension called DimEmployeeTest. The dimension includes an attribute named EmployeeTest. You also host a Microsoft SQL Server 2005 Reporting Services (SSRS) project which includes a report on an employee. You can browerthe information. Which is the correct answer? A. You should develop a URL action on the EmployeeTest attribute. B. You should develop a DataSet action on the EmployeeTest attribute. C. You should develop a DataTable action on the DimEmployeeTest dimension. D. You should develop a Rewrite action on the DimEmployeeTest dimension. Answer: A Question:13
For Latest 70-445 Exam Questions and study guides- visit- http://www.testkingprep.com/70-445.html
How would you use SSIS to import a file from an FTP server to an SQL Server table? Click here to input the answer. Answer & Explanation First, you would use the FTP Task to copy the file to the machine on which SSIS is installed. You can then import the file into a SQL Server table by using a data flow task configured with a Flat File Source adapter and either a SQL Server Destination adapter or an OLE DB Destination adapter. Explanations No more information available Answer: Pending Question:14 Can SQL Server 2005 Analysis Services be configured for Mixed Mode authentication, allowing both Windows Authentication and SQL Server Authentication? Click here to input the answer. Answer & Explanation No, SSAS works only with Windows Authentication and therefore does not have the capability for Mixed Mode or SQL Server Authentication. The Mixed Mode selection in the installation is only for the database engine. Explanations No more information available Answer: Pending Question:15 To run a stored procedure within an SQL Server database, what task would you choose? Click here to input the answer. Answer & Explanation The Execute SQL Task can run a stored procedure within SQL Server or any relational database for which you have an installed data provider. The syntax of the statement entered in the Execute SQL Task will be in the native language of the underlying database. Explanations No more information available Answer: Pending Question:16 You are using the technology of Microsoft SQL Server 2005 Analysis Services (SSAS) project The cube is listed below: The cube includes the following objects: A dimension named DimAccountsDimension which utilized a table called AccountsTable. A dimension named DimCustomersDimension which utilized a table called CustomersTable. A measure group called Transactions which utilized a fact table called Transactions. A measure group called Customer Accounts which utilized a fact table called Customer AccountsTable. You need to create a cube dimension to browse through the measures in the Transactions facttable by using the CustomersTable dimension. Which is the correct answer?
For Latest 70-445 Exam Questions and study guides- visit- http://www.testkingprep.com/70-445.html
A. You should develop a one-to-many relationship and configure the intermediate measure group to Transactions. B. You should develop a one-to-one relationship and configure the intermediate measure group to Transactions. C. You should develop a many-to-one relationship and configure the intermediate measure group to Transactions. D. You should develop a many-to-many relationship and configure the intermediate measure group to Customer Accounts. Answer: D Question:17 You are using the technology of Microsoft SQL Server 2005 Analysis Services (SSAS) project. Some object show below in the cube A time dimension named TimeDimension that has an attribute named TimeKiller. A fact table named FactOrdersTable. Different hierarchies should be included in the Time dimension, You should take method to do it.Which is the correct answer? A. You should design three dimension usage relationship between the Time dimension and th FactOrdersTable fact table. B. By defining a one-to-one relationship, You should design a single dimension usage relationship between the Time dimension and the FactOrdersTable fact table. C. By defining a regular relationship for both the dimension usages, You should design two dimension usage relationships between the Time dimension and the FactOrdersTable fact table D. By defining a many-to-many relationship for both the dimension usages,You should design two dimension usage relationships between the Time dimension and the FactOrdersTable fact table Answer: C Question:18 What is the difference between a control flow task and a control flow container? Click here to input the answer. Answer & Explanation Control flow tasks perform operations, while containers coordinate and group tasks. For example, a ForEach Container Task can look through the files in a system folder, and then a File System Task embedded within the container can move the file to a new folder location. Explanations No more information available
For Latest 70-445 Exam Questions and study guides- visit- http://www.testkingprep.com/70-445.html
Answer: Pending Question:19 You are using the technology of Microsoft SQL Server 2005 Analysis Services (SSAS) project.There is a cube named CompanyFinance in it. The CompanyFinance cube includes the following conditions: A time dimension hierarchy named CalendarList which includes Year on the first level, Quarter on the second level, and Month on the third level. A measure group named MeasuresSales. A measure named AmountSales. A time dimension named DimTimeSales. You should use the expression which shows the drop and down in the AmountSales measure for the current DimTimeSales member, irrespective of the level of the Calendar hierarchy. Which is the correct answer? A. Case When [MeasuresSales].[ AmountSales]> [MeasuresSales].[ AmountSales],[DimTime]. [ CalendarList].PrevMember Thenl When [MeasuresSales].[ AmountSales]< [MeasuresSales]. [ AmountSales],[ DimTimeSales].[ CalendarList].PrevMember Then -1 End B. Case When [MeasuresSales]. [ AmountSales],[ DimTimeSales]. [ CalendarList]< [MeasuresSales]. [ AmountSales],[ DimTimeSales]. [ CalendarList].PrevMember Thenl When [MeasuresSales].[ AmountSales],[ DimTimeSales].[ CalendarList]> [MeasuresSales].[ AmountSales],[ DimTimeSales].[ CalendarList].PrevMember Then -1 End C. Case When [MeasuresSales].[ AmountSales]> [MeasuresSales].[ AmountSales],[ DimTimeSales].[ CalendarList].NextMember Thenl When [MeasuresSales].[ AmountSales]< [MeasuresSales]. [ AmountSales],[ DimTimeSales].[ CalendarList].NextMember Then -1 End D. Case When [MeasuresSales].[SalesAmount]==[MeasuresSales].[SalesAmount],[ DimTimeSales]. [ CalendarList].NextMember Thenl When [MeasuresSales]. [SalesAmount]!= [MeasuresSales]. [SalesAmount],[ DimTimeSales].[ CalendarList].NextMember Then -1 End Answer: A Question:20 You are using the technology of Microsoft SQL Server 2005 Reporting Services (SSRS) There is financial data in the report, in the report, An input parameter called SoureTarget is present, in the SoureTarget_Mfr field, When a value matches the selected value in the input parameter, the color of the output in a column is Black. Otherwise, the color of the output is Orange. You need to set the Lable that includes the color property of the Machine_Mfr field to the proper method. Which is the correct answer? A. You should utilize the expression of =Iif(Fields! SoureTarget_Mfr = Parameterslrc: SoureTarget.Value," Black"," Orange "). B. You should utilize the expression of =Iif(Fields! SoureTarget_Mfr.Value = Parameters! SoureTarget.Value," Black"," Orange "). C. You should utilize the expression of =Iif(InScope(SoureTarget_Mfr)," Black"," Orange "). D. You should utilize the expression of =Iif(InScope(SoureTarget)," Black"," Orange "). Answer: B
For Latest 70-445 Exam Questions and study guides- visit- http://www.testkingprep.com/70-445.html
For complete Exam 70-445 Training kits and Self-Paced Study Material Visit: http://www.testkingprep.com/70-445.html
http://www.testkingprep.com/
For Latest 70-445 Exam Questions and study guides- visit- http://www.testkingprep.com/70-445.html