June 26, 2017

C2090-610 DB2 10.1 Fundamentals

Test information:
Number of questions: 69
Time allowed in minutes: 90
Required passing score: 66%
Languages: English, Japanese

This Database Associate certification is an entry level exam for a user of any of the DB2 family of products. This individual is knowledgeable about the fundamental concepts of DB2 10.1 through either hands on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand which additional products are available with DB2 10.1, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.

Section 1 - Planning (10%)
Knowledge of DB2 products (z/OS vs LUW vs pureScale - at a high-level; different products and what they do)
Knowledge of database workloads (appropriate DB2 product to use - OLTP vs warehousing)
Knowledge of non-relational data concepts (XML data, LOB data)

Section 2 - Security (15%)
Knowledge of restricting data access
Knowledge of different privileges and authorities
Given a DCL SQL statement, knowledge to identify results (grant/revoke/connect statements)
Knowledge of Row and Column Access Control (RCAC)
Knowledge of Roles and Trusted Contexts

Section 3 - Working with Databases and Database Objects (20%)
Ability to create and connect to DB2 servers and databases (requirements to give ability to connect)
Ability to identify DB2 objects
Knowledge of basic characteristics and properties of DB2 objects
Given a DDL SQL statement, knowledge to identify results (ability to create objects)
Knowledge of Temporal (Time Travel) Tables - System-period, Application-period, and Bi-temporal - ability to create (Greater precision time stamps)

Section 4 - Working with DB2 Data using SQL (20%)
Ability to use SQL to SELECT data from tables
Ability to use SQL to SORT or GROUP data
Ability to use SQL to UPDATE, DELETE, or INSERT data
Knowledge of transactions (i.e., commit/rollback and transaction boundaries)
Ability to create and call an SQL supported procedure or a user defined function (understanding of passing parameters and results)
Given an XQuery statement, knowledge to identify results
Knowledge of Temporal (Time Travel) Tables - System-period, Application-period, and Bi-temporal - ability to query

Section 5 - Working with DB2 Tables, Views and Indexes (22%)
Ability to demonstrate usage of DB2 data types (XML data types, Oracle compatibility data types)
Given a situation, ability to create a temporary table
Knowledge to identify when referential integrity should be used
Knowledge to identify methods of data constraint
Knowledge to identify characteristics of a table, view or index
Knowledge to identify when triggers should be used
Knowledge of schemas

Section 6 - Data Concurrency (13%)
Knowledge to identify factors that influence locking
Ability to list objects on which locks can be obtained (lock table)
Knowledge to identify characteristics of DB2 locks (common locks shared across platforms)
Given a situation, knowledge to identify the isolation levels that should be used (currently committed)



QUESTION 1
If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of thedatabase?

A. 4
B. 8
C. 16
D. 32

Answer: A


QUESTION 2
Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wishes to increase the size of the ITEM column, which SQL statement needs to be used?

A. ALTER TABLE sales ADD COLUMN item CHAR(40);
B. ALTER TABLE sales ALTER COLUMN item CHAR(40);
C. ALTER TABLE sales MODIFY COLUMN item CHAR(40);
D. ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);

Answer: D


QUESTION 3
Which DB2 object can be used to improve theexecution performance of qualified SELECT statements?

A. Trigger
B. SQL Procedure
C. Sequence Object
D. Materialized Query Table

Answer: D


QUESTION 4
When is it appropriate to use a sequence?

A. When you want to control the order in which triggersare fired.
B. When you want to control the order in which stored procedures can be invoked.
C. When you want to automatically generate a numeric value that is not tied to any specific column or table.
D. When you want to automatically generate a numeric value for each row that is added to a specific table.

Answer: C


August 19, 2016

Exam 70-532 Developing Microsoft Azure Solutions

Published: September 1, 2014
Languages: English, Japanese
Audiences: Developers
Technology: Microsoft Visual Studio, Microsoft Azure
Credit toward certification: MCP, Microsoft Azure Developer Specialist

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

The Microsoft Azure environment is constantly evolving. To maximize relevance, this exam is regularly updated to reflect both deprecated and new technologies and processes. As of March 10, 2016, this exam reflects an update. To learn more about these changes and how they affect the skills measured, please download and review the Exam 70-532 changes document.

Note To ensure that they are aware of the latest updates, it is recommended that all individuals registering for this exam review this page several times before their scheduled exam.

Design and implement Web Apps (15‒20%)
Deploy Web Apps
Define deployment slots; roll back deployments; implement pre and post deployment actions; create, configure and deploy a package; create App Service plans; migrate Web Apps between App Service plans; create a Web App within an App Service plan
Configure Web Apps
Define and use app settings, connection strings, handlers, and virtual directories; configure certificates and custom domains; configure SSL bindings and runtime configurations; manage Web Apps by using the API, Azure PowerShell, and Xplat-CLI
Configure diagnostics, monitoring, and analytics
Retrieve diagnostics data, view streaming logs, configure endpoint monitoring, configure alerts, configure diagnostics, use remote debugging, monitor Web App resources
Implement web jobs
Write web jobs using the SDK, package and deploy web jobs, schedule web jobs
Configure Web Apps for scale and resilience
Configure auto-scale using built-in and custom schedules, configure by metric, change the size of an instance, configure Traffic Manager
Design and implement applications for scale and resilience
Select a pattern, implement transient fault handling for services, respond to throttling, disable Application Request Routing (ARR) affinity

Preparation resources
How to Deploy an Azure Web Site
Getting Started with the Azure WebJobs SDK
Cloud Design Patterns: Prescriptive Architecture Guidance for Cloud Applications

Create and manage virtual machines (20‒25%)
Deploy workloads on Azure Virtual Machines (VMs)
Identify workloads that can and cannot be deployed, run workloads including Microsoft and Linux, create VMs
Create and manage a VM image or virtual hard disk
Create specialized and reusable images, prepare images using SysPrep and Windows Agent (Linux), copy images between storage accounts and subscriptions, upload VMs
Perform configuration management
Automate configuration management by using PowerShell Desired State Configuration and VM Agent (custom script extensions); configure VMs using a configuration management tool, such as Puppet or Chef; enable remote debugging
Configure VM networking
Configure reserved IP addresses, Network Security Groups (NSG), DNS at the virtual network level, load balancing endpoints, HTTP and TCP health probes, public IPs, firewall rules, direct server return, and keep-alive
Scale VMs
Scale up and scale down VM sizes, configure auto-scale and availability sets
Design and implement VM storage
Configure disk caching, plan for storage capacity, configure shared storage using Azure File service, configure geo-replication
Monitor VMs
Configure endpoint monitoring, configure alerts, configure diagnostic and monitoring storage location

Preparation resources
Copy Blob
Load Balancing for Azure Infrastructure Services
How to Monitor Cloud Services

Design and implement cloud services (20‒25%)
Design and develop a cloud service
Install SDKs, install emulators, develop a web role or worker role, design and implement resiliency including transient fault handling, develop startup tasks
Configure cloud services and roles
Configure HTTPS endpoint and upload an SSL certificate, and instance count and size; configure network access rules, local storage, multiple Web Apps, custom domains, and dedicated and co-located caching; scale up and scale down role sizes; configure auto-scale
Deploy a cloud service
Upgrade an automatic, manual, or simultaneous deployment; VIP swap a deployment; package a deployment; implement continuous deployment from Visual Studio Online (VSO); implement runtime configuration changes using the portal; configure regions and affinity groups
Monitor and debug a cloud service
Configure diagnostics using the SDK or configuration file, profile resource consumption, enable remote debugging, establish a connection using Remote Desktop CmdLets in Azure PowerShell, debug using IntelliTrace or the emulator

Preparation resources
Continuous delivery to Azure using Visual Studio Online
Configuring SSL for an application in Azure
Windows Azure SDK for .NET - 2.2

Design and implement a storage strategy (20‒25%)
Implement Azure Storage blobs and Azure files
Read data, change data, set metadata on a container, store data using block and page blobs, stream data using blobs, access blobs securely, implement async blob copy, configure Content Delivery Network (CDN), design blob hierarchies, configure custom domains, scale blob storage, implement Azure Premium storage
Implement Azure storage tables
Implement CRUD with and without transactions, design and manage partitions, query using OData; scale tables and partitions
Implement Azure storage queues
Add and process messages, retrieve a batch of messages, scale queues
Manage access
Generate shared access signatures, including client renewal and data validation; create stored access policies; regenerate storage account keys; configure and use Cross-Origin Resource Sharing (CORS)
Monitor storage
Set retention policies and logging levels, analyze logs
Implement SQL databases
Choose the appropriate database tier and performance level, configure and perform point in time recovery, enable geo-replication, import and export data and schema, scale SQL databases

Preparation resources
Azure Cloud Service Tutorial: ASP.NET MVC Web Role, Worker Role, and Azure Storage Tables, Queues, and Blobs - 1 of 5
Shared Access Signatures, Part 1: Understanding the SAS Model
How to Monitor a Storage Account

Manage application and network services (15‒20%)
Integrate an app with Azure Active Directory
Develop apps that use WS-federation, OAuth, and SAML-P endpoints; query the directory using graph API
Configure a virtual network
Deploy a VM into a virtual network, deploy a cloud service into a virtual network
Modify network configuration
Modify a subnet, import and export network configuration
Design and implement a communication strategy
Develop messaging solutions using service bus queues, topics, relays, and notification hubs; create service bus namespaces and choose a tier; scale service bus
Monitor communication
Monitor service bus queues, topics, relays, and notification hubs
Implement caching
Implement Redis caching, migrate solutions from Azure Cache Service to use Redis caching

Preparation resources

Azure AD Graph API
Notification Hubs Monitoring and Telemetry


QUESTION 1
You are deploying the web-based solution in the West Europe region.
You need to copy the repository of existing works that the plagiarism detection service uses. You must achieve this goal by using the least amount of time.
What should you do?

A. Copy the files from the source file share to a local hard disk. Ship the hard disk to the West Europe data center by using the Azure Import/Export service.
B. Create an Azure virtual network to connect to the West Europe region. Then use Robocopy to copy the files from the current region to the West Europe region.
C. Provide access to the blobs by using the Microsoft Azure Content Delivery Network (CDN). Modify the plagiarism detection service so that the files from the repository are loaded from the CDN.
D. Use the Asynchronous Blob Copy API to copy the blobs from the source storage account to a storage account in the West Europe region.

Answer: D

Explanation:
Ref: http://blogs.msdn.com/b/windowsazurestorage/archive/2012/06/12/introducing-asynchronous-cross-account-copy-blob.aspx

QUESTION 2
You update the portion of the website that contains biographical information about students.
You need to provide data for testing the updates to the website.
Which approach should you use?

A. Use SQL Server data synchronization.
B. Use the Active Geo-Replication feature of Azure SQL Database.
C. Use SQL Replication.
D. Use the Geo-Replication feature of Azure Storage.

Answer: A


QUESTION 3
The website does not receive alerts quickly enough.
You need to resolve the issue.
What should you do?

A. Enable automatic scaling for the website.
B. Manually Increase the instance count for the worker role.
C. Increase the amount of swap memory for the VM instance.
D. Set the monitoring level to Verbose for the worker role.
E. Enable automatic scaling for the worker role.

Answer: B

August 1, 2016

Exam 70-511 TS: Windows Applications Development with Microsoft .NET Framework 4

Published: July 2, 2010
Languages: English
Audiences: Developers
Technology: Microsoft Visual Studio 2010
Credit toward certification: MCTS

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Building a user interface by using basic techniques (23%)
Choose the most appropriate control class
Evaluating design requirements and then selecting the most appropriate control based on those requirements; recognizing when none of the standard controls meet requirements; item controls, menu controls, content controls
This objective does not include: designing a custom control
Implement screen layout by using nested control hierarchies
Using panel-derived controls, attaching properties
This objective does not include: items controls, control customization
Create and apply styles and theming
Application-level styles, overriding styles, style inheritance, Generic.xaml, theming attributes
This objective does not include: data-grid view style sharing
Manage reusable resources
Fonts, styles, data sources, images, resource dictionaries, resource-only DLLs
Implement an animation in WPF
Creating a storyboard; controlling timelines; controlling the behavior when the animation completes; double, color, and point animations; starting an animation from code and from XAML
This objective does not include: direct rendering updates, implementing key frame animations

Preparation resources
Styling and templating
Layout system
Animation tips and tricks

Enhancing a user interface by using advanced techniques (21%)
Manage routed events in WPF
Tunneling vs. bubbling events, handling and cancelling events
This objective does not include: simple event handling; creating custom events
Configure WPF commanding
Defining WPF commands based on RoutedCommand; associating commands to controls; handling commands; command bindings; input gestures
This objective does not include: creating custom commands by implementing ICommand
Modify the visual interface at run time
Adding/removing controls at run time; manipulating the visual tree; control life cycle; generating a template dynamically
This objective does not include: instantiating forms and simple modification of control properties at runtime
Implement user-defined controls
Deciding whether to use a user/composite, extended, or custom control; creating a user/composite control; extending from an existing control
This objective does not include: creating a custom control by inheriting directly from the control class and writing code
Create and display graphics
Creating and displaying graphics by using geometric transformation; brushes; drawing shapes; clipping; double buffering; overriding render (WPF) and OnPaint (WinForms); differentiating between retained and non-retained graphics
This objective does not include: creating and displaying three-dimensional graphics; hit testing; creating images
Add multimedia content to an application in WPF
Media player vs. media element; adding a sound player; images
This objective does not include: buffering
Create and apply control templates in WPF
Template binding
This objective does not include: styling and theming; data templating
Create data, event, and property triggers in WPF

Preparation resources
Input and commands how-to topics
Control styles and templates

Managing data at the user interface layer (23%)
Implement data binding
Binding options, static and dynamic resources, element bindings, setting the correct binding mode and update mode; binding to nullable values
This objective does not include: binding to a specific data source
Implement value converters in WPF
Implementing custom value converters, implementing multivalue converters
Implement data validation
Handling validation and providing user feedback via the error provider (WinForms) or data templates (WPF), IDataErrorInfo, validation control, form validation and control validation
Implement and consume change notification interfaces
Implementing INotifyPropertyChanged; using INotifyCollectionChanged (ObservableCollection)
Prepare collections of data for display
Filtering, sorting, and grouping data; LINQ; CollectionView (WPF), BindingSource object (WinForms)
Bind to hierarchical data
TreeView; MenuControl
Implement data-bound controls
Using the DataGridView (WinForms) or DataGrid (WPF) control to display and update the data contained in a data source, implementing complex data binding to integrate data from multiple sources; ItemsControl-derived controls (WPF)
Create a data template in WPF
Implementing a data template selector; using templates with ItemsControl

Preparation resources
Data binding (WPF)
DataGrid

Enhancing the functionality and usability of a solution (17%)
Integrate WinForms and WPF within an application
Using ElementHosts within WinForms and ControlHosts within WPF; using the PropertyMap property
Implement asynchronous processes and threading
Implementing asynchronous programming patterns; marshalling between threads; freezing UI elements; using timers; task parallel library; parallel LINQ; using the dispatcher; BackgroundWorker component
Incorporate globalization and localization features
Loading resources by locale; marking localizable elements; using culture settings in validators and converters; using language properties and rendering direction properties; working with resource files for localization; determining installed locales; regional settings
Implement drag and drop operations within and across applications
This objective does not include: Dynamic Data Exchange (DDE)
Implement security features of an application
Configuring Software Restriction Policy (SRP); full trust and partially trusted security; interoperability with legacy CAS policy; User Account Control (UAC)
Manage user and application settings
Creating application settings; creating user settings; loading and saving settings
This objective does not include: persisting to database
Implement dependency properties
Enabling data binding and animation, property metadata, property change callbacks

Preparation resources
WPF and Windows Forms interoperation
How to: Perform drag-and-drop operations between applications
Dependency properties overview

Stabilizing and releasing a solution (16%)
Implement a WPF test strategy
Automation peer, UI automation, IntelliTrace
Debug XAML by using the WPF visualizer
Accessing the visualizer, drilling down into the visual tree, viewing and changing properties
This objective does not include: setting a breakpoint and stepping through code
Debug WPF issues by using PresentationTraceSources
Animation, data binding, dependency properties
Configure a ClickOnce deployment
Configuring the installation of a WinForms, WPF, or XBAP application by using ClickOnce technology; choosing appropriate settings to manage upgrades
Create and configure a Windows installer project
Configuring a setup project to add icons during setup, setting deployment project properties, configuring conditional installation based on operating system versions, setting appropriate launch conditions based on the .NET framework version, adding custom actions to a setup project, adding error-handling code to a setup project
Configure deployment security settings
Configuring and integrating UAC by using ClickOnce deployments; setting appropriate security permissions to deploy the application

Preparation resources
Debugging WPF – WPF Tree Visualizer and helper class
PresentationTraceSources class
How to: Use ClickOnce to deploy applications that can run on multiple versions of the .NET Framework

QUESTION 1
You use Microsoft .NET Framework 4 to create a Windows Forms application.
You add a new class named Customer to the application. You select the Customer class to create a new object data source.
You add the following components to a Windows Form:
? A BindingSource component named customerBindingSource that is data-bound to the Customer object data source.
? A set of TextBox controls to display and edit the Customer object properties. Each TextBox control is data-bound to a property of the customerBindingSource component.
? An ErrorProvider component named errorProvider that validates the input values for each TextBox control.
You need to ensure that the input data for each TextBox control is automatically validated by using the ErrorProvider component.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A. Implement the validation rules inside the Validating event handler of each TextBox control by throwing an exception when the value is invalid.
B. Implement the validation rules inside the TextChanged event handler of each TextBox control by throwing an exception when the value is invalid.
C. Implement the validation rules inside the setter of each property of the Customer class by throwing an exception when the value is invalid.
D. Add the following code segment to the InitializeComponent method of the Windows Form.
this.errorProvider.DataSource = this.customerBindingSource;
E. Add the following code segment to the InitializeComponent method of the Windows Form.
this.errorProvider.DataSource = this.customerBindingSource.DataSource; this. errorProvider. DataMember = this. customerBindingSource. DataMember;

Answer: C,D


QUESTION 2
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application.
The application contains a ListBox control named IbxItems that is data-bound to a collection of objects. Each object has a DisplayValue property.
You add a Button control to the application.
You need to ensure that the Content property of the Button control is data-bound to the DisplayValue property of the selected item of IbxItems.
Which binding expression should you use?

A. {Binding ElementName= IbxItems, Source=SelectedItem, Path=DisplayValue}
B. {Binding Source=lbxItems, ElementName=SelectedItem, Path=DisplayValue}
C. {Binding ElementName=lbxItems, Path=SelectedItem.DisplayValue}
D. {Binding Source=lbxItems, Path=SelectedItem.DisplayValue}

Answer: C


QUESTION 3
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application.
You write the following code fragment.
< TextBox Text="{Binding Path=StringMember} " / >
You need to ensure that the StringMember property of the data-bound object is updated immediately when the user types in the TextBox control.
Which binding expression should you use?

A. { Binding Path=StringMember, Mode=TwoWay }
B. { Binding Path=StringMember, NotifyOnSourceUpdated=True }
C. { Binding Path-StringMember, NotifyOnTargetUpdated=True }
D. { Binding Path=StringMember, UpdateSourceTrigger=PropertyChanged }

Answer: D


QUESTION 4
You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application.
You add a ListBox control to the application. The ListBox control is data-bound to an instance of a custom collection class of the Product objects named ProductList.
The number of items of the data-bound collection is fixed. However, users can modify the properties of each of the Product objects in the collection.
You need to ensure that changes made on the Product objects are automatically reflected in the ListBox control.
What should you do?

A. Implement the INotifyPropertyChanged interface in the Product class.
B. Implement the INotifyCollectionChanged interface in the ProductList class.
C. Set the Mode property of the Binding object of the ListBox control to TwoWay.
D. Set the UpdateSourceTrigger property of the Binding object of the ListBox control to PropertyChanged.

Answer: A
Bookmark and Share