최신Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan - 70-448무료샘플문제
문제1
You are an ETL developer for a mortgage company. Your application has two tables names Vendor and Loan.
Vendor
VendorID VendorName 1 VendorA
2 VendorB
3 VendorC
4 VendorD
5 VendorE
Loan
LoanNumber VendorID LoanAmount
I-100 1 120000
I-200 1 130000
I-300 2 150000
I-400 3 155000
I-500 4 160000
I-600 4 170000
I-700 5 180000
You need to build a SQL Server 2008 Integration Services (SSIS) package that meets the following
requirements:
The package should be able to generate the Excel files dynamically. Each file should have the vendor name
as a prefix and the date as the suffix (e.g., VendorA_DDMMYYYY.xlsx).
All the vendor names should be added to a variable and loop through the variable to generate and load
separate files for each vendor dynamically.
Which property in the Excel file destination connection manager should you set with a variable?
You are an ETL developer for a mortgage company. Your application has two tables names Vendor and Loan.
Vendor
VendorID VendorName 1 VendorA
2 VendorB
3 VendorC
4 VendorD
5 VendorE
Loan
LoanNumber VendorID LoanAmount
I-100 1 120000
I-200 1 130000
I-300 2 150000
I-400 3 155000
I-500 4 160000
I-600 4 170000
I-700 5 180000
You need to build a SQL Server 2008 Integration Services (SSIS) package that meets the following
requirements:
The package should be able to generate the Excel files dynamically. Each file should have the vendor name
as a prefix and the date as the suffix (e.g., VendorA_DDMMYYYY.xlsx).
All the vendor names should be added to a variable and loop through the variable to generate and load
separate files for each vendor dynamically.
Which property in the Excel file destination connection manager should you set with a variable?
정답: B
문제2
You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package uses an OLE DB connection manager to connect to a third-party database server. The
database does not support Integrated Windows authentication.
You create an XML configuration file that provides configuration for the connection manager. You add the
configuration file to the package.
When the package executes, you receive an error message which indicates that login failure occurred.
You need to execute the package successfully.
What should you do?
You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package uses an OLE DB connection manager to connect to a third-party database server. The
database does not support Integrated Windows authentication.
You create an XML configuration file that provides configuration for the connection manager. You add the
configuration file to the package.
When the package executes, you receive an error message which indicates that login failure occurred.
You need to execute the package successfully.
What should you do?
정답: C
문제3
You develop a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a parameter named Category that is used to filter a list of products. The list uses a
dataset that contains the following query:
SELECT p.ProductID, p.Name, p.ListPrice
FROM Production.Product AS p
WHERE p.Category = @Category;
You modify the report parameter to allow multiple values.
You need to modify the report to help search for multiple Category values by using minimum amount of
development effort.
What should you do?
You develop a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a parameter named Category that is used to filter a list of products. The list uses a
dataset that contains the following query:
SELECT p.ProductID, p.Name, p.ListPrice
FROM Production.Product AS p
WHERE p.Category = @Category;
You modify the report parameter to allow multiple values.
You need to modify the report to help search for multiple Category values by using minimum amount of
development effort.
What should you do?
정답: C
문제4
You create a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a tablE.You need to ensure that alternate rows in the table have a pale green
backgrounD.Which code segment should you use for each text box?
You create a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a tablE.You need to ensure that alternate rows in the table have a pale green
backgrounD.Which code segment should you use for each text box?
정답: B
문제5
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?
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?
정답: A
문제6
You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution contains a time
dimension named DimTime that contains a hierarchy named Yr-Qtr-Mth.
You have a measure named Amount from a measure group named Measures.
You need to create a calculated member to display the Amount measure in the previous time period for the
current level of the Yr-Qtr-Mth hierarchy.
Which expression should you use?
You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution contains a time
dimension named DimTime that contains a hierarchy named Yr-Qtr-Mth.
You have a measure named Amount from a measure group named Measures.
You need to create a calculated member to display the Amount measure in the previous time period for the
current level of the Yr-Qtr-Mth hierarchy.
Which expression should you use?
정답: B
문제7
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?
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?
정답: D
문제8
You work for an organization with global operations. You are responsible for the SQL Server 2008 Integration Services (SSIS) instance. You develop SSIS packages to load daily and weekly feeds. These packages are deployed via the SQL Server method.
These servers reside in geographies with a high risk of natural disaster.
You need to implement a disaster recovery plan to back up the SSIS packages for availability.
What should you back up?
You work for an organization with global operations. You are responsible for the SQL Server 2008 Integration Services (SSIS) instance. You develop SSIS packages to load daily and weekly feeds. These packages are deployed via the SQL Server method.
These servers reside in geographies with a high risk of natural disaster.
You need to implement a disaster recovery plan to back up the SSIS packages for availability.
What should you back up?
정답: A
문제9
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?
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?
정답: D