Microsoft Technology Associate (MTA) — Questions and Answers

Question 1: What is the primary key in a database table?

A field that refers to data in another table
A field that can be left empty
A field that uniquely identifies each record in a table (Correct answer)
A field that contains duplicate values

Correct answer: A field that uniquely identifies each record in a table

A primary key in a database table is a special field or a combination of fields that uniquely identifies each individual record (row) within that table. It must contain unique values for every record and cannot be null. The primary key is crucial for maintaining data integrity and for establishing relationships between different tables in a relational database.

Question 2: Which HTML5 API allows web applications to work offline by caching resources?

localStorage API
IndexedDB API
Service Worker API (Correct answer)
Web Storage API

Correct answer: Service Worker API

Service Workers are JavaScript files that run in the background, intercepting network requests and caching resources to enable offline functionality and faster load times.

Question 3: What is a cloud SLA (Service Level Agreement)?

A security policy for cloud data
A contract defining the guaranteed performance and uptime of a cloud service (Correct answer)
A list of available cloud regions
A user license for cloud software

Correct answer: A contract defining the guaranteed performance and uptime of a cloud service

An SLA is a formal commitment from a cloud provider specifying minimum performance standards such as uptime percentage, with penalties if the provider fails to meet them.

Question 4: Which HTML5 input type is used to collect email addresses with built-in validation?

<input type='string'>
<input type='text'>
<input type='url'>
<input type='email'> (Correct answer)

Correct answer: <input type='email'>

The email input type provides browser-level validation ensuring the entered value matches an email format, and shows a suitable keyboard on mobile devices.

Question 5: What is the primary purpose of Mobile Device Management (MDM)?

Synchronizing mobile device clocks
Providing mobile internet access
Centrally managing and securing mobile devices in an organization (Correct answer)
Developing mobile applications

Correct answer: Centrally managing and securing mobile devices in an organization

MDM solutions allow IT administrators to enroll, configure, monitor, and remotely manage mobile devices to enforce security policies and protect corporate data.

Question 6: Which Windows feature encrypts entire disk volumes to protect data at rest?

EFS
BitLocker (Correct answer)
AppLocker
Windows Defender

Correct answer: BitLocker

BitLocker Drive Encryption protects data by encrypting entire volumes, requiring authentication before Windows can boot.

Question 7: What is the Shared Responsibility Model in cloud security?

Security is only the responsibility of third-party vendors
Customers are responsible for all security
Security responsibilities are divided between the provider and the customer based on service model (Correct answer)
The cloud provider handles all security

Correct answer: Security responsibilities are divided between the provider and the customer based on service model

The Shared Responsibility Model divides security duties: the provider secures the infrastructure, while the customer is responsible for data, access management, and application security.

Question 8: What does CSS specificity determine?

The order in which CSS files are loaded
Which CSS rule applies when multiple rules target the same element (Correct answer)
How fast CSS animations run
The maximum number of CSS classes per element

Correct answer: Which CSS rule applies when multiple rules target the same element

CSS specificity is the algorithm browsers use to determine which CSS rule wins when multiple conflicting rules target the same element, calculated from selector types.

Question 9: What does the Sysvol folder on a Domain Controller store?

Group Policy templates and logon scripts (Correct answer)
Server backup files
User profile data and home folders
DHCP lease information

Correct answer: Group Policy templates and logon scripts

Sysvol is a shared directory on Domain Controllers that stores Group Policy templates, logon scripts, and other domain-wide files replicated to all DCs.

Question 10: True or False? IPSec requires network applications to be a IPSec aware

False (Correct answer)
True

Correct answer: False

IPSec (Internet Protocol Security) operates at the network layer (Layer 3) of the OSI model, providing security services like authentication and encryption transparently. This means that applications running on top of the network layer do not need to be specifically designed or 'IPSec aware' to benefit from the security provided by an IPSec-enabled connection. IPSec secures the communication channel itself, not the application data directly.

Question 11: As part of a training exercise, you have been asked to identify the layer that allows applications and a number of useful functions access to the network. Which of the following options represents your response?

The system layer.
The application layer. (Correct answer)
The Data-link layer.
The document layer.

Correct answer: The application layer.

The application layer is the highest layer (Layer 7) in the OSI model, providing network services directly to end-user applications. It enables applications to access network resources and perform various functions such as file transfer, email, and web browsing. This layer interacts with software applications that implement a communicating component, allowing users to interact with the network.

Question 12: What is the role of a Mobile Application Store in enterprise mobility?

Managing app developer accounts
Providing a public marketplace for games
Selling mobile hardware accessories
Distributing approved corporate apps to managed devices in a controlled manner (Correct answer)

Correct answer: Distributing approved corporate apps to managed devices in a controlled manner

An enterprise app store or company portal allows IT to distribute approved, tested applications to managed devices, ensuring employees install only vetted software.

Question 13: A clients network is made up of two network segments, named Subnet A and Subnet B. DHCP clients are located on Subnet A. A DHCP server on Subnet B. You need to make sure that DHCP clients are able to connect to the server. Which of the following actions should you take?

You should make sure that the DNS service is configured.
You should make sure that the RRAS service is configured.
You should make sure that WEb service is configured.
You should make sure that the DHCP relay agent service is configured. (Correct answer)

Correct answer: You should make sure that the DHCP relay agent service is configured.

DHCP (Dynamic Host Configuration Protocol) clients typically use broadcast messages to discover a DHCP server. If the DHCP server is located on a different network segment (subnet) than the clients, these broadcast messages will not traverse routers by default. Therefore, a DHCP relay agent service must be configured on the client's subnet to receive these broadcast requests and forward them as unicast messages to the DHCP server, enabling clients to obtain IP addresses across subnets.

Question 14: What is the purpose of JavaScript promises?

Defining CSS animations
Handling asynchronous operations with a cleaner alternative to nested callbacks (Correct answer)
Declaring variable types
Creating HTML templates

Correct answer: Handling asynchronous operations with a cleaner alternative to nested callbacks

Promises represent the eventual completion or failure of an asynchronous operation, providing .then() and .catch() methods for cleaner asynchronous code than nested callbacks.

Question 15: Which cloud computing concept ensures that resources are shared among multiple customers on the same physical hardware?

Multi-tenancy (Correct answer)
Dedicated hosting
Bare-metal provisioning
Single-tenancy

Correct answer: Multi-tenancy

Multi-tenancy is a cloud architecture where a single physical infrastructure serves multiple customers simultaneously, with logical isolation keeping their data separate.

Question 16: Which cloud service model provides virtualized computing resources like VMs, storage, and networking over the internet?

PaaS
IaaS (Correct answer)
FaaS
SaaS

Correct answer: IaaS

IaaS (Infrastructure as a Service) provides virtualized hardware resources including compute, storage, and networking, giving users control over the OS and applications.

Question 17: What does the HTML5 doctype declaration <!DOCTYPE html> do?

Links an external stylesheet
Tells the browser to render the page in HTML5 standards mode (Correct answer)
Declares the page encoding as UTF-8
Imports JavaScript libraries

Correct answer: Tells the browser to render the page in HTML5 standards mode

The <!DOCTYPE html> declaration instructs the browser to use the HTML5 specification and render the page in standards mode rather than quirks mode.

Question 18: In SQL, what does the JOIN clause do?

Adds a new row to a table
Combines columns from different tables (Correct answer)
Removes duplicates from a result set
Deletes rows from a table

Correct answer: Combines columns from different tables

In SQL, the `JOIN` clause is used to combine rows from two or more tables based on a related column between them. This allows you to retrieve a unified result set that includes columns from all joined tables, effectively linking data that is spread across different parts of the database. Various types of joins, such as INNER JOIN or LEFT JOIN, dictate how rows are matched and included in the output.

Question 19: What does 'fault tolerance' mean in the context of cloud computing?

The speed at which data is processed
The ability to add more servers quickly
The geographic spread of cloud regions
The ability to continue operating correctly even when components fail (Correct answer)

Correct answer: The ability to continue operating correctly even when components fail

Fault tolerance is the ability of a system to continue functioning correctly and without interruption even when one or more of its components fail.

Question 20: Which JavaScript method is used to make asynchronous HTTP requests to a server?

setTimeout()
querySelector()
fetch() (Correct answer)
addEventListener()

Correct answer: fetch()

The fetch() API provides a modern, promise-based way to make asynchronous HTTP requests to servers and APIs, replacing the older XMLHttpRequest (XHR) approach.

Question 21: Which cloud deployment model uses infrastructure exclusively maintained for a single organization?

Hybrid cloud
Public cloud
Community cloud
Private cloud (Correct answer)

Correct answer: Private cloud

A private cloud is cloud infrastructure operated exclusively for one organization, either on-premises or hosted by a third party, offering greater control and security.

Question 22: Which Azure tool allows administrators to manage all Azure services through a web browser?

Azure CLI
Azure Portal (Correct answer)
Azure PowerShell
Azure Resource Manager

Correct answer: Azure Portal

The Azure Portal is a web-based graphical interface that provides a unified view to manage all Azure services, resources, and subscriptions.

Question 23: Which Windows troubleshooting tool logs system errors, warnings, and informational events?

Performance Monitor
Event Viewer (Correct answer)
Reliability Monitor
Resource Monitor

Correct answer: Event Viewer

Event Viewer records system, application, and security events, providing detailed logs that help diagnose errors and troubleshoot Windows issues.

Question 24: What defends targets staff within an organization, explaining what to do, when, why, and by whom

Full Control
Answer : A
Policies, Procedures,& Awareness (Correct answer)
Click run and choose administrator

Correct answer: Policies, Procedures,& Awareness

Policies establish the rules and guidelines for an organization's security posture. Procedures provide the detailed, step-by-step instructions on how to implement those policies, clearly defining what actions to take, when, why, and by whom. Awareness training is crucial for educating staff on these policies and procedures, ensuring they understand their roles and responsibilities in maintaining organizational security.

Question 25: You have been tasked with making sure that a client's network includes a server that converts NetBIOS names to IP addresses. Which of the following actions should you take?

You should consider adding a DHCP server to the client's network.
You should consider adding a WINS server to the client's network. (Correct answer)
You should consider adding a Web server to the client's network.
You should consider adding a DNS server to the client's network.

Correct answer: You should consider adding a WINS server to the client's network.

A WINS (Windows Internet Name Service) server is specifically designed to resolve NetBIOS names to IP addresses. In older Windows-based networks, NetBIOS names were used for identifying network resources. While DNS has largely superseded WINS for modern IP networks, a WINS server would be essential if the client's network still relies on NetBIOS names for resource identification and requires their conversion to IP addresses.

Question 26: What is the difference between sessionStorage and localStorage in HTML5?

localStorage requires user authentication; sessionStorage does not
sessionStorage is cleared when the browser tab is closed; localStorage persists indefinitely (Correct answer)
sessionStorage holds more data than localStorage
sessionStorage is server-side; localStorage is client-side

Correct answer: sessionStorage is cleared when the browser tab is closed; localStorage persists indefinitely

sessionStorage stores data only for the duration of a browser session (cleared when the tab closes), while localStorage persists data with no expiration until explicitly cleared.

Question 27: What is the Document Object Model (DOM) in web development?

A server-side rendering engine
A database for storing web content
A programming interface representing the HTML document as a tree of objects that scripts can manipulate (Correct answer)
A CSS styling framework

Correct answer: A programming interface representing the HTML document as a tree of objects that scripts can manipulate

The DOM is a tree-structured programming interface that represents an HTML document's elements as objects, allowing JavaScript to dynamically read and modify content and structure.

Question 28: A client has requested a network setup for his home. The network has to be cost-effective, and easy to extend and implement. Further more, the client wants his workstations connected by a single cable. Which of the following network topologies should you use?

A mesh network topology.
A ring network topology.
A star network topology.
A bus network topology. (Correct answer)

Correct answer: A bus network topology.

A bus network topology connects all devices to a single central cable, or 'bus.' This setup is cost-effective and straightforward to implement for small networks, as it requires minimal cabling. It also offers ease of extension by simply adding more devices to the shared cable, making it a suitable choice for a home network requiring simplicity and expandability.

Question 29: What is the purpose of the HTML5 <semantic> elements like <header>, <nav>, <article>, and <footer>?

Providing meaningful structure that improves accessibility and SEO (Correct answer)
Adding visual styling to the page
Loading external content
Executing JavaScript code

Correct answer: Providing meaningful structure that improves accessibility and SEO

HTML5 semantic elements convey meaning about the content they contain, helping browsers, screen readers, and search engines understand the document structure.

Question 30: True or False? UAC reduces your permissions to that of a standard user unless higher permissions are necessary

False
True (Correct answer)

Correct answer: True

User Account Control (UAC) is a security feature in Windows designed to prevent unauthorized changes to the operating system. It operates by running most applications with standard user permissions by default, even for administrator accounts. When an action requires higher privileges, UAC prompts the user for consent, effectively reducing the attack surface and protecting against malicious software or accidental system alterations.

Question 31: What is a mobile device wipe, and when is it used?

A physical cleaning process for device screens
Removing malware from a mobile device
Remotely erasing all data on a device when it is lost or stolen (Correct answer)
Updating a device to the latest OS version

Correct answer: Remotely erasing all data on a device when it is lost or stolen

A remote wipe erases all data on a mobile device to protect sensitive information when the device is lost, stolen, or when an employee leaves the organization.

Question 32: Which type of testing validates the smallest individually testable units of code in isolation?

Integration testing
Acceptance testing
System testing
Unit testing (Correct answer)

Correct answer: Unit testing

Unit testing validates individual functions, methods, or components in isolation from the rest of the system.

Question 33: What is the default file system used by modern Windows installations?

NTFS (Correct answer)
ReFS
exFAT
FAT32

Correct answer: NTFS

NTFS (New Technology File System) is the default file system for Windows, supporting large files, permissions, encryption, and journaling.

Question 34: True or False? Because senior executives have rights to access sensitive data, they should use administrator accounts

True
False (Correct answer)

Correct answer: False

The principle of least privilege dictates that users, including senior executives, should only have the minimum necessary permissions to perform their job functions. Using an administrator account for daily tasks, even with rights to sensitive data, creates an unnecessary security risk. It exposes the system to potential malware or accidental changes that could compromise data integrity and system security.

Question 35: Which Control Panel tool is used to configure power plans in Windows?

Power Options (Correct answer)
System
Administrative Tools
Device Manager

Correct answer: Power Options

Power Options in Control Panel allows you to select and configure power plans like Balanced, Power Saver, and High Performance.

Question 36: Which Azure service provides scalable object storage for unstructured data like images and videos?

Azure Files
Azure Disk Storage
Azure Blob Storage (Correct answer)
Azure SQL Database

Correct answer: Azure Blob Storage

Azure Blob Storage is Microsoft's massively scalable object storage service optimized for storing large amounts of unstructured data like images, videos, and backups.

Question 37: What is the purpose of the Windows pagefile (pagefile.sys)?

Store temporary internet files
Store user profile data
Act as virtual memory when RAM is full (Correct answer)
Cache frequently used applications

Correct answer: Act as virtual memory when RAM is full

The pagefile serves as virtual memory, allowing Windows to move less-used data from RAM to disk when physical memory is exhausted.

Question 38: What is the primary role of Active Directory Domain Services (AD DS)?

Providing DNS resolution only
Hosting websites
Centralizing user authentication and resource management (Correct answer)
Managing email servers

Correct answer: Centralizing user authentication and resource management

AD DS provides centralized identity management, authenticating users and computers and enabling administrators to control access to network resources.

Question 39: You have recently designed a home office network for a client that includes a switch. Which of the following are TRUE with regards to network switches?

It operates at the Data-Link layer of the OSI model.
It operates at the Physical layer of the OSI model.
It keeps track of the MAC addresses attached to each of its ports and directs traffic intended for a particular address only to the port to which is attached. (Correct answer)
It keeps track of the IP addresses attached to each of its ports and directs traffic intended for a particular address only to the port to which it is attached.

Correct answer: It keeps track of the MAC addresses attached to each of its ports and directs traffic intended for a particular address only to the port to which is attached.

A network switch operates at the Data Link layer (Layer 2) of the OSI model. Its primary function is to learn the MAC addresses of devices connected to each of its ports and store this information in a MAC address table. When a data frame arrives, the switch examines the destination MAC address and intelligently forwards the frame only to the specific port where the destination device is attached, significantly reducing unnecessary network traffic and improving efficiency.

Question 40: Which of the following is a characteristic of a relational database?

Data is organized into tables with rows and columns (Correct answer)
Hierarchical relationships between data elements
Data stored in flat files
Tables that store unstructured data

Correct answer: Data is organized into tables with rows and columns

A relational database is characterized by its structured organization, where data is arranged into two-dimensional tables consisting of rows and columns. Each row represents a unique record, and each column represents an attribute or field. Relationships between these tables are established through common fields, known as foreign keys, adhering to the principles of the relational model for efficient data management.

Question 41: What does the term 'elasticity' mean in cloud computing?

The ability to recover quickly from failures
The ability to automatically scale resources up or down based on demand (Correct answer)
The speed of network connections
The geographic distribution of data centers

Correct answer: The ability to automatically scale resources up or down based on demand

Elasticity refers to the ability of a cloud system to automatically provision and release resources to match workload demand, scaling out during peaks and in during lulls.

Question 42: True or False? Tools like Microsoft Security Compliance Manager and Microsoft Baseline Security Analyzer can assist with server hardening

True (Correct answer)
False

Correct answer: True

Server hardening involves configuring a server to enhance its security and reduce vulnerabilities. Tools like Microsoft Security Compliance Manager (now part of the Security Compliance Toolkit) and the deprecated Microsoft Baseline Security Analyzer (MBSA) were specifically designed to help administrators identify security misconfigurations, apply security baselines, and manage updates. These functions are integral to the process of hardening servers against potential threats.

Question 43: What Windows feature allows administrators to configure and enforce settings across multiple computers?

Remote Desktop
Task Scheduler
Windows Update
Group Policy (Correct answer)

Correct answer: Group Policy

Group Policy allows administrators to define and enforce configuration settings for users and computers across an Active Directory domain.

Question 44: Which HTML5 element is used to draw graphics and animations using JavaScript?

<graphic>
<figure>
<canvas> (Correct answer)
<svg>

Correct answer: <canvas>

The <canvas> element provides a bitmap drawing surface that JavaScript can use to render 2D graphics, animations, games, and data visualizations.

Question 45: Which file system is most suitable for USB drives shared between Windows and macOS?

ReFS
exFAT (Correct answer)
NTFS
FAT32

Correct answer: exFAT

exFAT is designed for flash drives and supports large files (over 4GB) while remaining compatible with both Windows and macOS without additional drivers.

Microsoft Technology Associate (MTA)

The MTA is an entry-level Microsoft certification suite validating foundational technology knowledge across IT infrastructure, software development, and database tracks. Individual MTA exams cover networking, security, cloud, HTML5 development, and software testing fundamentals.

Questions

45 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds