Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 71:

  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 are in charge of an instance of a SQL Server 2008 server.

  You use the server to execute SQL Server 2008 Integration Services (SSIS) packages. Now you get an e- mail from your company CIO, according to the requirement of the CIO, the server must only execute only correctly signed packages.

  The company CIO assigns this task to you. So what should you do to achieve this goal?

  A. On all packages, the package protection level should be set to DontSaveSensitive
  B. On all packages, the package protection level should be set to EncryptSensitiveWithPassword
  C. You should set the BlockedSignatureStates registry entry to Block invalid and untrusted signatures and unsigned packages
  D. Tthe BlockedSignatureStates registry entry should be set to NoAdministrativeRestriction
  C. You should set the BlockedSignatureStates registry entry to Block invalid and untrusted signatures and unsigned packages

  ---

  Signing Packages with Certificates

  A SQL Server 2005 Integration Services (SSIS) package can be signed with a certificate and configured to require the runtime to check the signature before loading the package. The properties of the package, CheckSignatureOnLoad and

  CertificateObject, indicate whether a certificate must be checked, and specify the certificate that was used to sign the package. The certificate used to sign the package must be enabled for code signing. Integration Services provides a

  registry value that you can use to manage an organization's policy for loading signed and unsigned packages. The registry value can also manage untrusted signatures of signed packages.

  With regard to the status of signatures used to sign packages, the BlockedSignatureStates registry value uses the following definitions:

  A valid signature is one that can be read successfully.

  An invalid signature is one for which the decrypted checksum (the one-way hash of the package code encrypted by a private key) does not match the decrypted checksum that is calculated as part of the process of loading Integration

  Services packages. A trusted signature is one that is created by using a digital certificate signed by a Trusted Root Certification Authority. This setting does not require the signer to be found in the user's list of Trusted Publishers.

  An untrusted signature is one that cannot be verified as issued by a Trusted Root Certification Authority, or a signature that is not current.

  To use the registry value to prevent packages from loading if the packages are unsigned, or have invalid or untrusted signatures, you must add the BlockedSignatureStates DWORD value to the HKEY_LOCAL_MACHINE\SOFTWARE

  \Microsoft\MSDTS registry key and specify the value 0, 1, 2, or 3. The following table lists the valid values of the DWORD data and their associated policies.

  

• Question 72:

  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
  D. You should set Content Manager

  ---

  http://msdn.microsoft.com/en-us/library/ms157363.aspx Content Manager Role Includes all item-level tasks. Users who are assigned to this role have full permission to manage report server content, including the ability to grant permissions to other users, and to define the folder structure for storing reports and other items.

• Question 73:

  

  You are developing a SQL Server 2008 Reporting Services (SSRS) method for Company.com. There is a report which includes one dataset and a query parameter in this solution. From the Report Manager; you should make sure that the report runs without user interaction.

  Which is the correct answer?

  A. You should utilize the snapshot execution to set the report
  B. You should set useful data for the parameter from the datatable.
  C. You should set the default value for the parameter which is base on an expression.
  D. When the parameter is updated you should set the parameter data to update.
  C. You should set the default value for the parameter which is base on an expression.

• Question 74:

  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 Analysis Services (SSRS) for the company.

  You are in charge of a SSAS database that is contained on a default instance. According to your plan, the Analysis Services performance information will be documented by the computer. In order to achieve this goal, information related to the

  temporary file usage should be collected at the time of processing the database.

  So of the following objects, which one object should be used?

  A. MSAS 2008: Proc Aggregations would be used to achieve this goal
  B. MSAS 2008: Storage Engine Query would be used to achieve this goal
  C. MSAS 2008: Memory would be used to achieve this goal
  D. MSAS 2008: Cache would be used to achieve this goal
  A. MSAS 2008: Proc Aggregations would be used to achieve this goal

  ---

  http://www.ssas-info.com/analysis-services-articles/58-ssas-2008/1113-analysis-services-2008- performancecounters

  

• Question 75:

  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 Northeast Region and Bikes.

  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 Bikes category in the Northeast region.

  Which is the correct answer?

  A. You should increase Clerk to a Bikes role
  B. You should increase Clerk to the Northeast Region role.
  C. You should increase Clerk to a new role which owns components below: [Products Territory Region]. [Northeast]} as the permitted configuration.{[Product].[Product Category]. [Product Category].[Bikes]} as the permitted
  D. You should increase Clerk to the default Region role.
  C. You should increase Clerk to a new role which owns components below: [Products Territory Region]. [Northeast]} as the permitted configuration.{[Product].[Product Category]. [Product Category].[Bikes]} as the permitted

  ---

  There was a mess in original q - Nikes, Bikes, Southwest, Northwest... I think I have fixed it :) another version of the q is:

• Question 76:

  You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com. In order to specify the XML configuration during package development, you should apply the configuration to the deployed package.

  Which is the correct answer?

  A. You should utilize the Publish utility.
  B. You should utilize the default command line utility.
  C. You should utilize the exec command line utility.
  D. You should utilize the DTEXEC command line utility.
  D. You should utilize the DTEXEC command line utility.

• Question 77:

  Through utilizing SQL Server 2008 Analysis Services (SSAS) for Company.com,you are developing a model of data mining. Through utilizing the listed Data Mining Extensions (DMX) codes, you could develop a structure

  CREATE MINING STRUCTURE [Clerk Maker] ( [User Key] LONG KEY,[Total Age] LONG DISCRETIZED (Automatic, 20),[Clerk Maker] LONG ISCRETE,[Distance] TEXT DISCRETE,[Monthly Income] DOUBLE CONTINUOUS)

  Not only should you develop a mining model which could be operated through utilizing this structure, but also you should make sure that the model utilizes the Microsoft algorithm. Which is the correct answer?

  A. You should add codes below: ALTER MINING STRUCTURE [Clerk Maker] ADD MINING MODEL [Decision Tree] ([User Key], [Total Age], [Clerk Maker] PREDICT, [Distance], [Monthly Income])
  B. You should add codes below: INSERT INTO [Decision Tree] ([User Key], [Clerk Maker], [Monthly Income]) OPENQUERY ([Clerk Maker],'Select [User Key], [Clerk Maker], [Monthly Income]')
  C. You should add codes below: SELECT * FROM [Decision Tree] USING [Microsoft_Decision_Trees] FROM [Decision Tree]]
  D. You should add codes below: SELECT * FROM [Decision Tree] USING [Microsoft_Decision_Trees] FROM [Clerk Maker]
  A. You should add codes below: ALTER MINING STRUCTURE [Clerk Maker] ADD MINING MODEL [Decision Tree] ([User Key], [Total Age], [Clerk Maker] PREDICT, [Distance], [Monthly Income])

• Question 78:

  You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. Among the cubes, you are developing a new measure group. You own a program which keeps partitions on the production copy of the cube. You should make sure that you could get the cube definition on the production server when you should not overwrite any existed partitions.

  Which is the correct answer?

  A. You should utilize the Deployment Wizard together with the proper selection.
  B. You should utilize a SQL Server 2008 Integration Services (SSIS) package and configure the processing selection to Do Process.
  C. You should utilize the Analysis Services Destination component in Microsoft SQL Server Integration Services (SSIS).
  D. You should utilize the DBCC SHRINKFILE and configure the processing selection to Do Process.
  A. You should utilize the Deployment Wizard together with the proper selection.

• Question 79:

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

  You need to modify the path where the package writes event data to a text file.

  What should you do?

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

• Question 80:

  You are developing a SQL Server 2008 Reporting Services (SSRS) solution for Company.com. The codes in the report listed below:

  Private Shared Function GetResultFromPar(ByVal TestValue As Double ) As Double If IsNothing (TestValue) Then Return NothingElseReturn InchValue * 3.15 End If End Function The above function will display error when you compile the codes. You should make sure that conditions listed below are required: *The code segment compiles normally. *The GetResultFromPar function could be implemented from other reports.

  Which is the correct answer?

  A. You should delete the ByVal keyword from the function definition.
  B. You should delete the Shared keyword from the function definition.
  C. You should create the function as protected Shared instead of Public Shared.
  D. Before declaring the function as Public Shared, you should develop a custom assembly through utilizing Microsoft Visual Basic .NET.
  D. Before declaring the function as Public Shared, you should develop a custom assembly through utilizing Microsoft Visual Basic .NET.