SQL Server 2008 70-448 Dump2

30 Questions | Total Attempts: 131

SettingsSettingsSettings
Please wait...
SQL Server Quizzes & Trivia

Microsoft SQL Server is a database management system. It was built for storing and retrieving data as requested by software applications. Microsoft markets different versions of Microsoft SQL Server for different target audiences. How well do you understand this database management system? Take up the test below to gauge your understanding.


Related Topics
Questions and Answers
  • 1. 
    You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com. The package contains six Data Flow tasks and three Control Flow tasks. You should alter the package . Which is the correct answer? 
    • A. 

      You should increase the two Control Flow tasks and one Data Flow task to a container. Change the TransactionOption property of the container to Supported

    • B. 

      You should increase the two Control Flow tasks and one Data Flow task to a container. Change the TransactionOption property of the container to Disabled.

    • C. 

      You should increase the two Control Flow tasks and one Data Flow task to a container. Change the TransactionOption property of the container to Required

    • D. 

      You should increase the two Control Flow tasks and one Data Flow task to a container. Change the TransactionOption property of the container to RequiredNew

  • 2. 
    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? 
    • A. 

      You should back up the master database.

    • B. 

      You should back up the local database.

    • C. 

      You should back up the system database.

    • D. 

      You should back up the systemdb databse.

  • 3. 
    You are developing a SQL Server 2008 Reporting Services (SSRS) instance of report model for Company.com.In the Report Builder tool, the users should need to create their SSRS reports. The data source they used will include a Microsoft SQL Server 2008 database. Which include 1000 tables? You should design the report model for users, and allow access to only the 20tables which they require for reporting. Which is the correct answer? 
    • A. 

      You should develop DataSet using the Web Service to Schema(s) option.

    • B. 

      You should develop DataTable using the Web Service to Schema(s) option.

    • C. 

      You should develop a data source view and select only the required tables and views.

    • D. 

      You should set the data source view in the setting file.

  • 4. 
    You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com.A sales manager called Clerk is responsible for the sales of bikes in the Northeast region. You decide to give some rights to the rights to Clerk to visit the database.You won two roles below called Southern Region and Nikes. Their schemas are listed below:You have make The Visual Totals properties attribute true for roles above.You should make sure that Clerk could browser the workers in the Product dimension which link to the Nikes category in the Southern region. Which is the correct answer? 
    • A. 

      You should increase Clerk to a Nikes role

    • B. 

      You should increase Clerk to the Southern Region role.

    • C. 

      You should increase Clerk to a new role which owns components below:

    • D. 

      [ Products Territory Region].[Southern]} as the permitted configuration.{[Product].[Product Category].[Product Category].[Nikes]} as the permitted

    • E. 

      You should increase Clerk to the default Region role.

  • 5. 
    You are developing a SQL Server 2008 Reporting Services (SSRS) report for Company.com.Assembly should be created in order to run real-time lookup and currency conversion. The assembly has a static class named daily which lives in the namespace HomeCalc.there is a method called DMO which need two arguments, Cuurnt and HomeCalcWhen the report is operating, you should reference the ToEUR method in an expression to convert USD to USO. Which is the correct answer? 
    • A. 

      You should use the expression of =Code. HomeCalc. Daily. USO (Fields! Cuurnt.Value," DMO ")

    • B. 

      You should use the expression of =Code! HomeCalc. Daily. USO (Fields! Cuurnt.Value," DMO")

    • C. 

      You should use the expression of = HomeCalc. Daily.USO (Fields! Cuurnt.Value,"USD")

    • D. 

      You should use the expression of = HomeCalc! Daily.USO (Fields! Cuurnt.Value,"USD")

  • 6. 
    You are developing a report which is difficult and cost a lot of time to produce. You use the technology of SQL Server 2008 Reporting Services (SSRS).You should make sure that you could set the report server to cache the report for 40 minutes at the beginning of the request. Which is the correct answer? 
    • A. 

      Report snapshots should be run for report.

    • B. 

      You should run report execution caching for report.

    • C. 

      You should set the data source to utilize a DBCC INDEXDEFRAG.

    • D. 

      You should set the data source to utilize a DBCC SHRINKFILE. INDEXDEFRAG

  • 7. 
    You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com.There are three characters in a dimensionality called DProducts below:An attribute named Categories.A key attribute named Products that has a relationship to the Categories attribute.A hierarchy that has the Categories attributes on the first level and the Products attribute on the second level. When you browse through the dimension, it shows all the Products that do not have a relationship to the Categories attribute. The attribute is grouped under a Categories member named Unknown. You need to ensure that only those products that have a relationship to the Categories attribute are displayed. Which is the correct answer below? 
    • A. 

      In the hierarchy, you should change the HideMemberIf property of the Categories level to OnlyChildWithNoName.

    • B. 

      In the hierarchy, you should change the HideMemberIf property of the Products level to OnlyChildWithNoName.

    • C. 

      You should Change the UnKnownMember property of the DimProducts dimension to none.

    • D. 

      You should Change the UnKnownMember property of the DimProducts dimension to Hidden.

  • 8. 
    You are developing a SQL Server 2008 Reporting Services (SSRS) instance for Company.com. In order to keep all reports render to Microsoft Excel only, you should compile the items, which are contained in the <Extension> subelement of the <Render> element in the RSReportServer.config file. Which is the correct answer below? 
    • A. 

      You should set the value of the Type attribute to render where the value of the Name attribute is equal to EXCEL.

    • B. 

      You should set the value of the visible attribute to false where the value of the Name attribute is not equal to EXCEL.

    • C. 

      You should set the value of the Type attribute to prevent where the value of the Name attribute is not equal to EXCEL.

    • D. 

      You should add an OverrideNames subelement to the extension element where the value of the Name attribute is not equal to EXCEL.

  • 9. 
    You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com. The package should contain a Data Flow task with a Fuzzy Grouping transformation that creates data. You should browser the output data of the Fuzzy Grouping transformation to debug the package.Which is the correct answer? 
    • A. 

      You should increase a Data Viewer object to the Data Flow task for constraints on the Fuzzy Grouping transformation.

    • B. 

      You should increase a DBCC SHRINKFILE to the Data Flow task for constraints on the Fuzzy Grouping transformation.

    • C. 

      You should increase a web service to the Data Flow task for constraints on the Fuzzy Grouping transformation.

    • D. 

      You should increase a Transactions log to the Data Flow task for constraints on the Fuzzy Grouping transformation.

  • 10. 
    You are managing a SQL Server 2008 Analysis Services (SSAS) instance for Company.com.There is a cube in an SSAS instance. Because the queries operate not as fast as usual, you should affirm which queries run slowly and change the storage setting of the cube. Which is the correct answer? 
    • A. 

      You should run the Cube Storage Wizard to analyze and design aggregations.

    • B. 

      You should run the Usage-Based Optimization Wizard to analyze and design aggregations.

    • C. 

      You should use SQL Profiler to examine the execution plans to analyze and design aggregations.

    • D. 

      You should modify the Data Source Impersonation Info property of the Analysis Services database.

  • 11. 
    You are creating a SQL Server 2008 Reporting Services (SSRS) instance which includes a parameter called Type that is utilized to filter some products for Company.com.You could utilize a dataset to include query listed below:SELECT Item.ProductID, Item.Name, Item.ListPriceFROM Production. Product AS ItemWHERE Item.Category = @ Type; You should change the parameter to permit values. You should make sure that you could change the report to help search for Type values through utilizing fewer effort. Which is the correct answer? 
    • A. 

      You should change the search to utilize the store procedure

    • B. 

      You should change the search to utilize the left join

    • C. 

      You should change the search to utilize the IN operator.

    • D. 

      You should change the search to utilize the inner join.

  • 12. 
    You are managing a Microsoft SQL Server 2008 Reporting Services (SSRS) instance for Company.com. You need to assign a group of users a predefined security role that permits them to read all the report definitions. Which is the correct answer? 
    • A. 

      You should set Transactions technology

    • B. 

      You should set Web Service technology

    • C. 

      You should set Log technology

    • D. 

      You should set Content Manager

  • 13. 
    You are using the technology of Business Intelligence Development Studio (BIDS) project for data mining structure. In order to change the settings on Chart tabWhich is the correct answer
    • 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

  • 14. 
    You are developing a SQL Server 2008 Reporting Services (SSRS) report for Company.com.The source of the SSRS report data is a Transact-SQL stored procedure. The procedure does not have any input parameters and returns all records in a set of tables. Three other applications that run on Microsoft SQL Server also use the stored procedure. You need to limit the amount of data that is displayed on the report without affecting any other applications that use the stored procedure. What should you do? 
    • A. 

      You should run the Database Engine Tuning Advisor tool in the database.

    • B. 

      You should create a dataset filter and include the appropriate limiting expression.

    • C. 

      You should create a Report Parameter dialog box and include the appropriate limiting expression.

    • D. 

      You should add an expression to the Visibility property and include the appropriate limiting expression.

  • 15. 
    You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com.Through utilizing a Dynamic Management View (DMV), you decide to troubleshoot query performance you should make sure that you could improve query sessions times. In order to solve the problem, which is the correct answer? 
    • A. 

      You should utilize Discover_Log for DMV.

    • B. 

      You should utilize Discover_Link for DMV.

    • C. 

      You should utilize Discover_Commands for DMV.

    • D. 

      You should utilize Discover_request for DMV.

  • 16. 
    You are managing a SQL Server 2008 Analysis Services (SSAS) project for Company.com. 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 increase 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

  • 17. 
    You are creating a SQL Server 2008 Integration Services (SSIS) data flow which moves information to a SQL Server 2008 database for Company.com. You should make sure that data flow refreshes the existed data in the SQL Server database through utilizing data in your data flow. Which is the correct answer? 
    • A. 

      You should utilize Dynamic Management View (DMV)

    • B. 

      You should utilize OLE DB Destination

    • C. 

      You should utilize SQL Server Destination

    • D. 

      You should utilize Data Conversion Transformation

  • 18. 
    You are managing a SQL Server 2008 Analysis Services (SSAS) instance for Company.com. A data mining structure should be deployed which contains the Microsoft Clustering mining model. From Scalable K-Means 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

  • 19. 
    You are managing a SQL Server 2008 Reporting Services (SSRS) sample for Company.com. The company network security type regarding the domain which masters the sample alterations. You should make sure that the sample would help Kerberos authentication. Which is the correct answer? 
    • A. 

      You should change the RSReportServer.config file for authentication.

    • B. 

      Through using Microsoft SQL Server Management Studio (SSMS), you should change the Server Settings

    • C. 

      Through using Transactions Log, you should change the Site Settings of the instance.

    • D. 

      You should delete RSReportServer Configuration File

  • 20. 
    You are managing a SQL Server 2008 Analysis Services (SSAS) project for Company.com.You develop a cube which utilized a dimension called DimEmployeeTest. The dimension includes an attribute named EmployeeTest. You also host a Microsoft SQL Server 2008 Reporting Services (SSRS) project which includes a report on an employee. You can browser the 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.

  • 21. 
    You are developing a SQL Server 2008 Analysis Services (SSAS) solution which contains a table called TestFact which includes two columns listed below for Company.com.In order to develop a measure which gets the amount of customers who owns placed orders.Which is the correct answer? 
    • A. 

      You should configure the Usage attribute to Distinct count and the Source Column attribute to OrderKey.

    • B. 

      You should configure the Usage attribute to Sum count and the Source Column attribute to OrderKey.

    • C. 

      You should configure the Usage attribute to Distinct count and the Source Column attribute to CustomerKey.

    • D. 

      You should configure the Usage attribute to Sum count and the Source Column attribute to CustomerKey.

  • 22. 
    You are developing a SQL Server 2008 Analysis Services (SSAS) solution which contains a data source view (DSV) which owns a table called Worker for Company.com.There are some columns in the Worker belowWorkerKey BossKey The BossKey column references the manager of the Workers. You should make sure that you should create the relationship between the workers and their boss in the DSV.Which is the correct answer? 
    • A. 

      You should develop a Calculation which utilizes WorkerKey and BossKey

    • B. 

      You should develop a View which utilizes a relationship with WorkerKey as the source column and BossKey as the destination column.

    • C. 

      You should develop a Query which utilizes a relationship with WorkerKey as the source column and BossKey as the destination column.

    • D. 

      Through utilizing BossKey, you should develop a relationship as the source column and WorkerKey as the destination colmnu.

  • 23. 
    You are managing a SQL Server 2008 Analysis Services (SSAS) project for Company.com.A parent-child hierarchy should be included for the dimension. There is children key attribute named EmployeeTest and a parent attribute named EmployeesTest. As the root member, you should make sure that the topmost employee should be included. Which is the correct answer? 
    • A. 

      You should configure the IsAggregatable property of the Employee attribute to default.

    • B. 

      You should configure the IsNotAggregatable property of the Employee attribute to false.

    • C. 

      You should configure the IsNotAggregatable property of the Employees attribute to true.

    • D. 

      You should configure the IsAggregatable property of the Employees attribute to false.

  • 24. 
    You are developing a SQL Server 2008 Reporting Services (SSRS) report for Company.com. The parameter called DislayValue you design for the report will display below (it has some properties)Data Type: StringPrompt: Display NumberAvailable Values: queried with the following Label/Value pairs:oYes/10oNo/1Default Values: Empty You could operate the visibility of the column by the parameter.You should use the proper expression to meet this situation.Which is the correct answer? 
    • A. 

      You should use the expression of =Iif(Parameters!rc: DislayValue.Value=10, True,True)"

    • B. 

      You should use the expression of =Iif(Parameters!rc: DislayValue.Value=10,False, False)"

    • C. 

      You should use the expression of "=Iif(Parameters! DislayValue.Value=0,False,True)"

    • D. 

      You should use the expression of =Iif(Parameters!rc: DislayValue.Value=10,False,True)"

  • 25. 
    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 solution. You enable proactive caching for a partition. A data source view(DSV) is added to the solution. The DSV contains a table which is named Worker. The table has two columns: WorkerKey and ExecutiveKey. The ExecutiveKey column references the executive of the workers. In the DSV, you have to define the relationship between the employees and their manager. What action should you perform? 
    • A. 

      You should use WorkerKey as the source column and ExecutiveKey as the destination column to create a relationship

    • B. 

      A Named Calculation should be created. The Name Calculaton uses WorkerKey and ExecutiveKey

    • C. 

      You should use ExecutiveKey as the source column and WorkerKey as the destination column to create a relationship.

    • D. 

      A Named Query should be created. The Named Query uses a relationship with WorkerKey as the source column and ExecutiveKey as the destination column

  • 26. 
    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 you are in charge of a SQL Server 2008 Analysis Services (SSRS) instance for the company. According to your plan, a Dynamic Management View (DMV) will be used to troubleshoot query performance. Now you get an order from your manager, according to his requirements, query sessions that execute a query for more than 30,000 ms should be identified. So of the following DMV, which one would be used? 
    • A. 

      Discover_Sessions would be used

    • B. 

      Discover_Commands would be used

    • C. 

      Discover_Connections would be used

    • D. 

      Discover_Traces would be used

    • E. 

      Discover_Wizard would be used

  • 27. 
    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. You have a table named Bills with three columns contained. They are respectively Shipper, BillKey and BillQuantity. To meet the business development, a dimension named DimBills and a measure group named TruthBills are created from the Bills table. Besides, the BillKey is set as a key column and the Shipper is set as an attribute column. According to the order of the CIO, a dimension relationship between the BillQuantity column and the Shipper column should be created to make sure that the Shipper column is able to aggregate BillQuantity column. What action below should be performed to achieve this goal? 
    • A. 

      A regular dimension relationship should be created between the DimBills dimension and the TruthBills measure group.

    • B. 

      The relationship between the TruthBills measure group and DimBills dimension should be set to No Relationship.

    • C. 

      A Truth dimension relationship should be created between the TruthBills measure group and DimBills dimension

    • D. 

      A regular dimension relationship should be created between the DimBills dimension and the TruthBills measure group. Besides, the Granularity attribute to Shipper and the measure group columns should be set to BillQuantity.

    • E. 

      A regular dimension relationship should be created between the DimBills dimension and the TruthBills measure group. Besides, the Granularity attribute to BillKey and the measure group columns should be set to BillQuantity

  • 28. 
    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'a SQL Server 2008 Analysis Services (SSAS) solution is created. Then a dimension named DimClient is created with the three attributes of Client, Age and Name. Of the three attributes, the Client is the key. There is a measure group named Production with the Granularity property set to Age and DimClient is related to this group. Now you receive an e-mail from your company CIO, according to his requirement, you should make sure that measure values can be retrieved based on the Age and Name attributes. To achieve this goal, what action should you perform? 
    • A. 

      First the source attribute should be set to Age and the related attribute should be set to Client, and then the source attribute should be set to Name and the related attribute should be set to Client

    • B. 

      First the source attribute should be set to Name and the related attribute should be set to Client, and then the source attribute should be set to Age and the related attribute should be set to Client

    • C. 

      First the source attribute should be set to Client and the related attribute should be set to Age, and then the source attribute should be set to Age and the related attribute should be set to Name.

    • D. 

      First the source attribute should be set to Age and the related attribute should be set to Client, and then the source attribute should be set to Name and the related attribute should be set to Age

    • E. 

      First the source attribute should be set to Client and the related attribute should be set to Age, and then the source attribute should be set to Client and the related attribute should be set to Name

  • 29. 
    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 and you use it tocreate a report, which is so complex that it needs a few minutes to generate. Now you are assigned a task to find a solution to configure the report server so that it can be cached for half an hour after the original request. Which solution should be chosen to accomplish this task? 
    • A. 

      The solution of using snapshot isolation to configure the data source would be chosen to accomplish this task

    • B. 

      The solution of using a database snapshot to configure the data source would be chosen to accomplish this task

    • C. 

      The solution of implementing report snapshots would be chosen to accomplish this task

    • D. 

      The solution of implementing report execution caching would be chosen to accomplish this task.

  • 30. 
    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. There is a SQL Server 2008 instance. Now you are in charge of SQL Server 2008 Integration Services (SSIS) on this instance. Now you get an order from your company, according to the company requirement, a failure recovery plan has to be created for packages that are deployed to a SQL Server. As the IT support, you have to accomplish this task. So what action should be performed? 
    • A. 

      You should perform the backup of the model database

    • B. 

      You should perform the backup of the MSDB database.

    • C. 

      You should perform the backup of the tempdb databse

    • D. 

      You should perform the backup of the master database