Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 131:

  You maintain a SQL Server 2008 Analysis Services (SSAS) instance.

  You plan to run the Usage-Based Optimization Wizard. You need to enable query logging.

  What should you do?

  A. Set the LogDir server property to a valid path.
  B. Set the QueryLogSampling server property to 10.
  C. Set the AllowedBrowsingFolders server property to include the folder from the LogDir setting.
  D. Set the QueryLogConnectionString server property to a valid connection string.
  D. Set the QueryLogConnectionString server property to a valid connection string.

• Question 132:

  You are creating a SQL Server 2008 Integration Services (SSIS) instance which is deployed to a production server for Company.com.

  You should utilize local development environment to check it.

  You should make sure that you should set the protection level for users when the user decides to run it.

  Which is the correct answer?

  A. You should utilize EncryptPartWithPassword
  B. You should utilize EncryptSensitiveWithLoginName
  C. You should utilize SaveSensitive
  D. You should utilize EncryptAllWithUserKey
  D. You should utilize EncryptAllWithUserKey

• Question 133:

  You are creating a SQL Server 2008 Integration Services (SSIS) instance which utilizes a default connection manager to link to a component for Company.com.

  In order to provide authentication for your report, you develop an XML configuration file. You increase the file to an XML configuration file. But you get error message that you could not login when you running the package.

  You should make sure that you should run the package normally.

  Which is the correct answer?

  A. You should change the XML configuration file.
  B. You should utilize direct XML settings.
  C. On the same server, you should execute the package as the component.
  D. You should utilize a Microsoft ADO.NET connection manager.
  A. You should change the XML configuration file.

• Question 134:

  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) for the company. You use SSRS to design a report.

  A Windows Forms application is distributed to remote users and it contains the report, but the report server can not be accessed by these remote users.

  Now you are asked to make sure that the report can be rendered by the application correctly.

  Of the following methods, which one would be used to accomplish this task?

  A. The ReportViewer control should be used along with the RenderStream property
  B. The ReportViewer control should be used along with the LocalReport property
  C. The ReportViewer control should be used along with the RemoteReport property
  D. The Render method of the Reporting Services Simple Object Access Protocol (SOAP) API should be used.
  E. The RenderStream method of the Reporting Services Simple Object Access Protocol (SOAP) API should be Used
  B. The ReportViewer control should be used along with the LocalReport property

• Question 135:

  You are developing a SQL Server 2008 Reporting Services (SSRS) method for Company.com. There are some components listed below:

  A hierarchy called Test in a time dimension called DimTestTime A method called SalesNumber You decide to increase codes to the cube's calculation

  11. . . .

  12 Freeze([Measures].[ SalesNumber],

  13 [DimTestTime].[ Test].[Quarter].[Q0 2008]);

  14. . . .

  For every month in the second quarter of 2008, not only should you add the value of the SalesNumber measure through 80%. But also you should make sure that the value for the second quarter of 2008 keeps common. Which is the correct answer?

  A. You should increase codes below at line 14. Scope([Measures].[DimTime].[Date].[Quarter]. [Q0 2008]);This= [DimTime].[Date].currentmember * 3;End Scope;
  B. You should increase codes below at line 11. Scope([Measures].[ SalesNumber], [ DimTestTime].[ Test]. [Quarter]. [Q0 2008]);End Scope;
  C. You should increase codes below at line 14 [ SalesNumber],Descendants([DimTestTime]. [ Test].[Quarter]. [Q0 2008][ DimTestTime].[ Test].[Month]));This=[ DimTestTime]. [ Test].currentmember * 5;End Scope;
  D. You should increase codes below at line 11. Scope([Measures] SalesNumber],Descendants ([DimTestTime]. [ Test].[Second].[ Q0 2008][ DimTestTime].[ Test]. [ Second]));This=[ [ Test] [Second].currentmember * 1.5; End Scope;
  C. You should increase codes below at line 14 [ SalesNumber],Descendants([DimTestTime]. [ Test].[Quarter]. [Q0 2008][ DimTestTime].[ Test].[Month]));This=[ DimTestTime]. [ Test].currentmember * 5;End Scope;

• Question 136:

  You are creating a SQL Server 2008 Analysis Services (SSAS) database which contains some measure groups for Company.com.

  One of measure groups Product Data allows refresh Than others' frequently. You should make sure that Product Data measure group would operate on a schedule managed through SSAS.

  Which is the correct answer?

  A. You should change the attribute of the ProactiveCaching property.
  B. You should change the attribute of the DataAggregation property.
  C. You should change the attribute of the ProcessingMode property.
  D. You should change the attribute of the ProcessingPriority property.
  A. You should change the attribute of the ProactiveCaching property.

  ---

  The ProactiveCaching property determines whether the SSAS service will process and update the dimension automatically. Most typical SSAS solutions use MOLAP storage and do not employ proactive caching.

  EXAM TIP Proactive caching is especially useful when the relational database is transaction oriented and data changes at random. When data changes are predictable--such as when you use an extract, transform, and load (ETL) process to load data-consider processing the cube explicitly. When the data source is transaction oriented and you want minimum latency, consider confi guring the cube to process automatically by using proactive caching. How Proactive Caching Works When you enable proactive caching, the server can listen for data change notifications and can update dimensions and measures dynamically in an "autopilot" mode.

• Question 137:

  You are developing a SQL Server 2008 Integration Services (SSIS) data flow that loads data to a SQL Server 2008 database.

  You need to ensure that the data flow updates the existing records in the SQL Server database by using data from the rows in your data flow.

  Which data flow component should you use?

  A. OLE DB Destination
  B. SQL Server Destination
  C. Data Conversion Transformation
  D. OLE DB Command Transformation
  B. SQL Server Destination

  ---

  Destinations are the data flow components that load the data in a data flow into different types of data sources or create an in-memory dataset.

  Note 1: SQL Server Integration Services provides three different types of data flow components:

  sources, transformations, and destinations. Sources extract data from data stores such as tables and views in relational databases, files, and Analysis Services databases. Transformations modify, summarize, and clean data. Destinations

  load data into data stores or create in-memory datasets. Note 2: The Data Flow task encapsulates the data flow engine that moves data between sources and destinations, and lets the user transform, clean, and modify data as it is moved.

  Addition of a Data Flow task to a package control flow makes it possible for the package to extract, transform, and load data. A data flow consists of at least one data flow component, but it is typically a set of connected data flow components:

  sources that extract data; transformations that modify, route, or summarize data; and destinations that load data. Components are connected in the data flow by paths. Each path specifies the two components that are the start and the end of

  the path.

• Question 138:

  You create a SQL Server 2008 Reporting Services (SSRS) report that contains a dataset.

  The dataset retrieves data by executing a stored procedure. The report contains a table and a matrix that use the dataset.

  You need to limit data that is displayed in the table while ensuring that the matrix is unaffected.

  What should you do?

  A. Add a filter to the dataset.
  B. Add a filter to the matrix.
  C. Add a filter to the table.
  D. Add a parameter to the stored procedure that filters the result set.
  C. Add a filter to the table.

• Question 139:

  Your company network includes a SQL Server 2008 R2 database server with the SQL Server 2008 Analysis Services (SSAS) role enabled.

  You design a cube named Materials with a measure group named MaterialsInventory. This group has a measure, QuantityOnHand, which shows the total stock in inventory for the company by time.

  You need to determine the inventory at the end of a quarter.

  What should you do?

  A. Define the MaterialsInventory group as a semi-additive measure group.
  B. Define the MaterialsInventory group as an additive measure group.
  C. Define the QuantityOnHand measure as an additive measure.
  D. Define the QuantityOnHand measure as a semi-additive measure.
  D. Define the QuantityOnHand measure as a semi-additive measure.

• Question 140:

  You maintain a SQL Server 2008 Analysis Services (SSAS) database. You plan to troubleshoot query performance by using SQL Profiler.

  You need to identify the queries that take a long time to run.

  Which trace event should you use?

  A. Query Cube End
  B. Query Subcube
  C. MDX Script End
  D. Get Data from Cache
  B. Query Subcube