Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 211:

  You are designing a SQL Server 2008 Integration Services (SSIS) package. The package includes a Data Flow task that copies several million rows. The data flow requires a match against a reference table that contains 10,000 rows. Each

  row in the reference table will be used during the data flow.

  You need to ensure that the data flow executes in the minimum amount of time.

  Which data flow component should you select?

  A. a Fuzzy Lookup transformation
  B. a Lookup transformation along with the Full cache option
  C. a Lookup transformation along with the No cache option
  D. a Lookup transformation along with the Partial cache option
  B. a Lookup transformation along with the Full cache option

• Question 212:

  You develop reports by using SQL Server 2008 Reporting Services (SSRS) Enterprise Edition.

  You need to use data-driven subscription to distribute reports based on dynamic subscription data.

  Which role should you use?

  A. Publisher
  B. System User
  C. Content Manager
  D. Browser
  C. Content Manager

• Question 213:

  You are developing a SQL Server 2008 Analysis Services (SSAS) method for Company.com. There is a dimension called DimProductTester which includes a property called PriceTester. You should make sure that aggregations could not link

  to the Price property.

  Which is the correct answer?

  A. You should configure the IsAggregatable attribute of the PriceTester attribute to True.
  B. You should configure the AttributeHierarchyEnabled attribute of the PriceTester attribute to False.
  C. You should configure the MembersWithData attribute of the PriceTester attribute to LeafDataHidden.
  D. You should configure the MembersWithOutData attribute of the PriceTester attribute to LeafDataHidden.
  B. You should configure the AttributeHierarchyEnabled attribute of the PriceTester attribute to False.

  ---

  AttributeHierarchyEnabled Determines whether the attribute is enabled as a hierarchy; this must be True if the attribute will be used in a multilevel hierarchy

• Question 214:

  You maintain a report in a SQL Server 2008 Reporting Services (SSRS) instance.

  The report contains query parameters that allow users to filter the contents of the report. The report queries the data source randomly.

  You configure the report to be rendered from a report execution snapshot. You need to ensure that users can continue to use parameters to filter the report.

  What should you do?

  A. Add a default value to all parameters.
  B. Modify the datasets to use the Table query type.
  C. Remove the filters from the dataset queries. Use the parameters to filter the datasets.
  D. Move the queries to the stored procedures. Use the stored procedures to populate and filter the datasets of the report.
  C. Remove the filters from the dataset queries. Use the parameters to filter the datasets.

• Question 215:

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

  The report is complex and takes several minutes to generate.

  You need to configure the report server to cache the report for 30 minutes after the initial request.

  What should you do?

  A. Implement report snapshots.
  B. Implement report execution caching.
  C. Configure the data source to use snapshot isolation.
  D. Configure the data source to use a database snapshot.
  B. Implement report execution caching.

• Question 216:

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

  You are developing a new data mining structure.

  You need to set the Microsoft Clustering Algorithm to meet the following requirements:

  

  Allow data points to be assigned to two clusters.

  

  Generate a probability for each combination of data point and cluster.

  

  Provide the fastest results on large datasets (greater than one million records).

  Which clustering method should you use?

  A. Scalable Expectation Maximization (EM)
  B. Non-scalable Expectation Maximization (EM)
  C. Non-scalable K-Means
  D. Scalable K-Means
  C. Non-scalable K-Means

• Question 217:

  You maintain a SQL Server Analysis Services (SSAS) database. The database is configured by using multiple security roles.

  The database is accessed by a Microsoft ASP.NET application that runs on a remote computer. The application is configured to use Windows Authentication. You need to ensure that the users of the application can successfully access the

  SSAS database.

  You also need to ensure that security restrictions of the roles are applied.

  What should you do?

  A. Configure Kerberos authentication
  B. Configure Analysis Services for HTTP authentication
  C. Set the AnonymousConnectionsEnabled policy to True
  D. Set the Security\RequireClientAuthentication property to True
  A. Configure Kerberos authentication

• Question 218:

  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.

  Now you are in charge of a SQL Server 2008 Analysis Services (SSAS) database. Now you get an e-mail from your company CIO, according to his requirement, he wants the data in a partition to be refreshed every two hours.

  He has assigned this task to you. You have to implement the incremental processing strategy. Of the following options, which XML for Analysis (XMLA) command should you choose?

  A. You should choose ProcessFull
  B. You should choose ProcessIndex
  C. You should choose ProcessAdd.
  D. You should choose ProcessData
  C. You should choose ProcessAdd.

• Question 219:

  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 the technical support for the company which uses SQL Server2008 Analysis Services (SSAS) solution. To meet the business development, a dimension named

  DimSales is created with an Amount attribute, and then it is used in a cube structure.

  Now you are assigned a task to make sure that aggregations have no relationship with the Amount attribute.

  What action should you perform to accomplish this task?

  A. The MembersWithData property of the Amount attribute should be set to False to accomplish this task.
  B. The IsAggregatable property of the Amount attribute should be set to False to accomplish this task.
  C. The AttributeHierarchyEnabled property of the Amount attribute should be set to False to accomplish this task.
  D. The MembersWithData property of the Amount attribute should be set to NonLeafDataHidden to accomplish this task
  E. The GroupingBehavior property of the Amount attribute should be set to DiscourageGrouping to accomplish this task.
  C. The AttributeHierarchyEnabled property of the Amount attribute should be set to False to accomplish this task.

• Question 220:

  You create a SQL Server 2008 Reporting Services (SSRS) report. You plan to create a list of customers by using a List control. For each customer in the List control, you plan to include a table that contains the orders for that customer. The

  customer data is stored in the Customers table in the data source, and the order data is stored in the Orders table. You need to define the required dataset or datasets for this report.

  What should you do?

  A. Create a query that joins the two tables in the data source by using the JOIN clause. Add the query as a single data set to the report.
  B. Create a query that combines the two tables in the data source by using the UNION operator. Add the query as a single data set to the report.
  C. Create a query for each table. Group both tables on the column that is used to join the tables. Add both queries as separate data sets to the report.
  D. Create a query for each table. Sort both tables on the column that is used to join the tables. Add both queries as separate data sets to the report.
  A. Create a query that joins the two tables in the data source by using the JOIN clause. Add the query as a single data set to the report.