SQL Server 2008 70-448 Dump2

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 Ranaguha
R
Ranaguha
Community Contributor
Quizzes Created: 3 | Total Attempts: 7,048
| Attempts: 653
SettingsSettings
Please wait...
  • 1/30 Questions

    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? 

    • 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
    • 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.
    • 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
    • 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
Please wait...
SQL Server Quizzes & Trivia
About This Quiz

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.

Quiz Preview

  • 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? 

    • 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 stores important system information and metadata. By backing up the master database, you ensure that you have a copy of this critical information in case of a failure. This allows for easier recovery and restoration of the SQL Server instance. Backing up the local or system databases may not include all the necessary system information, so it is important to specifically back up the master database.

    Rate this question:

  • 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? 

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

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

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

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

    Correct Answer
    A. You should develop a data source view and select only the required tables and views.
    Explanation
    The correct answer is to develop a data source view and select only the required tables and views. This approach allows for the creation of a report model that includes only the necessary tables and views, limiting the access and complexity for the users. By selecting only the required tables and views, the report model can be optimized for performance and ease of use. Developing a DataSet or DataTable using the Web Service to Schema(s) option would not provide the same level of control over the tables and views included in the report model.

    Rate this question:

  • 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? 

    • You should increase Clerk to a Nikes role

    • You should increase Clerk to the Southern Region role.

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

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

    • You should increase Clerk to the default Region role.

    Correct Answer
    A. You should increase Clerk to a new role which owns components below:
  • 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? 

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

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

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

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

    Correct Answer
    A. You should use the expression of = HomeCalc. Daily.USO (Fields! Cuurnt.Value,"USD")
    Explanation
    The correct answer is to use the expression = HomeCalc. Daily.USO (Fields! Cuurnt.Value,"USD"). This expression references the ToEUR method in the HomeCalc assembly and passes the Cuurnt value and "USD" as arguments to convert USD to USO.

    Rate this question:

  • 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? 

    • Report snapshots should be run for report.

    • You should run report execution caching for report.

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

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

    Correct Answer
    A. You should run report execution caching for report.
    Explanation
    To ensure that the report server caches the report for 40 minutes at the beginning of the request, you should run report execution caching for the report. This means that the report will be stored in the cache for a specified period of time, allowing subsequent requests for the same report to be served from the cache instead of generating the report again, saving time and resources. This caching mechanism can improve the performance and reduce the load on the server.

    Rate this question:

  • 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? 

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

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

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

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

    Correct Answer
    A. You should Change the UnKnownMember property of the DimProducts dimension to Hidden.
    Explanation
    In order to ensure that only those products that have a relationship to the Categories attribute are displayed, the correct answer is to change the UnKnownMember property of the DimProducts dimension to Hidden. This will hide the Unknown member under the Categories attribute, resulting in only the products with a relationship to the Categories attribute being displayed.

    Rate this question:

  • 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? 

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

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

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

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

    Correct Answer
    A. You should set the value of the visible attribute to false where the value of the Name attribute is not equal to EXCEL.
    Explanation
    The correct answer is to set the value of the visible attribute to false where the value of the Name attribute is not equal to EXCEL. This means that all items in the subelement of the element, except for the one with the Name attribute equal to EXCEL, will not be visible. This ensures that all reports will only render to Microsoft Excel.

    Rate this question:

  • 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? 

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

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

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

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

    Correct Answer
    A. You should increase a Data Viewer object to the Data Flow task for constraints on the Fuzzy Grouping transformation.
    Explanation
    Adding a Data Viewer object to the Data Flow task allows you to view the output data of the Fuzzy Grouping transformation, which will help in debugging the package. It provides a way to visually inspect the data at that point in the package and verify if the Fuzzy Grouping transformation is producing the expected results. This can help identify any issues or errors in the transformation and aid in troubleshooting.

    Rate this question:

  • 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? 

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

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

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

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

    Correct Answer
    A. You should run the Usage-Based Optimization Wizard to analyze and design aggregations.
    Explanation
    The correct answer is to run the Usage-Based Optimization Wizard to analyze and design aggregations. This is because the question states that the queries are running slower than usual, indicating a performance issue. The Usage-Based Optimization Wizard analyzes the usage patterns of the cube and identifies which aggregations are needed to improve query performance. By running this wizard, the cube can be optimized to better suit the query workload and improve overall performance.

    Rate this question:

  • 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? 

    • You should change the search to utilize the store procedure

    • You should change the search to utilize the left join

    • You should change the search to utilize the IN operator.

    • You should change the search to utilize the inner join.

    Correct Answer
    A. You should change the search to utilize the IN operator.
    Explanation
    By changing the search to utilize the IN operator, the report will be able to search for multiple Type values at once. This allows for more flexibility and efficiency in searching for different types without having to modify the report each time.

    Rate this question:

  • 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? 

    • You should set Transactions technology

    • You should set Web Service technology

    • You should set Log technology

    • You should set Content Manager

    Correct Answer
    A. You should set Content Manager
    Explanation
    The correct answer is to set the Content Manager role. The Content Manager role in Microsoft SQL Server 2008 Reporting Services allows users to read all report definitions, which means they can view and access the content of the reports. This role provides the necessary permissions and access to the report definitions, ensuring that the group of users can fulfill their requirement of reading all the report definitions.

    Rate this question:

  • 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

    • The trends in the lift chart will keep the same and the trends in the profit chart will show.

    • The trends in the lift chart will keep the same but the trends in the profit chart will modify

    • The trends in the lift chart will keep the same but the trends in the profit chart will change.

    • The trends in the lift chart will not remain the same but the trends in the profit chart will update

    Correct Answer
    A. The trends in the lift chart will keep the same but the trends in the profit chart will change.
    Explanation
    The correct answer is that the trends in the lift chart will remain the same, meaning they will not change. However, the trends in the profit chart will change, indicating that they will be modified or updated. This suggests that when changing the settings on the Chart tab in the Business Intelligence Development Studio (BIDS) project for data mining structure, the lift chart will remain consistent while the profit chart will be affected.

    Rate this question:

  • 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? 

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

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

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

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

    Correct Answer
    A. You should create a dataset filter and include the appropriate limiting expression.
    Explanation
    Creating a dataset filter and including the appropriate limiting expression is the correct answer because it allows you to limit the amount of data displayed on the report without affecting any other applications that use the stored procedure. By applying a filter to the dataset, you can specify the conditions that need to be met for the data to be included in the report, effectively reducing the amount of data displayed. This ensures that the report only shows the necessary information while maintaining the integrity of the stored procedure for other applications.

    Rate this question:

  • 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? 

    • You should utilize Discover_Log for DMV.

    • You should utilize Discover_Link for DMV.

    • You should utilize Discover_Commands for DMV.

    • You should utilize Discover_request for DMV.

    Correct Answer
    A. You should utilize Discover_Commands for DMV.
    Explanation
    The correct answer is to utilize Discover_Commands for DMV. This DMV provides information about the commands that have been issued against the Analysis Services database, including the duration of the command execution. By analyzing the commands and their durations, you can identify any performance bottlenecks and take necessary actions to improve query session times.

    Rate this question:

  • 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? 

    • You should select ProcessFull

    • You should select INDEXDEFRAG

    • You should select SHRINKFILE

    • You should select VIEWDELETE

    Correct Answer
    A. You should select ProcessFull
    Explanation
    The correct answer is "You should select ProcessFull." When altering the design of the data mining structure, selecting ProcessFull will ensure that the changes are fully processed and applied to the data mining model and underlying case table. This option is necessary to accurately test and examine different data mining theories.

    Rate this question:

  • 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? 

    • You should utilize Dynamic Management View (DMV)

    • You should utilize OLE DB Destination

    • You should utilize SQL Server Destination

    • You should utilize Data Conversion Transformation

    Correct Answer
    A. You should utilize SQL Server Destination
    Explanation
    The correct answer is to utilize the SQL Server Destination. This is because the SQL Server Destination is specifically designed for loading data into a SQL Server database. It provides better performance and efficiency compared to other options like the OLE DB Destination or Data Conversion Transformation. Additionally, using the SQL Server Destination ensures that the data flow is optimized for the target SQL Server database, resulting in faster and more reliable data refreshes.

    Rate this question:

  • 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? 

    • You should change MODELLING_CARDINALITY

    • You should change CLUSTERING_METHOD

    • You should change INDEXDEFRAG

    • You should change SHRINKFILE

    Correct Answer
    A. You should change CLUSTERING_METHOD
    Explanation
    The correct answer is to change the CLUSTERING_METHOD. The CLUSTERING_METHOD determines the algorithm used to perform the clustering in the Microsoft Clustering mining model. By changing the CLUSTERING_METHOD, you can switch from the Scalable K-Means algorithm to the Non-scalable K-Means algorithm, or vice versa. This can affect the performance and accuracy of the clustering in the data mining structure.

    Rate this question:

  • 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? 

    • You should change the RSReportServer.config file for authentication.

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

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

    • You should delete RSReportServer Configuration File

    Correct Answer
    A. You should change the RSReportServer.config file for authentication.
    Explanation
    The correct answer is to change the RSReportServer.config file for authentication. This is because the RSReportServer.config file is the configuration file for SQL Server Reporting Services and contains settings for various aspects of the service, including authentication. By making changes to this file, you can configure the sample to use Kerberos authentication, which is the desired authentication method for the company's network security.

    Rate this question:

  • 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? 

    • You should develop a URL action on the EmployeeTest attribute.

    • You should develop a DataSet action on the EmployeeTest attribute

    • You should develop a DataTable action on the DimEmployeeTest dimension

    • You should develop a ReWrite action on the DimEmployeeTest dimension.

    Correct Answer
    A. You should develop a URL action on the EmployeeTest attribute.
    Explanation
    Developing a URL action on the EmployeeTest attribute allows users to click on the attribute value in the SSRS report and navigate to a specific URL. This can be useful for linking to additional information or external resources related to the selected employee.

    Rate this question:

  • 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? 

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

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

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

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

    Correct Answer
    A. You should configure the Usage attribute to Distinct count and the Source Column attribute to CustomerKey.
    Explanation
    The correct answer is to configure the Usage attribute to Distinct count and the Source Column attribute to CustomerKey. This is because the measure is meant to calculate the number of customers who have placed orders, which requires counting the distinct values of the CustomerKey column.

    Rate this question:

  • 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? 

    • You should develop a Calculation which utilizes WorkerKey and BossKey

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

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

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

    Correct Answer
    A. Through utilizing BossKey, you should develop a relationship as the source column and WorkerKey as the destination colmnu.
    Explanation
    The correct answer is to develop a relationship using BossKey as the source column and WorkerKey as the destination column. This means that the BossKey column in the Worker table will be used to establish the relationship between workers and their bosses in the data source view (DSV). By creating this relationship, you can easily analyze the hierarchy and relationships between workers and their bosses in the SSAS solution.

    Rate this question:

  • 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? 

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

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

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

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

    Correct Answer
    A. You should configure the IsAggregatable property of the Employees attribute to false.
    Explanation
    The correct answer is to configure the IsAggregatable property of the Employees attribute to false. This means that the Employees attribute will not be aggregated, allowing it to be used as the root member of the parent-child hierarchy. By setting IsAggregatable to false, the topmost employee will be included in the hierarchy.

    Rate this question:

  • 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? 

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

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

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

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

    Correct Answer
    A. You should use the expression of "=Iif(Parameters! DislayValue.Value=0,False,True)"
    Explanation
    The correct answer is "=Iif(Parameters! DislayValue.Value=0,False,True)". This expression checks if the value of the parameter "DislayValue" is equal to 0. If it is, then the expression returns False, otherwise it returns True. This expression is used to operate the visibility of the column based on the parameter value.

    Rate this question:

  • 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? 

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

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

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

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

    Correct Answer
    A. You should use ExecutiveKey as the source column and WorkerKey as the destination column to create a relationship.
    Explanation
    To define the relationship between the employees and their manager in the data source view (DSV), you should use ExecutiveKey as the source column and WorkerKey as the destination column. This means that the ExecutiveKey column in the Worker table will be used to establish the relationship with the WorkerKey column. This relationship will help in organizing and analyzing the data in the BI solution created using SQL Server 2008 Reporting Services (SSRS).

    Rate this question:

  • 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? 

    • Discover_Sessions would be used

    • Discover_Commands would be used

    • Discover_Connections would be used

    • Discover_Traces would be used

    • Discover_Wizard would be used

    Correct Answer
    A. Discover_Commands would be used
    Explanation
    The correct answer is Discover_Commands would be used. This DMV provides information about the commands that are being executed on the SQL Server Analysis Services instance. By using this DMV, the query sessions that execute a query for more than 30,000 ms can be identified, as per the manager's requirements.

    Rate this question:

  • 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 regular dimension relationship should be created between the DimBills dimension and the TruthBills measure group.

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

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

    • 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.

    • 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

    Correct Answer
    A. A Truth dimension relationship should be created between the TruthBills measure group and DimBills dimension
    Explanation
    A Truth dimension relationship should be created between the TruthBills measure group and DimBills dimension. This means that the Shipper column is able to aggregate the BillQuantity column. This relationship allows for accurate analysis and reporting of data in the BI solution.

    Rate this question:

  • 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? 

    • 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

    • 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

    • 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.

    • 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

    • 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

    Correct Answer
    A. 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.
    Explanation
    To retrieve measure values based on the Age and Name attributes, the source attribute should be set to Client and the related attribute should be set to Age. This will establish a relationship between the DimClient dimension and the Production measure group based on the Client attribute. Then, the source attribute should be set to Age and the related attribute should be set to Name. This will create a hierarchy within the DimClient dimension, allowing measure values to be retrieved based on both the Age and Name attributes.

    Rate this question:

  • 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? 

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

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

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

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

    Correct Answer
    A. The solution of implementing report execution caching would be chosen to accomplish this task.
    Explanation
    The solution of implementing report execution caching would be chosen to accomplish this task. This solution allows the report to be cached for a specific duration, in this case, half an hour, after the original request. This means that subsequent requests for the same report within that timeframe can be served from the cache instead of generating the report again, reducing the processing time. This improves the performance and responsiveness of the report server, especially for complex reports that take a few minutes to generate.

    Rate this question:

  • 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? 

    • You should perform the backup of the model database

    • You should perform the backup of the MSDB database.

    • You should perform the backup of the tempdb databse

    • You should perform the backup of the master database

    Correct Answer
    A. You should perform the backup of the master database
    Explanation
    To create a failure recovery plan for packages deployed to a SQL Server, it is important to perform a backup of the master database. The master database contains crucial system configuration information and metadata about all other databases on the server. By backing up the master database, you ensure that you have a copy of this important information in case of any failures or issues. This backup will help in restoring the server to a known state and recovering the packages effectively.

    Rate this question:

Quiz Review Timeline (Updated): Mar 16, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 16, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Nov 14, 2012
    Quiz Created by
    Ranaguha

Related Topics

Recent Quizzes

Microsoft SQL Server Test! Trivia Quiz Microsoft SQL Server Test! Trivia Quiz
How well do you know MS SQL Server 2005/2008 Assessment Test? How well do you know MS SQL Server 2005/2008 Assessment Test?
SQL Server 2005 - Exam SQL Server 2005 - Exam

Featured Quizzes

Test Your Science Basics: Science Quiz Bee Test Your Science Basics: Science Quiz Bee
The Ultimate College Football Quiz Trivia The Ultimate College Football Quiz Trivia
Measurement Reading Quiz: Questions and Answers Measurement Reading Quiz: Questions and Answers
Does He Like Me? Does He Like Me?
ICT Practice Questions and Answers ICT Practice Questions and Answers
JoJo's Bizarre Adventure: Which JoJo Stand Do You Have? JoJo's Bizarre Adventure: Which JoJo Stand Do You Have?
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.