1. Home
  2. Microsoft
  3. 70-448

Microsoft 70-448 Online Practice Questions and Exam Preparation

70-448 Exam Details

  • Exam Code
    :70-448
  • Exam Name
    :TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan
  • Certification
    :Microsoft Certifications
  • Vendor
    :Microsoft
  • Total Questions
    :331 Q&As
  • Last Updated
    :Feb 05, 2022

Microsoft 70-448 Online Questions & Answers

  • Question 231:

    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.

  • Question 232:

    You are editing a SQL Server 2008 Integration Services (SSIS) package by using Business Intelligence Development Studio. The package uses a custom data flow component. The package runs successfully. You attempt to add another

    instance of the custom data flow component to the package. The data flow component does not appear in the toolbox or in the Choose Toolbox Items dialog box.

    You need to add the custom data flow component to the toolbox.

    What should you do?

    A. Copy the assembly to the appropriate folder.
    B. Add the assembly to the Global Assembly Cache.
    C. Register the assembly by using the REGSVR32 utility.
    D. Register the assembly by using the Assembly Registration utility (REGASM.EXE).

  • Question 233:

    You are developing a SQL Server 2008 Analysis Services (SSAS) method for Company.com.

    The cube structure is listed below:

    For one TestAccount member, the total value in the Ownership column is 100%. The Ownership column includes decimal values which stand for percentage of ownership. The measures listed below are developed:Ownershiper Number You

    should make sure that the weighted value is computed according to the Ownership measure

    when you are computing against the TestCustomer dimension.

    Which is the correct answer?

    A. You should configure the MeasureExpression attribute of the Number method to [Number]* Ownershiper].
    B. You should configure the FormatString attribute of the Number method to [DimCustomer]. [Number]*[ Ownershiper].
    C. You should configure the MeasureExpression attribute of the Number method to [TestCustomer]. [ Number].
    D. You should configure the FormatString attribute of the Number method to [TestCustomer]. [ Number].

  • Question 234:

    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

  • Question 235:

    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.

    The package includes several data flows. Now you receive an e-mail from your company CIO, according to his requirement, you have to make use of the Business Intelligence Development Studio to monitor the data that passes through each

    path in the data flow.

    Besides this, the company CIO also wants the data flow logic is retained. You have to achieve this goal. So what action should you perform?

    A. In order to accomplish the task, the Audit transformation should be used
    B. In order to accomplish the task, the Data Viewer tool should be used
    C. In order to accomplish the task, you should use breakpoints in the Script component
    D. In order to accomplish the task, the Data Profiling task should be used

  • Question 236:

    You are creating a SQL Server 2008 Integration Services (SSIS) instance which includes components below for Company.com.

    *An OnError method *A data flow job included in a For Loop container *A Flat File result component which utilizes a Flat File connection controller.

    You decide to log error information from an expression which contains the package version to a doc file when you get error message. You should make sure that the information is writte into the doc file.

    Which is the correct answer?

    A. You should utilize the VersionGUID variable.
    B. You should utilize the GUID variable.
    C. You should utilize the TESTID variable.
    D. You should utilize the USERID variable.

  • Question 237:

    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). To meet the business development, you create a (SSAS) solution

    and enable proactive caching for a partition. Now you get an order from your company CIO, according to his requirement, while updating the multidimensional storage, you should make sure that you can use SSAS to query relational data.

    What action below should be performed?

    A. To achieve this goal, the OnlineMode property for the partition should be set to OnCacheComplete
    B. To achieve this goal, the ProcessingMode property for the partition should be set to LazyAggregations.
    C. To achieve this goal, the OnlineMode property for the partition should be set to Immediate.
    D. To achieve this goal, the ProcessingMode property for the partition should be set to Regular

  • Question 238:

    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 Reporting Services (SSRS) database server. Large quantities of reports are contained in the instance, and the reports executes slowly. Multiple execution snapshots are contained in the reports.

    There is a new production server and you have installed SSRS on the server.

    Now you receive an e-mail from your company CIO, according to the requirement of the CIO, the reports and their snapshots have to be moved to the production server as soon as possible.

    You've been assigned this task. So what action should you perform to achieve this goal?

    A. In order to achieve this goal, you should use Business Intelligence Development Studio (BIDS) to deploy the solutions
    B. In order to achieve this goal, you should use the rs.exe utility
    C. In order to achieve this goal, you should copy the Report Server databases to the production server. Then use the Reporting Services Configuration tool to configure the server.
    D. In order to achieve this goal, you should use the rskeymgmt.exe utility

  • Question 239:

    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, you're desinging a SQL Server 2008 Integration Services (SSIS) package.

    The package contains a Data Flow task which copies several million rows. There is a reference table that contains 10,000 rows. The data flow needs a match against the reference table. During the data flow, each row in the reference table will be used.

    You must make sure that the data flow takes as little time to execute as possible. Of the following data flow components, which one should you use?

    A. You should use a Fuzzy Lookup transformation
    B. You should use a Lookup transformation along with the No cache option
    C. You should use a Lookup transformation along with the Full cache option
    D. You should use a Lookup transformation along with the Partial cache option

  • Question 240:

    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.

    Now you are assigned a task to have the analysis services query log configured for the SSAS instance.

    Which tool below would be used to accomplish this task?

    A. SQL Server Business Intelligence Development Studio would be used to accomplish this task
    B. SQL Server Business Intelligence Management Studio would be used to accomplish this task
    C. SQL Server Configuration Manager would be used to accomplish this task
    D. SQL Server Management Studio would be used to accomplish this task
    E. SQL Server Error and Usage Reporting would be used to accomplish this task

Related Exams:

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Microsoft exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 70-448 exam preparations and Microsoft certification application, do not hesitate to visit our Vcedump.com to find your solutions here.