I85PREP
⌘ K
Blue Prism Installation Engineer study materials
Blue Prism Installation Engineer study resources

Blue Prism Installation Engineer practice questions

One question at a time. Build your Blue Prism Installation Engineer understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Infrastructure Planning and Prerequisites

A Blue Prism environment plan calls for separating the interactive development work from unattended production runs. Which component is designed to execute processes and objects without a logged-in interactive user session?

  1. Interactive client
  2. Application server
  3. Process studio
  4. Runtime resource Correct answer.

Explanation

A runtime resource is the Blue Prism component that runs published processes unattended, typically under a service account on a dedicated machine. Developers use interactive clients instead, and the application server coordinates the environment rather than executing business processes itself.

Question 2Infrastructure Planning and Prerequisites

Which database engine is the supported backend for a Blue Prism production environment?

  1. PostgreSQL
  2. Microsoft SQL Server Correct answer.
  3. Oracle Database
  4. SQLite

Explanation

Blue Prism stores its configuration, credentials, queues and audit data in a Microsoft SQL Server database. The application server connects clients and runtime resources to that database, so sizing and availability of SQL Server directly determine environment reliability.

Question 3Infrastructure Planning and Prerequisites

Before installing a Blue Prism client on an engineer's workstation, which prerequisite must be satisfied for the client to authenticate users against the environment?

  1. The workstation must have a static public IP address.
  2. The workstation must be joined to the same Active Directory domain as the application server. Correct answer.
  3. The workstation must host a local copy of the Blue Prism database.
  4. The workstation must run the same Windows build as the runtime resources.

Explanation

Blue Prism uses Active Directory (or another configured directory) for user authentication, so client machines must be able to resolve and authenticate against the same directory as the application server. Local databases and public addressing are not part of the authentication model.

Question 4Infrastructure Planning and Prerequisites

An engineer is preparing a server that will host the Blue Prism application server role. Which capability must be available on that server for the role to function?

  1. A dedicated GPU for screen rendering
  2. A licensed installation of Microsoft Office
  3. The .NET Framework runtime required by the Blue Prism version Correct answer.
  4. Internet Information Services with FTP enabled

Explanation

Blue Prism components are .NET applications, so the matching .NET runtime must be present on the application server before installation. Office automation belongs on runtime resources that drive business applications, and web or graphics services are unrelated to the server role.

Question 5Infrastructure Planning and Prerequisites

What is the primary purpose of the connection configuration held by the Blue Prism client?

  1. It sets the screen resolution used during unattended runs.
  2. It stores the process diagrams locally for offline editing.
  3. It defines the credentials used by automated business applications.
  4. It tells the client how to reach the application server and database. Correct answer.

Explanation

The connection configuration supplies the client with the server address and database details it needs to attach to the environment. Without a valid connection the client cannot retrieve processes, users or work queues, regardless of local settings.

Question 6Infrastructure Planning and Prerequisites

Which account type should be used to run the Blue Prism service on a runtime resource so that the robot can log in and interact with the desktop?

  1. A dedicated domain user account with interactive logon rights Correct answer.
  2. The built-in LocalSystem account
  3. The personal account of the process developer
  4. A shared administrator account used by the whole team

Explanation

Runtime resources run under a dedicated domain account that has the rights to log on interactively and access the applications being automated. Using named service accounts keeps auditing clear and lets permissions be scoped to exactly what the robot needs.

Question 7Infrastructure Planning and Prerequisites

When planning capacity for the SQL Server database that backs Blue Prism, which growth driver should be estimated first?

  1. The volume of work queue items and session logs retained Correct answer.
  2. The number of published process diagrams
  3. The number of installed browser extensions
  4. The count of users assigned the developer role

Explanation

Queue items, session logs and audit records account for the bulk of database growth in a busy environment, so retention policy and daily throughput drive sizing. Process definitions and user records are comparatively small and stable.

Question 8Infrastructure Planning and Prerequisites

Which statement best describes the network requirement between Blue Prism clients and the application server?

  1. Clients must have unrestricted outbound internet access.
  2. Clients need reliable TCP connectivity to the server's configured port and name resolution for the server host. Correct answer.
  3. Clients must be on the same physical subnet as the server.
  4. Clients must reach the server only through a VPN tunnel.

Explanation

Clients require routable TCP connectivity to the application server on its configured port, plus working name resolution so the server can be located. Physical subnet placement, internet access and mandatory VPNs are not requirements of the product itself.

Question 9Infrastructure Planning and Prerequisites

An organisation wants two application servers so that a hardware failure does not stop the environment. Which arrangement supports this goal?

  1. Install both servers on the same physical host as virtual machines.
  2. Run both servers against the same Blue Prism database and place them behind a load balancer. Correct answer.
  3. Configure one server as a client and the other as a runtime resource.
  4. Install two separate databases and let each server use its own.

Explanation

High availability for the application server tier relies on multiple servers sharing a single Blue Prism database, with clients directed through a load balancer or equivalent name. Splitting the database would create two disconnected environments.

Question 10Infrastructure Planning and Prerequisites

A runtime resource must automate a desktop application that requires a visible, unlocked session. Which configuration satisfies this requirement?

  1. Schedule the robot to run only while a developer is logged on.
  2. Keep the resource machine logged on with the automation account and the session unlocked. Correct answer.
  3. Enable Remote Desktop sessions that are disconnected after login.
  4. Run the resource as a Windows service with no user session.

Explanation

UI automation of desktop applications depends on an active, unlocked interactive session for the automation account. Disconnected or locked sessions typically prevent the robot from interacting with the desktop correctly.

Question 11Infrastructure Planning and Prerequisites

During installation planning, an engineer must decide where Blue Prism credentials will be stored. Which statement is correct?

  1. Credentials are stored in plain text in the client configuration file.
  2. Credentials are held only in the memory of the process developer's machine.
  3. Credentials are stored in the Windows registry of each runtime resource.
  4. Credentials are encrypted in the Blue Prism database and decrypted only for authorised use. Correct answer.

Explanation

Blue Prism stores credential values encrypted within its database and controls access through role permissions. This centralised, permissioned model is why credential management is part of the database and security design rather than a local file concern.

Question 12Infrastructure Planning and Prerequisites

Which consideration determines whether a runtime resource needs a full desktop operating system rather than a server core installation?

  1. Whether the process uses work queues
  2. Whether the database is hosted on a separate machine
  3. Whether the automated applications require a graphical user interface Correct answer.
  4. Whether the environment uses a load-balanced application server

Explanation

Runtime resources that automate applications through the user interface need a full desktop experience with a graphical shell. Processes that only call APIs or services can run on leaner installations, so the nature of the automation drives the OS choice.

Question 13Infrastructure Planning and Prerequisites

An engineer is preparing a runtime resource that will automate a thick-client business application. Which practice supports reliable unattended operation?

  1. Disable automatic Windows updates permanently on the resource.
  2. Set the machine's display scaling and resolution to a fixed, documented configuration. Correct answer.
  3. Allow the screen saver to activate after five minutes of inactivity.
  4. Enable fast user switching so other users can log on concurrently.

Explanation

UI automation depends on element positions and rendering, so a fixed, documented resolution and scaling profile reduces breakage between runs. Screen savers, concurrent sessions and disabled patching all introduce instability or security risk.

Question 14Infrastructure Planning and Prerequisites

A team plans to install the Blue Prism client on laptops used by developers who sometimes work offline. Which expectation is accurate?

  1. The client only needs connectivity when a licence key is renewed.
  2. The client requires connectivity to the application server to retrieve and save process content. Correct answer.
  3. The client can fully operate and publish processes while disconnected from the server.
  4. The client caches the entire database locally for offline use.

Explanation

The Blue Prism client is not an offline tool; process content lives in the central database and is retrieved and saved through the application server. Developers therefore need stable connectivity whenever they edit or publish work.

Question 15Infrastructure Planning and Prerequisites

Which firewall rule set is essential for a runtime resource to operate in a standard Blue Prism architecture?

  1. Inbound SMTP access for alert notifications
  2. Outbound access to the application server port and to the SQL Server if the resource connects directly Correct answer.
  3. Outbound access to public file-sharing services
  4. Inbound access from the internet on port 443

Explanation

A runtime resource must reach the application server on its configured port, and in configurations where it connects to the database directly it also needs SQL Server connectivity. Internet inbound access and unrelated service ports are not part of the required path.

Question 16Infrastructure Planning and Prerequisites

An environment uses a single application server and a single database server. Which additional measure most directly protects against loss of the configuration and audit history?

  1. Installing the client on the database server
  2. Increasing the RAM of the application server
  3. Configuring regular backups of the Blue Prism database Correct answer.
  4. Adding a second runtime resource

Explanation

Configuration, credentials, queues and audit records all live in the Blue Prism database, so a tested backup and restore regime is the direct protection against data loss. Additional resources or memory do not safeguard the data itself.

Question 17Infrastructure Planning and Prerequisites

Which factor most strongly influences the number of runtime resources required for a planned workload?

  1. The number of process diagrams in the environment
  2. The expected transaction volume and the average handling time per transaction Correct answer.
  3. The number of users holding the administrator role
  4. The size of the SQL Server data files

Explanation

Resource counts follow from throughput: transactions per period divided by the number of transactions one resource can complete in that period. Diagram count, administrator headcount and database file size do not translate into execution demand.

Question 18Infrastructure Planning and Prerequisites

An engineer must ensure that a runtime resource can be patched and rebooted without losing scheduled work. Which design choice supports this?

  1. Run all processes on a single resource to simplify scheduling.
  2. Configure the resource to hibernate between transactions.
  3. Deploy multiple resources and use work queues so pending items are processed by whichever resource is available. Correct answer.
  4. Disable the scheduler and start processes manually each morning.

Explanation

Work queues decouple work items from any single machine, so if one resource is offline its items are picked up by others. A single-resource design makes every maintenance window an outage.

Question 19Infrastructure Planning and Prerequisites

Which statement about licensing is most relevant when planning an environment with several runtime resources?

  1. Licences are assigned per process diagram published.
  2. Licences are allocated to runtime resources and interactive clients, so the count must match the planned deployment. Correct answer.
  3. Licences are tied only to the SQL Server edition.
  4. Licences are consumed automatically without any configuration step.

Explanation

Blue Prism licensing covers the runtime resources and interactive clients in the environment, so the deployment plan must match the licence entitlement. Under-provisioning blocks resources from starting, which is why licence counts belong in the infrastructure plan.

Question 20Infrastructure Planning and Prerequisites

A security review asks how to limit which engineers can change process logic in production. Which mechanism addresses this?

  1. The SQL Server recovery model
  2. Role-based permissions assigned to user accounts in Blue Prism Correct answer.
  3. Windows firewall rules on developer laptops
  4. The screen resolution configured on runtime resources

Explanation

Blue Prism enforces access through roles that grant or withhold capabilities such as editing and releasing processes. Assigning users to appropriate roles is the control that separates developers from release authority.

Question 21Infrastructure Planning and Prerequisites

An environment plan specifies that runtime resources must not connect directly to the SQL Server. What must the architecture provide?

  1. Resources must use a shared memory connection to the database.
  2. The SQL Server must be moved onto the same host as the resources.
  3. Each resource must host a local database replica.
  4. All resource traffic must pass through the application server, which brokers database access. Correct answer.

Explanation

When direct database access is prohibited, resources communicate only with the application server, which handles database connectivity on their behalf. This simplifies firewall rules and centralises control of data access.

Question 22Infrastructure Planning and Prerequisites

A design uses two application servers behind a load balancer. Which additional dependency must be made highly available to avoid reintroducing a single point of failure?

  1. The process documentation repository
  2. The Blue Prism database instance Correct answer.
  3. The browser installed on runtime resources
  4. The developer workstations

Explanation

Redundant application servers still depend on one shared database, so the database tier must itself be resilient, for example through failover clustering or availability groups. Otherwise a database outage stops the whole environment despite the server redundancy.

Question 23Infrastructure Planning and Prerequisites

An engineer must choose between installing the client on individual workstations and publishing it through a central delivery mechanism. Which factor most favours central delivery in a large estate?

  1. It removes the need for Active Directory authentication.
  2. It ensures consistent client versions and simplifies patching across many machines. Correct answer.
  3. It eliminates the requirement for connectivity to the application server.
  4. It allows clients to share a single Windows user profile.

Explanation

Central delivery keeps every workstation on a controlled, matching client version and makes upgrades repeatable at scale. It does not change authentication, connectivity or user profile requirements, which remain per-machine concerns.

Question 24Infrastructure Planning and Prerequisites

During sizing, an engineer notes that a process performs many small queue updates per transaction. Which infrastructure component is most likely to become the bottleneck first?

  1. The client's display adapter
  2. The load balancer in front of the application servers
  3. The runtime resource's CPU
  4. The SQL Server database handling the queue transactions Correct answer.

Explanation

Queue operations translate into database writes, so a high rate of small updates stresses SQL Server I/O and locking before it stresses the resource's processor. Sizing and indexing of the database therefore dominate this workload profile.

Question 25Infrastructure Planning and Prerequisites

A runtime resource must run processes that use a business application requiring a specific regional date format and language pack. Where should this be configured?

  1. In the client connection configuration
  2. In the Blue Prism process diagram at design time
  3. In the SQL Server collation of the Blue Prism database
  4. On the runtime resource's Windows regional and language settings Correct answer.

Explanation

Regional format and language behaviour is a property of the Windows session in which the automated application runs, so it must be set consistently on each runtime resource. Process design and database collation do not control how the target application renders dates.

Question 26Infrastructure Planning and Prerequisites

Which component must be installed on a runtime resource before it can connect to the Blue Prism application server?

  1. The Blue Prism process studio only
  2. The Blue Prism hub service
  3. The Blue Prism client software Correct answer.
  4. The Blue Prism database engine

Explanation

Every runtime resource requires the Blue Prism client software to communicate with the application server and execute processes. The client provides the necessary runtime components and connection configuration. Without it, the resource cannot register or receive work.

Question 27Infrastructure Planning and Prerequisites

When planning the database server for Blue Prism, which edition of SQL Server is required to support the application?

  1. SQL Server Compact
  2. SQL Server Standard or Enterprise Correct answer.
  3. SQL Server Developer only
  4. SQL Server Express

Explanation

Blue Prism requires a full edition of SQL Server such as Standard or Enterprise to support its database workload and features. Express editions have size and performance limitations that are unsuitable for production Blue Prism environments. Developer edition is licensed for non-production use only.

Question 28Infrastructure Planning and Prerequisites

Which Windows feature must be enabled on a runtime resource to allow Blue Prism to interact with applications?

  1. Windows Firewall
  2. Internet Information Services
  3. Windows User Account Control
  4. Remote Desktop Services Correct answer.

Explanation

Blue Prism runtime resources require an interactive user session to automate applications. Remote Desktop Services enables the creation and management of such sessions. Without an active session, the robot cannot interact with the desktop.

Question 29Infrastructure Planning and Prerequisites

What is the primary purpose of the Blue Prism application server in an infrastructure plan?

  1. To execute automated processes on the desktop
  2. To broker communication between clients and the database Correct answer.
  3. To provide a development environment for process authors
  4. To store process definitions and audit logs

Explanation

The application server acts as a middle tier that handles connections from Blue Prism clients and coordinates access to the database. It does not store the database itself nor execute processes. This separation improves security and scalability.

Question 30Infrastructure Planning and Prerequisites

An engineer is planning the service account for the Blue Prism application server service. Which requirement is most important?

  1. The account must be a domain administrator.
  2. The account must have a password that never expires.
  3. The account must have log on as a service right. Correct answer.
  4. The account must be a local system account.

Explanation

The service account under which the Blue Prism server service runs must be granted the 'Log on as a service' right. This allows the service to start and run in the background. Domain administrator rights are excessive and not required.

Question 31Infrastructure Planning and Prerequisites

When sizing the SQL Server for Blue Prism, which factor most directly affects the required transaction log growth?

  1. The volume of queue item updates and audit logging Correct answer.
  2. The size of the Blue Prism client installation
  3. The number of runtime resources
  4. The number of process studio sessions

Explanation

The transaction log grows with the number of write operations, which include queue item updates and audit log entries. High volumes of these operations will cause the log to grow significantly. Process studio sessions and client size do not directly impact log growth.

Question 32Infrastructure Planning and Prerequisites

Which network port must be open between Blue Prism clients and the application server by default?

  1. 8199 Correct answer.
  2. 3389
  3. 8080
  4. 1433

Explanation

Blue Prism clients communicate with the application server over TCP port 8199 by default. This port is used for the .NET Remoting communication. Port 1433 is for SQL Server, and 3389 is for RDP.

Question 33Infrastructure Planning and Prerequisites

An organisation plans to use a load-balanced pair of Blue Prism application servers. What must be configured to ensure clients can connect reliably?

  1. SSL offloading on the load balancer
  2. A wildcard DNS record
  3. A shared database instance
  4. Session affinity on the load balancer Correct answer.

Explanation

Blue Prism clients maintain a session with a specific application server. Session affinity, also known as sticky sessions, ensures that all requests from a client during a session are directed to the same server. Without it, clients may lose connection state.

Question 34Infrastructure Planning and Prerequisites

Which statement best describes the recommended placement of the Blue Prism database in a multi-server environment?

  1. On the same server as the application server to reduce latency
  2. On a file share accessible to all components
  3. On each runtime resource to distribute load
  4. On a dedicated SQL Server instance with high availability Correct answer.

Explanation

Best practice is to host the Blue Prism database on a dedicated SQL Server instance that is configured for high availability, such as failover clustering or Always On. This isolates database workload and ensures resilience. Placing it on the application server or runtime resources is not supported or recommended.

Question 35Infrastructure Planning and Prerequisites

When planning for Blue Prism user authentication, which method allows integration with Active Directory?

  1. LDAP authentication
  2. Multi-factor authentication
  3. Blue Prism native authentication
  4. Single sign-on with Windows authentication Correct answer.

Explanation

Blue Prism supports single sign-on using Windows authentication, which leverages Active Directory for user authentication. This allows users to log in with their domain credentials. Native authentication uses Blue Prism-specific credentials, and LDAP is not natively supported.

Question 36Infrastructure Planning and Prerequisites

An engineer must ensure that runtime resources can be patched without interrupting scheduled processes. Which design consideration is most appropriate?

  1. Disable Windows updates on all runtime resources
  2. Use a pool of resources with rolling maintenance Correct answer.
  3. Configure automatic Windows updates during business hours
  4. Install all patches manually on each resource

Explanation

A pool of runtime resources allows for rolling maintenance where resources are taken offline one at a time for patching while others continue to process work. This maintains availability. Automatic updates during business hours or disabling updates entirely are risky.

Question 37Infrastructure Planning and Prerequisites

Which component is responsible for storing Blue Prism process logs and audit information?

  1. The application server
  2. The SQL Server database Correct answer.
  3. The Blue Prism client
  4. The runtime resource

Explanation

All Blue Prism process logs, audit logs, and session information are stored in the SQL Server database. The application server coordinates access, but the data resides in the database. Runtime resources and clients do not persist this data locally.

Question 38Infrastructure Planning and Prerequisites

A Blue Prism environment requires high availability for the application server tier. Which configuration is most appropriate?

  1. A single application server with a powerful CPU
  2. Two application servers in a load-balanced cluster Correct answer.
  3. Two application servers with independent databases
  4. A single application server with a backup image

Explanation

High availability for the application server tier is achieved by deploying multiple application servers behind a load balancer. This allows continued operation if one server fails. A single server, even with backup, introduces downtime during failover.

Question 39Infrastructure Planning and Prerequisites

When planning the installation of Blue Prism interactive clients for developers, which practice is recommended?

  1. Install the client on the same server as the database
  2. Run the client from a USB drive
  3. Use a central shared installation directory
  4. Install the client locally on each developer workstation Correct answer.

Explanation

Blue Prism interactive clients should be installed locally on each developer workstation to ensure performance and proper registration. Central shared installations or running from removable media can cause configuration and performance issues. Installing on the database server is not supported.

Question 40Infrastructure Planning and Prerequisites

An engineer is designing the backup strategy for a Blue Prism environment. Which component's backup is most critical for disaster recovery?

  1. The runtime resource images
  2. The application server configuration files
  3. The SQL Server database Correct answer.
  4. The client installation packages

Explanation

The SQL Server database contains all Blue Prism configuration, process definitions, and transactional data. Regular backups of the database are essential for disaster recovery. Application server configuration and client packages can be reinstalled or recreated.

Question 41Database Setup and Configuration

Before creating a Blue Prism database, which server component must already be installed and running on the target machine?

  1. Blue Prism Interactive Client
  2. Blue Prism Hub
  3. Microsoft SQL Server Database Engine Correct answer.
  4. Blue Prism Resource PC

Explanation

Blue Prism stores its configuration and process data in a Microsoft SQL Server relational database, so the SQL Server Database Engine instance must exist and be reachable before any Blue Prism schema can be created. The client, Resource PC, and Hub are Blue Prism components that consume the database rather than host it.

Question 42Database Setup and Configuration

Which authentication mode allows a Blue Prism application server to connect using a Windows domain account rather than a SQL login?

  1. Contained database authentication
  2. Mixed mode with SQL logins only
  3. SQL Server authentication
  4. Windows authentication Correct answer.

Explanation

Windows authentication uses the Windows security token of the connecting account and is validated by Active Directory, so no separate SQL username and password are stored. SQL Server authentication relies on logins defined inside the instance instead.

Question 43Database Setup and Configuration

During a Blue Prism database creation, what is the purpose of the connection string supplied to the configuration tool?

  1. It specifies the polling interval for process schedules.
  2. It tells the client which SQL Server instance and database to contact. Correct answer.
  3. It lists the licensed Blue Prism users permitted to log in.
  4. It defines the encryption key for credentials stored in the database.

Explanation

A connection string carries the server or instance name, the database name, and the authentication details needed to open a session. Blue Prism uses it to locate and authenticate against the correct SQL Server database.

Question 44Database Setup and Configuration

Which built-in SQL Server role should be granted to a Blue Prism service account so it can read and write data but cannot alter server-wide security settings?

  1. db_owner on the Blue Prism database Correct answer.
  2. sysadmin
  3. serveradmin
  4. securityadmin

Explanation

Granting db_owner within the Blue Prism database gives the account the object and data permissions the application needs while keeping it scoped to that database. Server-level roles such as sysadmin grant far broader control than Blue Prism requires.

Question 45Database Setup and Configuration

A Blue Prism environment must run multiple Resource PCs writing to the same process data. Which database configuration supports this requirement?

  1. A single shared Blue Prism database on a SQL Server instance reachable by all components Correct answer.
  2. An in-memory cache on the application server with no persistent store
  3. A database attached to each Interactive Client workstation
  4. A separate local database on each Resource PC

Explanation

Blue Prism is designed around one central database that every client and Resource PC connects to, which keeps work queues and session data consistent. Local or per-workstation databases would fragment state and prevent coordinated processing.

Question 46Database Setup and Configuration

Which SQL Server service should be running for scheduled SQL Agent jobs that perform Blue Prism database maintenance to execute?

  1. SQL Server Agent Correct answer.
  2. SQL Server Browser
  3. SQL Server Integration Services
  4. SQL Server Full-Text Search

Explanation

SQL Server Agent is the component that runs scheduled jobs, including index maintenance and backup routines. Without the Agent service running, those scheduled jobs will not start.

Question 47Database Setup and Configuration

What does a Blue Prism database backup primarily protect?

  1. The configuration, credentials metadata, and process data held in the database Correct answer.
  2. The compiled code of running automations on each Resource PC
  3. The local log files written by the Interactive Client
  4. The Windows registry settings of the application server

Explanation

Because Blue Prism keeps processes, objects, queues, schedules, and user configuration in SQL Server, a database backup is the authoritative recovery artifact. Local client files and registry entries are not captured by a database backup.

Question 48Database Setup and Configuration

Which collation property of a Blue Prism database affects how text comparisons and sorting behave for stored process data?

  1. The filegrowth increment
  2. The compatibility level
  3. The database collation Correct answer.
  4. The recovery model

Explanation

Collation determines the code page, case sensitivity, and sort rules applied to character data, so it directly influences comparisons and ordering. Recovery model, compatibility level, and file growth control logging, engine behavior, and storage sizing instead.

Question 49Database Setup and Configuration

An engineer needs to create a new Blue Prism database on an existing SQL Server instance. Which approach is supported?

  1. Attach a SQLite file through the Blue Prism client
  2. Restore a MySQL dump using the SQL Server Agent
  3. Copy an .mdb file into the SQL Server data directory
  4. Run the Blue Prism database creation script against the target instance Correct answer.

Explanation

Blue Prism ships SQL scripts that create the schema, tables, and baseline data on a supported SQL Server instance. File formats from other database engines are not compatible with SQL Server.

Question 50Database Setup and Configuration

After restoring a Blue Prism database to a new server, users receive login failures even though their Windows accounts are unchanged. What is the most likely cause?

  1. The SQL logins are orphaned from their database users after the restore Correct answer.
  2. The tempdb file size was reset
  3. The SQL Server Agent service is set to manual start
  4. The database compatibility level was lowered during restore

Explanation

Restoring a database to a different instance recreates database users but does not automatically relink them to server-level logins, producing orphaned users. The standard remedy is to remap each user to its login with sp_change_users_login or ALTER USER.