Monday 5 August 2013

Integrated Data

In the data warehouse, data is not stored by operational applications, but by business subjects. 
.

Figure 2-1 the data warehouse is subject oriented.

In a data warehouse; there is no application flavor. The data in a data warehouse cut across applications.

Integrated Data

For proper decision making, you need 10 pull together all the relevant data from the various applications. The data in the data warehouse comes from several operational systems. Source data are in different databases, files, and data segments. These are disparate applications, so the operational platforms and operating systems could be different. The file layouts. Character code representations and field naming conventions all could be different.

In addition to data from internal operational systems. For many enterprises. Data from outside source is likely to be very important. Companies such as Metro. Mail. A. C. Nielsen, and IR I specialize in providing vital data on a regular basis. Your data warehouse may need data from such sources. This is one more variation in the mix of source data for a data warehouse.

Figure 2-2 illustrates a simple process of data integration for a banking institution. Here the data fed into the subject area of arrow:, in the data warehouse comes from three different operational applications. Even within just three applications, there could be several variations, Naming conventions could be different; attributes or data items could be different. The account number in the Savings Account application could be eight bytes long, but only six bytes in the Checking Account application.

Before die data from various disparate sources can be usefully stored in a data ware-house. you have to remove the inconsistencies. You have to standardize the various data elements and make sure ()I the meanings of data names in "each source application. Before moving the data into the data warehouse, you have to go through a process or transformation. Consolidation. And integration of the source data.

DATA WAREHOUSE: THE BUILDING BLOCKS

CHAPTER 2 DATA WAREHOUSE: THE BUILDING BLOCKS

CHAPTER OBJECTIVES
  • Review formal definitions of a data warehouse
  • Discuss the defining features
  • Distinguish between data warehouses and data marts t
  • Study each component or building block that makes up a data warehouse
  • Introduce metadata and highlight its significance
As we have seen the last chapter, the data warehouse is an information delivery system. In this system, you integrate and transform enterprise data into information suitable for strategic decision making. You take all the historic data from the various operational systems, combine this internal data with any relevant data from outside sources, and pull them together. You resolve any conflicts in the way data resides in different systems and transform the integrated data content into formal suitable for providing information to the various classes of users. Finally, you implement the information delivery methods.

In order to set up this information delivery system, you need different components or building blocks. These building blocks are arranged together in the most optimal way to serve the intended purpose; they are arranged in a suitable architecture. Before we get into the individual components and their arrangement in the overall architecture, let us first look at some fundamental features of the data warehouse.

Bill lemon, considered to be the father of Data Warehousing provides the following definition: "A Data Warehouse is a subject oriented. Integrated, nonvolatile, and lime variant collection of data in support of management's decisions." Sean Kelly, another leading data warehousing practitioner defines the data warehouse in the following way.

The data in the data warehouse is:
 

Separate
Available
Integrated
Time Stamped
Subject oriented
Nonvolatile
Accessible

DEFINING FEATURES

Let us examine some of the key defining features of the data warehouse based on these definitions. What about the nature of Mc data in the data warehouse? how is this data ferent from the data in any operational system'? Why does it have to be different? how is  the data content in the data warehouse used'?

Tuesday 25 June 2013

70-412 Question 12

70-412 Question 12

You have a file server named Server1 that runs a Server Core Installation of Windows Server 2012. You need to ensure that users can access previous versions of files that are shared on Server1 by using the Previous Versions tab. Which tool should you use?

Microsoft 70-412 Exam

A. wbadmin
B. Diskpart
C. Storrept
D. Vssadmin

Correct Answer: D
Section: (none)


Explanation
Explanation/Reference:



70-412 Question 11

70-412 Question 11

You have a server named Server1 that runs Windows Server 2012. You modify the properties of a system driver and you restart Server1. You discover that Server1 continuously restarts without starting Windows Server 2012. You need to start Windows Server 2012 on Server1 in the least amount of time. The solution must minimize the amount of data loss. Which Advanced Boot Option should you select?

A. Repair Your Computer
B. Disable Driver Signature Enforcement
C. Last Know Good Configuration (advanced)
D. Disable automatic restart on system failure

Correct Answer: C
Section: (none)


Explanation
Explanation/Reference:

70-412 Question 10

70-412 Question 10

Your network contains an Active Directory domain named contoso.com. The domain contains three servers named Server1, Server2, and Server3 that run Windows Server 2012. All three servers have the Hyper-V server role installed and the Failover Clustering feature installed. Server1 and Server2 are nodes in a failover cluster named Cluster1. Several highly available virtual machines run on Cluster1. Cluster1 has the Hyper-V Replica Broker role installed. The Hyper-V Replica Broker currently runs on Server1. Server3 currently has no virtual machines. You need to configure Cluster1 to be a replica server for Server3 and Server3 to be a replica server for Cluster1. Which two tools should you use? (Each correct answer presents part of the solution. Choose two.)

A. The Hyper-V Manager console connected to Server3
B. The Hyper-V Manager console connected to Server2
C. The Failover Cluster Manager console connected to Cluster1
D. The Failover Cluster Manager console connected to Server3
E. The Hyper-V Manager console connected to Server1

Correct Answer: AC
Section: (none)


Explanation
Explanation/Reference:

70-412 Question 9

70-412 Question 9

You have a server named File1 that runs Windows Server 2012. File1 has the File Server role service installed. You plan to back up all shared folders by using Microsoft Online Backup. You download and install the Microsoft Online Backup Service Agent on File1. You need to ensure that you use Windows Server Backup to back up data to Microsoft Online Backup. What should you do?

A. From Computer Management, add the File1 computer account to the Backup Operators group.
B. From the Services console, modify the Log On settings of the Microsoft Online Backup Service Agent.
C. From Windows Server Backup, run the Register Server Wizard.
D. From a command prompt, run wbadmin.exe enable backup.

Correct Answer: C
Section: (none)


Explanation
Explanation/Reference:

70-412 Question 8

70-412 Question 8

Your network contains two servers named Server1 and Server2 that run Windows Server 2012. Both servers have the Hyper-V server role installed. Server1 and Server2 are located in different offices. The offices connect to each other by using a high-latency WAN link. Server2 hosts a virtual machine named VM1. You need to ensure that you can start VM1 on Server1 if Server2 fails. The solution must minimize hardware costs. What should you do?

A. On Server2, install the Multipath I/O (MPIO) feature. Modify the storage location of the VHDs for VM1.
B. From the Hyper-V Settings of Server1, modify the Replication Configuration settings. Enable replication for VM1.
C. On Server1, install the Multipath I/O (MPIO) feature. Modify the storage location of the VHDs for VM1.
D. From the Hyper-V Settings of Server2, modify the Replication Configuration settings. Enable replication for VM1.

Correct Answer: B
Section: (none)

 

Explanation
Explanation/Reference:

You first have to enable replication on the Replica server--Server1--by going to the server and modifying the "Replication Configuration" settings under Hyper-V settings. You then. go to VM1--which presides on Server2-- and run the "Enable Replication" wizard on VM1.