Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 191:

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

  You need to modify the package to log event data from a text file to the SQL Server database.

  Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

  A. Modify the Flat File Destination.
  B. Modify the log provider.
  C. Move the package file to the new path.
  D. Modify the Connection Manager.
  B. Modify the log provider.
  D. Modify the Connection Manager.

  ---

  B: The SQL Server log provider, which writes log entries to the sysssislog table in a SQL Server database.

  D: A package typically includes at least one connection manager. A connection manager is a link between a package and a data source that defines the connection string for accessing the data that the tasks, transformations, and event handlers in the package use. Integration Services includes connection types for data sources such as text and XML files, relational databases, and Analysis Services databases and projects.

  Note: A log is a collection of information about the package that is collected when the package runs. For example, a log can provide the start and finish time for a package run. A log provider defines the destination type and the format that the package and its containers and tasks can use to log run-time information.

  The logs are associated with a package, but the tasks and containers in the package can log information to any package log. Integration Services includes a variety of built-in log providers for logging. For example, Integration Services includes log providers for SQL Server and text files. You can also create custom log providers and use them for logging.

  Incorrect:

  Not A: The destination is a SQL Server database, not a text file. References: Integration Services (SSIS) Packages

• Question 192:

  You are a database developer and you have about two years experience in reating 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.

  Your solution includes a time dimension named DimDay.

  And the DimDay dimension contains a hierarchy named Yr-Qtr-Mth. There is a measure group named Measures01 which contains a measure named Number. Now a calculated member has to be created, then it will be used to display the

  Number measure in the previous time period for the current level of the Yr-Qtr- Mth hierarchy.

  In the following options, which expression should be used?

  A. ([Measures01].[Number],OPENINGPERIOD( [DimDay].[Yr-Qtr-Mth].FirstSibling.Level))
  B. ([Measures01].[Number],LASTPERIODS( 0,[DimDay].[Yr-Qtr-Mth].PrevMember))
  C. ([Measures01].[Number],[DimDay].[Yr-Qtr-Mth].PrevMember)
  D. ([Measures01].[Number],[DimDay].[Yr-Qtr-Mth].FirstSibling)
  C. ([Measures01].[Number],[DimDay].[Yr-Qtr-Mth].PrevMember)

  ---

  Functions for navigating Hierarchies

  MDX provides functions such as PrevMember, Children, and Parent for navigating hierarchies. PrevMember takes a member and returns a previous member in the hierarchy. For example, [Order Date]. [Calendar].PrevMember returns the

  previous member with respect to the current member of the Calendar hierarchy. So if the Calendar hierarchy is expanded to the Year level and the current cell is referenced by year 2004, PrevMember will return year 2003.

  EXAM TIP

  The PrevMember function is frequently used to defi ne the KPI Trend or Goal properties. for example, the Reseller Sales KPI uses the following expression to set the Goal property to 40 percent more than the Reseller Sales Amount for the

  previous date period: 1.40 * ([Date].

  [Calendar].PrevMember, [Measures].[Reseller Sales

  Amount])

  Consequently, if the user browses the cube data by years, the PrevMember function will return the previous year for each year. If the user browses data by quarters, the PrevMember will return the previous quarter for each quarter, and so on.

• Question 193:

  You maintain a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains a database that is used by the members of the Engineering group.

  You configure a new role named Engineering and Design by using the following allowed permission set:

  {[Employees].[Department].[Engineering and Design]}

  You assign the Engineering group to the Engineering and Design role.

  You need to ensure that users in the Engineering and Design role can only view data for their department.

  What should you do?

  A. Add your account temporarily to the Engineering and Design role.
  B. Select the Enable Visual Totals check box for the Engineering and Design role.
  C. Add the Roles= [Engineering and Design]; parameter to the connection string.
  D. Add the User ID= [Engineering and Design]; parameter to the connection string.
  C. Add the Roles= [Engineering and Design]; parameter to the connection string.

• Question 194:

  You are an ETL developer for a mortgage company. In your application you have two tables named Vendor and Loan. Vendor sample data is shown in the following table:

  

  Loan sample data is shown in the following table:

  

  You need to build a SQL Server 2008 Integration Services (SSIS) package that meets the following requirements:

  

  The package should be able to generate the Excel files dynamically.

  

  Each file should have the vendor name as the prefix and the date as the suffix (e.g.,VendorA_DDMMYYYY.xlsx).

  

  All the vendor names should be added to a variable and loop through the variable to generate and load separate files for each vendor dynamically.

  Which type of variable should you create? (To answer, select the appropriate option in the dialog box in the answer area.)

  Hot Area:

  

  

• Question 195:

  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.
  D. You should Change the UnKnownMember property of the DimProducts dimension to Hidden.

• Question 196:

  You are managing a SQL Server 2008 Analysis Services (SSAS) instance which includes a database for Company.com.

  You alter the DataDir attribute of the instance to a new folder. You should make sure that instance utilizes the new folder in least time.

  Which is the correct answer?

  A. You should operate the database.
  B. You should operate the database at the same time.
  C. You should stop the Analysis Services service.
  D. Before stopping the Analysis Services service you should remove the files in the original folder,
  A. You should operate the database.

• Question 197:

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

  You create a dimension named DimCustomer that contains the following three attributes:

  

  Customer

  

  City

  

  Country

  The Customer attribute is the key. The DimCustomer dimension is related to a measure group named Sales that has the Granularity property set to City.

  You need to ensure that you can retrieve measure values based on the City and Country attributes.

  What should you do?

  A. Set the source attribute to Customer and the related attribute to City.Set the source attribute to City and the related attribute to Country.
  B. Set the source attribute to City and the related attribute to Customer.Set the source attribute to Country and the related attribute to City.
  C. Set the source attribute to Customer and the related attribute to City.Set the source attribute to Customer and the related attribute to Country.
  D. Set the source attribute to City and the related attribute to Customer.Set the source attribute to Country and the related attribute to Customer.
  A. Set the source attribute to Customer and the related attribute to City.Set the source attribute to City and the related attribute to Country.

• Question 198:

  You design a report by using SQL Server 2008 Reporting Services (SSRS).

  The report will be included in a Windows Forms application that is distributed to remote users.

  These users have no access to the report server.

  You need to ensure that the application renders the report correctly.

  What should you do?

  A. Use the ReportViewer control along with the LocalReport property.
  B. Use the ReportViewer control along with the RemoteReport property.
  C. Use the Render method of the Reporting Services Simple Object Access Protocol (SOAP) API.
  D. Use the RenderStream method of the Reporting Services Simple Object Access Protocol (SOAP) API.
  A. Use the ReportViewer control along with the LocalReport property.

• Question 199:

  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.
  B. You should create a dataset filter and include the appropriate limiting expression.

• Question 200:

  You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the package by using your local development environment.

  You deploy the package to the file system in the production environment. The users report that the connection strings contained in the package are blank. The package fails to execute.

  You need to change the protection level of the package to ensure that users can view and execute the package.

  Which protection level should you use?

  A. DontSaveSensitive
  B. EncryptAllWithUserKey
  C. EncryptAllWithPassword
  D. ServerStorage
  C. EncryptAllWithPassword