Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 161:

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

  The report uses a Table data region and contains a dataset. The dataset has a column named LastName.

  You need to ensure that the report items are grouped by the first character in the LastName column.

  Which expression in the Group properties dialog box should you use?

  A. =First(Fields!LastName)
  B. =Fields!LastName.Value
  C. =First(Fields!LastName.Value)
  D. =Fields!LastName.Value.Substring(0,1)
  D. =Fields!LastName.Value.Substring(0,1)

• Question 162:

  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 Integration Services (SSIS) for the company.

  To meet the business requirement, you use the SSIS to develop a package and use your local development environment to test the package.

  Then the package is deployed to the file system in the production environment. After the deployment, the users notice that the package contains no connection strings, which means the package gets a failure of the deployment.

  Now you are assigned a task to make sure that the package can be viewed and executed by changing the protection level of the package.

  So of the protection levels of the package, which one would be used?

  A. EncryptAllWithPassword level would be used
  B. ServerStorage level would be used
  C. ServerChange level would be used
  D. DontSaveSensitive level would be used
  E. EncryptAllWithUserKey level would be used
  A. EncryptAllWithPassword level would be used

• Question 163:

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

  The package displays job listed below:

  -

  You should operate multiple files through utilizing a For Each Loop container.

  -

  You should get the files' content to a table through utilizing a Data Flow task.

  -

  Through utilizing an Execute SQL task, you should Log the results of the state into a table

  -

  You should make sure that the Execute SQL task only could not run in one transaction. Which is the correct answer? (Select more than one)

  A. You should set the TransactionOption property to RequiredNew in the package.
  B. You should set the TransactionOption property to Supported in the package.
  C. You should set the TransactionOption property to Required in the package.
  D. You should set the TransactionOption property to None in the package.
  E. You should set the TransactionOption property to NotSupported in the Execute SQL task.
  F. You should set the TransactionOption property to Supported in the Execute SQL task.
  C. You should set the TransactionOption property to Required in the package.
  E. You should set the TransactionOption property to NotSupported in the Execute SQL task.

  ---

  To enable a transaction within a package, you need to set the TransactionOption property of the task or container to Required. Figure 2-1 highlights the properties of a package at the control flow level, which means that the properties apply to the package as a whole. The TransactionOption property is the same on any control flow object. When deciding whether and how to implement a transaction, follow these guidelines:

  -

  For transactions to be enabled in SSIS, you need to start the MSDTC service, and the tasks that you want to be part of the transaction must work with the MSDTC service natively.

  -

  If a series of tasks must be completed as a single unit in which either all the tasks are successful and committed or an error occurs and none of the tasks are committed, place the tasks within a Sequence Container and then set the TransactionOption property of the container to Required.

  -

  A task can inherit the transaction setting of its parent when the TransactionOption property is set to Supported, which is the default setting when creating a task or container.

  -

  You can prevent a task from participating in a transaction by setting its TransactionOption property to NotSupported.

  -

  If you set the TransactionOption property of a Foreach Loop Container or For Loop Container to Required, a new transaction will be created for each loop of the container.

  -

  Transactions work at the control fl ow level and not within a data flow. Therefore, you can turn on a transaction for a Data Flow Task, but you cannot turn it on separately for selected components within the data fl ow; either the entire data process will be successful or it will be rolled back.

• Question 164:

  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. Now you are in charge of a SQL Server 2008 Analysis Services (SSAS) instance. There is a database in the instance.

  After the DataDir property of the instance is changed to a new folder, you must make sure that the instance uses the new folder with as little downtime as possible. So what action should you perform?

  A. You have to synchronize the database
  B. You have to process the database
  C. After you delete the files in the original folder, you have to restart the Analysis Services service.
  D. You have to shut down the Analysis Services service, and then restart it
  B. You have to process the database

• Question 165:

  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 configured with the use of multiple security roles. There is a Microsoft ASP.NET application running on a remote computer.

  Then in order access the database, Windows Authentication is used to configure the application. Now you get an order from your company CIO, according to his requirement, you have to make sure that the SSAS database can be accessed

  successfully by the users of the application. Besides, you have to make sure that you apply security restrictions of the roles on SSAS.

  So what action should you perform to achieve that goal?

  A. You should have the Security\RequireClientAuthentication property set to True
  B. You should have Securityproperty configured for HTTP authentication
  C. You should have Kerberos authentication configured on the Analysis Services
  D. You should have Analysis Services configured for HTTP authentication
  E. You should have the AnonymousConnectionsEnabled policy set to True
  C. You should have Kerberos authentication configured on the Analysis Services

• Question 166:

  You develop a SQL Server 2008 Reporting Services (SSRS) report.

  A Multidimensional Expressions (MDX) query used in the report contains a parameter to display sales data for various product categories. You write the following query.

  

  You discover that the query generates an error when executed. You need to ensure that the query executes successfully.

  What should you do?

  A. Remove the NON EMPTY clauses.
  B. Replace the CHAPTERS axis with the ROWS axis.
  C. Replace the CHAPTERS axis with the SECTIONS axis.
  D. Rewrite the query to display the Order Quantity on the COLUMNS axis, the Calendar Year on the ROWS axis, and the Category data on the PAGES axis.
  B. Replace the CHAPTERS axis with the ROWS axis.

• Question 167:

  You are responsible for the SQL Server 2008 Integration Services (SSIS) instance at your organization.

  This instance uses SQL Server Authentication.

  Other developers develop, configure, and deploy packages to the MSDB database.

  You need to determine whether a package named "DailyLoad" exists in the MSDB database on the local instance of SQL Server.

  What is the correct dtutil command syntax?

  A. dtutil /FILE W:/DailyLoad.dtsx /EXISTS
  B. dtutil /SQL DailyLoad /EXISTS
  C. dtutil SQL DailyLoad /USERNAME xyz /OSERPASSWORD xxxxxx /EXISTS
  D. dtutil /DTS DailyLoad.dtsx /MOVE SQL; destPackage
  C. dtutil SQL DailyLoad /USERNAME xyz /OSERPASSWORD xxxxxx /EXISTS

• Question 168:

  You are managing a SQL Server 2008 Reporting Services (SSRS) sample which includes some reports for Company.com.

  Through utilizing the Business Intelligence Development Studio (BIDS), you will publish a report project.

  You find out that the data sources are changed through the test data sources on the report. You should make sure that the existed reports are running normally when the report project is published soon. Which is the correct answer?

  A. You should modify properties of OverwriteDataSources
  B. You should modify properties of DataSourceFolder
  C. You should modify properties of ServerURL
  D. You should modify properties of ReportFolder
  A. You should modify properties of OverwriteDataSources

• Question 169:

  You administer an instance of a SQL Server 2008 server.

  The server is used to execute SQL Server 2008 Integration Services (SSIS) packages.

  You need to ensure that the server executes only correctly signed packages.

  What should you do?

  A. Set the BlockedSignatureStates registry entry to NoAdministrativeRestriction.
  B. Set the package protection level on all packages to EncryptSensitiveWithPassword.
  C. Set the BlockedSignatureStates registry entry to Block invalid and untrusted signatures and unsigned packages.
  D. Set the package protection level on all packages to DontSaveSensitive.
  C. Set the BlockedSignatureStates registry entry to Block invalid and untrusted signatures and unsigned packages.

  ---

  A SQL Server 2008 Integration Services (SSIS) package can be signed with a certificate and configured to require the runtime to check the signature before loading the package. he 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 170:

  You are creating a SQL Server 2008 Integration Services (SSIS) instance which contains a Data Flow task for Company.com.

  In order to change the package to write the whole rows that gets errors to a doc file. Which is the correct answer? (Select more than one)

  A. For the doc file, you should utilize the SSRS log provider.
  B. For the SQL Provider, you should utilize the SSRS log provider.
  C. You should utilize a Flat File Destination component.
  D. You should utilize a text File Destination component.
  E. You should increase an Error output to the Data Flow component
  C. You should utilize a Flat File Destination component.
  E. You should increase an Error output to the Data Flow component