Microsoft 70-448 Actual Free Exam Questions & Community Discussion
You maintain a SQL Server 2008 Analysis Services (SSAS) database.
You plan to troubleshoot query performance by using SQL Profiler.
You need to replay the queries issued to the SSAS database.
Which three trace events should you use? (Each correct answer presents part of the solution.
Choose three.)
You plan to troubleshoot query performance by using SQL Profiler.
You need to replay the queries issued to the SSAS database.
Which three trace events should you use? (Each correct answer presents part of the solution.
Choose three.)
Correct Answer: B,C,E
Vote an answer
You create a SQL Server 2008 Analysis Services (SSAS) solution.
Your solution contains a cube with a dimension named Factories. The dimension has a property names ProductionLines. This solution also includes data about the suers employed at each factory.
You need to provide a way to browse the data within the dimension.
What should you do?
Your solution contains a cube with a dimension named Factories. The dimension has a property names ProductionLines. This solution also includes data about the suers employed at each factory.
You need to provide a way to browse the data within the dimension.
What should you do?
Correct Answer: D
Vote an answer
You design a report by using SQL Server 2008 Reporting Services (SSRS).
The report will be included in a Windows Forms application that is distributed to remote users. These users have access to the report server.
You need to ensure that the application renders the report correctly. What should you do?
The report will be included in a Windows Forms application that is distributed to remote users. These users have access to the report server.
You need to ensure that the application renders the report correctly. What should you do?
Correct Answer: D
Vote an answer
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?
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?
Correct Answer: A
Vote an answer
You maintain a SQL Server 2008 Reporting Services (SSRS) instance.
Your instance supports several different rendering extensions.
You need to configure the server so that all reports render only to Microsoft Excel.
What should you do?
Your instance supports several different rendering extensions.
You need to configure the server so that all reports render only to Microsoft Excel.
What should you do?
Correct Answer: B
Vote an answer
You plan to use SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 failover cluster.
You have a complex package that takes a long time to run.
You need to ensure that if the package executes during a failover, the package can be resumed at the point
of failure.
What should you do?
You have a complex package that takes a long time to run.
You need to ensure that if the package executes during a failover, the package can be resumed at the point
of failure.
What should you do?
Correct Answer: A
Vote an answer
0
0
0
10