70-595 IT-Beschaffung 10g DBA,it-pruefungen.de,11g,11i,9i DBA,9i Internet Application Developer, Applications,EBS,E Business Suite,Hyperion,Java and Middleware,Java-OCJ-BC, Java Technology, NetBeans IDE, OCA
,OCE,OCJ-A,OCJ-EA,OCJ-MA, OCJ-P,OCJ-WC,OCM,OCNA,OCP, OCSA
,OCSAs,OCSecA,OPN Certified Specialist,Oracle Applications
,Oracle Certification Program,Oracle Database,Oracle Middleware,Oracle Openoffice,Oracle SO,Oracle Solaris,Oracle Solaris Cluster,Other Oracle Certification,Server and Storage Systems, WebLogic

70-595 IT-Beschaffung TS: Developing Business Process and Integration Solutions by Using Microsoft BizTalk Server 2010 Alle Lernmaterialien werden rechtzeitig nach der Änderung der Prüfung aktualisiert, damit Sie immer mit der neuesten Version auf Ihrere Prüfung vorbereiten können. Bevor Sie unsere Produkte einkaufen, können Sie auch kosteblos bei it-pruefungen.de .

Deutsche Zertifizierung 70-595 Microsoft

QUESTION 1
You are developing a BizTalk Server 2010 orchestration that consumes a web service located at http://localhost/ProcessData.asmx. The orchestration contains a non-transactional scope with an exception handler that handles any SOAP exceptions returned from the web service. The orchestration then completes successfully. After the orchestration completes with exceptions, you notice that the original messages posted to the web service are suspended in the BizTalk Administration console. You need to ensure that the messages are not suspended but are saved in an archive file on a shared server.
What should you do?

A. In the Administration console, modify the SOAP send port and enable routing for failed messages.
Create a FILE send port with filters ErrorReport.ErrorType==FailedMessage and ErrorReport.OutboundTransportLocation==http://localhost/ProcessData.asmx.
B. In Orchestration Designer, set Delivery Notification to Transmitted on the request/response port that sends the SOAP message. Create an exception handler with exception type DeliveryFailureException. In the handler, send a copy of the original message to a new send port that will transmit the message as a file.
C. In the Administration console, change the send pipeline to PassThruTransmit and enable Ordered delivery in the transport options.
D. In Orchestration Designer, modify the SOAP exception handler to send a copy of the original message to a new send port that will transmit the message as a file.

Answer: A

QUESTION 2
A BizTalk Server 2010 orchestration consumes a Microsoft Windows Communication Foundation (WCF) service. A request-response call to the WCF service is made inside a non-transactional scope. The scope has an exception handler that has its Exception Object Type property set to the type of the fault operation returned from the service. The handler receives the fault message. The WCF service throws a typed fault exception named WidgetException. You need to extract the exceptions detail node from thefault message. What should you do in the WCF send port configuration?

A. Set the Propagate Fault Message option to True. Specify the source of the outbound WCF message body by selecting Template. In the XML expression box, enter the XML of the WidgetException message.
B. Set the Propagate Fault Message option to True. Specify the source of the inbound BizTalk message body by selecting Path and entering the XPath expression for the WidgetException node.
C. Set the Propagate Fault Message option to True. Specify the source of the inbound WCF message body by selecting BizTalk Request Message Body.
D. Set the Propagate Fault Message option to True. Specify the source of the inbound BizTalk message body by selecting Envelope (soap:Envelope).

Answer: B

QUESTION 3
You are integrating BizTalk Server 2010 with a secure Microsoft Windows Communication Foundation (WCF) service that does not have metadata exchange (MEX) enabled. The web service provider distributes an XML schema with a root node named SecretData without a namespace for the data provided by the web service. You generate a BizTalk schema based on the XML schema. You finish developing the application and deploy it for integration testing. When testing the service, you trace the messages received from the service. You see that the response message is within a single element named SecureResponse. SOAP elements wrap the response message and the SecureResponse element. You need to specify the inbound message body properties to ensure that the message can be received. What should you do?

A. Choose the Envelope option. Add the soapProcessing endpoint behavior with the property processMessages=True.
B. Choose the Path option. For the body path expression, specify /*[local-name()='SecureResponse']/*[local-name()='SecretData'].
C. Choose the Path option. For the body path expression, specify /*[local-name()='SecretData']. Add the soapProcessing endpoint behavior with the property processMessages=True.
D. Choose the Body option. Add the useRequestHeadersForMetadataAddress service behavior.

Answer: B

Deutsche Zertifizierung 70-595 Microsoft

70-573 Echte Fragen it-pruefungen.de bietet qualitativ hochwertige Prüfungsfragen und Antworten für die Vorbereitung auf Ihre IT-Zertifizierungsprüfungen, die alle Examfragen und Examsantworten abdecken. Bei it-pruefungen.de stehen Ihnen zahlreiche kostenlose Zertifizierungsfragen von IT Prüfungen zur Verfügung. Die neuesten Unterlagen und Simulationssoftware bei it-pruefungen.de machen die IT Prüfungen ganz leicht für Sie. Im Falle eines Scheiterns erhalten Sie nämlich die Gebühr zurückerstattet

70-573 Echte Fragen TS: Office SharePoint Server, Application Development (available in 2010) IT Prüfung,IT Zertifizierung,Prüfungsfrage, originale Fragen,Antorten, Fragenkataloge,Prüfungsunterlagen, Prüfungsfragen, Prüfungsfrage, Testfagen, Testantworten, Vorbereitung, Zertifizierungsfragen, Zertifizierungsantworten, Examsfragen, Antworten, echte Fragen

Echte Fragen 70-573 Microsoft Fragenkatalog

QUESTION 1
You need to create a custom Web Part that meets the following requirements:

Includes all of the functionalities of the Search Results Web Part
Includes additional filters based on the current user department

What should you do?

A. Create a Web Part that inherits the CoreResultsWebPart class.
B. Create a Web Part that inherits the SearchResultsBaseDatasource class.
C. Modify the SearchDisco.aspx page and modify the descriptor file for the Search Summary Web Part.
D. Modify the SearchDisco.aspx page and modify the descriptor file for the Search Core Results Web Part.

Answer: A

Explanation/Reference:
MNEMONIC RULE: “Search Results Web Part = CoreResultsWebPart”
Specifies the user interface (UI) control that displays the results for a search query in the SharePoint Enterprise Search UI
CoreResultsWebPart Class

http://msdn.microsoft.com/en-us/library/microsoft.office.server.search.webcontrols.coreresultswebpart.aspx

QUESTION 2
You are creating a custom content type named CT1.

You need to use a Feature to add an existing site column named SiteCol1 to CT1.

Which code segment should you include in the Feature?

A.
B.
C.
D.

Answer: D

Explanation/Reference:
MNEMONIC RULE: “existing Field needs to be Referenced”
FieldRef Element (ContentType)

http://msdn.microsoft.com/en-us/library/aa543225.aspx

QUESTION 3
You need to create a custom content type and specify the content type ID.

What should you do?

A. Create a new module.
B. Create a custom Feature.
C. Call the Lists Web service.
D. Call the Webs Web service.

Answer: B

Echte Fragen 70-573 Microsoft Fragenkatalog

70-557  Fortbildungsprüfung TS:Microsoft Forefront Client and Server,Configuring ACE Acrobat, ACE AfterEffects, ACE Captivate, ACE ColdFusion
,ACE Dreamweaver,ACE Flash, ACE Flex, ACE FrameMaker,ACE GoLive,ACE Illustrator,ACE InDesign,ACE LiveCycle,ACE Premiere,ACE RoboHelp, Adobe Certification, Photoshop,Photoshop Certified Expert

Zertifizierungsprüfung 70-557 Microsoft

QUESTION 1
You need to configure Forefront Security for Exchange Server (FSE) to scan the bodies and attachments of all e-mail messages when you run a Manual Scan Job. What should you do?

A. Select the Enable Store Scanning option.
B. Select the Enable Transport Scanning option.
C. Enable the Body Scanning C Manual option.
D. Enable the Body Scanning C Realtime option.

Answer: C

QUESTION 2
You deploy Forefront Client Security to all client computers. You configure a Microsoft Operations Manager (MOM) 2005 operator group named FCS Admins. FCS Admins contains
e-mail-enabled user accounts. You notice that the FCS Admins operator group is not notified when Client Security alerts are generated in the MOM 2005 Administrator Console. You verify that MOM 2005 is configured with a valid SMTP server and that FCS Admins contains the appropriate user accounts. You need to ensure that FCS Admins receives Client Security alerts by e-mail. What should you do next?

A. In the MOM 2005 Administrator Console, add FCS Admins to Custom Fields 1 on the Custom Alerts Field
tab.
B. In the MOM 2005 Administrator Console, add the FCS Admins operator group to the Client Security
notification group.
C. On the Client Security server, add the FCS Admins operator group to the local MOM 2005 Administrators
group.
D. In the Client Security policy, change the reporting alert level to 5.

Answer: B

QUESTION 3
You deploy Forefront Client Security to all client computers. You need to verify that all client computers have up-to-date antivirus definitions. What should you review?

A. Deployment Summary report
B. fcsam.log file
C. Malware Summary report
D. Security event log

Answer: A

Zertifizierungsprüfung 70-557 Microsoft

70-516 IT-Expert SAP ABAP,it-pruefungen.de,SAP Certified Associate,SAP Certified Development Associate,SAP Application Associate,SAP-Certifications,SAP Certified Application Associate,SAP Certified Application Professional,SAP Certified Development Professional, SAP Certified Technology Associate, SAP Certified Technology Professional

70-516 IT-Expert TS: Accessing Data with Microsoft .NET Framework 4 Die rasante Entwicklung im Bereich der Informationstechnik macht es zwingend, sich regelmäßig fortzubilden. Weisen Sie Ihr IT-Können nach, absolvieren Sie Ihre Prüfung. Bei Ihrer Zertifizierungsvorbereitung werde Ihnen it-pruefungen.de sehr gut helfen.

Prüfungsfragen 70-516 Microsoft

QUESTION 1
You use Microsoft .NET Framework 4.0 to develop an application that uses the Entity Framework.
The application defines the following Entity SQL (ESQL) query, which must be executed against the mode.

string prodQuery = “select value p from Products as p where p.ProductCategory.Name = @p0″;

You need to execute the query. Which code segment should you use?

A. var prods = ctx.CreateQuery(prodQuery,
new ObjectParameter(“p0″, “Road Bikes”)).ToList();
B. var prods = ctx.ExecuteStoreCommand(prodQuery,
new ObjectParameter(“p0″, “Road Bikes”)).ToList();
C. var prods = ctx.ExecuteFunction(prodQuery,
new ObjectParameter(“p0″, “Road Bikes”)).ToList();
D. var prods = ctx.ExecuteStoreQuery(prodQuery,
new ObjectParameter(“p0″, “Road Bikes”)).ToList();

Answer: A

Explanation/Reference:
CreateQuery – Creates an ObjectQuery in the current object context by using the specified query string.
ExecuteStoreCommand – Executes an arbitrary command directly against the data source using the existing connection.
ExecuteFunction(String, ObjectParameter[]) – Executes a stored procedure or function that is defined in the data source and
expressed in the conceptual model; discards any results returned from the function; and returns the number of rows affected by the execution.
ExecuteStoreQuery(String, Object[]) – Executes a query directly against the data source that returns a sequence of typed results.

ObjectContext.CreateQueryMethod
(http://msdn.microsoft.com/en-us/library/bb339670.aspx)

QUESTION 2
You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server 2008 database.
The application uses nested transaction scopes. An inner transaction scope contains code that inserts records into the database.
You need to ensure that the inner transaction can successfully commit even if the outer transaction rolls back.

What are two possible TransactionScope constructors that you can use for the inner transaction to achieve this goal?
(Each correct answer presents a complete solution. Choose two.)

A. TransactionScope(TransactionScopeOption.Required)
B. TransactionScope()
C. TransactionScope(TransactionScopeOption.RequiresNew)
D. TransactionScope(TransactionScopeOption.Suppress)

Answer: CD

Explanation/Reference:
Required – A transaction is required by the scope. It uses an ambient transaction if one already exists.
Otherwise, it creates a new transaction before entering the scope. This is the default value.
RequiresNew – A new transaction is always created for the scope.
Suppress – The ambient transaction context is suppressed when creating the scope.
All operations within the scope are done without an ambient transaction context.

TransactionScopeOption Numeration
(http://msdn.microsoft.com/en-us/library/system.transactions.transactionscopeoption.aspx)

QUESTION 3
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that uses the Entity Framework.
Entity types in the model are generated by the Entity Data Model generator tool (EdmGen.exe).
You write the following code. (Line numbers are included for reference only.)

01 MemoryStream stream = new MemoryStream();
02 var query = context.Contacts.Include(“SalesOrderHeaders.SalesOrderDetails”);
03 var contact = query.Where(“it.LastName = @lastname”, new ObjectParameter(“lastname”, lastName)).First();
04 ….

You need to serialize the contact and all of its related objects to the MemoryStream so that the contact can be deserialized back into the model.
Which code segment should you insert at line 04?

A. var formatter = new XmlSerializer(typeof(Contact), new Type[]
{

typeof(SalesOrderHeader),

typeof(SalesOrderDetail)
});
formatter.Serialize(stream, contact);

B. var formatter = new XmlSerializer(typeof(Contact));
formatter.Serialize(stream, contact);

C. var formatter = new BinaryFormatter();
formatter.Serialize(stream, contact);

D. var formatter = new SoapFormatter();
formatter.Serialize(stream, contact);

Answer: A

Prüfungsfragen 70-516 Microsoft

70-515 Deutsche Zertifizierung 10g DBA,it-pruefungen.de,11g,11i,9i DBA,9i Internet Application Developer, Applications,EBS,E Business Suite,Hyperion,Java and Middleware,Java-OCJ-BC, Java Technology, NetBeans IDE, OCA
,OCE,OCJ-A,OCJ-EA,OCJ-MA, OCJ-P,OCJ-WC,OCM,OCNA,OCP, OCSA
,OCSAs,OCSecA,OPN Certified Specialist,Oracle Applications
,Oracle Certification Program,Oracle Database,Oracle Middleware,Oracle Openoffice,Oracle SO,Oracle Solaris,Oracle Solaris Cluster,Other Oracle Certification,Server and Storage Systems, WebLogic

70-515 Deutsche Zertifizierung TS: Web Applications Development with Microsoft.NET Framework 4 Alle Lernmaterialien werden rechtzeitig nach der Änderung der Prüfung aktualisiert, damit Sie immer mit der neuesten Version auf Ihrere Prüfung vorbereiten können. Bevor Sie unsere Produkte einkaufen, können Sie auch kosteblos bei it-pruefungen.de .

Deutsche Zertifizierung 70-515 Microsoft

QUESTION 1
You are developing an ASP.NET Web page. You add a data-bound GridView control. The GridView contains a TemplateField that includes a DropDownList. You set the GridViews ClientIDMode property to Static, and you set the ClientIDRowSuffix property to ProductID. You need to be able to reference individual DropDownList controls from client-side script by using the ProductID. What should you set the ClientIDMode property of the DropDownList to?

A. AutoID
B. Static
C. Inherit
D. Predictable

Answer: D
Section: linq, data controls, dynamic data

QUESTION 2
Gridview: How to change the image of an image control place in each row in a gridview:

A. ItemDataBound
B. Init
C. Prerender
D.

Answer: A
Section: linq, data controls, dynamic data

QUESTION 3
You are developing an ASP.NET Web page. The page includes a List instance. You add a FormView control to display a single Product from this list. You need to bind the list to the FormView control. Which FormView property should you set in the code-behind file?

A. DataSource
B. DataSourceID
C. DataKeyNames
D. DataMember

Answer: A

Deutsche Zertifizierung 70-515 Microsoft

70-513 IT Zertifizierung it-pruefungen.de bietet qualitativ hochwertige Prüfungsfragen und Antworten für die Vorbereitung auf Ihre IT-Zertifizierungsprüfungen, die alle Examfragen und Examsantworten abdecken. Bei it-pruefungen.de stehen Ihnen zahlreiche kostenlose Zertifizierungsfragen von IT Prüfungen zur Verfügung. Die neuesten Unterlagen und Simulationssoftware bei it-pruefungen.de machen die IT Prüfungen ganz leicht für Sie. Im Falle eines Scheiterns erhalten Sie nämlich die Gebühr zurückerstattet

70-513 IT Zertifizierung TS: Windows Communication Foundation velopment with Microsoft .NET Framework 4 IT Prüfung,IT Zertifizierung,Prüfungsfrage, originale Fragen,Antorten, Fragenkataloge,Prüfungsunterlagen, Prüfungsfragen, Prüfungsfrage, Testfagen, Testantworten, Vorbereitung, Zertifizierungsfragen, Zertifizierungsantworten, Examsfragen, Antworten, echte Fragen

Echte Fragen 70-513 Microsoft Fragenkatalog

QUESTION 1
You are developing a Windows Communication Foundation (WCF) service that contains the following operation contract.

[OperationContract]
CustomerNames GetCustomerNames();

The operation returns customer names. You need to develop a definition for the operation contract that produces XML with the following structure.

Customer1
Customer2
Customer3

Which code segment should you use?

A. [MessageContract(IsWrapped = false)]
public class CustomerNames
{
[MessageBodyMember]
public string[] Names;
}

B. [MessageContract(WrapperName = "")]
public class CustomerNames
{
[MessageBodyMember]
public string[] Names;
}

C. [DataContract]
public class CustomerNames
{
[DataMember]
public string[] Names;
}

D. [DataContract]
public class CustomerNames
{
[DataMember(IsRequired = false)]
public string[] Names;
}

Answer: A

Explanation/Reference:
If the message contract is not wrapped, that is, if the property IsWrapped is set to false,
the message contract can have only one body part.

The name of the wrapper element for the request message contract must match the operation name.
Use the WrapperName property of the message contract for this.

Using Message Contracts
(http://msdn.microsoft.com/en-us/library/ms730255.aspx)

QUESTION 2
You are creating a client application and configuring it to call a Windows Communication Foundation (WCF) service.
When the application is deployed, it will be configured to send all messages to a WCF routing service.
You need to ensure that the application can consume the target service after the application is deployed.
What should you do?

A. In the client application, add a service reference to the router service.
In the client binding configuration, specify the address of the router service.

B. In the client application, add a service reference to the target service.
In the client binding configuration, specify the address of the target service.

C. In the client application, add a service reference to the router service.
In the client binding configuration, specify the address of the target service.

D. In the client application, add a service reference to the target service.
In the client binding configuration, specify the address of the router service.

Answer: D

QUESTION 3
You create a service and deploy it on a network in a building named Building1. You will deploy the service to Building2.

The service in Building1 is configured using the following discovery scopes.

The service in Building2 will be configured using the following discovery scopes.

You need to ensure that the client application can discover the service in Building1 or the service in Building2.
Which scopes should you add to the client configuration file?

A.
B.
C.
D.
Answer: B

Echte Fragen 70-513 Microsoft Fragenkatalog

Zertifizierungsprüfung 70-511-Csharp MCTS: Windows Applications Development with Microsoft .NET Framework 4 Practice Test ACE Acrobat, ACE AfterEffects, ACE Captivate, ACE ColdFusion
,ACE Dreamweaver,ACE Flash, ACE Flex, ACE FrameMaker,ACE GoLive,ACE Illustrator,ACE InDesign,ACE LiveCycle,ACE Premiere,ACE RoboHelp, Adobe Certification, Photoshop,Photoshop Certified Expert

Zertifizierungsprüfung 70-511-Csharp Microsoft

QUESTION 1
You use Microsoft .NET Framework 4 to create a Windows Forms application.
You have a DataGridView that is bound to a DataTable containing a column named ProductName.
The ProductName column can contain any valid string, except “ProductX,” “ProductY,” “ProductZ.”
You need to ensure that only valid entries for ProductName are saved when users edit the DataGridView.
Which DataGridView event should you use?
A. CellBeginEdit
B. Invalidated
C. Validated
D. Validating

Answer: D

QUESTION 2
You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application.
The application contains three text boxes named txtAddress, txtCity, and txtState.
You need to ensure that the postal code is automatically set based on the information typed by users in the text boxes.
You also need to ensure that the complete address is displayed in a TextBlock control.
Which code fragment should you use?
A.

B.

C.

D.

Answer: C

QUESTION 3
You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application.
The application contains an ObservableCollection object named Pictures that contains several Picture objects.
Each Picture object contains the Name and PictureFilePath properties.
You add a ListBox control to the application.
You need to ensure that the pictures are displayed in the ListBox control.
Which code fragment should you use?
A.

B.

C.

D.

Answer: D

Zertifizierungsprüfung 70-511-Csharp Microsoft

Prüfungsthemen 70-511 SAP ABAP,it-pruefungen.de,SAP Certified Associate,SAP Certified Development Associate,SAP Application Associate,SAP-Certifications,SAP Certified Application Associate,SAP Certified Application Professional,SAP Certified Development Professional, SAP Certified Technology Associate, SAP Certified Technology Professional

Prüfungsthemen 70-511 TS: Windows Applications Development with Microsoft.NET Framework 4 Die rasante Entwicklung im Bereich der Informationstechnik macht es zwingend, sich regelmäßig fortzubilden. Weisen Sie Ihr IT-Können nach, absolvieren Sie Ihre Prüfung. Bei Ihrer Zertifizierungsvorbereitung werde Ihnen it-pruefungen.de sehr gut helfen.

Prüfungsfragen 70-511 Microsoft

QUESTION 1
AB-VB
You are developing a Windows Presentation Foundation (WPF) application. This application will be deployed to 20 countries. However, it will only be localized to some of those countries’ regional dialects.
The localization will be performed by using resource files. However, no culture will be specified in the project file with the UlCulture tags.
You must ensure that the application defaults to English for those regions that are not localized.
What should you do?

A. Add the following code segment to the Assemblylnfo file.

B. Add the following code segment to the Assemblylnfo file.

C. Add the following code segment to the Application constructor.
Thread.CurrentThread.CurrentCulture
New CultureInfo (“en-US”)
D. Add the following code segment to the Application constructor.
Thread.CurrentThread.CurrentUICulture =
New CultureInfo(“en-US”)

Answer: A

QUESTION 2
AB-VB
You are developing a Windows Presentation Foundation (WPF) application page.
The page uses extensive graphics controls and animation that require absolute positioning.
You need to select a control to use as a container.
Which control should you select?

A. Canvas
B. DockPanel
C. StackPanel
D. Grid

Answer: A

QUESTION 3
AB-VB
You are creating a Windows Presentation Foundation (WPF) application.
A control periodically appears to alert the user of status changes within the application.
You need to specify that each time the control appears, it fades out within half a second.
Which markup segment should you add to the Storyboard element of the control?

A.
B.
C.
D.

Answer: A

Prüfungsfragen 70-511 Microsoft

70-463 mit 800 Punkten bestanden Implementing a Data Warehouse with Microsoft SQL Server 2012 Alle Lernmaterialien werden rechtzeitig nach der Änderung der Prüfung aktualisiert, damit Sie immer mit der neuesten Version auf Ihrere Prüfung vorbereiten können. Bevor Sie unsere Produkte einkaufen, können Sie auch kosteblos bei it-pruefungen.de .

Deutsche Zertifizierung 70-463 Microsoft

QUESTION: 1
You are designing a data warehouse for a fresh food distribution business that stores sates by individual product. It stores sales targets by product category. Products are classified into subcategories and categories. Each product is included in only a single product subcategory, and each subcategory is included in only a single category. The data
warehouse will be a data source for an Analysis Services cube. The data warehouse
contains two fact tables:
- factSales, used to record daily sales by product
- factProductTarget, used to record the monthly sales targets by product category Reports
must be developed against the warehouse that reports product sales by product, category
and subcategory, and product sales targets. You need to design the product dimension.
The solution should use as few tables as possible while supporting all the requirements.
What should you do?

A. Create two product tables, dimProduct and dimProductCategory. Connect
factSales to dimProduct and factProductTarget to dimProductCategory with foreign key
constraints. Direct the cube developer to use key granularity attributes.
B. Create one product table, dimProduct, which contains product detail, category, and
subcategory columns. Connect factSales to dimProduct with a foreign key constraint.
Direct the cube developer to use a non-key granularity attribute for factProductTarget.
C. Create three product tables, dimProduct, dimProductCategory, and dimProductSubcategory, and a fourth bridge table that joins products to their appropriate
category and subcategory table records with foreign key constraints. Direct the cube
developer to use key granularity attributes.
D. Create three product tables, dimProduct, dimProductCategory, and
dimProductSubcategory. Connect factSales to all three product tables and connect
factProductTarget to dimProductCategory with foreign key constraints. Direct the cube developer to use key granularity attributes.

Answer: B

QUESTION: 2
You are reviewing the design of a student dimension table in an existing data warehouse
hosted on SQL Azure. The current dimension design does not allow the retention of
historical changes to student attributes such as ParentOccupation. You need to redesign
the dimension to enable the full historical reporting of changes to multiple student
attributes including ParentOccupation. What should you do?

A. Add CurrentValue and PreviousValue columns to the student dimension.
B. Enable Snapshot Isolation on the data warehouse.
C. Add an IsCurrent column to the student dimension.
D. Add StartDate and EndDate columns to the student dimension.

Answer: C

Deutsche Zertifizierung 70-463 Microsoft