Prüfungsinhalte ändern sich – unsere Lernmaterialien ändern sich mit. Bei Fast2test erhalten Sie zur Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan im Jahr 2026 365 Tage lang kostenlose Updates, damit Ihre Vorbereitung auf die 070-448 Prüfung stets auf dem neuesten Stand bleibt.

Microsoft 070-448 Prüfungsübersicht:

Microsoft 070-448 Prüfungsthemen:

FAQ: Alles Wichtige zur Microsoft 070-448 Zertifizierungsprüfung

Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan 070-448 Prüfungsfragen mit Lösungen

Frage #1

You create a SQL Server 2008 Analysis Services (SSAS) solution.
You enable proactive caching for a partition.
You need to ensure that SSAS can query relational data when multidimensional storage is being updated.
What should you do?

A. Set the ProcessingMode property for the partition to LazyAggregations.
B. Set the OnlineMode property for the partition to Immediate.
C. Set the OnlineMode property for the partition to OnCacheComplete.
D. Set the ProcessingMode property for the partition to Regular.

Frage #2

You maintain a SQL Server 2008 Analysis Services (SSAS) database. You create a new measure group
in one of the cubes.
You have a program that maintains partitions on the production copy of the cube.
You need to update the cube definition on the production server without overwriting any existing partitions.
What should you do?

A. Use the Analysis Services Destination component in Microsoft SQL Server Integration Services (SSIS).
B. Execute an UPDATE CUBE statement in Microsoft SQL Server Management Studio (SSMS).
C. Use the Business Intelligence Development Studio (BIDS) and set the processing option to Do Not Process.
D. Use the Deployment Wizard along with the appropriate options.

Frage #3

You 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, QualityOnHand, which shows the total stock in inventory for the company by the time.
You need to determine the inventory at the end of the quarter. What should you do?

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

Frage #4

You design a SQL Server 2008 Integration Services (SSIS) package that contains several data flows.
You need to monitor the data that passes through each path in the data flow by using the Business
Intelligence Development Studio. You also need to ensure that data flow logic is retained.
What should you do?

A. Use breakpoints in the Script component.
B. Use the Data Viewer tool.
C. Use the Audit transformation.
D. Use the Data Profiling task.

Frage #5

You are an ETL developer. The CIO asks you to develop a SQL Server 2008 Integration Services (SSIS) package to load data from a source to a destination system. As part of the solution you have to use the script component as a source to load the data in the SQL Server table dbo.Employee.
The table dbo.Employee has the following fields:
Emp_ID int NOT NULL Emp_Name varchar (100) NOT NULL Emp_City varchar(50) NOT NULL Emp_State varchar(2) Emp_Zip varchar(10)
The Script Transformation Editor, which displays the column properties of the script component, is shown in the following exhibit. (Click the Exhibit button.)
You need to code the CreateNewOutputRows() method to assign values to the buffer.
Which code snippet should you use?

A. Public override void CreateNewOutputRows() ( OutoutBuffer0.AddRow(); OutoutBuffer0.EmpID = 1; OutoutBuffer0.EmpName = "Jeff Price"; OutoutBuffer0.EmpCity = "Any City"; OutoutBuffer0.EmpState = "TX"; OutoutBuffer0.EmpZip = "88001"; )
B. Public override void CreateNewOutputRows() ( EmployeeBuffer.AddRow(); EmployeeBuffer.EmpID = 1; EmployeeBuffer.EmpName = "Jeff Price"; EmployeeBuffer.EmpCity = "Any City"; EmployeeBuffer.EmpState = "TX"; EmployeeBuffer.EmpZip = "88001"; )
C. Public override void CreateNewOutputRows() ( InputBuffer.AddRow(); InputBuffer.EmpID = 1; InputBuffer.EmpName = "Jeff Price"; InputBuffer.EmpCity = "Any City"; InputBuffer.EmpState = "TX"; InputBuffer.EmpZip = "88001"; )
D. Public override void CreateNewOutputRows() ( OutoutBuffer.AddRow(); OutoutBuffer.EmpID = 1; OutoutBuffer.EmpName = "Jeff Price"; OutoutBuffer.EmpCity = "Any City"; OutoutBuffer.EmpState = "TX"; OutoutBuffer.EmpZip = "88001"; )

Fragen und Antworten: