Parallel Processing Hardware Options Explain

Implementing a data warehouse without parallel processing options is almost thinkable in the current slate of the technology. In summary, you will realize the following significant advantages when you adopt parallel processing in your data warehouse:

• Performance improvement for & piety processing, data loading, and index creation
• Scalability, allowing, the addition of CPUs Is and memory modules without any changes to the existing application
•  Fault tolerance so that the database would be available even when some of the parallel processors fail o Single logical view of the database even though the data may reside on the disks of multiple nodes

Query Tools

In a data warehouse, if there is one set of functional took that arc most significant, it is the set of query tools, the success of your data warehouse oil your query tools because of this data warehouse vendors have improved query tools during the past few years. We will discuss query toots in greater detail in Chapter 14. At this stage, just note the following functions for which vendors have greatly enhanced their query tools.

• Flexible presentations--- Easy to use and able to present results online and on reports in many different formats
• Aggregate awareness__ Able to recognize the existence of summary of aggregate in-ables and automatically route queries to the summitry tables when summarized results are desired
• Crossing subject areas—Able to cross over from one subject data mart to another automatically .
• Multiple heterogeneous sources—Capable of accessing heterogeneous data sources on different plat forms
• Integration—Integrate query tools for online queries, hatch reports, and data extraction for analysis and provide seamless hued-ace to go from one type of output to another
• Overcoming SQL limitations--Provide SQL extensions to handle requests that can-not usually be done through standard SQL.

Parallel Processing Hardware Options

Parallel Processing Hardware Options: In a parallel processing environment. you will find these characteristics: multiple CPUs. memory modules, one or snore server nOdes. and high-speed communication links between interconnected nodes. Essentially. you can choose from three architectural options. Figure 3-6 indicates the three options and their comparative merits. Please noic the advantages and disadvantages so that you may choose the proper option for your data warehouse.

Parallel Processing Software Implementation: You may choose the appropriate parallel processing hardware configuration for your data warehouse. Hardware alone would be worthless if the operating system and the database software cannot make use of the parallel features of the hardware. You will have to ensure that the software can allocate units of a larger task to the hardware components appropriately.

Parallel processing software must be capable of performing' the following steps:

• Analyzing a large task to identify independent units that can be executed in parallel
• Identifying which of the smaller units must he executed one after the other
• Executing the independent units in parallel and the dependent units in the proper sequence • Collecting. collecting and consolidating the results returned by the smaller units.

Database vendors usually provide two options Air parallel processing: -paral/el server option and parallel query option. You may purchase each option separately. Depending on the provisions made by the database vendors, these options may be used %vith one or more of the parallel hardware configurations. The parallel server option allows each hardware node to have its own separate database instance, and enables all database instances to access a .common sct of underlying data-base files. The parallel query option supports key operations such as query processing, data load-ing, and index creation in be parallelized.

Parallel Processing

Parallel Processing
You know that the data warehouse is a user-centric and query-intensive environment. Your users will constantly he executing complex queries to perform all types or analyses. Each query would need to read large volumes or data to produce result sets. Analysis usually performed interactively. requires the execution or several queries, one after the other, by each user. if the data warehouse is not tuned properly for handling large, complex, simultaneous queries efficiently, the value of the data warehouse will be lost. Performance is of primary importance.

The other functions for which performance is crucial arc the functions of loading diva and creating indexes. Because of large volumes, loading or data can the slow again, indexing is usually elaborate in a data warehouse because of the need to access the data in many different ways. Because of large numbers of indexes, index creation could also be slow.

How do you speed sip query processing data loading, and index creation? A very effective way to do accomplish this is to use parallel processing. Both hardware configurations and software techniques go hand in hand to accomplish parallel processing. A task is divided into smaller units and these smaller units are executed concurrently.

70-247 Question 4

You have a System Center 2012 Virtual Machine Manager (VMM) infrastructure that contains 20 Hyper-V hosts. You configure VMM to use a Window Server Update Services (WSUS) server named WSUS1 as an update server. You open the VMM Administrator Console as shown in the exhibit. (Click the Exhibit button.) You need to identify which hosts comply with the Sample Baseline for Security Updates. What should you do?

70-247

A. Modify the properties of the baseline.
B. Modify the properties of the All hosts group.
C. Modify the properties of WSUS1.
D. Select the All hosts group from the Fabric navigation pane.

Answer: A

70-247 Question 3

70-247 Question 3

You have a System Center 2012 Virtual Machine Manager (VMM) infrastructure that contains five virtualization hosts. You add new storage to the network. You need to discover the storage from the VMM Administrator Console. What should you create first?

A. a Guest OS Profile
B. a Run As Account
C. a Hardware Profile
D. a classification

Answer: B