Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 61:

  You build and deploy a SQL Server 2008 Integration Services (SSIS) package.

  During package development, the XML configuration is not specified.

  You need to apply the configuration to the deployed package.

  What should you do?

  A. Use the Deployment utility.
  B. Use the SETX command line utility.
  C. Use the DTUTIL command line utility.
  D. Use the DTEXEC command line utility.
  D. Use the DTEXEC command line utility.

• Question 62:

  You are managing a SQL Server 2008 Analysis Services (SSAS) project for Company.com. You need to include a parent-child hierarchy for the dimension.

  The child key feature is named CKUser and the parent key feature is named CKManager. As the root member you need to ensure that the top user is included.

  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.
  D. You should configure the IsAggregatable property of the Employees attribute to false.

  ---

  IsAggregatable Specifies whether measures aggregate across the members of the attribute into an "all" level. http://technet.microsoft.com/en-us/library/ms174497.aspx Configuring the (All) Level for Attribute Hierarchies In Microsoft SQL Server Analysis Services, the (All) level is an optional, system-generated level. It contains only one member whose value is the aggregation of the values of all members in the immediately subordinate level. This member is called the All member. It is a system- generated member that is not contained in the dimension table. Because the member in the (All) level is at the top of the hierarchy, the member's value is the consolidated aggregation of the values of all members in the hierarchy. The All member often serves as the default member of a hierarchy.

  The presence of an (All) level in an attribute hierarchy depends on the IsAggregatable property setting for the attribute and the presence of an (All) level in a user-defined hierarchy depends on the IsAggregatable property of the attribute at the top-most level of user-defined hierarchy. If the IsAggregatable property is set to True, an (All) level will exist. A hierarchy has no (All) level if the IsAggregatable property is set to False.

  Establishing the Topmost Level If the IsAggregatable property is set to False on the source attribute of a level in a hierarchy, then no aggregatable level can appear in the hierarchy above that level. A non- aggregatable level must be the topmost level of any hierarchy or the IsAggregatable property of the source attributes for any levels above it must also be set to False. All Member and (All) Level The single member of the (All) level is called the All member. The AttributeAllMemberNameproperty on a dimension specifies the name of the All member for attributes in a dimension. The AllMemberName property on a hierarchy specifies the name of the All member for the hierarchy.

• Question 63:

  You are developing a SQL Server 2008 Analysis Services (SSAS) solution which includes a time dimension called TestTime which includes a hierarchy called Year-By-Day for Company.com. You own a measure called Number from a measure group called MeasureTester.

  In the previous time period for the current level of the Yer-Bet-Day hierarchy, you should make sure that you develop a calculated member to show the Number measure.

  Which is the correct answer?

  A. You should utilize [Measures].[ Number],OPENINGPERIOD [TestTime].[Yer-Bet- Day].FirstSibling.Level))
  B. You should utilize ([Measures].[ Number],LASTPERIODS( 0,[TestTime].[Yer-Bet- Day].PrevMember))
  C. You should utilize ([Measures].[ Number],LASTPERIODS( 1,[TestTime].[Yer-Bet- Day].PrevMember))
  D. You should utilize ([Measures].[ Number],[ TestTime].[Yer-Bet-Day].NextSibling)
  C. You should utilize ([Measures].[ Number],LASTPERIODS( 1,[TestTime].[Yer-Bet- Day].PrevMember))

  ---

  LastPeriods (MDX)

  SQL Server 2008 R2 Other Versions Returns a set of members up to and including a specified member.

  Syntax LastPeriods(Index [ ,Member_Expression ] )

  Arguments Index - A valid numeric expression that specifies a number of periods. Member_Expression - A valid Multidimensional Expressions (MDX) expression that returns a member.

  Remarks

  If the specified number of periods is positive, the LastPeriods function returns a set of members that start with the member that lags Index - 1 from the specified member expression, and ends with the specified member.

  The number of members returned by the function is equal to Index. If the specified number of periods is negative, the LastPeriods function returns a set of members that start with the specified member and ends with the member that leads (Index - 1) from the specified member. The number of members returned by the function is equal to the absolute value of Index.

  If the specified number of periods is zero, the LastPeriods function returns the empty set. This is unlike the Lag function, which returns the specified member if 0 is specified. If a member is not specified, the LastPeriods function uses

  Time.CurrentMember. If no dimension is marked as a Time dimension, the function will parse and execute without an error, but will cause a cell error in the client application.

  Examples

  The following example returns the default measure value for the second third, and fourth fiscal quarters of fiscal year 2002.

  SELECT LastPeriods(3,[Date].[Fiscal].[Fiscal Quarter].[Q4 FY 2002]) ON 0 FROM [Adventure Works]

  Note

  This example can also be written using the : (colon) operator:

  [Date].[Fiscal].[Fiscal Quarter].[Q4 FY 2002]: [Date].[Fiscal].[Fiscal Quarter].[Q2 FY 2002] The following example returns the default measure value for the first fiscal quarter of fiscal year 2002. Although the specified number of periods is

  three, only one can be returned because there are no earlier periods in the fiscal year.

  SELECT LastPeriods (3,[Date].[Fiscal].[Fiscal Quarter].[Q1 FY 2002] ) ON 0 FROM [Adventure Works]

• Question 64:

  You are developing a SQL Server 2008 Integration Services (SSIS) sample which includes some data flows for Company.com.

  Not only you should control the data that passes by every path in the data flow through utilizing the Business Intelligence Development Studio., but also you should make sure that data flow logic is left.

  Which is the correct answer?

  A. You should utilize the Data Viewer tool.
  B. You should utilize the Process Control tool.
  C. You should utilize the Audit Control tool.
  D. You should utilize Web Service.
  A. You should utilize the Data Viewer tool.

• Question 65:

  You maintain a SQL Server 2008 Integration Services (SSIS) instance.

  The instance stores packages in a SQL Server 2008 instance.

  You need to deploy the package of an instance of SSIS to another SSIS instance that stores its packages in a shared directory. What should you do?

  A. Execute the dtutil command.
  B. Execute the dtexec command.
  C. Execute the dtexecui command.
  D. Execute the dtswizard command.
  A. Execute the dtutil command.

• Question 66:

  You develop a series of SQL Server 2008 Integration Services (SSIS) packages. You need to ensure that the following requirements are met:

  

  The packages contain configurations.

  

  The configuration information is centrally stored for all packages.

  

  There are no dependencies among the packages.

  Which component should you use to configure the package? (Each correct answer presents a complete solution. Choose two.)

  A. A SQL Server 2008 table
  B. A parent package variable
  C. A registry entry
  D. An environment variable
  E. An XML configuration file
  A. A SQL Server 2008 table
  E. An XML configuration file

  ---

  Integration Services supports several different methods of storing package configurations, such as XML files, tables in a SQL Server database, and environment and package variables.

  Each configuration is a property/value pair. The XML configuration file and SQL Server configuration types can include multiple configurations. The following table describes the package configuration types.

  

  If you select the XML configuration file configuration type, you can create a new configuration file, reuse an existing file and add new configurations, or reuse an existing file but overwrite existing file content. If you select the SQL Server configuration type, you specify the connection to the SQL Server database in which you want to store the configurations. You can save the configurations to an existing table or create a new table in the specified database. Note: SSIS (SQL Server Integration Services) is an upgrade of DTS (Data Transformation Services), which is a feature of the previous version of SQL Server. Integration Services provides a platform to build data integration and workflow applications. The primary use for SSIS is data warehousing as the product features a fast and flexible tool for data extraction, transformation, and loading (ETL). ). The tool may also be used to automate maintenance of SQL Server databases, update multidimensional cube data, and perform other functions.

• Question 67:

  You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.

  

  Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.

  According to the requirement of the company CIO, you use SQL Server 2008 Integration Services (SSIS) to create a package. The exhibit below shows the structure of the package.

  You have to define a variable. The variable contains sensitive information that can only be accessed by the Sequence Container, the Data Flow Task, and the Execute SQL Task. What action should you perform?

  A. At the Data Flow Task scope, the variable should be created
  B. At the package scope, the variable should be created
  C. At the Sequence Container scope the variable should be created
  D. At the Execute SQL Task scope, the variable should be created
  C. At the Sequence Container scope the variable should be created

• Question 68:

  You create a SQL Server 2008 Analysis Services (SSAS) solution.

  You enable proactive caching for a partition.

  You need to ensure that SSAS can query relational data when multidimensional storage is being updated.

  What should you do?

  A. Set the OnlineMode property for the partition to Immediate.
  B. Set the ProcessingMode property for the partition to Regular.
  C. Set the OnlineMode property for the partition to OnCacheComplete.
  D. Set the ProcessingMode property for the partition to LazyAggregations.
  A. Set the OnlineMode property for the partition to Immediate.

• Question 69:

  You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.

  Now you are employed in a company which is named NaproStar and work as a developer of a SQL Server 2008 Reporting Services (SSRS) solution for the company. You use the solution to create a report, and then write the code segment

  in the report that is shown as the following:

  Private Shared Function GetMFromMeters(ByVal MetersPrice As Decimal) As Decimal If

  IsNothing

  (MetersPrice) Then

  Return Nothing

  Else

  Return MetersPrice * 1.78

  End If

  End Function

  However, when you compile code segment, you will get errors. Now you get an order from your company CIO, according to his requirement, not only you should get the call of the GetMFromMeters function from other reports, but also you

  should have the code segment compiled without any errors.

  So what action should be performed to accomplish the tasks above?

  A. The function should be declared from Private Shared to Public Shared
  B. Microsoft Visual Basic .NET should be used to create a custom assembly and then have the function declared as Public Shared
  C. The Public keyword should be removed from the function definition
  D. The Private keyword should be removed from the function definition
  E. The Shared keyword should be removed from the function definition
  B. Microsoft Visual Basic .NET should be used to create a custom assembly and then have the function declared as Public Shared

• Question 70:

  You develop a SQL Server 2008 Integration Services (SSIS) package.

  The package downloads several files from a remote FTP server by using multiple FTP tasks, and then processes data by using multiple Execute SQL tasks.

  You need to configure the package to restart at the point of failure after the package downloads the files.

  What should you do?

  A. Configure the FTP tasks to support transactions.
  B. Configure the Execute SQL tasks to support transactions.
  C. Move all the FTP tasks to a sequence container.
  D. Configure the package to use a checkpoint.
  D. Configure the package to use a checkpoint.