www.cert24.com,test dumps, practice test, pdf HP2-T26 HP cert24
www.cert24.com,test dumps, practice test, pdf HP2-T26 HP cert24

IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, cert24.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions

HP2-T26 Servicing HP BladeSystem Solutions We believe in helping our customers achieve their goals. For this reason, we take great care while preparing our Questions and Answers , Core Administration. Our practice tests Administration are prepared with the help of highly professional people from the industry, so we benefit from their vast experience and knowledge.

QUESTION NO: 1
Technician is installing HP ProLiant servers at different customer sites. Since the technician wants to have the ProLiant equipped with the latest firmware level available, what is the best solution?

A. Before going onsite, the technician should download the latest SmartStart Firmware CD and use this SmartStart Firmware CD for deploying the latest firmware.
B. The technician should download the latest SmartStart firmware CD and add the firmware releases published after the release of the latest SmartStart Firmware CD to the
\compaq\swpackages on the CD-ROM.
C. The technician should create a bootable USB stick containing the latest SmartStart Firmware CD and add the firmware releases published after the release of the latest SmartStart Firmware CD to the \compaq\swpackages on the USB stick.
D. Before going onsite, the technician should download the latest SmartStart Firmware CD. The technician should download the firmware releases published after the release of the latest SmartStart Firmware CD and save these images on floppies. The SmartStartFirmware CD and downloaded images on floppy are used for deploying the latest firmware.

Answer: C

QUESTION NO: 2
Which interface can be used to check the firmware version of all components in a blade
enclosure?

A. HP System Update Manager
B. Virtual Connect Manager
C. Onboard Administrator
D. HP System Management Homepage

Answer: C

QUESTION NO: 3
Which ProLiant Server Blade utilities are available to check the system information and BIOS version? (Select two.)

A. ROM-Based Setup Utility
B. Diagnostic Utility
C. Inspect Utility
D. Option ROM Configuration for Arrays Utility
E. Network Boot Utility

Answer: A,C
www.cert24.com,test dumps, practice test, pdf HP2-T26 HP cert24

www.cert24.com,test dumps, practice test, pdf HP2-Z09 HP cert24
www.cert24.com,test dumps, practice test, pdf HP2-Z09 HP cert24

IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, cert24.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions

HP2-Z09 TippingPoint Advanced Technical Security Products We believe in helping our customers achieve their goals. For this reason, we take great care while preparing our Questions and Answers , Core Administration. Our practice tests Administration are prepared with the help of highly professional people from the industry, so we benefit from their vast experience and knowledge.

QUESTION NO: 1
What happens when an IPS enters Performance Protection Mode (also known as Logging Mode)?
A. Traffic is permitted or blocked depending on segment configuration.
B. Blocks still occur, but other traffic is permitted without notifications.
C. Traffic continues to be inspected, but event notifications are suppressed.
D. Network congestion ceases.
Answer: D

QUESTION NO: 2
The TippingPoint Threat Suppression Engine defines a flow based on which criteria? (Select three.)
A. source/destination IP address
B. source/destination MAC address
C. IP protocol
D. source/destination TCP/UDP port
E. incoming segment port
Answer: A,C,D

QUESTION NO: 3
Which inbuilt feature can prevent the IPS from degrading network performance due to a poorly performing filter where that filter sees a lot of suspicion but fails to match, and congestion is occurring?
A. Link-down synchronization
B. Layer-2 Fallback
C. Performance Protection
D. Adaptive Filter Configuration (AFC)
Answer: D

www.cert24.com,test dumps, practice test, pdf HP2-Z09 HP cert24

www.cert24.com,test dumps, practice test, pdf HP2-Z18 HP cert24
www.cert24.com,test dumps, practice test, pdf HP2-Z18 HP cert24

IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, cert24.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions

HP2-Z18 Network Infrastructure AIS 2011 We believe in helping our customers achieve their goals. For this reason, we take great care while preparing our Questions and Answers , Core Administration. Our practice tests Administration are prepared with the help of highly professional people from the industry, so we benefit from their vast experience and knowledge.

QUESTION NO: 1
Port B1 on an HP ProCurve 5406zl switch is an untagged member of VLAN 155 and not a tagged member of any VLAN. Port C1 is a tagged member of VLAN 155 and an untagged member of VLAN 100. You issue the following command:
5406zl(config)# no vlan 155
Why do you receive the following prompt?
The following ports will be moved to the default VLAN:
Bl
Do you want to continue? [y/n] :
A. The CLI always issues this prompt when deleting a VLAN.
B. The CLIwill not allow you to orphan a port.
C. The CLI will not delete a VLAN with any port membership.
D. All ports must be moved to the default VLAN before you can delete the VLAN.

Answer: D

QUESTION NO: 2
After issuing the following two CLI commands, how can you gain access to the CLI of the switch if the manager and operator passwords have been lost?
E5406 (config)# no front-panel-security password-clear
E5406(config)# no front-panel-security factory-reset
A. Power cycle the switch and access the ROM console to clear passwords at the manager prompt.
B. Press the Reset and Clear buttons on the switch’s front panel, release the Reset button and hold the Clear button until the all switch LEDs blink rapidly.
C. Contact support and obtain a one-time password to gain access to the switch.
D. Reset the passwords using the Secure Access Wizard i n ProCurve Manager Plus.

Answer: C

QUESTION NO: 3
You have configured a dynamic LACP four-port trunk connecting two HP E-Series switches How will the switches share the load over the trunk?
A. The switch that receives the first packet in each conversation will balance the load by ensuring reply packets use a different link.
B. Each switch will assign conversations to links independent of the other switch’s selection.
C. The switches will exchange LACP BPDUs to negotiate a load-sharing algorithm.
D. The switches wi II dynamically calculate the path of least congesti on for each conversation

Answer: C

www.cert24.com,test dumps, practice test, pdf HP2-Z18 HP cert24

www.cert24.com,test dumps, practice test, pdf HP2-Z21 HP cert24
www.cert24.com,test dumps, practice test, pdf HP2-Z21 HP cert24

IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, cert24.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions

HP2-Z21 Planning and Designing HP Enterprise Networking Solutions We believe in helping our customers achieve their goals. For this reason, we take great care while preparing our Questions and Answers , Core Administration. Our practice tests Administration are prepared with the help of highly professional people from the industry, so we benefit from their vast experience and knowledge.

QUESTION NO: 1
The exhibit displays the type of information about an HP A5820-24XG-SFP+ switch that a sales professional might cite to a customer interested in the product’s performance.
Exhibit: Product specifications
HP A5820-24XG-SPF+ specifications
Maximum 10G: 24
Routing and switching capacity (Gbps): 488
Throughput (Mpps): 363
Typical latency (microseconds):
Layer 2 = Less than 3; normal Layer 3 = Less than 6; jumbo Layer 3 = 26
Which specification demonstrates that this switch provides a good QoS with minimal lag and jitter for all types of traffic?
A. total routing and switching capacity
B. throughput
C. typical latency
D. maximum 10G port density

Answer: C

Reference: http://www.wimax.com/wimax-tutorial/quality-of-service (first paragraph)

QUESTION NO: 2
Which feature is supported on the HP A8800 Router Series, but not on the HP A6600 Router Series?
A. Layer 3/4 traffic prioritization
B. Hierarchical QoS (H-QoS)
C. Intelligent Resilient Framework (IRF)
D. Virtual Routing and Forwarding (VRF)

Answer: B

Reference: http://h18000.www1.hp.com/products/quickspecs/13810_na/13810_na.PDF

QUESTION NO: 3
Which versatile switch series is designed to function at the aggregation layer of a three-tier enterprise campus LAN, the core of a small data center, and the access layer of an advanced enterprise campus LAN?
A. A12500
B. A9500
C. A7500
D. A5820

Answer: D

www.cert24.com,test dumps, practice test, pdf HP2-Z21 HP cert24

www.cert24.com,test dumps, practice test, pdf HP2-Z22 HP cert24
www.cert24.com,test dumps, practice test, pdf HP2-Z22 HP cert24

IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, cert24.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions

HP2-Z22 Selling HP Network Solutions We believe in helping our customers achieve their goals. For this reason, we take great care while preparing our Questions and Answers , Core Administration. Our practice tests Administration are prepared with the help of highly professional people from the industry, so we benefit from their vast experience and knowledge.

QUESTION NO: 1
A company is concerned that the temporary workers at a branch office will introduce viruses and other malware into the internal network. The company also wants to provide network access for branch employees who telecommute. Which features make the HP Threat Management Services zl Module a possible security solution for this company’s branch office? (Select two.)

A. Endpoint Admission Defense (EAD)
B. Web filtering
C. Virtual Private Network (VPN)
D. Intrusion Protection System (IPS)
E. User Access Management (UAM)

Answer: C,D
Explanation: The HP Threat Management Services (TMS) zl Module is a multifunction security system for the HP E5400 zl and E8200 zl Switch Series. It is comprised of a stateful firewall, an intrusion detection/prevention system (IDS/IPS), and a virtual private network (VPN) concentrator. It enables network administrators to compartmentalize department traffic, protect the network from malware, and provide secure remote access and site-to-site connectivity.
Reference: HP Threat Management Services zl Module, QuickSpecs
http://h18000.www1.hp.com/products/quickspecs/13376_div/13376_div.PDF Page 1, ProductOverview)

QUESTION NO: 2
Which is a benefit that distinguishes HP PCM+ from HP PCM?

A. Customers can monitor basic device health.
B. Customers can capture and browse Simple Network Management Protocol (SNMP) and syslog events.
C. Customers can map network devices.
D. Customers can manage their many remote sites.

Answer: D

QUESTION NO: 3
Your customer’s network provides mission-critical services. The company has customers
worldwide, so these services are being used all the time. The company cannot afford any
downtime. Because the company’s IT staff is relatively new and inexperienced, the customer wants both hardware replacement services and an HP support person onsite if a problem occurs.
Which care pack would you recommend?

A. HP Support Plus
B. HP 24×7 Software Support with 4-hour Hardware Exchange
C. HP Support Plus 24
D. HP 4-hour Same Business Day

Answer: C

www.cert24.com,test dumps, practice test, pdf HP2-Z22 HP cert24

www.cert24.com,test dumps, practice test, pdf 70-461 Microsoft cert24
www.cert24.com,test dumps, practice test, pdf 70-461 Microsoft cert24

IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, cert24.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions

70-461 Querying Microsoft SQL Server 2012 We believe in helping our customers achieve their goals. For this reason, we take great care while preparing our Questions and Answers , Core Administration. Our practice tests Administration are prepared with the help of highly professional people from the industry, so we benefit from their vast experience and knowledge.

www.cert24.com,test dumps, practice test, pdf 70-461 Microsoft cert24

1.You use Microsoft SQL Server 2012 to develop a database application. You create a stored procedure named dbo.ModifyData that can modify rows. You need to ensure that when the transaction fails, dbo.ModifyData meets the following requirements:
Does not return an error
Closes all opened transactions
Which Transact-SQL statement should you use?

A. BEGIN TRANSACTION
BEGIN TRY
EXEC dbo.ModifyData
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@ TRANCOUNT = 0
ROLLBACK TRANSACTION;
END CATCH
B. BEGIN TRANSACTION
BEGIN TRY
EXEC dbo.ModifyData
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@ERROR != 0
ROLLBACK TRANSACTION;
THROW;
END CATCH
C. BEGIN TRANSACTION
BEGIN TRY
EXEC dbo.ModifyData
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@TRANCOUNT = 0
ROLLBACK TRANSACTION;
THROW;
END CATCH
D. BEGIN TRANSACTION
BEGIN TRY
EXEC dbo.ModifyData
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@ERROR != 0
ROLLBACK TRANSACTION;
END CATCH

Answer: D

2.You are developing a database application by using Microsoft SQL Server 2012. An application that uses a database begins to run slowly. You discover that during reads, the transaction experiences blocking from concurrent updates. You need to ensure that throughout the transaction the data maintains the original version. What should you do?

A. Add a HASH hint to the query.
B. Add a LOOP hint to the query.
C. Add a FORCESEEK hint to the query.
D. Add an INCLUDE clause to the index.
E. Add a FORCESCAN hint to the Attach query.
F. Add a columnstore index to cover the query.
G. Enable the optimize for ad hoc workloads option.
H. Cover the unique clustered index with a columnstore index.
I. Include a SET FORCEPLAN ON statement before you run the query.
J. Include a SET STATISTICS PROFILE ON statement before you run the query.
K. Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query.
L. Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query.
M. Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query.
N. Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query.

Answer: M

3.You are developing a database application by using Microsoft SQL Server 2012. You have a query that runs slower than expected. You need to capture execution plans that will include detailed information on missing indexes recommended by the query optimizer. What should you do?

A. Add a HASH hint to the query.
B. Add a LOOP hint to the query.
C. Add a FORCESEEK hint to the query.
D. Add an INCLUDE clause to the index.
E. Add a FORCESCAN hint to the Attach query.
F. Add a columnstore index to cover the query.
G. Enable the optimize for ad hoc workloads option.
H. Cover the unique clustered index with a columnstore index.
I. Include a SET FORCEPLAN ON statement before you run the query.
J. Include a SET STATISTICS PROFILE ON statement before you run the query.
K. Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query.
L. Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query.
M. Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query.
N. Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query.

Answer: K

www.cert24.com,test dumps, practice test, pdf 70-461 Microsoft cert24

www.cert24.com,test dumps, practice test, pdf 70-452 Microsoft cert24
www.cert24.com,test dumps, practice test, pdf 70-452 Microsoft cert24

IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, cert24.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions

70-452 PRO:MS SQL Server 2008, Designing a Business Intelligence We believe in helping our customers achieve their goals. For this reason, we take great care while preparing our Questions and Answers , Core Administration. Our practice tests Administration are prepared with the help of highly professional people from the industry, so we benefit from their vast experience and knowledge.

www.cert24.com,test dumps, practice test, pdf 70-452 Microsoft cert24

QUESTION 1
You are the administrator of your company network. You use SQL Server 2008 to develop a
Business Intelligence (BI) solution. You create a SQL Server 2008 Reporting Services (SSRS) solution which has a report named SellDetails. The report contains a parameter named
WorkerID. You have the following constraints: Eight thousand employees need the report to be in different file formats.The employees can view only their sales data by specifying their
identity number as the EmployeeID parameter. You have to make sure that before you deliver
the report to the workers, the constraints are met. So what should you do?

A. You should create a data-driven subscription.
B. You should create a SharePoint Report Center site.
C. You should create a report model for each employee.
D. You should create a subscription for each employee.

Answer: A

QUESTION 2
You are the administrator of your company network. You use SQL Server 2008 to develop a
Business Intelligence (BI) solution.A SQL Server 2008 Analysis Services (SSAS) solution
includes a cube that has the following objects: Measures named TotalSales and
InternetSalesDimensions named DimCustomer, DimProduct, and DimGeographyBy
authenticating with their Windows accounts, users run reports against all dimensions and
measures.You have to offer the users a basic view of data to display only DimGeography,
DimProduct, and TotalSales while using as little storage space as possible. So what should you do?

A. You should create a new cube. Add DimGeography, DimProduct, and TotalSales.
B. You should create a new role. Grant access only to DimGeography, DimProduct, and
TotalSales.
C. You should create a new data source view. Add the tables used for DimGeography,
DimProduct, and TotalSales.
D. You should create a new perspective for the current cube. Select DimGeography,
DimProduct, and TotalSales.

Answer: D

QUESTION 3
You are the administrator of your company network. You use SQL Server 2008 to develop a
Business Intelligence (BI) solution. A SQL Server 2008 instance is used by the SQL Server
2008 Integration Services (SSIS) developers as the primary development environment. All the
SSIS packages contain data connection managers that use SQL Server authentication to extract data. All the SSIS packages contain data connection managers that use SQL Server
authentication to extract data. You intend to use an automated script to perform the package
migration from the development environment to a production environment. You must make
sure that the packages execute while no error occur in the production environment. So what
should you do?

A. You should create a package configuration for every package that uses a SQL Server table.
B. You should export each package and change the package protection level to
DontSaveSensitive.
C. You should create a package configuration for every package that uses an XML
configuration file.
D. You should export each package and change the package protection level to
EncryptSensitiveWithPassword.

Answer: D

www.cert24.com,test dumps, practice test, pdf 70-452 Microsoft cert24

www.cert24.com,test dumps, practice test, pdf 70-451 Microsoft cert24
www.cert24.com,test dumps, practice test, pdf 70-451 Microsoft cert24

IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, cert24.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions

70-451 PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008 We believe in helping our customers achieve their goals. For this reason, we take great care while preparing our Questions and Answers , Core Administration. Our practice tests Administration are prepared with the help of highly professional people from the industry, so we benefit from their vast experience and knowledge.

www.cert24.com,test dumps, practice test, pdf 70-451 Microsoft cert24

1.You manage sql server 2008 instances for a large retail organization.
You want to design a reporting solution to allow users read-only access to data in databases on different instances.
Users generating reports only need read-only access.
Users in different locations have different uses for the data.
Some users perform complex reporting that is resource-intensive.
You want to provide reporting capability with optimum responsiveness for all users, while minimizing administration effort and performance impact to production systems using the data.
Which action should you take?

A. Configure peer-to-peer replication.
B. Create a database snapshot
C. Implement scalable shared databases.
D. Configure log shipping.

Answer: C

2.You are a database developer on an instance of sql server 2008.
You need to provide a custom function that will perform complex calculations on groups of data in one of your tables.
You want users to be able to reference the function directly from a query as if they were using a built-in scalar function.
Which type of object should you create?

A. A clr user-defined type
B. A transact-sql user-defined function that returns a scalar value
C. A clr user-defined aggregate
D. A transact-sql user-defined stored procedure

Answer: C

3.You work for a company that builds parts for an aerospace contractor.
You use the following transact-sql to update the widget table in the research database:
use research
go
begin transaction toleranceupdate
with mark ‘update tolerance level’;
go
update engineering.widgetset tolerance = tolerance * 1.03 where widgetid like ‘aa-%’;
go
commit transaction toleranceupdate;
go
After a few hours, you notice that an error occurred in the database.
A regular backup and log backup of the research database have been made.
You restore the full backup of the research database.
What should you do restore the widget table to the tolerance update transaction?

A. Restore the log backup using with stopbeforemark= ‘toleranceupdate’
B. Restore the log backup using with stopatmark=’toleranceupdate’
C. Use the rollback statement to roll back to the tolerance update transaction.
D. Restore the transaction log. use a rollback statement to roll back to the tolerance update transaction.

Answer: B

www.cert24.com,test dumps, practice test, pdf 70-451 Microsoft cert24

www.cert24.com,test dumps, practice test, pdf 70-450 Microsoft cert24
www.cert24.com,test dumps, practice test, pdf 70-450 Microsoft cert24

IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, cert24.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions

70-450 PRO:MS SQL Serv 08,Design,Optimize, and Maintain DB Admin Solution We believe in helping our customers achieve their goals. For this reason, we take great care while preparing our Questions and Answers , Core Administration. Our practice tests Administration are prepared with the help of highly professional people from the industry, so we benefit from their vast experience and knowledge.

www.cert24.com,test dumps, practice test, pdf 70-450 Microsoft cert24

QUESTION 1
You administer a SQL Server 2008 instance for your company. Your company has a team of database administrators.

A team of application developers create SQL Server 2008 Integration Services (SSIS) packages on the test server in a shared project. One of the packages requires a fixed cache file. On completion of development, the packages will be deployed to the production server.

Only the database administrators can access the production server.

You need to ensure that the application developers can deploy the project successfully to the production server.

What should you do?

A. Use the Import and Export Wizard to save packages.
B. Create a deployment utility for the SSIS project.
C. Create a direct package configuration for each package.
D. Create an indirect package configuration for all packages.

Answer: B

Explanation/Reference:
—Jeff—
This is a strange question. I think the underlying lession is that deployment utilities make SSIS package deployment easier, especially in situations where limited access may be available. Direct and indirect package configurations are explained on MSDN.

Official source: http://msdn.microsoft.com/en-us/library/ms141682.aspx

QUESTION 2
You administer a SQL Server 2008 infrastructure. You plan to design an infrastructure for a new application.

The application has the following requirements:

Users can connect to an instance named SQLSERVER1.
SQLSERVER1 is linked to a server named SQLSERVER2.
SQLSERVER1 and SQLSERVER2 run on different computers.
The SQL Server instances use only Windows authentication.

You need to configure the infrastructure to ensure that the distributed queries are executed in the Windows security context of the login.

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A. Configure all servers to use the Shared Memory network protocol.
B. Register a server principal name (SPN) for SQLSERVER1 and SQLSERVER2.
C. Use the local computer account as a service account for SQLSERVER1 and SQLSERVER2.
D. Create a map for each SQL login from SQLSERVER1 to SQLSERVER2 and use the
impersonate option.
E. Ensure that the two instances use the same Windows account for the Microsoft SQL
Service. Create the link so that each account uses the current security context.

Answer: BD

Explanation/Reference:

http://msdn.microsoft.com/en-us/library/ms189580%28v=SQL.100%29.aspx

QUESTION 3
You administer two SQL Server 2008 instances named Instance1 and Instance2. Instance1 contains the Sales database, and Instance2 contains the Accounts database.

A procedure in the Sales database starts a transaction. The procedure then updates the Sales.dbo.Order table and the Accounts.dbo.OrderHistory table through a linked server.

You need to ensure that the transaction uses a two-phase commit.

What should you do?

A. Configure the linked server to use distributed transactions.
B. Configure a Service Broker to enable the appropriate transaction control.
C. Ensure that the linked server is appropriately configured for delegation.
D. Ensure that the linked server is appropriately configured for impersonation.

Answer: A

www.cert24.com,test dumps, practice test, pdf 70-450 Microsoft cert24

www.cert24.com,test dumps, practice test, pdf 70-448 Microsoft cert24
www.cert24.com,test dumps, practice test, pdf 70-448 Microsoft cert24

IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, cert24.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions

70-448 TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan We believe in helping our customers achieve their goals. For this reason, we take great care while preparing our Questions and Answers , Core Administration. Our practice tests Administration are prepared with the help of highly professional people from the industry, so we benefit from their vast experience and knowledge.

www.cert24.com,test dumps, practice test, pdf 70-448 Microsoft cert24

QUESTION 1
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 get an order from your company CIO, you’re asked to develop a SQL Server 2008
Integration Services (SSIS) data flow.
The data flow loads data to a SQL Server 2008 database.
Using data from the rows in your data flow, you must make sure that the existing records in the SQL Server database is updated by the data flow.
Of the following data flow components, which one should be used?

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

Answer: C

Explanation/Reference:
Msdn OLE DB Command Transformation
The OLE DB Command transformation runs an SQL statement for each row in a data flow. For example, you can run an SQL statement that inserts, updates, or deletes rows in a database table.
You can configure the OLE DB Command Transformation in the following ways:
* Provide the SQL statement that the transformation runs for each row.
* Specify the number of seconds before the SQL statement times out.
* Specify the default code page.
Typically, the SQL statement includes parameters. The parameter values are stored in external columns in the transformation input, and mapping an input column to an external column maps an input column to a parameter. For example, to locate rows in the DimProduct table by the value in their ProductKey column and then delete them, you can map the external column namedParam_0 to the input column named ProductKey, and then run the SQL statement DELETE FROM
DimProduct WHERE ProductKey = ?.. The OLE DB Command transformation provides the
parameter names and you cannot modify them. The parameter names are Param_0, Param_1, and so on.
If you configure the OLE DB Command transformation by using the Advanced Editor dialog box, the parameters in the SQL statement may be mapped automatically to external columns in the transformation input, and the characteristics of each parameter defined, by clicking the Refresh button. However, if the OLE DB provider that the OLE DB Command transformation uses does not support deriving parameter information from the parameter, you must configure the external columns manually. This means that you must add a column for each parameter to the external input to the transformation, update the column names to use names like Param_0, specify the value of the DBParamInfoFlags property, and map the input columns that contain parameter values to the external columns.
The value of DBParamInfoFlags represents the characteristics of the parameter. For example, the value 1 specifies that the parameter is an input parameter, and the value 65 specifies that the parameter is an input parameter and may contain a null value. The values must match the values in the OLE DB DBPARAMFLAGSENUM enumeration. For more information, see the OLE DB reference documentation. The OLE DB Command transformation includes the SQLCommand custom property. This property can be updated by a property expression when the package is loaded. For more information, see Integration Services Expression Reference, Using Property Expressions in Packages, and Transformation Custom Properties. This transformation has one input, one regular output, and one error output.

QUESTION 2
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 get an order from your company CIO, you are asked to design a SQL Server 2008
Integration Services (SSIS) package.
The package contains a Data Flow task. According to the requirement of the company CIO, the package has to be modified to write all rows by which errors are generated to a text file.
So what should you do? (choose more than one)

A. A Flat File Destination component should be used
B. A Raw File Destination component should be used
C. The SSIS log provider for the SQL Profiler should be used
D. An Error output should be added to the Data Flow component
E. The SSIS log provider for the text file should be used

Answer: AD

QUESTION 3
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

Answer: C

www.cert24.com,test dumps, practice test, pdf 70-448 Microsoft cert24