Desencriptar!

MYSQL: Recuperar base de datos mediante los archivos FRM, IDB, MAD, MAI

2024-05-29T12:37:00.010-05:00

Fuentes:

https://medium.com/@dennis.garcia/recuperar-datos-desde-archivos-frm-ibd-de-mysql-server-ae88d5b9c0fc (El más útil)

https://www.youtube.com/watch?v=SqQaR-1Noso

https://www.youtube.com/watch?v=NngseaqS7jk&ab_channel=Mat%C3%ADasTato

https://www.youtube.com/watch?v=qeEAKVF33Y0&ab_channel=CodeForYou

https://downloads.mysql.com/archives/utilities/

https://stackoverflow.com/questions/26868956/restore-table-structure-from-frm-and-ibd-files/48207488#48207488

https://github.com/abg/dbsake/

Versiones:

MySQL 10.4.21 (Maria DB)
Ubuntu

Consideraciones:

Los pasos de la sección A aplican para tablas con engine InnoDB que tienen archivo FRM y IDB.
Los pasos de la sección B aplican para tablas con engine Aria que tienen archivos FRM, MAD y MAI
Comando para listar las tablas de una base de datos: SHOW TABLES;
Las tablas en las que se encuentran:

Procedimientos almacenados:

SELECT * FROM mysql.proc WHERE type='PROCEDURE'

Funciones:

SELECT * FROM mysql.proc WHERE type='FUNCTION'
SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_TYPE = 'FUNCTION';

Eventos:

SELECT * FROM information_schema .event

Vistas:

SELECT * FROM information_schema .views

Disparadores:

SELECT * FROM information_schema .triggers

Pasos que me funcionaron:

Para el servicio de la base de datos.
Hacer un respaldo de los archivos de la base de datos, por lo general se encuentran en: C:\xampp\mysql\data
Instalar Linux, en mi caso Ubuntu.
En el Linux, instalar dbsake (https://github.com/abg/dbsake/)

$ curl -s http://get.dbsake.net > dbsake
$ chmod u+x dbsake // dar permisos de ejecución.

Subir los archivos frm de la base de datos al Linux.
Ejecutar dbsake para obtener las consultas que nos permitirán crear la estructura de nuestras tablas.

$ ./dbsake frmdump --type-codes /backup/*.frm > mysqlSchemas.sql

Verificar que el archivo mysqlSchemas.sql tenga las consultas de CREATE ATBLE.
Iniciar el servicio de mysql y crear una nueva base de datos donde restauraremos la información. Asegurar que la base de datos tenga el mimo CHARSET y COLLATION que la base de datos original.
En la nueva BBDD ejecutar el script mysqlSchemas.sql

Sección A: Para tablas engine InnoDB

En la nueva BBDD ejecutar la consulta que nos permitirá quitar el IDB para luego reemplazarlo por el IDB que queremos recuperar.

ALTER TABLE `nombre_tabla` DISCARD TABLESPACE;

Deben eliminar/deshabilitar todos los KEY y UNIQUE de la tabla (en seccion D y E encontrarás ayuda), para que no les muestre el siguiente mensaje de error: #1815 - Internal error: Drop all secondary indexes before importing table onlinelogistics/users when .cfg file is missing.

ALTER TABLE ....

Ahora copiar el IDB a recuperar en la carpeta de la nueva BBDD creada

cp /bakcup/nombre_tabla.idb /servidor/mysql/data/nombre_basedatos/nombre_tabla.idb

Dar los permisos al archivo IDB

chown mysql:mysql /servidor/mysql/data/nombre_basedatos/nombre_tabla.idb

Ejecutar la siguiente consulta para volver asociar la la tabla al IDB.

ALTER TABLE `nombre_tabla` IMPORT TABLESPACE;

Verificar:

SELECT * FROM nombre_tabla LIMIT 10;

Sección B: Para tablas engine Aria

Se usa por lo general para restaurar las tablas donde se encuentran los procedimientos almacenados, funciones, eventos, disparadores de la base de datos MYSQL.
Pausar el servicio de MYSQL.
Borrar los archivos con extensión MAD y MAI de la tabla a recuperar de la ubicación donde esta instalado MYSQL
Copiar los archivos MAD y MAI de la tabla desde la carpeta backup a la ubicación donde esta instalado MYSQL.

cp /bakcup/nombre_tabla.mad /servidor/mysql/data/nombre_basedatos/nombre_tabla.mad
cp /bakcup/nombre_tabla.mai /servidor/mysql/data/nombre_basedatos/nombre_tabla.mai

Iniciar el servicio de MYSQL.
Verificar:

SELECT * FROM nombre_tabla LIMIT 10;

Sección C: Consulta para recuperar los Procedimientos Almacenados

Consulta para generar los scripts de creación de los procedimientos almacenados desde la tabla proc de la base de datos mysql.

SELECT db, TYPE,

CONCAT('DELIMITER $$', '\n',

'CREATE PROCEDURE ', `name`, '(', `param_list` , ') ', '\n',

`body`, '$$\n',

'DELIMITER ;', '\n') AS script

FROM

`proc`

WHERE db='nombre_basedatos'

AND TYPE='PROCEDURE'

-- and type='FUNCTION'

Sección D: Consulta para generar los script de creación de índices de las tablas

SELECT DISTINCT CONCAT('ALTER TABLE `', TABLE_NAME, '` ADD ',

CASE WHEN non_unique = 1 THEN 'INDEX' ELSE 'UNIQUE INDEX' END,

' `', index_name, '` (`', GROUP_CONCAT(COLUMN_NAME ORDER BY seq_in_index), '`);') AS script

FROM information_schema.statistics

WHERE table_schema = 'nombre_basedatos'

AND index_name <> 'PRIMARY'

GROUP BY TABLE_NAME, index_name, non_unique;

Sección E: Consulta para generar los script de eliminación de índices de las tablas

SELECT CONCAT('ALTER TABLE `', TABLE_NAME, '` DROP INDEX `', index_name, '`;') AS script

FROM information_schema.statistics

WHERE table_schema = 'nombre_basedatos'

AND index_name <> 'PRIMARY'

ORDER BY TABLE_NAME, index_name;

Oracle Cloud: Agregar clave SSH pública para acceso remoto

2023-10-22T10:54:00.005-05:00

Fuentes:

https://medium.com/@carolina.ingenieriateleco/configurar-usuarios-en-oci-vm-ab11a258f3ea

https://docs.oracle.com/es/learn/generate_ssh_keys/index.html#connecting-to-an-instance-using-putty

https://docs.oracle.com/es-ww/iaas/Content/Compute/Tasks/managingkeypairs.htm

https://blogs.oracle.com/lad-cloud-experts-es/post/como-crear-un-par-de-llaves-ssh-para-conectarse-a-una-instancia-en-oracle-cloud-infrastructure

Si no tienes una clave SSH, puedes seguir la siguiente guía para generar una: https://docs.oracle.com/es/learn/generate_ssh_keys/index.html#connecting-to-an-instance-using-putty .

Para un usuario ya creado

Una vez tengas tu llave privada y tu llave pública, podrás configurar tu instancia de la siguiente manera:

Ingresa a tu instancia:

# sudo -i

# cd /home/usuario/.ssh

En el archivo authorized_keys agregar tu llave publica previamente creada. Puedes agregar cuantas llaves públicas desees siempre respetando una llave por línea

# vi authorized_keys

Valida que te puedas a autenticar con tu nueva llave SSH a tu instancia.

Para un usuario nuevo

Ingresa a tu instancia:

# sudo su -

# useradd -m -d /home/username -s /bin/bash username

# mkdir -p /home/username/.ssh

# touch /home/username/.ssh/authorized_keys

# chown -R username:username /home/username/

# chmod 700 /home/username/.ssh

# chmod 600 /home/username/.ssh/authorized_keys

Valida que te puedas a autenticar con tu nuevo usuario y tu nueva llave SSH a tu instancia.

Bitnami: Configurar Let's Encrypt SSL en Apache 2.4

2023-09-22T21:08:00.012-05:00

Fuente: https://docs.bitnami.com/general/how-to/understand-bncert/

Fuente: https://docs.bitnami.com/aws/how-to/understand-bncert/

Fuente: https://www.youtube.com/watch?v=BF4OlDwPZds

Generar un certificado SSL

Ingresar a la carpeta de instalación de bitnami

# cd /opt/bitnami/

Ejecutar el comando bncert-tool

# ./bncert-tool

Seguir las instrucciones.

----------------------------------------------------------------------------

Welcome to the Bitnami HTTPS Configuration tool.

----------------------------------------------------------------------------

Domains

Please provide a valid space-separated list of domains for which you wish to

configure your web server.

Domain list []: subdominio.dominio.com

The following domains were not included: www.subdominio.dominio.com. Do you want to add them? [Y/n]: n

Warning: No www domains (e.g. www.example.com) or non-www domains (e.g.

www.example.com) have been provided, so the following redirections will be

disabled: non-www to www, www to non-www.

Press [Enter] to continue:

----------------------------------------------------------------------------

Enable/disable redirections

Please select the redirections you wish to enable or disable on your Bitnami

installation.

Enable HTTP to HTTPS redirection [Y/n]: Y
----------------------------------------------------------------------------
Changes to perform
The following changes will be performed to your Bitnami installation:
1. Stop web server
2. Configure web server to use a free Let's Encrypt certificate for the domains: subdominio.dominio.com
3. Configure a cron job to automatically renew the certificate each month
4. Configure web server name to:
subdominio.dominio.com
5. Enable HTTP to HTTPS redirection (example: redirect http://subdominio.dominio.com
to https://subdominio.dominio.com)
6. Start web server once all changes have been performed

Do you agree to these changes? [Y/n]: Y
----------------------------------------------------------------------------
Create a free HTTPS certificate with Let's Encrypt
Please provide a valid e-mail address for which to associate your Let's Encrypt
certificate.
Domain list: subdominio.dominio.com
Server name: subdominio.dominio.com
E-mail address []: email@correo.com
The Let's Encrypt Subscriber Agreement can be found at:
https://letsencrypt.org/documents/LE-SA-v1.3-September-21-2022.pdf
Do you agree to the Let's Encrypt Subscriber Agreement? [Y/n]: Y
----------------------------------------------------------------------------
Performing changes to your installation
The Bitnami HTTPS Configuration Tool will perform any necessary actions to your
Bitnami installation. This may take some time, please be patient.
----------------------------------------------------------------------------
Success
The Bitnami HTTPS Configuration Tool succeeded in modifying your installation.
The configuration report is shown below.
Backup files:
* /opt/bitnami/apache2/conf/httpd.conf.back.202106121242
*
/opt/bitnami/apache2/conf/bitnami/bitnami-apps-prefix.conf.back.2021061
21242
* /opt/bitnami/apache2/conf/bitnami/bitnami.conf.back.202106121242
Find more details in the log file:
/tmp/bncert-202406121242.log
If you find any issues, please check Bitnami Support forums at:
https://github.com/bitnami/vms
Press [Enter] to continue:

Luego de configurar, para las renovaciones, notará que en el crontab se a programado la ejecución de un script, por ejemplo:

# crontab -l

0 0 * * * /opt/wordpress/letsencrypt/lego --path /opt/wordpress/letsencrypt --email="correo@correo.com" --http --http-timeout 30 --http.webroot /opt/wordpress/apps/letsencrypt --domains=nombre.dominio.com renew && /opt/wordpress/apache2/bin/httpd -f /opt/wordpress/apache2/conf/httpd.conf -k graceful # bncert-autorenew

Revocar un certificado SSL

No se aconseja revocar un certificado, sino crear un nuevo certificado. Si revoca tendrá que modificar manualmente algunos archivos de configuración para que el servidor apache inicie de nuevo.

Comando para listar certificados instalados:

# /opt/bitnami/letsencrypt/lego --path /opt/bitnami/letsencrypt list

Comando para revocar un certificado:

# /opt/bitnami/letsencrypt/lego --path /opt/bitnami/letsencrypt --email="jonycaleb@gmail.com" --http --http-timeout 30 --http.webroot /opt/bitnami/apps/letsencrypt --domains=subdominio.dominio.com revoke

Para el servicio de Apache:

#/opt/bitnami/ctlscript.sh stop apache

Iniciar el servicio de Apache (no iniciará, deberás resolverlo interpretando los mensajes de error):

#/opt/bitnami/ctlscript.sh start apache

Puedes revisar el log de error:

# cat /opt/bitnami/apache2/logs/error_log

Si es muy grande el archivo de error, puedes truncar los datos e intentar iniciar el servicio de apache para que muestre el error.

# dd if=/dev/null of=/opt/bitnami/apache2/logs/error_log

Recargar archivos PHP en el navegador usando Visual Studio Code

2023-01-05T20:02:00.003-05:00

Fuente: https://stackoverflow.com/questions/60678203/is-it-possible-to-use-live-server-for-php-with-autoreload-on-save

For having auto reload in PHP files in Visual Studio Code:

Install Live Server extension.
Install PHP Server extension.
Config PHP Server: (PHP Config Path), (PHP Path).
Install Google Chrome Live Server extensions.
Open your PHP file in Visual Studio Code and 'Click to run Lie Server'.
Copy the opened page address and past it in "Live Server Address" in live server chrome extension and click Apply.
Switch again to Visual Studio Code and right click on your PHP file and click on "PHP Server: Reload server", it will open your PHP file in browser and just copy IP and port (for example: http://localhost:3000) and paste it on "Actual Server Address" in live server of Google Chrome extension and click apply.
Turn On live Reload in live server of chrome extension. Now whenever you run your PHP file with "PHP Server: Reload server", it will reload automatically on each saving.

Note: For having good experience of automatically reload active Autosave and set 400ms for its delay.

Crear módulos en JavaScript

2022-11-24T10:22:00.002-05:00

Fuente: https://www.wextensible.com/temas/javascript-closure/encapsulamiento.html#:~:text=El%20encapsulamiento%20usa%20las%20t%C3%A9cnicas,m%C3%A9todos)%20definidos%20en%20ese%20objeto.

Patrón módulo

<div class="ejemplo-linea">
    <div><input type="button" class="codigo"
        value="alert(modulo.variablePublica)"
        onclick="alert(modulo.variablePublica)" />
    </div>
    <div><input type="button" class="codigo"
        value="modulo.metodoPublico(Date())"
        onclick="modulo.metodoPublico(Date())" />
    </div>
</div>
<script>
    var modulo = (function(){
        //Variables y métodos privados
        var variablePrivada = "Esto es privado";
        var metodoPrivado = function(argumentoPrivado){
            alert(variablePrivada + " Fecha: " + argumentoPrivado);
        };
        //Devuelve un objeto con lo público
        return {
            variablePublica: "Esto es público",
            metodoPublico: function(argumentoPublico){
                variablePrivada += " (ahora es público a través del método público)";
                metodoPrivado(argumentoPublico);
            }
        };
    })();
</script>

Patrón singleton

<div class="ejemplo-linea">
    <div>La función pública no estará disponible hasta que instanciemos el singleton:</div>
        <input type="button" class="codigo"
        value="ejecutarFuncionPublica(unSingleton)"
        onclick="ejecutarFuncionPublica(unSingleton)" />
    <div>Si ahora instanciamos el singleton podemos pulsar el botón anterior y accedemos
    a la función pública</div>
        <input type="button" class="codigo"
        value="unSingleton = singleton.obtenerInstancia()"
        onclick="unSingleton = singleton.obtenerInstancia()" />
    <div>Cualquier otra instanciación conduce al mismo singleton</div>
        <input type="button" class="codigo"
        value="otroSingleton = singleton.obtenerInstancia()"
        onclick="otroSingleton = singleton.obtenerInstancia()" />
    <div>El cuerpo del módulo de todos los singletones es el mismo. La función pública
    accede a las mismas variables. Observe que la fecha-hora es la misma, momento
    en que se inició el primer singleton.</div>
        <input type="button" class="codigo"
        value="ejecutarFuncionPublica(otroSingleton)"
        onclick="ejecutarFuncionPublica(otroSingleton)" />
    <div>Podemos cerciorarnos de que es el mismo singleton</div>
        <input type="button" class="codigo"
        value="sonIguales(unSingleton, otroSingleton)"
        onclick="sonIguales(unSingleton, otroSingleton)" />
</div>
<script>
    var singleton = (function(){
        //Una instancia que haremos única
        var instancia;
        //iniciar el singleton: Esto devolverá el cuerpo del módulo,
        //lo privado en el closure y lo público en un objeto devuelto
        function iniciar(){
            var varPrivada = "Esto es privado. Fecha: " + Date();
            var funPrivada = function(){
                //hace algo
            };
            return {
                varPublica: "Esto es público",
                funPublica: function(){
                    alert(this.varPublica + " y " + varPrivada);
                }
            };
        }
        //En la autoejecución devolvemos una función que inicia
        //el singleton en todas las declaraciones
        return {
            obtenerInstancia: function(){
                if (!instancia){
                    instancia = iniciar();
                    alert("Singleton instanciado");
                } else {
                    alert("Este singleton ya fue instanciado");
                }
                return instancia;
            }
        };
    })();
    //Declaramos dos variables del singleton
    var unSingleton;
    var otroSingleton;
    //Funciones auxiliares para probar el ejemplo
    function ejecutarFuncionPublica(esteSingleton){
        //Si el singleton no ha sido instanciado no llamamos a la
        //función pública para evitar un error
        if (!esteSingleton){
            alert("El singleton no ha sido instanciado");
        } else {
            esteSingleton.funPublica();
        }
    }
    function sonIguales(uno, otro){
        //Sólo comparamos si hemos instanciado los dos singletones
        if (uno && otro){
            return alert(uno === otro);
        } else {
            alert("Instancie los dos singletones y luego compruebe esto");
        }
    }
</script>

Patrón lanzador o inicializador

<div class="ejemplo-linea">
    <div id="lanza-aqui"></div>
    <input type="button" class="codigo"
        value="unLanzador.verVariablePrivada()"
        onclick="unLanzador.verVariablePrivada()" />
    <input type="button" class="codigo"
        value="ejecutaOtroLanzador()"
        onclick="ejecutaOtroLanzador()" />
</div>
<script>
    var lanzador = (function(){
        //variables privadas
        var iniciado = false;
        var variablePrivada = "Esto es privado";
        var funcionPrivada = function(){
            alert(Date());
        };
        //En la auto-ejecución devuelve esta función lanzadora o iniciadora
        //del módulo, construyendo el HTML si no ha sido iniciado.
        return function(id, argumento){
            if (iniciado){
                alert("Lanzador ya fue iniciado. Sólo puede ejecutarse una vez.");
            } else {
                //Construye el HTML
                var donde = document.getElementById(id);
                var elemento = document.createElement("div");
                elemento.innerHTML = argumento;
                elemento.style.border = "blue solid 1px";
                elemento.onclick = funcionPrivada;
                donde.appendChild(elemento);
                iniciado = true;
                //Devuelve un objeto público
                return {
                    verVariablePrivada: function(){
                        alert(variablePrivada);
                    }
                };
            }
        };

    })();
    //
    var unLanzador = lanzador("lanza-aqui", "Contenedor generado por el lanzador. " +
                              "Haz click aquí para ver la fecha");
    var otroLanzador;
    function ejecutaOtroLanzador(){
        otroLanzador = lanzador("lanza-aqui", "Haz click aquí TAMBIÉN");
    }
</script>

Exportar tabla HTML a Excel con JavaScript (Opción 02)

2022-09-07T17:00:00.006-05:00

Fuente: https://codepen.io/Bilal1909/pen/zYoKYez?editors=1010

Fuente: https://github.com/rainabba/jquery-table2excel

1. Incluir los javascript a el HTML

2. Código de javascript para exportar tabla HTML a Excel


var table2excel = new Table2Excel();
table2excel.export(document.querySelector("#hidden_bloco_1"));

Exportar tabla HTML a Excel con JavaScript (Opción 01)

2022-09-07T16:48:00.006-05:00

Fuente: https://parzibyte.me/blog/2019/12/04/exportar-tabla-html-excel-javascript/

Fuente: https://github.com/clarketm/TableExport/

Fuente: https://tableexport.travismclarke.com/

Fuente: https://github.com/SheetJS

1. Agregar en el HTML los JS

2. Código de ejemplo con ajustes avanzados


var fechayhora = function(d){
    var month = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'];
    var date = ""+d.getFullYear()+(d.getMonth()+1).toString().padStart(2,'0')+d.getDate().toString().padStart(2,'0');
    var time = d.toLocaleTimeString().toLowerCase().replaceAll(":","");
    return (date + "_" + time); 
}


/* Tabla 01: */
var hidden_bloco_0 = document.querySelector("#hidden_bloco_0");

let tableExport_0_77a45 = new TableExport(hidden_bloco_0, {
    exportButtons: false, // No queremos botones
	headers: false,
	ignoreCols: [],
	ignoreRows: [],
	RTL: false,
	bootstrap: false,
    filename: "Ejemplo_tabla_01_"+fechayhora(new Date()), //Nombre del archivo de Excel
    sheetname: "Datos", //Título de la hoja
});
let datos_tabla_0_77a45 = tableExport_0_77a45.getExportData();

console.log(datos_tabla_0_77a45);
myArray_tabla_0_77a45 = datos_tabla_0_77a45.hidden_bloco_0.xlsx.data;
console.log(myArray_tabla_0_77a45.length);


// Filtramos los valores de la cabecera
var cabecera_0_77a45 = myArray_tabla_0_77a45.filter(function(value, index, arr){ 
        return index == 0;
});

let y_0_77a45=[0,3];
for (let x_tabla_0_77a45 in cabecera_0_77a45) {
  console.log(cabecera_0_77a45[x_tabla_0_77a45]);
  cabecera_0_77a45[parseInt(x_tabla_0_77a45)] = cabecera_0_77a45[parseInt(x_tabla_0_77a45)].filter((el,i)=>y_0_77a45.some(j => i === j));
}

// Filtramos los valores de los datos 
var filtered_0_77a45 = myArray_tabla_0_77a45.filter(function(value, index, arr){ 
        return (value.length == 5 && index == 3);
});

let x_0_77a45=[0,1];
for (let x_tabla_0_77a45 in filtered_0_77a45) {
  console.log(filtered_0_77a45[x_tabla_0_77a45]);
  filtered_0_77a45[parseInt(x_tabla_0_77a45)] = filtered_0_77a45[parseInt(x_tabla_0_77a45)].filter((el,i)=>x_0_77a45.some(j => i === j));
}

// Limpiamos datos atípicos
for (let x_tabla_0_77a45 in filtered_0_77a45) {
  console.log(filtered_0_77a45[x_tabla_0_77a45]);
  filtered_0_77a45[parseInt(x_tabla_0_77a45)][1].v = filtered_0_77a45[parseInt(x_tabla_0_77a45)][1].v.replaceAll("\n Registre Porcentaje","").replaceAll("Datos inválidos","");
  filtered_0_77a45[parseInt(x_tabla_0_77a45)][1].t = 'n';
}

// Concatenamos los datos a la cabecera*/
var newdata_0_77a45 = cabecera_0_77a45.concat(filtered_0_77a45);

/* Reemplazamos los valores del excel por la nueva data */
datos_tabla_0_77a45.hidden_bloco_0.xlsx.data= newdata_0_77a45;


// para pruebas de desarrollo
/*
console.log('Preparando para descargar Excel');
let preferenciasDocumento = datos_tabla_0_77a45.hidden_bloco_0.xlsx;
tableExport_0_77a45.export2file(preferenciasDocumento.data, preferenciasDocumento.mimeType, preferenciasDocumento.filename, preferenciasDocumento.fileExtension, preferenciasDocumento.merges, preferenciasDocumento.RTL, preferenciasDocumento.sheetname);
console.log('Archivo excel generado');
*/







/* Tabla 02:  */
var hidden_bloco_1 = document.querySelector("#hidden_bloco_1");

let tableExport_1_77a45 = new TableExport(hidden_bloco_1, {
    exportButtons: false, // No queremos botones
	headers: false,
	ignoreCols: [],
	ignoreRows: [],
	RTL: false,
	bootstrap: false,
    filename: "Ejemplo_tabla_02_"+fechayhora(new Date()), //Nombre del archivo de Excel
    sheetname: "Datos", //Título de la hoja
});
let datos_tabla_1_77a45 = tableExport_1_77a45.getExportData();

console.log(datos_tabla_1_77a45);
myArray_tabla_1_77a45 = datos_tabla_1_77a45.hidden_bloco_1.xlsx.data;
console.log(myArray_tabla_1_77a45.length);

// Filtramos los valores de la cabecera
var cabecera_1_77a45 = myArray_tabla_1_77a45.filter(function(value, index, arr){ 
        return index == 0;
});

let y_1_77a45=[0,3];
for (let x_tabla_1_77a45 in cabecera_1_77a45) {
  console.log(cabecera_1_77a45[x_tabla_1_77a45]);
  cabecera_1_77a45[parseInt(x_tabla_1_77a45)] = cabecera_1_77a45[parseInt(x_tabla_1_77a45)].filter((el,i)=>y_1_77a45.some(j => i === j));
}

// Filtramos los valores de los datos 
var filtered_1_77a45 = myArray_tabla_1_77a45.filter(function(value, index, arr){ 
        return (value.length == 5 && index >= 1);
});

let x_1_77a45=[0,1];
for (let x_tabla_1_77a45 in filtered_1_77a45) {
  console.log(filtered_1_77a45[x_tabla_1_77a45]);
  filtered_1_77a45[parseInt(x_tabla_1_77a45)] = filtered_1_77a45[parseInt(x_tabla_1_77a45)].filter((el,i)=>x_1_77a45.some(j => i === j));
}

// Limpiamos datos atípicos
for (let x_tabla_1_77a45 in filtered_1_77a45) {
  //console.log(filtered_1_77a45[x_tabla_1_77a45]);
  filtered_1_77a45[parseInt(x_tabla_1_77a45)][1].v = filtered_1_77a45[parseInt(x_tabla_1_77a45)][1].v.replaceAll(",","");
  filtered_1_77a45[parseInt(x_tabla_1_77a45)][1].t = 'n';
}

// Concatenamos los datos a la cabecera*/
var newdata_1_77a45 = cabecera_1_77a45.concat(filtered_1_77a45);

/* Reemplazamos los valores del excel por la nueva data */
datos_tabla_1_77a45.hidden_bloco_1.xlsx.data= newdata_1_77a45;


// para pruebas de desarrollo
/*
console.log('Preparando para descargar Excel');
let preferenciasDocumento = datos_tabla_1_77a45.hidden_bloco_1.xlsx;
tableExport_1_77a45.export2file(preferenciasDocumento.data, preferenciasDocumento.mimeType, preferenciasDocumento.filename, preferenciasDocumento.fileExtension, preferenciasDocumento.merges, preferenciasDocumento.RTL, preferenciasDocumento.sheetname);
console.log('Archivo excel generado');
*/









/* Tabla 03:  */
var hidden_bloco_2 = document.querySelector("#hidden_bloco_2");

let tableExport_2_77a45 = new TableExport(hidden_bloco_2, {
    exportButtons: false, // No queremos botones
	headers: false,
	ignoreCols: [],
	ignoreRows: [],
	RTL: false,
	bootstrap: false,
    filename: "Ejemplo_tabla_03_"+fechayhora(new Date()), //Nombre del archivo de Excel
    sheetname: "Datos", //Título de la hoja
});
let datos_tabla_2_77a45 = tableExport_2_77a45.getExportData();

console.log(datos_tabla_2_77a45);
myArray_tabla_2_77a45 = datos_tabla_2_77a45.hidden_bloco_2.xlsx.data;
console.log(myArray_tabla_2_77a45.length);

// Filtramos los valores de la cabecera
var cabecera_2_77a45 = myArray_tabla_2_77a45.filter(function(value, index, arr){ 
        return index == 0;
});

let y_2_77a45=[0,3];
for (let x_tabla_2_77a45 in cabecera_2_77a45) {
  console.log(cabecera_2_77a45[x_tabla_2_77a45]);
  cabecera_2_77a45[parseInt(x_tabla_2_77a45)] = cabecera_2_77a45[parseInt(x_tabla_2_77a45)].filter((el,i)=>y_2_77a45.some(j => i === j));
}

// Filtramos los valores de los datos 
var filtered_2_77a45 = myArray_tabla_2_77a45.filter(function(value, index, arr){ 
        return (value.length == 5 && index >= 1);
});

let x_2_77a45=[0,1];
for (let x_tabla_2_77a45 in filtered_2_77a45) {
  console.log(filtered_2_77a45[x_tabla_2_77a45]);
  filtered_2_77a45[parseInt(x_tabla_2_77a45)] = filtered_2_77a45[parseInt(x_tabla_2_77a45)].filter((el,i)=>x_2_77a45.some(j => i === j));
}

// Limpiamos datos atípicos
for (let x_tabla_2_77a45 in filtered_2_77a45) {
  //console.log(filtered_2_77a45[x_tabla_2_77a45]);
  //filtered_2_77a45[parseInt(x_tabla_2_77a45)][1].v = filtered_2_77a45[parseInt(x_tabla_2_77a45)][1].v.replaceAll("\n Registre Porcentaje","")
}

// Concatenamos los datos a la cabecera*/
var newdata_2_77a45 = cabecera_2_77a45.concat(filtered_2_77a45);

/* Reemplazamos los valores del excel por la nueva data */
datos_tabla_2_77a45.hidden_bloco_2.xlsx.data= newdata_2_77a45;


// para pruebas de desarrollo
/*
console.log('Preparando para descargar Excel');
let preferenciasDocumento = datos_tabla_2_77a45.hidden_bloco_2.xlsx;
tableExport_2_77a45.export2file(preferenciasDocumento.data, preferenciasDocumento.mimeType, preferenciasDocumento.filename, preferenciasDocumento.fileExtension, preferenciasDocumento.merges, preferenciasDocumento.RTL, preferenciasDocumento.sheetname);
console.log('Archivo excel generado');
*/





/* CREAMOS UN ARRAY DE VALORES EN BLANCO */
var espacio_blanco = [[{v:'',t:''},{v:'',t:''}]];

/* CONCATENAMOS LA DATA DE LAS 3 TABLAS*/
var finaldata_77a45 = newdata_0_77a45.concat(espacio_blanco).concat(newdata_1_77a45).concat(espacio_blanco).concat(newdata_2_77a45).concat(espacio_blanco);

/* REEMPLAZAMOS LOS DATOS DE LA PRIMERA TABLA */
datos_tabla_0_77a45.hidden_bloco_0.xlsx.data= finaldata_77a45
datos_tabla_0_77a45.hidden_bloco_0.xlsx.merges= null;

/* DESCARGAMOS EL EXCEL */
console.log('Preparando para descargar Excel');
let preferenciasDocumento_77a45 = datos_tabla_0_77a45.hidden_bloco_0.xlsx;
tableExport_0_77a45.export2file(preferenciasDocumento_77a45.data, preferenciasDocumento_77a45.mimeType, preferenciasDocumento_77a45.filename, preferenciasDocumento_77a45.fileExtension, preferenciasDocumento_77a45.merges, preferenciasDocumento_77a45.RTL, preferenciasDocumento_77a45.sheetname);
console.log('Archivo excel generado');

Instalar escritorio remoto XRDP en Ubuntu 20.0 minimal

2022-07-14T15:45:00.010-05:00

// Crear instancia en Oracle Free Tier AMD / INTEL 1 OCPU, 1 GB RAM, 50 GB HD

// Crear instancia en Oracle Free Tier AMPERE 2 OCPU, 6 GB RAM, 50 GB HD, pero con Ubuntu 20.0 (no el minimal)

// Accedemos a la terminal por SSH

// Actualizamos el sistema

# sudo apt update && sudo apt upgrade

# sudo apt install nano

Fuente: https://www.solvetic.com/tutoriales/article/9412-cambiar-hora-y-zona-horaria-ubuntu-21-04-20-04-terminal/

// Cambiar la zona horario de ubuntu

# date

# timedatectl list-timezones

# sudo timedatectl set-timezone America/Lima

# timedatectl

// En caso no este activo el servicio NTP

# sudo timedatectl set-ntp on

Fuente: https://apuntesit.tk/redes/registrarse-en-google-cloud-platform-gcp-y-crear-un-vps-gratis/

// Ubuntu no asigna memoria swap en Oracle, por lo que asignaremos 1 GB

# top

// Creamos el swapfile

# sudo fallocate -l 1G /swapfile

// Formatear el swapfile

# sudo dd if=/dev/zero of=/swapfile bs=1024 count=1048576

// Otorgar permisos al swapfile.

# sudo chmod 600 /swapfile

// Activar el swapfile en el sistema.

# sudo mkswap /swapfile

// Encender el swap

# sudo swapon /swapfile

// Agregar el swapfile para que lo reconozca el sistema en el inicio. Para eso hay que editar el archivo /etc/fstab agregar las siguiente línea.

# sudo nano /etc/fstab

add line: /swapfile swap swap defaults 0 0

# cat /etc/fstab

// Montar la partición de swap.

# sudo mount -a

// Verificar que este activo el swap en el sistema

# top

// Si todo esta OK, reiniciar la instanacia.

# sudo reboot

# top

Fuente: https://apuntesit.tk/tutoriales/instala-y-accede-al-escritorio-remoto-de-tu-vps-linux-con-xrdp/

// Instalar Escritorio XFCE4

// Cuando pregunte, utilizar el administrador de ventanas Lightdm por ser mucho mas liviano que GDM3

# sudo apt install -y xfce4 desktop-base xfce4-terminal tango-icon-theme

// Intalar XRDP Escritorio Remoto para Linux. Durante la instalación te guiará para configurar el idioma del teclado

# sudo apt install xrdp

// Verificar la instalación

# sudo systemctl status xrdp

// Agregar el usuario xrdp y agregarlo al grupo ssl-cert para que las sesiones gráficas remotas puedan utilizar los certificados generados por el VPS

# sudo adduser xrdp ssl-cert

// Autorizar el puerto TCP 3389 en el firewall

// Listar las reglas actuales de la tabla INPUT con el comando mostrado.

# sudo iptables -L INPUT

// editar el archivo /etc/iptables/rules.v4 y agregar la regla que se muestra antes de cualquier otra regla que bloquee el acceso de paquetes a cualquier puerto.

# sudo nano /etc/iptables/rules.v4

-A INPUT -p tcp -m state --state NEW -m tcp --dport 3389 -j ACCEPT

// Vallidar

# cat /etc/iptables/rules.v4

// Cargar las nuevas reglas en el servicio IPTABLES

# sudo iptables-restore < /etc/iptables/rules.v4

// recuerde que debe abrir también el puerto 3389 TCP en el firewall de la red virtual del cloud

// Agregar usuarios que se puedan conectar a través del escritorio remoto. Se recomeinda no dar acceso al usuario ROOT

# sudo adduser remoto

// Configurar XFCE4 en el perfil del usuario

// Se debe crear el archivo .xsession en cada directorio home de usuario con el contenido xfce4-session. Se deben seguir estos comandos.

# sudo nano /home/remoto/.xsession

agregar linea:

xfce4-session

// Verificar

# ls /home/remoto/ -lHa

// Conceder permisos al usuario remoto

# sudo chown -R remoto:remoto /home/remoto/.xsession

# sudo chmod 664 /home/remoto/.xsession

// Verificar

# ls /home/remoto/ -lHa

// Configurar XFCE4 en XRDP. El último paso es configurar el servidor XRDP para que inicie el escritorio XFCE4 cuando un usuario inicie sesión en el Escritorio Remoto.

// Se debe editar el archivo /etc/xrdp/startwm.sh comentando la última línea y agregando startxfce4.

# sudo nano /etc/xrdp/startwm.sh

Comentar linea:

# exec /bin/sh /etc/X11/Xsession

Agregar linea:

startxfce4

// Luego de guardar los cambios en el archivo de configuración se debe reiniciar el servicio xrdp.

# sudo systemctl restart xrdp

// Instalar Chrome desde el terminal para CPU AMD (A partir de octubre 2025 instalar Brave)

# wget https://dl.google.com/linux/direct/google-chrome-stable_current_amd64.deb

# sudo dpkg -i google-chrome-stable_current_amd64.deb

// Instalar Chrome desde el terminal para CPU ARM (A partir de octubre 2025 instalar Brave . Ya no soporta Manifest v2, solo v3)

~~# sudo apt install chromium-browser~~

~~# sudo apt-mark hold chromium-browser~~

~~# apt-mark showhold~~

// Instalar Brave desde el terminal para CPU ARM (A partir de octubre 2025 instalar Brave. Soporta Manifest v2 y V3)

# sudo apt install curl

# curl -fsS https://dl.brave.com/install.sh | sh

# sudo apt-mark hold brave-browser

# apt-mark showhold

// Usar cualquier cliente remoto que soporte el protocolo RDP para conectarse a la instancia

Si deja de funcionar el Ctrl+C Ctrl+V

// Cerrar sessión del usuario remoto, grabando la session y volver a ingresar.

Applitacions > Log Out > Save sessions for future login > Log Out

Si deseas eliminar un usuario remoto

// Cerrar sesión del usurio remoto, si no es posible, ejeuctar el sigueinte paso

Applitacions > Log Out > Save sessions for future login > Log Out

// Stop all process by username

sudo killall -u username

// Remover un usuario con su directorio de home

sudo deluser --remove-home username

// Remover el directorio del usuario

rm /home/username -R

Restaurar o corregir sesión xfce

// Intentar con

// Fuente: https://fioriticarlos.wordpress.com/2012/05/31/restaurar-o-corregir-sesion-xfce/

rm /home/username/.cache/sessions -R

rm /home/username/.config/xfce4 -R

Si luego del login se desconecta del escritorio remoto

// Lista los procesos del usuario remoto

sudo ps -u nombre_usuario

sudo ps -ef | grep nombre_usuario

// Mata todos los procesos del usuario_remoto

sudo pkill -u usuario_remoto

// Reinicia el servicio del escritorio remoto

sudo systemctl restart xrdp

Configurar Let's Encrypt SSL en Apache 2.4 y Centos 8

2022-05-31T17:22:00.003-05:00

Fuente: https://letsencrypt.org/

Fuente: https://certbot.eff.org/instructions?ws=apache&os=centosrhel8

Fuente: https://snapcraft.io/docs/installing-snap-on-centos

Fuente: https://stackoverflow.com/questions/59549309/unable-to-find-a-virtual-host-listening-on-port-80-please-add-a-virtual-host

Fuente: https://httpd.apache.org/docs/2.4/vhosts/examples.html

SSH into the server
SSH into the server running your HTTP website as a user with sudo privileges.
Install snapd
You'll need to install snapd and make sure you follow any instructions to enable classic snap support.
Follow these instructions on snapcraft's site to install snapd.
install snapd
Ensure that your version of snapd is up to date
Execute the following instructions on the command line on the machine to ensure that you have the latest version of snapd.
```
sudo snap install core; sudo snap refresh core
```
Remove certbot-auto and any Certbot OS packages
If you have any Certbot packages installed using an OS package manager like apt, dnf, or yum, you should remove them before installing the Certbot snap to ensure that when you run the command certbot the snap is used rather than the installation from your OS package manager. The exact command to do this depends on your OS, but common examples are sudo apt-get remove certbot, sudo dnf remove certbot, or sudo yum remove certbot. If you previously used Certbot through the certbot-auto script, you should also remove its installation by following the instructions here.
Install Certbot
Run this command on the command line on the machine to install Certbot.
```
sudo snap install --classic certbot
```
Prepare the Certbot command
Execute the following instruction on the command line on the machine to ensure that the certbot command can be run.
```
sudo ln -s /snap/bin/certbot /usr/bin/certbot
```
Choose how you'd like to run Certbot
Either get and install your certificates...
Run this command to get a certificate and have Certbot edit your apache configuration automatically to serve it, turning on HTTPS access in a single step.
```
sudo certbot --apache
```
Or, just get a certificate
If you're feeling more conservative and would like to make the changes to your apache configuration by hand, run this command.
```
sudo certbot certonly --apache
```
Test automatic renewal
The Certbot packages on your system come with a cron job or systemd timer that will renew your certificates automatically before they expire. You will not need to run Certbot again, unless you change your configuration. You can test automatic renewal for your certificates by running this command:
```
sudo certbot renew --dry-run
```
The command to renew certbot is installed in one of the following locations:
- /etc/crontab/
- /etc/cron.*/*
- systemctl list-timers
Confirm that Certbot worked
To confirm that your site is set up properly, visit https://yourwebsite.com/ in your browser and look for the lock icon in the URL bar.

Para renovar un certificado SSL utilizando Certbot, puedes simplemente ejecutar el siguiente comando:

# sudo certbot renew

HELP.

"sudo": Es un comando de Unix/Linux que se utiliza para ejecutar otros comandos con privilegios de administrador.

"certbot": Es una herramienta de gestión de certificados SSL, comúnmente utilizada con el servidor web Apache o Nginx, que simplifica el proceso de adquisición, instalación y renovación de certificados SSL/TLS gratuitos de Let's Encrypt.

"renew": Es un subcomando de Certbot que se utiliza para renovar los certificados SSL existentes antes de que expiren.

"--dry-run": Es una opción que se puede agregar al comando renew para simular el proceso de renovación sin realizar ningún cambio real en los certificados ni en la configuración del servidor. Esto es útil para probar el proceso de renovación sin afectar el funcionamiento del sitio web en producción.

Cómo configurar depurador de código PHP en Visual Code

2022-02-10T11:05:00.005-05:00

Recursos:

https://xdebug.org/wizard

https://www.youtube.com/watch?v=RXBDt10COsI

https://code.visualstudio.com/download

https://code.visualstudio.com/docs/languages/php

https://marketplace.visualstudio.com/items?itemName=xdebug.php-debug

Configuración:

1. Instalar PHP Debug en Visual Code

https://marketplace.visualstudio.com/items?itemName=xdebug.php-debug

2. Instalar XAMPP

https://www.apachefriends.org/es/download.html

3. Seguir las instrucciones de xdebug para descargar el driver.

https://xdebug.org/wizard

Para PHP 7.4.25: https://xdebug.org/files/php_xdebug-3.1.6-7.4-vc15-x86_64.dll

4. Descargar el driver y colocar en la carpeta C:\xampp\php\ext con el nombre "php_xdebug.dll". Si hay un archivo con el mismo nombre, borrar o renombrar.

5. Configurar el archivo php.ini para Xdebug v3.x.x:

[xdebug]

xdebug.mode = debug

xdebug.start_with_request = yes

zend_extension = xdebug

6. Reiniciar el servicio de Apache.

7. Instalar la extensión "PHP Debug" en Visual Estudio Code

8. Configurar la ruta de PHP que usará VSC.

File > Preferences > Settings : <ícono superior derecho> Open Settings (JSON)

Agregar un alinea con:

"php.validate.executablePath": "C:\\xampp\\php\\php.exe"

9. Clic en "Run and Debug". En la barra lateral izquierda de la pestaña de "Debug", busca y haz clic en el enlace "create a launch.json file".

Si tienes una sola versión de PHP instalada en tu PC, configurar la única versión de PHP en las variables de entorno del sistema, específicamente en la variable PATH y listo.

Si tienes más de una versión de PHP instalada en la PC, edita el archivo launch.json y agrega la siguiente línea en cada uno de los entornos.

"runtimeExecutable": "C:\\xampp\\php\\php.exe"

Ejemplo:

{

"name": "Listen for XDebug",

"type": "php",

"request": "launch",

"port": 9000,

"runtimeExecutable": "C:\\xampp\\php\\php.exe"

}

10. Guarda el archivo "launch.json".

7. Valida el funcionamiento

XAMPP 7.4.25 Configuración de VHOST en ambiente de desarrollo

2022-02-10T10:41:00.002-05:00

Recursos:

http://localhost/dashboard/docs/configure-vhosts.html https://stackoverflow.com/questions/3660066/hosting-multiple-local-sites-with-xampp

Configuración:

1. Agregar las siguientes líneas en el archivo C:\xampp\apache\conf\extra\httpd-vhosts.conf

#ServerAdmin webmaster@dummy-host2.example.com

DocumentRoot "C:/xampp/htdocs"

ServerName localhost

ErrorLog "logs/localhost"

CustomLog "logs/localhost.log" common

</VirtualHost>

#ServerAdmin webmaster@dummy-host2.example.com

DocumentRoot "C:/07_Workspace_php"

ServerName workphp

Options FollowSymLinks

AllowOverride None

</Directory>

Options Indexes FollowSymLinks

# this prevent.htaccess reading, remove if you want .htaccess

AllowOverride None

# allow web access

AllowOverride none

Require all granted

</Directory>

ErrorLog "logs/workphp"

CustomLog "logs/workphp.log" common

</VirtualHost>

2. Agregar la siguiente línea en el archivo C:\Windows\System32\drivers\etc\hosts

127.0.0.1 workphp

3. Reiniciar el servicio de Apache.

Oracle Cloud: Acceso remoto MariaDB en CentOS 7 Linux Bitnami

2021-10-28T14:06:00.006-05:00

# cd /opt/wordpress-5.7.2-0/
mariadb/bin
# ./mysql -u root -p

# CREATE USER 'xxx'@'%' IDENTIFIED BY 'clave';

# GRANT ALL PRIVILEGES ON *.* TO 'xxx'@'%';
# FLUSH PRIVILEGES;

# exit;

# firewall-cmd --permanent --zone=public --add-port=3306/tcp
# firewall-cmd --reload

// Additionally, you may change the my.cnf file to intruct MySQL (version 8) not to limit to local connections:
// Commnet line #bind_address=127.0.0.1

# cd /opt/wordpress-5.7.2-0/mariadb/

# vi my.cnf

// Reiniciar el servicio

# cd /opt/wordpress-5.7.2-0
# ./ctlscript.sh restart mariadb

// Configurar el firewall de Oracle Cloud para permitir el puerto 3306

Oracle Cloud: Instalar WordPress 4.5 en CentOS 7 Linux con Docker

2021-06-23T21:38:00.006-05:00

Fuentes:

Versiones del contenedor de Docker tutum/wordpress:

WordPress 4.5-beta3-36955
PHP 5.5.9-1ubuntu4.14
Apache/2.4.7 (Ubuntu)
MySQL 5.5.47-0ubuntu0.14.04.1

Paso 1: Verificar recursos

# sudo -i
# cat /etc/centos-release
# top
# free -m
# df
# yum update

Paso 2: Habilitar puertos en el firewall

# firewall-cmd --permanent --zone=public --add-port=80/tcp
# firewall-cmd --permanent --zone=public --add-port=443/tcp
# firewall-cmd --reload

Paso 3: Instalar contenedor

# sudo systemctl enable docker.service # Enable the service
# sudo systemctl start docker # Start the Docker daemon.
# sudo docker images # Show local images
# sudo docker run -d -p 80:80 tutum/wordpress # Run container
# sudo docker ps # Show container run
# sudo docker stop <id container> # Stop container
# sudo docker ps -a # Show container list
# sudo docker export <id container> > wp.tar # Export container
# cat wp.tar | sudo docker import - tutum/wordpress wp.tar # Import container

Desinstalar:

# docker ps

# docker stop <id container>

# docker container rm <id container>

# docker images

# docker image rm <id image>

Oracle Cloud: Instalar WordPress 5.7 en CentOS 7 Linux

2021-06-23T21:02:00.003-05:00

Fuentes:

Versiones usadas:

CentOS Linux release 7.9.2009 (Core)
WordPress 5.7.2
PHP 7.4.19
MySQL 10.4.19-MariaDB
Apache/2.4.47 (Unix)

Paso 1: Verificar recursos

# sudo -i

# cat /etc/centos-release

# top

# free -m

# df

# yum update

Paso 2: Habilitar puertos en el firewall

# firewall-cmd --permanent --zone=public --add-port=80/tcp

# firewall-cmd --permanent --zone=public --add-port=443/tcp

# firewall-cmd --reload

Paso 3: Instalar dependencias

# yum install perl perl-Data-Dumper

Paso 4: Instalar Bitnami-Wordpress

# wget https://bitnami.com/redirect/to/1492359/bitnami-wordpress-5.7.2-0-linux-x64-installer.run

# chmod 755 bitnami-wordpress-5.7.2-0-linux-x64-installer.run

# ./bitnami-wordpress-5.7.2-0-linux-x64-installer.run

. Check access page: http://<ip>/

Paso 5: Remover la página de inicio y banner de Bitnami

# /opt/wordpress-5.7.2/apps/wordpress/bnconfig --appurl /

# /opt/wordpress-5.7.2/apps/wordpress/bnconfig --disable_banner 1

Paso 6: Configurando SSL

# /opt/wordpress-5.7.2/bncert-tool

Desinstalar:

# /opt/wordpress-5.7.2/

# ./uninstall

Oracle Cloud: Instalar WordPress 5.6 en RHEL 8 / CentOS 8 Linux

2021-06-04T12:33:00.002-05:00

Fuentes:

https://linuxconfig.org/install-wordpress-on-redhat-8

Paso 1: Verificar recursos

# sudo -i

# cat /etc/centos-release

# top

# free

# df

# sudo yum update

# sudo yum install ncurses-compat-libs

# sudo yum install perl perl-Data-Dumper

Paso 2: Instalar Apache

# yum install httpd -y

# service httpd start

# service httpd status

# firewall-cmd --permanent --zone=public --add-port=80/tcp

# firewall-cmd --permanent --zone=public --add-port=443/tcp

# firewall-cmd --reload

# systemctl enable httpd.service

* Check access to page: http://<ip/domain>/

* Si no accede deshabilitamos el firewall (Caso particular de Oracle Cloud)

# service firewalld stop

# systemctl disable firewalld

Paso 3: Instalar Base de Datos MariaDB

# yum install mariadb-server mariadb -y

# service mariadb status

# service mariadb start

# mysql_secure_installation

# systemctl enable mariadb.service

# mysql -u root -p

mysql> show databases;

mysql> CREATE DATABASE wordpress;

mysql> CREATE USER `admin`@`localhost` IDENTIFIED BY 'pass';

mysql> GRANT ALL ON wordpress.* TO `admin`@`localhost`;

mysql> FLUSH PRIVILEGES;

mysql> exit

Paso 4: Instalar PHP

# dnf install dnf-utils http://rpms.remirepo.net/enterprise/remi-release-8.rpm

# dnf module list php

# dnf module reset php

# dnf module enable php:remi-7.4

# dnf install php php-opcache php-gd php-curl php-mysqlnd

# dnf yum -y install php php-cli php-fpm php-mysqlnd php-zip php-devel php-gd php-mbstring php-curl php-xml php-pear php-bcmath php-json

# systemctl enable --now php-fpm

# systemctl restart httpd

# php -v

# cd /var/wwww/html/

# echo "<?php phpinfo(); ?>" > info.php

* Check access to page http://<ip/domain>/info.php

Paso 5: Instalar Wordpress

# cd /var/wwww/html/

# wget https://pe.wordpress.org/latest.zip

# ls -l

# upzip lastest.zip

# ls -l

# chown apache.apache /var/www/html/wordpress -R

# chcon -t httpd_sys_rw_content_t wordpress /var/www/html/wordpress -R

* Configure SELinux and Start Services

# sestatus

# setsebool -P httpd_can_network_connect 1

# ls -l

# cd wordpress

# ls -l

* Acceder por web: http://<ip/domain>/wordpress/

Paso 6: Disfruta el proceso :)

Balanceo de carga con GlassFish

2019-08-13T11:18:00.002-05:00

Fuente: https://javiergarciaescobedo.es/despliegue-de-aplicaciones-web/86-servidores-de-aplicaciones/318-balanceo-de-carga-con-glassfish

Instalar certificado en Glassfish

2019-03-09T16:15:00.002-05:00

Proveedor de Certificado: https://www.sslforfree.com/

En mi caso el proveedor de certificados me envío estos archivos:
1. ca_bundle.crt
2. certificate.crt
3. private.key

Prerequisitos:
1. Instalar openssl.
2. Instalar java. En el carpera bin, de la instalación, encontrarán el software keytool.

Software de ayuda:
1. KeyStore Explorer. https://keystore-explorer.org/

Paso 1: Create PKCS12 keystore from private key and public certificate.
#openssl pkcs12 -export -name micertificado -in "D:\certificate.crt" -inkey "D:\private.key" -out keystore.p12

Paso 2: Convert PKCS12 keystore into a JKS keystore
#keytool -importkeystore -destkeystore "D:\glassfish\domains\domain1\config\mijks.jks" -srckeystore "D:\keystore.p12" -srcstoretype pkcs12 -alias micertificado

Paso 3:
#keytool -list -v -keystore "D:\glassfish\domains\domain1\config\mijks.jks"

Paso 4:

#keytool -importkeystore -srckeystore "D:\glassfish\domains\domain1\config\mijks.jks" -destkeystore "D:\glassfish\domains\domain1\config\keystore.jks"

Use clave por defecto "changeit"

Paso 5: Reinicie domain1 de Glassfish (GF).

Paso 6: Verifique en el log del domain1 de GF, server.log, se muestre que se ha reconocido correctamente el certificado importado. Puedes buscar con el nombre del alias, para nuestro ejemplo: micertificado. Para este último debes activar el Debug de las conexiones SSL usando el siguiente parámetro en la JVM:
-Djavax.net.debug=all

Paso 7: Configurar GF

Acceder al panel de administración: http://localhost:4848/

Navegar a "server-config > http-listener-2 > SSL"

Certificate NickName: micertificado

Grabar y reiniciar GF.

Paso 8: Verificar el acceso

https://localhost:8181/

Fin!

Páginas de información adicional y de apoyo:
1. SSL certificate installation on a GlassFish application server
2. How to install an SSL certificate on GlassFish
3. Importing the private-key/public-certificate pair in the Java KeyStore
4. Debugging SSL/TLS Connections

SQL: Tamaño de tablas

2017-07-31T13:32:00.002-05:00

SET NOCOUNT ON
DBCC UPDATEUSAGE(0)
-- Table row counts and sizes.
DECLARE @sizes TABLE
(
[name] NVARCHAR(128),
[rows] CHAR(11),
reserved VARCHAR(18),
data VARCHAR(18),
index_size VARCHAR(18),
unused VARCHAR(18)
)
INSERT @sizes EXEC sp_msForEachTable 'EXEC sp_spaceused ''?'''
SELECT *
FROM @sizes
ORDER BY convert(int, substring(data, 1, len(data)-3)) desc

SQL Server: While cambio de cursores

2017-07-31T12:04:00.006-05:00

declare @idbase as bigint
declare @Max int, @Ini int

DECLARE @Tab1 TABLE(Id int IDENTITY(1,1) PRIMARY KEY NOT NULL, idbase bigint)

insert into @Tab1
select idbase from base with (nolock)

select @Max = count(*) from @Tab1
set @Ini = 1
WHILE @Ini < @Max + 1
BEGIN
select @idbase = idbase from @Tab1 where Id = @Ini
exec [PA_eliminarBase] @idbase;
Print cast(@idbase as nvarchar)
set @Ini = @Ini + 1
END

declare @idbase as bigint
declare @Max int, @Ini int
declare @fechadesde datetime;
declare @fechahasta datetime;
set @fechadesde = DATEADD(dd,-1,DATEADD(dd,DATEDIFF(dd,0,getdate()),0))
set @fechahasta = DATEADD(dd,-1,DATEADD(dd,DATEDIFF(dd,0,getdate()),0))

set @Max =20
set @Ini = 1
WHILE @Ini < @Max + 1
BEGIN

set @fechadesde = DATEADD(dd,-1*@Ini,DATEADD(dd,DATEDIFF(dd,0,getdate()),0))
set @fechahasta = DATEADD(dd,-1*@Ini,DATEADD(dd,DATEDIFF(dd,0,getdate()),0))

print @fechadesde;

exec dbo.PA_ingresarindicador @fechadesde, @fechahasta

Print cast(@Ini as nvarchar)
set @Ini = @Ini + 1
END

FUNCIONES DE FECHA ÚTILES EN SQL SERVER.

2017-07-18T17:23:00.004-05:00

1. Para obtener el día de hoy.

SELECT GETDATE() 'Hoy'

2. Para obtener el día de ayer.

SELECT DATEADD(d,-1,GETDATE()) 'Ayer'

3. Inicio del día actual.

SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0) 'Inicio de este día'

4. Fin del día actual

SELECT DATEADD(ms,-3,DATEADD(dd,DATEDIFF(dd,0,GETDATE()),1)) 'Fin de este día'

5. Inicio de ayer.

SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE()),-1) 'Inicio de ayer'

6. Fin de ayer.

SELECT DATEADD(ms,-3,DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0)) 'Fin de ayer'

7. Primer día de la semana actual.

SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0) 'Primer día de la semana actual'

8. Último día de la semana actual.

SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),6) 'Último día de la semana actual'

9. Primer día de la semana pasada.

SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0) 'Primer día de la semana pasada'

10. Último día de la semana pasada.

SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),6) 'Último día de la semana pasada'

11. Primer día del mes actual.

SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0) 'Primer día del mes actual'

12. Último día del mes actual.

SELECT DATEADD(ms,-3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE())+1,0))) 'Último día del mes actual'

13. Primer día del mes pasado.

SELECT DATEADD(mm,-1,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)) 'Primer día del mes pasado'

14. Último día del mes pasado.

SELECT DATEADD(ms,-3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0))) 'Último día del mes pasado'

15. Primer día de este año.

SELECT DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0) 'Primer día de este año'

16. Último día de este año.

SELECT DATEADD(ms,-3,DATEADD(yy,0,DATEADD(yy,DATEDIFF(yy,0,GETDATE())+1,0))) 'Último día de este año'

17. Primer día del año pasado.

SELECT DATEADD(yy,-1,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0)) 'Primer día del año pasado'

18. Último día del año pasado.

SELECT DATEADD(ms,-3,DATEADD(yy,0,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0))) 'Último día del año pasado'

19. Primer día del próximo mes.

SELECT DATEADD(mm,1,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)) 'Primer día del próximo mes'

20. Último día del próximo mes.

SELECT DATEADD(ms,-3,DATEADD(mm,DATEADD(mm,(DATEDIFF(mm,0,GETDATE()),0))) 'Último día del próximo mes'

Extraído de CodeProject

Fuente: https://bloginspanish.wordpress.com/2014/01/04/funciones-de-fecha-utiles-en-sql-server/

Encuestas en MOODLE

2017-05-30T11:18:00.002-05:00

Encuestas en MOODLE

Moodle questionnaire

https://moodle.org/plugins/pluginversions.php?plugin=mod_questionnaire

Preguntas de examen de certificación TOGAF

2017-01-24T06:10:00.005-05:00

Question: Which of the following is not a part of the TOGAF document (official TOGAF documentation)?

A. ADM Guidelines and Techniques
B. Architecture Content Framework
C. Architecture Governance
D. TOGAF Reference Models
E. Architecture Capability Framework
You answered
The correct answer is: C

Question: What is the definition of Architecture in the context of TOGAF?
A. The fundamental organization of a system, embodied in its components, their relationships to each other and the environment, and the principles governing its design and evolution
B. A rigorous description of the structure of an enterprise, which comprises enterprise components (business entities), the externally visible properties of those components, and the relationships (e.g. the behavior) between them
C. An architecture is the most important, pervasive, top-level, strategic inventions, decisions, and their associated rationales about the overall structure (i.e., essential elements and their relationships) and associated characteristics and behavior
D. Architecture is the use of abstractions and models to simplify and communicate complex structures and processes to improve understanding and forecasting
E. A formal description of a system, or a detailed plan of the system at a component level to guide its implementation or the structure of components, their inter-relationships, and the principles and guidelines governing their design and evolution over time
You answered
The correct answer is: E

Question: Which of the following is not a reason to use an Enterprise Architecture Framework in the context of TOGAF?
A. It will speed up and simplify architecture development
B. It will ensure more complete coverage of the designed solution
C. It will make certain that the architecture selected allows for future growth in response to the needs of the business
D. Its use may be mandated by federal agencies
E. It will ensure compliance and protect the interest of stakeholders
You answered
The correct answer is: E

Question: Which are the three main categories of architectural work product does Architecture Content Framework specify?
A. Architecture Vision, Architecture Requirements Specification and Architecture Roadmap
B. Source Architecture, Target Architecture and Gap Analysis
C. Architecture Vision, Architecture Design Document and Transition Architecture
D. Building Block, Artifact and Deliverable
E. Request for Architecture Work, Statement of Architecture Work and Architecture Contract
You answered
The correct answer is: D

Question: Which of the following is not a part of Architecture Repository?
A. The organizationally tailored application of an architecture framework, including a meta-model for architecture content
B. The parameters, structures, and processes that support governance of the Architecture Repository
C. An architectural view of the building blocks that are in use within the organization today
D. A Stakeholder analysis and map
E. A record of governance activity across the enterprise
You answered
The correct answer is: D

Question: Which of these are not the benefits of Architecture Governance?
A. Increased visibility supporting internal processes and external parties’ requirements
B. Greater shareholder value
C. Improved software development productivity
D. Protection of the existing asset base through maximizing re-use
E. Controlled risk management
You answered
The correct answer is: C

Question: Which of the following statement is correct in the context of ADM iteration?
A. Yes, you can only cycle around the ADM
B. Yes, you can cycle around all single individual phase
C. Yes, you can cycle around any combination of phases
D. Yes, you can cycle around ADM, iterate across specific phases or cycle through some of the phases
E. No, ADM is not iterative
You answered
The correct answer is: D

Question: Which of the following statements is correct in the context of ADM and Architecture Repository relationship?
A. At relevant places throughout the ADM, there are reminders to consider which architecture assets from the Architecture Repository the architect should use
B. The practical implementation of the Enterprise Continuum will typically take the form of an Architecture Repository that includes reference architectures, models, and patterns mandated in TOGAF
C. In executing the ADM, the architect is only developing a snapshot of the enterprise at particular points in time, and populating the organization’s own Architecture Repository is outside the scope of ADM
D. The first execution of the ADM is simplified because of the re-use potential of the standard architecture assets available for re-use in TOGAF Architecture Repository
E. Architecture Repository is only accessed in the Requirement Management phase
You answered
The correct answer is: A

Question: Which of these is not the reason for wanting to tailor the ADM to the circumstances of an individual enterprise?
A. An important consideration is that the order of the phases in the ADM is to some extent dependent on the maturity of the architecture discipline within the enterprise concerned
B. An enterprise may wish to use or tailor the ADM in conjunction with the security best practices in use in the enterprise
C. The ADM is one of many corporate processes that make up the corporate governance model for an enterprise
D. The ADM is being mandated for use by a prime or lead contractor in an outsourcing situation, and needs to be tailored to achieve a suitable compromise between the contractor’s existing practices and the contracting enterprise’s equirements
E. The enterprise is a small-to-medium enterprise, and wishes to use a “cut-down” version of the ADM
You answered
The correct answer is: B

Question: Which of the following statements is not correct about Enterprise Continuum?
A. It is a view of the Architecture Repository that provides methods for classifying architecture and solution artifacts, both internal and external to the Architecture Repository
B. It is an important aid to communication and understanding, both within individual enterprises, and between customer enterprises and vendor organizations
C. It also represents an aid to organizing re-usable architecture and solution assets
D. It is a physical repository of all architecture assets models, patterns, architecture descriptions, and other artifacts produced during application of the ADM
E. It represents an aid to communication
You answered
The correct answer is: D

Question: Which of the following statements is not correct in the context of TOGAF?
A. The Architecture Continuum provides a consistent way to describe and understand the implementation of the assets
B. A Foundation Architecture supports the complete enterprise operating environment
C. Common Systems Architectures guide the creation of an architecture useful for building common solutions across a wide number of relevant domains
D. Industry Architectures guide the integration of common systems components with industry specific components
E. Organization-Specific Architectures describe and guide the final deployment of user-written or third-party components that constitute effective solutions for particular enterprises
You answered
The correct answer is: A

Question: Which of the following item is not a part of Architecture Repository?
A. Architecture Landscape
B. Standards Information Base
C. Architecture Metamodel
D. Architecture Capability
E. Compliance Log
You answered
The correct answer is: E

Question: What is a Standards Information Base (SIB) in context of TOGAF?
A. It holds guidelines, templates, patterns
B. It holds a set of specifications, to which architectures must conform
C. It defines the parameters, structures, and processes that support governance
D. It describes the organizationally tailored application of an architecture framework
E. It holds view of the building blocks that are in use within the organization today
You answered
The correct answer is: B

Question: Which of the following statements is not correct in the context of TOGAF?
A. Enterprise Continuum is a virtual repository where as the Architecture Repository is a physical repository
B. Enterprise Continuum can be thought of as a view of the Architecture Repository
C. The Architecture Repository defines six classes for architectural information held in the repository
D. TOGAF recognizes the need to manage the content of the Enterprise Continuum using tools but does not provide any guidance on tool selection
E. The Solutions Continuum is a population of the architecture with reference building blocks – either purchased products or built components – that represent a solution to the enterprise’s business needs
You answered
The correct answer is: D

Question: Which Phase of the ADM define and initiate the Business Scenarios?
A. Preliminary phase
B. Phase A
C. Phase B
D. Phase C
E. Phase D
You answered
The correct answer is: B

Question: Which of the following statements is not correct in context of the Business Architecture?
A. A knowledge of the Business Architecture is a prerequisite for architecture work in any other domain
B. Business Architecture is often necessary as a means of demonstrating the business value of subsequent architecture work
C. Business Architecture looks at the Enterprise in abstraction and does not look at the relationship between people and process
D. Business Architecture should support the agreed Architecture Vision
E. Business Architecture should demonstrate how stakeholder concerns are addressed
You answered
The correct answer is: C

Question: Which of the following is not comes under the Technology Architecture documentation?
A. Fundamental organization of the IT system
B. The principles governing its design and evolution IT system
C. Hardware, software, and communications technology and their relationships to each other and the environment
D. Technical implementation architecture
E. Target Technology Architecture that will form the basis of the subsequent implementation and migration planning
You answered
The correct answer is: D

Question: Which of the following is Phase F?
A. Technology Architecture
B. Migration Planning
C. Implementation Governance
D. Architecture Change Management
E. Oppurtunities and Solutions
You answered
The correct answer is: B

Question: Which of the following is H?
A. Requirement Management
B. Migration Planning
C. Implementation Governance
D. Architecture Change Management
E. Oppurtunities and Solutions
You answered
The correct answer is: D

Question: Which Phase of the ADM relates to agreement reached on the architecture method to be adopted?
A. Preliminary Phase
B. Phase A
C. Phase B
D. Phase E
E. Requirement Management Phase
You answered
The correct answer is: A

Question: In context of ADM, how is the Transition Architecture formulated?
A. It emerges through phase B to D and is finalized in phase E
B. It is first formulated in phase E and gets refined in phase F and G
C. It is formulated in phase E and then split into implementation projects
D. Based on the implementation projects selected in phase E, Transition Architectures is arrived at in phase F
E. In Phase E major implementation projects grouped into Transition Architectures and they are confirmed with relevant stakeholders in phase F
You answered
The correct answer is: E

Question: What phase of the ADM does the cost/benefit analysis?
A. Preliminary Phase
B. Phase A
C. Phase B
D. Phase E
E. Phase F
You answered
The correct answer is: E

Question: In which ADM phases, does Architecture Governance performed and operated?
A. It is established in Phase A and operated on Phase F to H
B. It is established in Preliminary Phase, refined in Phase A and operated on Phase F to H
C. It is established in Phase A and operated on Phase E to G
D. It is established in Preliminary Phase and operated on Phase G and H
E. It is established in Preliminary Phase and operated on all subsequent phases
You answered
The correct answer is: D

Question: Which of the following is not an ADM Guideline or Technique?
A. Architecture Principles
B. Usecase Modeling
C. Architecture Patterns
D. Interoperability Requirements
E. Capability-Based Planning
You answered
The correct answer is: B

Question: Which of the following is not described by a Business Scenario in TOGAF?
A. A business process, application, or set of applications
B. The business and technology environment
C. The people and computing components who execute the scenario
D. The underlying business vision
E. The desired outcome of proper execution
You answered
The correct answer is: D

Question: Which of the following is not the source of a business domain gap in context of TOGAF?
A. People gaps
B. Process gaps
C. Tools gaps
D. Information gaps
E. Data relationship gaps
You answered
The correct answer is: E

Question: In which phase of the ADM, the nature and security considerations of information and service exchanges determined?
A. Preliminary Phase
B. Phase A
C. Phase B
D. Phase C
E. Phase D
You answered
The correct answer is: B

Question: In which Phase of the ADM, the risk identification and mitigation assessment worksheets are maintained as governance artifacts and are kept up-to-date?
A. Phase A
B. Phase E
C. Phase F
D. Phase G
E. Phase H
You answered
The correct answer is: D

Question: Which technique can be used to discover the need for a Capability?
A. Gap Analysis
B. Architecture Patterns
C. Interoperability Requirements
D. Business Scenario
E. Business Transformation Readiness Assessment
You answered
The correct answer is: D

Question: Which of the following is not a part of Architecture Governance phase?
A. Implementing a system of controls over the creation and monitoring of all architectural components and activities
B. Improving the maturity level of architecture discipline within the organization
C. Implementing a system to ensure compliance with internal and external standards and regulatory obligations
D. Establishing processes that support effective management of the above processes within agreed parameters
E. Developing practices that ensure accountability to a clearly identified stakeholder community
You answered
The correct answer is: B

Question: The Architecture Governance Framework contain?
A. Compliance, Business Control , Monitoring and Reporting
B. Process, Content, Monitoring and Reporting
C. Process, Content, Repository and Process Flow Control
D. Content, Context, Process and Reporting
E. Business Control, Content, Monitoring and Reporting
You answered
The correct answer is: C

Question: Which of the following is not the purpose of Architecture Compliance Review exercise?
A. To improve the maturity level of architecture discipline within the organization
B. To identify where the standards themselves may require modification
C. To identify services that are currently application-specific but might be provided as part of the enterprise infrastructure
D. To document strategies for collaboration, resource sharing, and other synergies across multiple architecture teams
E. To take advantage of advances in technology
You answered
The correct answer is: A

Question: Which of the following is not a correct statement about the stakeholder concern?
A. Concerns determine the acceptability of the system
B. The terms “concern” and “requirement” are synonymous
C. Concerns are the root of the process of decomposition into requirements
D. Concerns are represented in the architecture by these requirements
E. Each stakeholder typically has interests in, or concerns relative to, that system
You answered
The correct answer is: B

Question: Which of these is not a recommended step to create the required views for a particular architecture?
A. Refer to any existing libraries of viewpoints
B. Select key stakeholders
C. Analyze their requirement and document them
D. Select appropriate viewpoints
E. Generate views of the system using the selected viewpoints as templates
You answered
The correct answer is: C

Question: Which of these is not the characteristic of a building block?
A. It considers implementation and usage, and evolves to exploit technology and standards
B. It may be assembled from other building blocks
C. It may be a subassembly of other building blocks
D. Ideally, a building block is re-usable and replaceable, and well specified with stable interfaces
E. It may specify implementation details
You answered
The correct answer is: E

Question: What Architecture Building Blocks does?
A. They define how the functionality will be realized through products and components
B. They capture architecture requirements
C. They define the implementation
D. They fulfill business requirements
E. They are product or vendor-aware
You answered
The correct answer is: B

Question: Which of these is not in the scope of governance of Architecture Contract?
A. Continuous monitoring to check integrity
B. Adherence to the principles and standards
C. Facilitate re-usablility
D. Identification of risks
E. Ensuring accountability, responsibility, and discipline
You answered
The correct answer is: C

Question: In which phase of the ADM, the Capability Assessment is carried out?
A. It is first carried out in Phase A and updated in Phase E
B. It is first carried out in Preliminary Phase and updated in Phase A to E
C. It is first carried out in Phase A, updated in Phase E and finalized in Phase F
D. It is first carried out in Preliminary Phase, updated in Phase A to E and finalized in Phase F
E. It is first carried out in Phase A and updated in Phase B to E
You answered
The correct answer is: A

Question: What is the (TRF) Technical Reference Model?
A. It is a reference model that focuses on the Application Software space
B. It is fundamentally an Application Architecture reference model – a model of the application components and application services software essential for an integrated information infrastructure
C. It enables each individual department to operate at maximum efficiency was for a long time accepted as the best approach to managing a large enterprise
D. It describes a fundamental architecture upon which other, more specific, architectures can be based
E. It points to rules and standards to assist in leveraging solutions and products within the value chain
You answered
The correct answer is: D

Question: Which of these is not a part of III-RM (Integrated Information Infrastructure Reference Model) taxonomy?
A. Information consumer application
B. Management utilities
C. Brokering application
D. Communication infrastructure interface
E. Information provider application
You answered
The correct answer is: D

Test 2

Question: What according to TOGAF is an Enterprise?
A. Entire business group or corporation comprising of all local and international main and sub offices, divisions, subsidiaries, and departments
B. Any collection of organizations that has a common set of goals
C. Any large organization
D. An enterprise is an organization that uses computers
E. A large corporation or government agency, but it may also refer to a company of any size with many systems and users to manage
You answered
The correct answer is: B

Question: Which of the following is NOT a correct statement about an Architecture Framework?
A. An architecture framework is a tool that can be used for developing a broad range of different architectures
B. An architecture framework should describe a method for designing an information system in terms of a set of building blocks, and for showing how the building blocks fit together
C. Architecture Framework is a set of resources, guidelines, templates, background information, etc. provided to help the architect establish an architecture practice within an organization
D. An architecture framework should contain a set of tools and provide a common vocabulary
E. An architecture framework should also include a list of recommended standards and compliant products that can be used to implement the building blocks
You answered
The correct answer is: C

Question: Which of the following statement is NOT a reason for suitability of TOGAF as a Framework for Enterprise Architecture?
A. It provides an immediate return on investment
B. It has been developed through the collaborative efforts of more than 300 Architecture Forum member companies from some of the world’s leading IT customers and vendors and represents best practice in architecture development
C. It will allow architectures to be developed that are consistent, reflect the needs of stakeholders, employ best practice, and give due consideration both to current requirements and to the likely future needs of the business
D. It plays an important role in helping to “de-mystify” and de-risk the architecture development process
E. It provides a platform for adding value, and enables users to build genuinely open systems-based solutions to address their business issues and needs
You answered
The correct answer is: A

Question: Which of the following is NOT a part of the Architecture Capability Framework?
A. Standards with which new architectures must comply
B. Guidelines for establishing an Architecture Capability within an organization
C. A set of role, skill, and experience norms for staff undertaking enterprise architecture work
D. Techniques for evaluating and quantifying an organization’s maturity in enterprise architecture
E. Framework and guidelines for Architecture Governance
You answered
The correct answer is: A

Question: TOGAF recommends running the enterprise architecture practice like any other operational unit within a business. For that, which of the following processes capability needs to be established?
A. Environment Management, Supplier Management and Network Management
B. Risk Management, Resource Management and IT Management
C. Communications and Stakeholder Management, Quality Management and Presentation Management
D. Financial Management, Performance Management and Service Management
E. Configuration Management, Release Management and Change management
You answered
The correct answer is: D

Question: According to TOGAF Document Categorization Model, which are the four categories of content?
A. Central, Mandated, Recommended and Supporting
B. Core, Mandated, Reference and Supplemental
C. Central, Mandated, Recommended and Supplemental
D. Central, Mandated, Reference and Supplemental
E. Core, Mandated, Recommended and Supporting
You answered
The correct answer is: E

Question: Which of the following statements is NOT true for ADM?
A. ADM defines a recommended sequence for the various phases and steps involved in developing an organization-wide enterprise architecture
B. ADM does not determine the scope for an enterprise architecture activity; this must be determined by the organization itself
C. The numbering scheme provided in the TOGAF ADM for its outputs is a mandated practice
D. An output in an early ADM phase may be modified in a later phase
E. The ADM has ten phases
You answered
The correct answer is: C

Question: Which of the following is a Key Point of the ADM Cycle?
A. Decisions taken should be based on the value accruing to the enterprise only
B. ADM provides a recommended the scope of activity which can be tailored by the organization itself
C. The main guideline is to focus on what creates value to the enterprise, and to select horizontal and vertical scope, and project schedules, accordingly
D. Where necessary, use of the ADM should be tailored to meet the needs of the organization but phases cannot be omitted
E. Though ADM is iterative, the decisions regarding enterprise coverage, level of detail, time period and architecture asset re-use needs to be take upfront
You answered
The correct answer is: C

Question: Which of the following is NOT a correct reason for limiting the scope of the Architecture Activity?
A. The inflexibility of the baseline IT technical architecture
B. The realities of resource and time constraints often mean there is not enough time, funding, or resources to build a top-down, all-inclusive architecture description encompassing all four architecture domains
C. To ensure an appropriate demarcation between the architecture effort and other, related activities (system design, system engineering, system development)
D. The organizational authority of the team producing the architecture
E. The objectives and stakeholder concerns to be addressed within the architecture
You answered
The correct answer is: A

Question: Which among the following statements about Architecture Continuum is NOT true?
A. It offers a consistent way to define and understand the generic rules, representations, and relationships in an architecture, including traceability and derivation relationships
B. It represents a structuring of Architecture Building Blocks (ABBs) which are re-usable architecture assets
C. Every artifact in the Solutions Continuum has a one to one relationship with a corresponding artifact in the Architecture Continuum
D. It shows the relationships among foundational frameworks, common system architectures, industry architectures, and enterprise architectures
E. It is a useful tool to discover commonality and eliminate unnecessary redundancy
You answered
The correct answer is: C

Question: The relationship between the Architecture Continuum and the Solutions Continuum is one of ___ (complete the sentence).
A. Guidance, derivation and support
B. Guidance, direction and support
C. Governance, direction and support
D. Guidance, direction and supplementing
E. Governance, derivation and supplementing
You answered
The correct answer is: B

Question: What are the levels of granularity the Architecture Landscape is divided into?
A. Strategic Architectures, Segment Architectures and Capability Architectures
B. Strategic Architectures, Segment Architectures and Transition Architectures
C. Enterprise Architectures, Segment Architectures and Capability Architectures
D. Enterprise Architectures, Segment Architectures and Transition Architectures
E. Enterprise Architectures, Solution Architectures and Transition Architectures
You answered
The correct answer is: A

Question: Which of the following is NOT a stated reason for using a tool for Enterprise Continuum?
A. Promote re-use
B. Enable sharing of architecture information within an organization
C. Facilitate easier maintenance of the software assets
D. Ensure common terminology is used
E. Provide stakeholders with relevant models
You answered
The correct answer is: C

Question: Which of the following is NOT an objective of the Preliminary phase?
A. Understand the business environment
B. Ensure high-level management commitment and obtain agreement on scope
C. Establish principles and establish governance structure
D. Agree architecture method to be adopted
E. Articulate an Architecture Vision and value proposition
You answered
The correct answer is: E

Question: What first-cut, high-level description does Architecture Vision provide?
A. Baseline Architectures, Target Architectures and Gap Analysis
B. Architecture Definition, Architecture Specification and Architecture Roadmap
C. Strategic Architectures, Segment Architectures and Capability Architectures
D. Business Architectures, Data Architectures, Application Architectures and Technology Architectures
E. Enterprise Architectures, Solution Architectures and Transition Architectures
You answered
The correct answer is: D

Question: Which are the Key Considerations for the Data Architecture?
A. Data Analysis, Data Integrity and Data Security
B. Data Management, Data Integrity and Data Governance
C. Data Management, Data Migration and Data Governance
D. Data Analysis, Data Migration and Data Governance
E. Data Analysis, Data Integrity and Data Governance
You answered
The correct answer is: C

Question: Which of the following is NOT an activity in Phase E?
A. Perform initial implementation planning
B. Group projects into Transition Architectures
C. Decide on approach — Make versus buy versus re-use
D. Identify the major implementation projects
E. Perform a cost/benefit analysis and a risk assessment
You answered
The correct answer is: E

Question: Which of the following is NOT an approach in Phase G?
A. Creation of an Implementation and Migration Plan in co-operation with the portfolio and project managers
B. Adopt a phased deployment schedule that reflects the business priorities embodied in the Architecture Roadmap
C. Follow the organization’s standard for corporate, IT, and Architecture Governance
D. Use the organization’s established portfolio/program management approach, where this exists
E. Define an operations framework to ensure the effective long life of the deployed solution
You answered
The correct answer is: A

Question: Which of the following statements about Requirements Management phase is correct?
A. This phase is executed at the beginning
B. It focuses on minimizing changes to requirement
C. It does not dispose of, address, or prioritize any requirements; this is done within the relevant phase of the ADM
D. TOGAF has a recommend process for requirements management
E. Prioritizing requirement is an activity of this phase
You answered
The correct answer is: C

Question: How is the scope of the enterprise architecture projects decided?
A. The scope is defined in phase A and refined in phases B, C and D
B. Agreement on the scope is reached in the Preliminary phase and it is defined in phase A
C. The scope is defined in the Preliminary phase and agreement is reached in phase A
D. Agreement on the scope is reached in the Preliminary phase but the definition happens through phase A to D
E. The scope is defined and agree upon in the Preliminary phase
You answered
The correct answer is: B

Question: In which phase is the make versus buy versus re-use decision taken?
A. Phase A
B. Phase D
C. Phase E
D. Phase F
E. Phase G
You answered
The correct answer is: C

Question: In which phase are the Architecture Contracts prepared?
A. Preliminary Phase
B. Phase A
C. Phase E
D. Phase F
E. Phase G
You answered
The correct answer is: E

Question: Which of the following is not a part of the guidelines for adapting the ADM process?
A. Coexisting with other Enterprise Architecture frameworks
B. Ways to apply iteration to the ADM
C. Applying the ADM at different levels of the enterprise
D. Security considerations when applying the ADM
E. Using TOGAF to define Service-Oriented Architectures (SOAs)
You answered
The correct answer is: A

Question: Which part of the TOGAF document provides a number of architecture development phases, together with narratives for each phase?
A. Part I: Introduction
B. Part II: Architecture Development Method (ADM)
C. Part III: ADM Guidelines and Techniques
D. Part IV: Architecture Content Framework
E. Part V: Enterprise Continuum and Tools
You answered
The correct answer is: B

Question: Where the process of creating a Business Scenario does starts?
A. Business and Technical environments
B. Problem statements
C. Desired objectives
D. Human participants
E. Roles and responsibilities
You answered
The correct answer is: B

Question: In which phases is the Gap Analysis technique used?
A. Phases B, C, D, and E
B. Phases B, C, and D
C. Phases A, B, C, D, and E
D. Phases A, B, C and D
E. Phases C, D, and E
You answered
The correct answer is: E

Question: For which phases is the Business Transformation Readiness Assessment a key technique?
A. Phases E only
B. Phases E, F and G
C. Phases A, E and F
D. Phases from A to F
E. Phases E and F
You answered
The correct answer is: C

Question: Which of the following statements is NOT correct?
A. Corporate Strategic Plan manages and creates Capabilities
B. Capability consists of Capability Increment
C. Capability is documented in Architecture Vision
D. Capability Increment is documented by Transition Architecture
E. Architecture and Solution Building Blocks are the basis for Capability Increment Solutions
You answered
The correct answer is: C

Question: Which of the following statements is NOT correct?
A. Effective governance ensures that problems are identified early and that subsequent changes to the environment occur in a controlled manner
B. Architecture Governance is the practice by which enterprise architectures and other architectures are managed and controlled at an enterprise-wide level
C. Architecture Governance typically operates within a hierarchy of governance structures
D. Corporate Governance is a broad topic and outside the scope of the TOGAF framework
E. Architecture Governance helps creating organizational structures that enabled each individual department to operate at maximum efficiency
You answered
The correct answer is: E

Question: Which are the six characteristics used in TOGAF to highlight both the value and necessity for governance?
A. Discipline, Transparency, Independence, Accountability, Responsibility and Fairness
B. Transparency, Independence, Accountability, Responsibility, Fairness and Compliance
C. Independence, Accountability, Responsibility, Fairness, Compliance and Discipline
D. Accountability, Responsibility, Fairness, Compliance, Discipline and Transparency
E. Responsibility, Fairness, Compliance, Discipline, Transparency and Independence
You answered
The correct answer is: A

Question: Which of the following is NOT the responsibility of Architecture Board?
A. Ensuring consistency between sub-architectures
B. Identifying re-usable components
C. Identification of risk and subsequent risk mitigation
D. Improving the maturity level of architecture discipline within the organization
E. Providing the basis for all decision-making with regard to changes to the architectures
You answered
The correct answer is: C

Question: Which of the following is NOT a recommendation for Architecture Capability building?
A. Establishing a sustainable Architecture Capability within an organization can be achieved by adhering to the same approach that is used to establish any other capability
B. TOGAF states that Architecture Capability development should not be seen as a phase of an architecture project but as a separate one-off project
C. The ADM is an ideal method to be used to architect and govern the implementation of such Architecture Capability
D. Applying the ADM with the specific Architecture Vision to establish an architecture practice within the organization would help building Architecture Capability
E. Implementing any capability within an organization would require the design of the four domain architectures
You answered
The correct answer is: B

Question: What question should the architect answer to ensure the completeness of the architecture?
A. Can the views be connected to each other?
B. Can the conflicting concerns be reconciled?
C. What trade-offs have been made?
D. Does it address all the concerns of its stakeholders?
E. Is the architecture implementable?
You answered
The correct answer is: D

Question: Which of the following relationship between view, viewpoint, stakeholder and architecture is correct?
A. Stakeholder concern is address by one or more viewpoints
B. An architecture consists of multiple viewpoints
C. One of more viewpoint can be used to cover a concern
D. A Viewpoint conforms to a view
E. Viewpoint library contains multiple views
You answered
The correct answer is: C

Question: Which among the following statements is NOT correct?
A. TOGAF recommends the way in which functionality, products, and custom developments are assembled into building blocks
B. Every organization must decide for itself what arrangement of building blocks works best for it
C. A good choice of building blocks can lead to improvements in legacy system integration, interoperability, and flexibility in the creation of new systems and applications
D. An architecture is a composition of a set of building blocks and the specification of how those building blocks are connected
E. Various building blocks in an architecture specify the services required in an enterprise specific system
You answered
The correct answer is: A

Question: Which among the following statements about patterns is NOT correct?
A. Pattern is “an idea that has been useful in one practical context and will probably be useful in others”
B. Patterns are considered to be a way of putting building blocks into context
C. Patterns can tell when, why, and what trade-offs you have to make
D. Patterns are a package of functionality defined to meet business needs across an organization
E. Patterns offer the promise of helping the architect to solutions that have been proven to deliver effective in the past
You answered
The correct answer is: D

Question: What does the Architecture Requirements Specification provide?
A. A qualitative view of the solution and aims to communicate the intent of the architects
B. A quantitative view of the solution stating measurable criteria
C. List of individual increments of change
D. An aspirational view of the end architecture product
E. Context for architecture work by describing the needs
You answered
The correct answer is: B

Question: Which of the following is NOT a key ADM Deliverable?
A. Architecture Contract
B. Architecture Principles
C. Architecture Repository
D. Change Request
E. Integrated Information Infrastructure
You answered
The correct answer is: E

Question: Which among the following are NOT service categories in the TRM?
A. Data management and data interchange
B. User interface, graphics and image
C. Security, system and network management
D. Software engineering
E. Information brokers and application integrators
You answered
The correct answer is: E

Question: Which among the following statements about Boundary-less Information Flow is NOTcorrect?
A. It is a trademark of The Open Group
B. It provides insights related to customer needs
C. An infrastructure that provides Boundaryless Information Flow has open standard components
D. Its problem space is one that is shared by many customer members of The Open Group, and by many similar organizations worldwide
E. It is a shorthand representation of “access to integrated information to support business process improvements”
You answered
The correct answer is: B

Test 3

Question: Which section of the TOGAF document describes the processes, skills and roles to establish and operate an architecture function within an enterprise?
A. Part II: Architecture Development Method
B. Part III: ADM Guidelines and Techniques
C. Part IV: Architecture Content Framework
D. Part VI: TOGAF Reference Models
E. Part VII: Architecture Capability Framework
You answered
The correct answer is: E
Part VII: Architecture Capability Framework discusses the organization, processes, skills, roles, and responsibilities required to establish and operate an architecture practice within an enterprise.

Question: Complete the sentence. To promote effective architectural activity within the enterprise, TOGAF 9 recommends the establishment of a(n) _____
A. Enterprise Architecture Capability
B. IT Governing Board
C. Program Management Office
D. Quality Assurance department
E. Service Management department
You answered
The correct answer is: A
A: An enterprise architecture capability (or architecture capability) in the context of TOGAF, is the ability for an organization to effectively undertake the activities of an enterprise architecture practice.

Question: Which phase of the ADM is used to finalize a set of transition architectures that will support implementation?
A. Phase D
B. Phase E
C. Phase F
D. Phase G
E. Phase H
You answered
The correct answer is: C
C: Phase F confirms the Transition Architectures defined in Phase E with the relevant stakeholders and finalizes them.

Question: Which one of the following statements best describes the ADM Guidelines and Techniques?
A. Guidelines address different usage scenarios including different process styles and specialist architectures that can be adapted in the ADM
B. Guidelines address different usage scenarios that cannot be adapted directly into the ADM iteration process
C. Techniques support different usage scenarios that can be adapted directly into the ADM iteration process
D. Techniques support different usage scenarios including different process styles and specialist architectures that can be adapted in the ADM
You answered
The correct answer is: A
TOGAF 9 Part III contains a collection of guidelines and techniques for use in applying TOGAF and the ADM. The guidelines document how to adapt the ADM process and specialist architecture styles, whereas the techniques are used when applying the ADM process.

Question: According to TOGAF, the recommended dimensions used to define the scope of an architecture include all the following, except:
A. Architecture Domains
B. Breadth
C. Depth
D. Subject Matter
E. Time Period
You answered
The correct answer is: D
The recommended dimensions to define the scope of an architecture activity are breadth, depth, time period and architecture domains.

Question: Which of the following classes of architectural information within the Architecture Repository defines processes that support governance of the Architecture Repository?
A. Architecture Capability
B. Architecture Landscape
C. Architecture Metamodel
D. Governance Log
E. Reference Library
You answered
The correct answer is: A
The Architecture Capability defines the parameters, structures, and processes that support governance of the Architecture Repository.

Question: In which ADM phase are the business principles, business goals and strategic drivers validated?
A. Preliminary Phase
B. Phase A, Architecture Vision
C. Phase B, Business Architecture
D. Phase H, Architecture Change Management
E. Requirements Management Phase
You answered
The correct answer is: B
Phase A, Architecture Vision includes the validation of business principles, goals, strategic drivers, and also Key Performance Indicators (KPIs)

Question: Which section of the TOGAF document describes the purpose of deliverables produced as outputs from the ADM cycle?
A. ADM Guidelines and Techniques
B. Architecture Capability Framework
C. Architecture Content Framework
D. Architecture Governance Framework
E. TOGAF Reference Models
You answered
The correct answer is: C
The Architecture Content Framework provides a detailed model of architectural work products, including deliverables and their purpose, artifacts within deliverables, and the Architecture Building Blocks (ABBs) that deliverables represent.

Question: Which of the following best describes the TOGAF Technical Reference Model?
A. The TOGAF Architecture Development Method mandates the use of the Technical Reference Model for large complex architecture projects
B. The Technical Reference Model is an integral part of the TOGAF Architecture Development Method
C. The Technical Reference Model should not be modified
D. The Technical Reference Model includes a set of graphical models and a corresponding taxonomy
E. The Technical Reference Model provides a direct mapping to the Zachman Framework
You answered
The correct answer is: D
The TRM has two main components:1. A taxonomy that defines terminology, and provides a coherent description of the components and conceptual structure of an information system. 2.A model, with an associated TRM graphic, that provides a visual representation of the taxonomy, as an aid to understanding

Question: Which one of the following best describes a primary use of the Architecture Vision document?
A. A checklist for compliance reviews
B. An evaluation tool to select vendors to conduct a proof of concept demonstration
C. To calculate detailed cost estimates
D. To project plan the implementation activities
E. To describe the benefits of the proposed capability to stakeholders
You answered
The correct answer is: E
The Architecture Vision provides the sponsor with a key tool to sell the benefits of the proposed capability to stakeholders and decision-makers within the enterprise. It describes how the new capability will meet the business goals and strategic objectives and address the stakeholder concerns when implemented.

Question: Which of the following could be considered for potential use in Phase C, Application Architecture?
A. The ARTS data model
B. The Integrated Information Infrastructure Reference Model
C. The Resource-Event-Agent model
D. The STEP framework
E. The TOGAF Technical Reference Model
You answered
The correct answer is: B
TOGAF includes the Reference Model for Integrated Information Infrastructure (III-RM) that could be considered for use in this phase. It focuses on the application-level components and services necessary to provide an integrated information infrastructure.

Question: In Phase G, what document establishes the connection between the architecture organization and the implementation organization?
A. Architecture Contract
B. Architecture Landscape
C. Architecture Roadmap
D. Requirements Impact Statement
E. Transition Architecture
You answered
The correct answer is: A
Architecture Contracts are the joint agreements between development partners and sponsors on the deliverables, quality, and fitness-for-purpose of an architecture. They are produced in Phase G.

Question: Which phase of the ADM is an on-going activity that is visited throughout a TOGAF architecture project?
A. Architecture Change Management
B. Implementation governance
C. Migration planning
D. Preliminary Phase
E. Requirements Management
You answered
The correct answer is: E
The process of managing architecture requirements applies to all phases of the ADM cycle. As shown by its central placement in the ADM cycle diagram, this process is central to driving the ADM process.

Question: Which of the following statements is true about risk management in the ADM?
A. Risk analysis is best conducted in the Architecture Vision phase so that the risk is eliminated in subsequent phases
B. Risk analysis should be carried out first in the Migration Planning phase
C. Risk analysis is outside the scope of enterprise architecture projects
D. Risk is pervasive in all enterprise architecture activity and should be managed in all phases of the ADM
E. The only risks that are within the scope of enterprise architecture are technological risks
You answered
The correct answer is: D
Risk is pervasive in any enterprise architecture activity and present in all phases within the ADM.

Question: Which of the following best describes capability based planning?
A. A business planning technique that focuses on business outcomes
B. A business planning technique that focuses on horizontal capabilities
C. A business planning technique that focuses on vertical capabilities
D. A human resource planning technique that focuses on capable architects
You answered
The correct answer is: A
Capability-Based Planning is a business planning technique that focuses on business outcomes. It is business-driven and business-led and combines the requisite efforts of all lines of business to achieve the desired capability. It accommodates most, if not all, of the corporate business models and is especially useful in organizations where a latent capability to respond (e.g., an emergency preparedness unit) is required and the same resources are involved in multiple capabilities.

Question: According to TOGAF, which one of the following is the practice by which the enterprise architecture and other architectures are managed and controlled at an enterprise level?
A. Architecture governance
B. Corporate governance
C. IT governance
D. Technology governance
E. The program management office
You answered
The correct answer is: A
Architecture Governance is the practice by which enterprise architectures and other architectures are managed and controlled at an enterprise-wide level.

Question: Which one of the following is documented in TOGAF Part VII as a guideline for how to establish an Enterprise Architecture Capability?
A. Develop an Architecture Roadmap
B. Populate the Architecture Repository
C. Populate the Enterprise Continuum
D. Use the Architecture Development Method
E. Use the Implementation Governance Phase
You answered
The correct answer is: D
TOGAF Part VII recommends applying the ADM with the specific Architecture Vision to establish an enterprise architecture capability within an organization.

Question: Which of the following statements best describes the purpose of the Architecture Requirements Specification?
A. A document that triggers the start of an architecture development cycle
B. A qualitative view of the solution to communicate the intent of the architect
C. A quantitative view of the solution to measure the implementation
D. A record of deviations from the planned architectural approach to identify changes to be made
You answered
The correct answer is: C
The Architecture Requirements Specification provides a set of quantitative statements that outline what an implementation project must do in order to comply with the architecture.

Question: Which one of the following best describes the purpose of the Communications Plan?
A. To ensure that architecture information is communicated to the right stakeholders at the right time
B. To support Boundaryless Information Flow
C. To evangelize the architecture to the end user community
D. To keep the Architecture Review Board appraised of changes to the architecture
E. To ensure that the outcomes of a Compliance Assessment are distributed to the members of the
You answered
The correct answer is: A
Effective communication of targeted information to the right stakeholders at the right time is a critical success factor for enterprise architecture. Development of a Communications Plan in Phase A for the architecture allows for this communication to be carried out within a planned and managed process.

Question: Complete the sentence. The statement, "Getting information to the right people at the right time in a secure, reliable manner in order to support the operations that are core to the extended enterprise" describes the concept of _____
A. Boundaryless Information Flow
B. Interoperability
C. Portability
D. Service Oriented Architecture
E. Semantic Web
You answered
The correct answer is: A
Boundaryless Information Flow is essentially the problem of getting information to the right people at the right time in a secure, reliable manner, in order to support the operations that are core to the extended enterprise.

Question: According to TOGAF, where should architecture governance artifacts be stored?
A. In the Architecture Repository
B. In the Foundation Architecture
C. In the Integrated Infrastructure Reference Model
D. In the Requirements Repository
E. In the Standards Information Base
You answered
The correct answer is: A
Architecture governance artifacts should be stored in the Architecture Repository.

Question: Which architecture domain describes logical software and hardware capabilities?
A. Application Architecture
B. Business Architecture
C. Data Architecture
D. Information Systems Architecture
E. Technology Architecture
You answered
The correct answer is: E
The Technology Architecture includes the software and hardware capabilities that are required to support the deployment of business, data, and application services. This includes IT infrastructure, middleware, networks, communications, processing, and standards.

Question: Which of the following lists the components within the Architecture Repository?
A. Organizational Metamodel, Architecture Capability, Architecture Landscape, Best Practices, Reference Library, Compliance Strategy
B. Architecture Metamodel, Organizational Capability Model, Application Landscape, SIB, Reference Library, Governance Model
C. Business Metamodel, Architecture Capability, Architecture Landscape, SIB, Reference Library, Governance Log
D. Architecture Metamodel, Architecture Capability, Architecture Landscape, SIB, Reference Library, Governance Log
You answered
The correct answer is: D
The main components of the Architecture Repository are the Architecture Metamodel, Architecture Capability, Architecture Landscape, SIB, Reference Library, and Governance Log.

Question Which of the following reasons best describes why the ADM numbering scheme for versioning output is an example and not mandatory?
A. To show the evolution of deliverables
B. To permit adaptation as required
C. To enable use with the Architecture Content Framework
D. To support change management
You answered
The correct answer is: B
The numbering scheme provided in the TOGAF ADM for its outputs is intended as an example. It should be adapted by the architect to meet the requirements of the organization and to work with the architecture tools and repositories employed by the organization.

Question: Which of the following is not one of the domain architectures produced by the TOGAF ADM process?
A. Application Architecture
B. Business Architecture
C. Data Architecture
D. Pattern Architecture
E. Technology Architecture
You answered
The correct answer is: D
D Pattern Architecture is not one of the four domain architectures, which are BDAT: Business, Data, Application, and Technology Architecture.

Question: Which of the TOGAF ADM phases is considered to be the initial phase of an Architecture Development Cycle?
A. Preliminary Phase
B. Phase A
C. Phase B
D. Phase E
E. Phase G
You answered
The correct answer is: B
B Phase A: Architecture Vision is the initial phase of a cycle. Note that the Preliminary Phase is a preparatory phase. Phase A: Architecture Vision describes the initial phase of an Architecture Development Cycle. It includes information about defining the scope, identifying the stakeholders, creating the Architecture Vision, and obtaining approvals.

Question: Which one of the following is defined as describing the state of an architecture at an architecturally significant point in time during the progression from the Baseline to the Target Architecture?
A. Capability Architecture
B. Foundation Architecture
C. Segment Architecture
D. Solution Architecture
E. Transition Architecture
You answered
The correct answer is: E
E A Transition Architecture is defined as a formal description of one state of the architecture at an architecturally significant point in time. One or more Transition Architectures may be used to describe the progression in time from the Baseline to the Target Architecture

Question: Which of the following is one of the Categories of Skills in the TOGAF Architecture Skills Framework?
A. Human Resource Skills
B. Vendor Management Skills
C. IT Procurement Skills
D. IT General Knowledge Skills
E. Programming Skills
You answered
The correct answer is: D
D Phase F: Migration Planning develops the detailed Implementation and Migration Plan that addresses how to move from the Baseline to the Target Architecture.

Question: Complete the sentence: The TOGAF Integrated Information Infrastructure Reference Model (III-RM) is classified in the Architecture Continuum as an example of a(n) _______.
A. Common Systems Architecture
B. Industry Architecture
C. Enterprise Architecture
D. Foundation Architecture
You answered
The correct answer is: A
A The III-RM is a Common Systems Architecture. The TOGAF Integrated Information Infrastructure Reference Model (III-RM) is a reference model that supports describing Common Systems Architecture in the Application domain that focuses on the requirements, building blocks, and standards relating to the vision of Boundaryless Information Flow.

Question: Which of the ADM phases includes the objective of establishing the organizational model for enterprise architecture?
A. Preliminary
B. Phase A
C. Phase B
D. Phase D
E. Phase E
You answered
The correct answer is: A
A The Preliminary Phase has as part of its objectives establishment of the Architecture Capability; it includes defining and establishing the Organizational

Question: Which of the following is a technique that can be used to discover and document business requirements in Phase A?
A. Business Scenarios
B. Business Transformation Readiness Assessment
C. Capability Based Planning
D. Gap Analysis
E. Stakeholder Management
You answered
The correct answer is: A
A Business scenarios are an appropriate and useful technique to discover and document business requirements in Phase A, and to articulate an Architecture Vision that responds to those requirements.

Question: Complete the sentence. The Transition Architectures defined in Phase E are confirmed with the stakeholders in _________________.
A. Phase E
B. Phase F
C. Phase G
D. Phase H
You answered
The correct answer is: B
B The Transition Architectures are confirmed in Phase F. An objective of Phase F is to ensure that the business value and cost of work packages and Transition Architectures is understood by key stakeholders

Question: Complete the sentence. According to the TOGAF standard, a good business scenario should be “SMART”. The letter “S” stands for ______________.
A. Solution-oriented
B. Specific
C. Strategic
D. Stakeholder-oriented
E. Segmented
You answered
The correct answer is: B
B The S in SMART stands for Specific. SMART is defined as follows: Specific, by defining what needs to be done. Measurable, through clear metrics for success. Actionable, by clearly segmenting the problem and providing the basis for a solution. Realistic, in that the problem can be solved within the bounds of physical reality, time, and cost constraints. Time-bound, in that there is a clear statement of when the opportunity expires.

Question: Which of the following best describes the Business Transformation Readiness Assessment technique?
A. A technique to define the degree to which information and services are to be shared
B. A technique used to validate an architecture
C. A technique used to identify and understand the business requirements an architecture must address
D. A technique used to develop general rules and guidelines for the architecture being developed
E. A technique used to understand the readiness of an organization to accept change
You answered
The correct answer is: E
E The Business Transformation Readiness Assessment technique is used for determining the readiness of an organization to accept change. Enterprise architecture often involves considerable change. It provides a technique for understanding the readiness of an organization to accept change, identifying the issues, and dealing with them in the Implementation and Migration Plan. It is based on the Canadian Government Business Transformation Enablement Program (BTEP).

Question: Which of the following best describes the Capability-Based Planning technique?
A. A technique used to plan the degree to which information and services are to be shared
B. A technique used to validate an architecture
C. A technique used for business planning that focuses on business outcomes
D. A technique used to develop general rules and guidelines for the architecture being developed
You answered
The correct answer is: C
C Capability-Based Planning is a business planning technique that focuses on business outcomes. It is business-driven and business-led and combines the requisite efforts of all lines of business to achieve the desired capability. It accommodates most, if not all, of the corporate business models and is especially useful in organizations where a latent capability to respond (e.g., an emergency preparedness unit) is required and the same resources are involved in multiple capabilities. Often the need for these capabilities is discovered and refined using business scenarios.

Question: Which one of the following best describes an Architecture Contract?
A. An agreement between the development partners and stakeholders on the acceptable risks and mitigating actions for an architecture
B. An agreement between development partners and sponsors on the deliverables, quality, and fitness-for-purpose of an architecture
C. An agreement between the lead architect and the development partners on the enforcement of Architecture Compliance for an architecture
D. An agreement between development partners and sponsors on how best to monitor implementation of the architecture
You answered
The correct answer is: B
B The agreement is between development partners and sponsors. Architecture Contracts are joint agreements between development partners and sponsors on the deliverables, quality, and fitness-for-purpose of an architecture. Successful implementation of these agreements will be delivered through effective Architecture Governance. Taking a governed approach to contract management ensures a system that continuously monitors integrity, changes, decision-making, and audit, as well as adherence to the principles, standards, and requirements of the enterprise. The architecture team may also be included in product procurement, to help minimize the opportunity for misinterpretation of the enterprise architecture.

Question: TOGAF defines a set of terms to describe Architecture Compliance. Which one of the following applies to the case where an implementation has no features in common with the architecture specification?
A. Compliant
B. Conformant
C. Irrelevant
D. Non-conformant
You answered
The correct answer is: C
C Where no features are in common then it is termed Irrelevant.

Question: Which of the following terms does TOGAF use to describe people who have key roles in, or concerns about, a system?
A. Architect
B. Consumer
C. Customer
D. Sponsor
E. Stakeholder
You answered
The correct answer is: E
E Stakeholders are people who have key roles in, or concerns about, the system; for example, users, developers, etc. Stakeholders can be individuals, teams, organizations, etc. A system has one or more stakeholders. Each stakeholder typically has interests in, or concerns relative to, that system.

Question: Which of the following ADM phases is where SBBs first appear in the ADM cycle?
A. Phase A
B. Phase B
C. Phase D
D. Phase E
E. Phase G
You answered
The correct answer is: D
D SBBs appear in Phase E of the ADM where product-specific building blocks are considered for the first time. SBBs define what products and components will implement the functionality, thereby defining the implementation.

Question: Which of the following documents acts as the deliverable container for the Business, Data, Application, and Technology architectural artifacts?
A. Architecture Contract
B. Architecture Definition Document
C. Architecture Requirements Specification
D. Architecture Roadmap
E. Architecture Vision
You answered
The correct answer is: B
B The Architecture Definition Document is the deliverable container for the core architectural artifacts created during a project and for important related information. The Architecture Definition Document spans all architecture domains (Business, Data, Application, and Technology) and also examines all relevant states of the architecture (baseline, transition, and target).

Test 4

Question:Which one of the following best describes TOGAF?
A. A framework and method for architecture development
B. An architecture pattern
C. A business model
D. A method for developing Technology Architectures
E. A method for IT Governance
You answered
The correct answer is: A
This is the best answer. TOGAF is a framework - a detailed method and a set of supporting tools - for developing an enterprise architecture.

Question:Which part of the TOGAF document provides a number of architecture development phases, together with narratives for each phase?
A. Part I: Introduction
B. Part II: Architecture Development Method (ADM)
C. Part III: ADM Guidelines and Techniques
D. Part IV: Architecture Content Framework
E. Part V: Enterprise Continuum and Tools
You answered
The correct answer is: B

Question: According to TOGAF, all of the following are suggested characteristics of an architecture framework, except __________
A. A common vocabulary
B. A list of recommended standards
C. A method for designing a target state of the enterprise in terms of building blocks
D. A set of structures which can be used to develop a broad range of architectures
E. A software development lifecycle method
You answered
The correct answer is: E
An architecture framework is a foundational structure, or set of structures, which can be used for developing a broad range of different architectures. It should describe a method for designing a target state of the enterprise in terms of a set of building blocks, and for showing how the building blocks fit together. It should contain a set of tools and provide a common vocabulary. It should also include a list of recommended standards and compliant products that can be used to implement the building blocks.

Question: Which of the TOGAF architecture development phases includes the development of Data and Application Architectures?
A. Phase A
B. Phase B
C. Phase C
D. Phase D
E. Phase E
You answered
The correct answer is: C
Phase C: Information Systems Architectures describes the development of Information Systems Architectures for an architecture project, including the development of Data and Application Architectures.

Question: Which one of the following does the Architecture Content Framework describe as a work product that is contractually specified, formally reviewed, and signed off by the stakeholders?
A. An artifact
B. A building block
C. A catalog
D. A deliverable
E. A matrix
You answered
The correct answer is: D
A deliverable is a work product that is contractually specified and in turn formally reviewed, agreed, and signed off by the stakeholders. Deliverables represent the output of projects and those deliverables that are in documentation form will typically be archived at completion of a project, or transitioned into an Architecture Repository as a reference model, standard, or snapshot of the Architecture Landscape at a point in time.

Question: Which of the following best completes the sentence: The Enterprise Continuum __________
A. describes a database of open industry standards
B. is an architecture framework
C. is a technical reference model
D. provides a method for architecture development
E. provides methods for classifying artifacts
You answered
The correct answer is: E
The Enterprise Continuum is a model providing methods for classifying architecture and solution artifacts as they evolve from generic Foundation Architectures to Organization-Specific Architectures. The Enterprise Continuum comprises two complementary concepts: the Architecture Continuum and the Solutions Continuum.

Question: According to TOGAF, in which ADM phase does the initial implementation planning occur?
A. Phase A: Architecture Vision
B. Phase B: Business Architecture
C. Phase C: Information Systems Architectures
D. Phase D: Technology Architecture
E. Phase E: Opportunities and Solutions
You answered
The correct answer is: E
Phase E: Opportunities & Solutions conducts initial implementation planning and the identification of delivery vehicles for the architecture defined in the previous phases.

Question: According to TOGAF, which of the following is the reason why the first execution of an ADM cycle will be more difficult than later cycles?
A. Because management is not familiar with the ADM process
B. Because there are few architecture assets available
C. Because of lack of governance
D. Because of insufficient trained architecture practitioners
E. Because the Baseline Architecture must be fully defined across the enterprise
You answered
The correct answer is: B
The first execution of the ADM will often be the hardest, since the architecture assets available for re-use will be relatively scarce. Even at this stage of development, however, there will be architecture assets available from external sources such as TOGAF, as well as the IT industry at large, that could be leveraged in support of the effort.

Question: As architecture deliverables and work products created in one ADM phase are modified by subsequent phases, how does TOGAF suggest tracking the changes?
A. Change control committee
B. Document checkpoints and journaling
C. Publish and subscribe system
D. Version numbers
E. Workflow management system
You answered
The correct answer is: D
Output is generated throughout the ADM process, and output in an early phase may be modified in a later phase. TOGAF recommends that the versioning of output is managed through version numbers. In all cases, the ADM numbering scheme is provided as an example. It should be adapted by the architect to meet the requirements of the organization and to work with the architecture tools and repositories employed by the organization.

Question: Complete the sentence: The architectures that address the detailed enterprise needs and business requirements within the Architecture Continuum are known as_______
A. Strategic Architectures
B. Foundation Architectures
C. Industry Architectures
D. Common Systems Architectures
E. Organization-Specific Architectures
You answered
The correct answer is: E
Organization-Specific Architectures are viewed as being at the right end of the Architecture Continuum, and are the most relevant to the IT customer community, since they describe and guide the final deployment of solution components for a particular enterprise or extended network of connected enterprises.

Question: According to TOGAF, which one of the following is described as a view of the Architecture Repository and provides methods for classifying architecture and solution artifacts as they evolve?
A. Architecture Landscape
B. Architecture Governance Repository
C. Enterprise Continuum
D. Governance Log
E. Standards Information Base
You answered
The correct answer is: C
The Enterprise Continuum provides a view of the Architecture Repository that shows the evolution of these related architectures from generic to specific, from abstract to concrete, and from logical to physical.

Question: Which one of the following represents the detailed construction of the architectures defined in the Architecture Continuum?
A. Architecture Building Blocks
B. Conceptual Models
C. Foundation Architectures
D. Reference Models
E. Solution Building Blocks
You answered
The correct answer is: E
The Solutions Continuum defines what is available in the organizational environment as re-usable Solution Building Blocks (SBBs).

Question: An organization has bought a large enterprise application. As a result, which of the following could be included in the organization’s Solutions Continuum?
A. A reference implementation of the Foundation Architecture
B. A reference implementation of the Technical Reference Model for the organization
C. Architecture Building Blocks for the organizations’ Industry-Specific Architecture
D. Detailed pricing information about the purchased products
E. Product information for purchased products
You answered
The correct answer is: E
The Solutions Continuum is a population of the architecture with reference building blocks - either purchased products or built components - that represent a solution to the enterprise's business need expressed at that level.

Question: Complete the sentence: All of the following are technology-related drivers for architecture Change Requests, except __________
A. asset management cost reductions
B. new technology reports
C. standards initiatives
D. strategic change
E. technology withdrawal
You answered
The correct answer is: D
Strategic change is a business driver.
ADM Phases

Question: Complete the sentence: In Phase C, when an existing application is to be replaced, the Data Architecture should______________
A. be re-factored to align with the technology infrastructure
B. describe how this change impacts other projects
C. identify the data migration requirements
D. include the application interoperability requirements
E. estimate the effort required to overcome any issues
You answered
The correct answer is: C
When an existing application is replaced, there will be a critical need to migrate data (master, transactional, and reference) to the new application. The Data Architecture should identify data migration requirements and also provide indicators as to the level of transformation, weeding, and cleansing that will be required to present data in a format that meets the requirements and constraints of the target application.

Question: The approach of the Preliminary Phase is about defining “where, what, why, who, and how we do architecture” in the enterprise concerned. Which one of the following statements is not correct?
A. “Where” can be seen as scoping the enterprise concerned
B. “Why” can be seen as the key drivers and elements in the context of the organization
C. “Who” can be seen as defining the sponsor responsible for performing the architectural work
D. “How” is determined by the frameworks selected and the methodologies that are going to be used
You answered
The correct answer is: C
Who is to identify the sponsor stakeholder(s) and other major stakeholders impacted by the business directive to create an enterprise architecture and determine their requirements and priorities from the enterprise, their relationships with the enterprise, and required working behaviors with each other. Note in this answer it incorrectly suggests that the sponsor performs the work.

Question: In which phase of the ADM are the gap analysis results from the four architecture domains taken into account?
A. Phase E
B. Phase F
C. Phase G
D. Phase H
E. Requirements Management
You answered
The correct answer is: A
In Phase E the gap analysis results from all architecture domains are taken into account.

Question: In Phase D, which of the following resources from the Architecture Repository should be considered in the development of the Technology Architecture?
A. Architecture Vision
B. Business rules, job descriptions
C. Implementation and Migration Plan
D. Stakeholder Map
E. TOGAF Technical Reference Model
You answered
The correct answer is: E
The TOGAF TRM should be considered in the development of the Technology Architecture in Phase D.

Question: Complete the sentence: All of the following are part of the approach to the Preliminary Phase, except ____________
A. defining the enterprise
B. identifying key drivers and elements in the organizational context
C. defining Architecture Contracts
D. defining the framework to be used
E. defining the requirements for architecture work
You answered
The correct answer is: C
Architecture Contracts are prepared and issued in Phase G.

Question: In which phase of the TOGAF ADM do activities include assessing the dependencies, costs, and benefits of the migration projects?
A. Phase E
B. Phase F
C. Phase G
D. Phase H
E. Requirements Management
You answered
The correct answer is: B
Phase F activities include assessing the dependencies, costs, and benefits of the various migration projects.

Question: Complete the sentence: Phase A is initiated upon receipt of ___________
A. approval from the Chief Information Officer
B. a directive from the Chief Executive Officer
C. a Request for Architecture Work from the sponsoring organization
D. the Implementation and Migration Plan
E. the Requirements Analysis document
You answered
The correct answer is: C
Phase A starts with receipt of a Request for Architecture Work from the sponsoring organization to the architecture organization.

Question: Complete the sentence: Business Architecture is the first architecture activity undertaken since __________
A. it focuses on identifying and defining the key applications used in the enterprise
B. it provides knowledge that is a prerequisite for undertaking work in the other architecture domains
C. it defines the physical realization of an architectural solution
D. it finalizes the Architecture Vision and Architecture Definition Documents
E. it mobilizes supporting operations to support the ongoing architecture development
You answered
The correct answer is: B
A knowledge of the Business Architecture is a prerequisite for architecture work in any other domain (Data, Application, Technology), and is therefore the first architecture activity that needs to be undertaken, if not catered for already in other organizational processes (enterprise planning, strategic business planning, business process re-engineering, etc.).

Question: Complete the sentence: According to TOGAF, Capability-Based Planning is ____
A. a tactical planning technique that enhances system performance
B. focused on technical capabilities
C. focused on staffing and human resource management issues
D. focused on business outcomes
E. relevant to IT architecture
You answered
The correct answer is: D
Capability-Based Planning is a business planning technique that focuses on business outcomes. It focuses on the planning, engineering, and delivery of strategic business capabilities to the enterprise. It is business-driven and business-led and combines the requisite efforts of all lines of business to achieve the desired capability. Capability-Based Planning accommodates most, if not all, of the corporate business models and is especially useful in organizations where a latent capability to respond (e.g., an emergency preparedness unit) is required and the same resources are involved in multiple capabilities.
ADM Guidelines and Techniques

Question: In which phase of the ADM is an initial assessment of Business Transformation Readiness performed?
A. Preliminary Phase
B. Phase A
C. Phase B
D. Phase E
E. Phase F
You answered
The correct answer is: B
Business Transformation Readiness is first assessed in Phase A, so actions can be worked into Phases E and F in the Implementation and Migration Plan.

Question: Which of the following is defined as the risk categorization after the implementation of mitigating actions?
A. Actual Level of Risk
B. Initial Level of Risk
C. Residual Level of Risk
D. Strategic Level of Risk
You answered
The correct answer is: C
The risk categorization after implementation of mitigating actions is known as "Residual Level of Risk".

Question: Which one of the statements about Architecture Principles is not correct?
A. A good set of principles is complete.
B. A principle is a general rule or guideline.
C. A principle is transient and updated frequently.
D. A principle statement should be succinct and unambiguous.
E. They are described in a standard way.
You answered
The correct answer is: C
Principles are intended to be enduring and seldom amended.

Question: What technique does TOGAF recommend for identifying and understanding the requirements that an architecture must address?
A. Stakeholder management
B. Risk management
C. Gap analysis
D. Business scenarios
E. Architecture principles
You answered
The correct answer is: D
Business scenarios are an important technique that may be used at various stages of the enterprise architecture, principally the Architecture Vision and the Business Architecture, but in other architecture domains as well, if required, to derive the characteristics of the architecture directly from the high-level requirements of the business. They are used to help identify and understand business needs, and thereby to derive the business requirements that the architecture development has to address.

Question: Gap analysis is a key step in validating the architecture in Phase B: Business Architecture. Which one of the following statements is true?
A. Gap analysis highlights services that are available
B. Gap analysis highlights the impacts of change
C. Gap analysis highlights services that are yet to be procured
D. Gap analysis identifies areas where the Data Architecture needs to change
E. Gap analysis can be used to resolve conflicts amongst different viewpoints
You answered
The correct answer is: C
A key step in validating an architecture is to consider what may have been forgotten.

Question: According to TOGAF, which of the following best describes why an Architecture Board should be established?
A. To conduct performance appraisals on the enterprise architecture team
B. To conduct source code design reviews
C. To ensure that new systems are introduced in a managed change process
D. To facilitate the adoption of advanced technologies
E. To oversee the implementation of the governance strategy
You answered
The correct answer is: E
A key element in a successful architecture governance strategy is a cross-organization Architecture Board to oversee the implementation of the strategy.
Architecture Governance

Question: TOGAF defines levels of architecture conformance. Which of the following describes a situation where some features in an architecture specification have not been implemented, but those that have are in accordance with the specification?
A. Compliant
B. Conformant
C. Consistent
D. Irrelevant
E. Non-conformant
You answered
The correct answer is: A
TOGAF describes "compliant" as a situation where some features in an architecture specification have not been implemented, but those that have are in accordance with the specification.

Question: Which Architecture Governance process ensures that regulatory requirements are being met?
A. Business control
B. Compliance
C. Dispensation
D. Environment management
E. Policy management
You answered
The correct answer is: B
The Compliance process ensures regulatory requirements are being met.

Question: When applying a cycle of the ADM with the Architecture Vision to establish an Architecture Capability, which phase does TOGAF Part VII recommend defines the structure of the organization’s Architecture Repository?
A. Application Architecture
B. Business Architecture
C. Data Architecture
D. Preliminary Phase
E. Technology Architecture
You answered
The correct answer is: C
The Data Architecture would define the structure of the organization's Enterprise Continuum and Architecture Repository.
Architecture View, Viewpoints, and Stakeholders

Question: Views and viewpoints are used by an architect to capture or model the design of a system architecture. Which one of the following statements is true?
A. A view is the perspective of an individual stakeholder
B. A viewpoint is the perspective of an individual stakeholder
C. Different stakeholders always share the same views
D. Different stakeholders always share the same viewpoints
You answered
The correct answer is: B
A view is what you see. A viewpoint is where you are looking from - the vantage point or perspective that determines what you see.

Question: Which of the following is a Core Metamodel Entity?
A. Department.
B. Framework.
C. Processes.
D. Organisation.
You answered
The correct answer is: D
Concerns are the key interests that are crucially important to the stakeholders in the system, and determine the acceptability of the system. Concerns may pertain to any aspect of the system’s functioning, development, or operation, including considerations such as performance, reliability, security, distribution, and evolvability. The terms "concern" and "requirement" are not synonymous. Concerns are the root of the process of decomposition into requirements. Concerns are represented in the architecture by these requirements. Requirements should be SMART (e.g., specific metrics).
Building Blocks

Question: Which of the following is considered by TOGAF as an attribute of a good building block?
A. A building block that is re-usable
B. A building block meeting business needs
C. A building block with public interfaces
D. A building block that guides the development of solutions
E. A building block that is product-aware
You answered
The correct answer is: A
TOGAF considers re-usability an attribute of a good building block.

Question: Which one of the following best describes the content of an Architecture Building Block?
A. Defined implementation
B. Fundamental functionality
C. Products and components used to implement the functionality
D. Product or vendor-aware
E. Specific functionality
You answered
The correct answer is: B
An ABB has fundamental functionality and attributes: semantic, unambiguous, including security capability and manageability.
ADM Deliverables

Question: Which one of the following statements does not correctly describe architecture deliverables?
A. They are consumed and produced across the ADM cycle
B. They are defined to avoid tailoring the inputs and outputs of the ADM cycle
C. They are typically contractual work products of an architecture project
D. They are usually reviewed and signed off by the stakeholders
You answered
The correct answer is: B
TOGAF provides a typical baseline of architecture deliverables in order to better define the activities required in the ADM and act as a starting point for tailoring within a specific organization.

Question: What TOGAF deliverable identifies changes that are needed to the current architecture requirements and specification, and also documents the implications of change?
A. Requirements Impact Assessment
B. Architecture Vision
C. Gap Analysis Results
D. Architecture Landscape
E. Architecture Roadmap
You answered
The correct answer is: A
Throughout the ADM, new information is collected relating to an architecture. As this information is gathered, new facts may come to light that invalidate existing aspects of the architecture. A Requirements Impact Assessment assesses the current architecture requirements and specification to identify changes that should be made and the implications of those changes.
TOGAF Ref. Model

Question: Which of the following best describes the purpose of the TRM?
A. To provide a generic framework for IT governance
B. To provide a list of standards
C. To provide a method for architecture development
D. To provide a system engineering viewpoint on a possible solution
E. To provide a visual model, and core terminology for generic platform services
You answered
The correct answer is: E
The TOGAF Foundation Architecture is an architecture of generic services and functions that provides a foundation on which more specific architectures and architectural components can be built. This Foundation Architecture is embodied within the Technical Reference Model (TRM), which provides a model and taxonomy of generic platform services.

Question: Where does the Integrated Information Infrastructure Reference Model fit in terms of the Enterprise Continuum?
A. Common Systems Architectures
B. Foundation Architectures
C. Industry Architectures
D. Organization-Specific Architectures
You answered
The correct answer is: A
The TOGAF Integrated Information Infrastructure Reference Model (III-RM) is a Common Systems Architecture that focuses on the requirements, building blocks, and standards relating to the vision of Boundaryless Information Flow.

Test 5

Question: Which of the following describes an architecture from a specific view point?
A. A deliverable
B. A building block
C. An Architectural Building Block
D. An artifact
E. A Solution Building Block
You answered
The correct answer is: D

Question: Which one of the following is not a characteristic of a building block?
A. Building blocks are potentially reusable component of business, IT or architectural capability
B. Building blocks cannot be decomposed into smaller supporting building blocks
C. Building blocks can be combined with other building blocks to deliver architectures and solutions
D. Building blocks can consist just of name or an outline description
E. Building blocks can be defined at various levels of detail
You answered
The correct answer is: B

Question: What kinds of architecture does TOGAF deal with?
A. Business, information, technology and application
B. Functional, data, technology and business
C. Application, data, infrastructure and business
D. Technology, application, integration and business
E. Technology, data, application and business
You answered
The correct answer is: E

Question: Which of the following is not true of the Architecture Development Method?
A. The ADM explains how generic solutions can be specialized to support an organisation
B. The ADM has ten phases
C. The ADM provides a tested process for developing architectures
D. The ADM is iterative
E. The ADM allows organisations to transform their enterprise in response to business goals and opportunities
You answered
The correct answer is: A

Question: Which Phase of the ADM describes the defining scope and identification of stakeholders?
A. Opportunities and Solutions
B. Architecture Vision
C. Preliminary Phase
D. This activity occurs outside of the ADM
E. Requirements management
You answered
The correct answer is: B

Question: Which of the following is incorrect when describing Architecture Deliverables?
A. Architecture Deliverables contain Artifacts
B. Artifacts within deliverables may include Catalogs, Matrices and Diagrams
C. An Architecture Definition Document is an architectural deliverable
D. Architecture Deliverables may be composed of more than one artifact
E. Deliverables cannot be used as building blocks
You answered
The correct answer is: E

Question: Which of the following is not part of the description of the Enterprise Continuum?
A. The Enterprise Continuum provides a view of the Architecture Repository
B. The Enterprise Continuum uses the structure in the architecture Repository for the classification of assets
C. The Enterprise Continuum comprises two complementary concepts: the Architecture Continuum and the Solutions Continuum
D. The Enterprise Continuum explains how generic solutions can be specialised to support a particular organisation
E. The Enterprise Continuum contains Architecture Context and Requirements, the Architecture Continuum, the Solutions Continuum and Deployed Solutions
You answered
The correct answer is: B

Question: The major components within an Architecture Repository are:
A. Architecture Metamodel, Reference Library, Architecture Landscape, Standards Information Base, Governance Log and Architecture Capability
B. Architecture Metamodel, Reference Library, Architecture Landscape, Standards Information Base, Architecture Board and Architecture Capability
C. Architecture Metamodel, Reference Library, Architecture Landscape, Standards Information Base, Architecture Board and Governance Log
D. Architecture Metamodel, Reference Library, Architecture Landscape, Standards Information Base, Architecture Board, Architecture Capability, External Reference Models, External Standards and Architecture Board
E. Architecture Metamodel, Reference Library, Architecture Landscape, Standards Information Base, Governance Log, Architecture Capability and the Enterprise Continuum
You answered
The correct answer is: A

Question: Under Architectural Capability as an Operational Entity TOGAF states several benefits of architecture governance. Which of the following is not stated as a benefit of Architecture Governance in TOGAF?
A. Value creation through monitoring, measuring, evaluation and feedback
B. Greater shareholder value
C. Protection of the existing asset base through reuse
D. Managing compliance
E. Controlled risk managementTOGAF 9 Example Multiple Choice Questions
You answered
The correct answer is: D

Question: The Architectural Representation of assets deployed within the operating enterprise’Is the TOGAF definition of which term?
A. Architecture view
B. Artifact
C. View
D. Architecture Landscape
E. Solution Architecture
You answered
The correct answer is: E

Question: The TOGAF Document categorisation Model consists of four categories. Which one is not a TOGAF Document category?
A. TOGAF Supporting
B. TOGAF Mandated
C. TOGAF Core
D. TOGAF Recommended
E. TOGAF Supplemental
You answered
The correct answer is: D

Question: Within Phase C: Information Systems Architectures of the ADM which of the following is not a step stated by TOGAF
A. Finalise the application architecture
B. Document dependencies and assumptions
C. Develop Target Application Architecture Description
D. Conduct formal stakeholder review
E. Create Architecture Definition Document
You answered
The correct answer is: B

Question: The objectives for Phase F, Migration Planning, does not include which of the following:
A. To create evolve and monitor the detailed Implementation and Migration plan
B. To prioritize all work packages, projects and building blocks
C. To confirm the Transition Architectures defined in Phase E
D. To finalise the Architecture Vision and Architecture Definition Document
E. To generate and gain consensus on an outline Implementation and Migration Strategy
You answered
The correct answer is: E

Question: Which of the following is not listed as a Technique for Architecture Development in TOGAF?
A. Architecture Patterns
B. Architecture Change Management
C. Risk Management
D. Capability Based Planning
E. Gap AnalysisTOGAF 9 Example Multiple Choice Questions
You answered
The correct answer is: B

Question: Which of the following is not true of Principles in TOGAF?
A. Architecture Principles maybe established at one or all three levels of enterprise, Information Technology and Architecture
B. Principles are developed by the lead enterprise architect in conjunction with the CIO, the Architecture Board and other key stakeholders
C. Principles must be Understandable, Robust, Complete, Consistent and Stable
D. The Components of Architecture Principles are Name, Statement, Rationale, Implications and Risks and Issues.
E. Principles are inter-related and need to be applied as a set. Principles will sometimes compete.
You answered
The correct answer is: B

Question: TOGAF defines four iteration cycles around the ADM phases. Which of the following answers correctly defines these four cycles?
A. Architecture Definition, Architecture Delivery, Architecture Planning and Architecture Governance
B. Architecture Context, Architecture Definition, Transition Planning and Architecture Governance
C. Architecture Context, Architecture Definition, Transition Planning and Architecture Requirements Management
D. Architecture Scope, Architecture Design, Transition Planning and Architecture Governance
E. Architecture Context, Architecture Definition, Architecture Planning and Architecture Requirements Management
You answered
The correct answer is: D

Question: Which of the following correctly defines the Organisation category in the Architecture Content Framework?
A. Organisation, Location and Capabilities
B. Actor, Location, Role and Capabilities
C. Requirements, Actor and Function
D. Location, Actor, Role, and Organisation
E. Actor, Location and Structure
You answered
The correct answer is: D

Question: Which of the following is not a Core Metamodel Entity?
A. Standards
B. Platform Service
C. Data Entity
D. Function
E. Organisation
You answered
The correct answer is: A

Question: Within the Taxonomy of Architecture Viewpoints which of the following is a Core Diagram of the Architecture Vision?
A. Stakeholder Map Matrix
B. Principles Catalog
C. Solution Concept Diagram
D. Benefits Diagram
E. Enterprise Manageability Diagram
You answered
The correct answer is: C

Question: The Implementation and Migration Plan deliverable has the following content, except:
A. Implementation and Migration Strategy
B. Implementation Plan
C. Project Charters
D. Work Package Portfolio
E. Interactions with other management frameworks
You answered
The correct answer is: D

Question: The Architecture Continuum consists of which types of architecture
A. Foundation Architectures, Solutions Architectures, Industry Architectures and Organisation Specific Architectures
B. Baseline Architectures, Solution Architectures, Industry Architecture and Business Specific Architectures
C. Foundation Architectures, Common Systems Architecture, Industry Architectures and Organisation Specific Architectures
D. Foundation Architectures, Common Systems Architecture, Industry Architectures and Business Specific Architectures
E. Baseline Architectures, Common Systems Architecture, Industry Architectures and Organisation Specific Architectures
You answered
The correct answer is: C

Question: Which of the following answers does not follow the TOGAF definition?
A. A viewpoint is where you are looking from – the vantage point or perspective that determines what you see
B. A view is a representation of a whole system from the perspective of a related set of concerns
C. An architectural description is a collection of artefacts that document an architecture
D. Concerns are the key interests that are crucially important to the stakeholders in the system and determine the acceptability of the system.
E. A system is a regularly interacting or interdependent group of items forming a unified whole
You answered
The correct answer is: E

Question: The following text is taken from the Terminology section of Architecture Compliance on TOGAF ‘All the features in the architecture specification are implemented in accordance with the specification, but some more features are implemented that are not in accordance with it.’ This text describes which level of architecture compliance?
A. Irrelevant
B. Consistent
C. Compliant
D. Conformant
E. Non-conformant
You answered
The correct answer is: D

Question: The TOGAF defined process for Risk Management consists of which activities?
A. Risk Classification, Risk identification, Initial Risk Assessment, Risk Mitigation and residual risk assessment, and Risk Monitoring
B. Risk Identification, Initial Risk Quantification, Risk Mitigation and residual risk assessment, and Risk Response Control
C. Risk Identification, Risk Quantification, Risk Response Development and Risk Response Control
D. Risk Classification, Risk Quantification, Initial Risk Assessment, Risk Response Development and residual risk assessment, and Risk Monitoring
E. Risk classification, Risk identification, Initial Risk Assessment, Risk Response Development and Risk Response Control
You answered
The correct answer is: A

Question: TOGAF classifies risk in response to their likely effect and frequency. Which of the following answers does not come from the suggested classification system in TOGAF?
A. Effect can be classified as ‘Catastrophic, Crucial, Marginal and Negligible’
B. Frequency can be classified as ‘Frequent, Likely, Occasional, Seldom and Unlikely’
C. The Impact of a risk, that is the combination of Effect and Frequency can be classified as ‘High Risk, Moderate Risk and Low Risk’
D. Risks with an Unlikely frequency and Negligible effect are classified with an impact of Low Risk
E. Risks with a Likely frequency and Marginal effect are classified with an impact of Moderate Risk
You answered
The correct answer is: C

Question: Which one of the following statements does not come from TOGAF Risk Management?
A. Risk Management is an integral part of enterprise architecture
B. Risk mitigation refers to the identification, planning, and conduct of actions that will reduce the risk to an acceptable level
C. Residual risks have to be approved by the IT governance framework
D. Initial Level of Risk is the risk categorisation prior to determining and implementing mitigating actions
E. The activities in risk management are Risk Identification, Risk Quantification, Risk Response Development and Risk Response Control
You answered
The correct answer is: E

Question: TOGAF states the basic premise of Gap Analysis is to:
A. Highlight a shortfall between the Baseline Architecture and the Target Architecture
B. Highlight stakeholders which have not been addressed
C. Validate an architecture to consider what may have been forgotten
D. Compare Baseline Architecture ABBs with Target Architecture ABBs identifying the building blocks which are ‘New, Eliminated and Included’
E. Identify potential sources of gaps from the business, data, applications and technology domains
You answered
The correct answer is: A

Question: Which answer is not an accurate statement about TOGAF Business Scenarios?
A. Business Scenarios describe a method for deriving business requirements for architecture and the implied technical requirements
B. Business Scenarios define requirements for sharing information and services within an organisation
C. Business Scenarios are principally used during the Architecture Vision and Business Architecture phases of the ADM.
D. Business Scenarios describe a business process and application, the business and technology environment, the actors and the desired outcome of proper execution
E. A good business scenario is Specific, Measureable, Actionable, Realistic and Time-bound
You answered
The correct answer is: B

Question: TOGAF states that establishing and operating an Architecture Board is more than offset by the savings accrued from preventing one off solutions and unconstrained development. Which of the following answers does TOGAF not state as a reason for establishing an Architecture Board?
A. Higher risk
B. High cost of operation and support
C. High costs of development
D. Lower quality
E. Better understanding of the business and their requirements
You answered
The correct answer is: E

Question: Which of the following is not one of the Categories of Skills in the TOGAF Architecture Skills Framework?
A. Generic Skills
B. Program or Project Management Skills
C. Legal Environment
D. Procurement and Vendor Management
E. IT General Knowledge Skills
You answered
The correct answer is: D

Question: TOGAF deals with the architecture for; Business, Data, Applications and ____
A. Transition
B. Infrastructure
C. Technology
D. Teams
E. Operations
You answered
The correct answer is: C

Question: The Enterprise Continuum contains the Architecture Continuum and ____
A. Technology Continuum
B. Solutions Continuum
C. Requirements Continuum
D. Business Continuum
E. Solutions Building Blocks
You answered
The correct answer is: B

Question: The Enterprise Continuum provides a model for structuring an architecture ____
A. Repository
B. Schematic
C. Design
D. Solution
E. Artifact
You answered
The correct answer is: A

Question: The TOGAF Resource Base is provided to be of assistance to the architect in the use of the ____
A. Repository
B. Implementation
C. Plans
D. Solutions
E. ADM
You answered
The correct answer is: E

Question: Including the Preliminary Phase, the ADM Cycle contains how many phases?
A. 11
B. 10
C. 8
D. 9
E. 12
You answered
The correct answer is: B

Question: The TOGAF Qualities of Principles are; Understandability, Robustness, Completeness, Consistency and ____
A. Accessibility
B. Availability
C. Stability
D. Confidentiality
E. Resilience
You answered
The correct answer is: C

Question: Business Requirements are of no value in TOGAF.
A. TRUE
B. FALSE
C. Sometimes
D. Unsure
E. Not Applicable
You answered
The correct answer is: B

Question: The TOGAF Foundation Architecture comprises of the Technical Reference Model and the Standards Information ____
A. Architecture
B. Base
C. Plans
D. Strategy
E. Business
You answered
The correct answer is: B

Question: The Resource Base contains information on a set of techniques for evaluating and quantifying an organisations EA ____
A. Auditability
B. Compliance
C. Direction
D. Maturity
E. Stage
You answered
The correct answer is: D

Question: In TOGAF, the letters ADM stand for Architecture Development _____
A. Meaning
B. Method
C. Model
D. Maturity
E. Metric
You answered
The correct answer is: B

Establecer un JVM para un dominio especifico de GlassFish

2016-09-27T15:25:00.001-05:00

C:\glassfish\config\asenv.bat

REM set AS_JAVA=C:\Program Files\Java\jdk1.6.0_04\jre/..
set AS_JAVA=C:\Program Files\Java\jdk1.5.0_16

Fuente: http://alvinalexander.com/blog/post/java/fixing-glassfish-jdk-path-problem-solved

Ablebits Add-ins for Microsoft Excel 2016, 2013-2007

2016-08-10T09:58:00.002-05:00

Link: https://www.ablebits.com/

Add-ins for Microsoft Excel 2016, 2013-2007

Como realizar mantenimiento a base de datos MySQL

2016-07-27T11:41:00.005-05:00

Fuente: http://www.thegeekstuff.com/2011/12/mysqlcheck/
Fuente: http://dev.mysql.com/doc/refman/5.7/en/mysqlcheck.html

When your mysql table gets corrupted, use mysqlcheck command to repair it.

Mysqlcheck command checks, repairs, optimizes and analyzes the tables.

1. Check a Specific Table in a Database

If your application gives an error message saying that a specific table is corrupted, execute the mysqlcheck command to check that one table.

The following example checks employee table in thegeekstuff database.

# mysqlcheck -c thegeekstuff employee -u root -p
Enter password:
thegeekstuff.employee    OK

You should pass the username/password to the mysqlcheck command. If not, you’ll get the following error message.

# mysqlcheck -c thegeekstuff employee
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect

Please note that myisamchk command that we discussed a while back works similar to the mysqlcheck command. However, the advantage of mysqlcheck command is that it can be executed when the mysql daemon is running. So, using mysqlcheck command you can check and repair corrupted table while the database is still running.

2. Check All Tables in a Database

To check all the tables in a particular database, don’t specify the table name. Just specify the database name.

The following example checks all the tables in the alfresco database.

# mysqlcheck -c alfresco  -u root -p
Enter password:
alfresco.JBPM_ACTION                               OK
alfresco.JBPM_BYTEARRAY                            OK
alfresco.JBPM_BYTEBLOCK                            OK
alfresco.JBPM_COMMENT                              OK
alfresco.JBPM_DECISIONCONDITIONS                   OK
alfresco.JBPM_DELEGATION                           OK
alfresco.JBPM_EVENT                                OK
..

3. Check All Tables and All Databases

To check all the tables and all the databases use the “–all-databases” along with -c option as shown below.

# mysqlcheck -c  -u root -p --all-databases
Enter password:
thegeekstuff.employee                              OK
alfresco.JBPM_ACTION                               OK
alfresco.JBPM_BYTEARRAY                            OK
alfresco.JBPM_BYTEBLOCK                            OK
..
..
mysql.help_category
error    : Table upgrade required. Please do "REPAIR TABLE `help_category`" or dump/reload to fix it!
mysql.help_keyword
error    : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" or dump/reload to fix it!
..

If you want to check all tables of few databases, specify the database names using “–databases”.

The following example checks all the tables in thegeekstuff and alfresco database.

# mysqlcheck -c  -u root -p --databases thegeekstuff alfresco
Enter password:
thegeekstuff.employee                              OK
alfresco.JBPM_ACTION                               OK
alfresco.JBPM_BYTEARRAY                            OK
alfresco.JBPM_BYTEBLOCK                            OK
..

4. Analyze Tables using Mysqlcheck

The following analyzes employee table that is located in thegeekstuff database.

# mysqlcheck -a thegeekstuff employee -u root -p
Enter password:
thegeekstuff.employee   Table is already up to date

Internally mysqlcheck command uses “ANALYZE TABLE” command. While mysqlcheck is executing the analyze command the table is locked and available for other process only in the read mode.

5. Optimize Tables using Mysqlcheck

The following optimizes employee table that is located in thegeekstuff database.

# mysqlcheck -o thegeekstuff employee -u root -p
Enter password:
thegeekstuff.employee         OK

Internally mysqlcheck command uses “OPTIMIZE TABLE” command. When you delete lot of rows from a table, optimizing it helps to get the unused space and defragment the data file. This might improve performance on huge tables that has gone through several updates.

6. Repair Tables using Mysqlcheck

The following repairs employee table that is located in thegeekstuff database.

# mysqlcheck -r thegeekstuff employee -u root -p
Enter password:
thegeekstuff.employee        OK

Internally mysqlcheck command uses “REPAIR TABLE” command. This will repair and fix a corrupted MyISAM and archive tables.

7. Combine Check, Optimize, and Repair Tables

Instead of checking and repairing separately. You can combine check, optimize and repair functionality together using “–auto-repair” as shown below.

The following checks, optimizes and repairs all the corrupted table in thegeekstuff database.

# mysqlcheck -u root -p --auto-repair -c -o thegeekstuff

You an also check, optimize and repair all the tables across all your databases using the following command.

# mysqlcheck -u root -p --auto-repair -c -o --all-databases

If you want to know what the command is doing while it is checking, add the –debug-info as shown below. This is helpful while you are checking a huge table.

# mysqlcheck --debug-info -u root -p --auto-repair -c -o thegeekstuff employee
Enter password:
thegeekstuff.employee  Table is already up to date

User time 0.00, System time 0.00
Maximum resident set size 0, Integral resident set size 0
Non-physical pagefaults 344, Physical pagefaults 0, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 12, Involuntary context switches 9

8. Additional Useful Mysqlcheck Options

The following are some of the key options that you can use along with mysqlcheck.

-A, –all-databases Consider all the databases
-a, –analyze Analyze tables
-1, –all-in-1 Use one query per database with tables listed in a comma separated way
–auto-repair Repair the table automatically it if is corrupted
-c, –check Check table errors
-C, –check-only-changed Check tables that are changed since last check
-g, –check-upgrade Check for version dependent changes in the tables
-B, –databases Check more than one databases
-F, –fast Check tables that are not closed properly
–fix-db-names Fix DB names
–fix-table-names Fix table names
-f, –force Continue even when there is an error
-e, –extended Perform extended check on a table. This will take a long time to execute.
-m, –medium-check Faster than extended check option, but does most checks
-o, –optimize Optimize tables
-q, –quick Faster than medium check option
-r, –repair Fix the table corruption

Desencriptar!

MYSQL: Recuperar base de datos mediante los archivos FRM, IDB, MAD, MAI

Sección A: Para tablas engine InnoDB

Sección B: Para tablas engine Aria

Sección C: Consulta para recuperar los Procedimientos Almacenados

Sección D: Consulta para generar los script de creación de índices de las tablas

Sección E: Consulta para generar los script de eliminación de índices de las tablas

Oracle Cloud: Agregar clave SSH pública para acceso remoto

Bitnami: Configurar Let's Encrypt SSL en Apache 2.4

Generar un certificado SSL

Revocar un certificado SSL

Recargar archivos PHP en el navegador usando Visual Studio Code

Crear módulos en JavaScript

Patrón módulo

Patrón singleton

Patrón lanzador o inicializador

Exportar tabla HTML a Excel con JavaScript (Opción 02)

Exportar tabla HTML a Excel con JavaScript (Opción 01)

Instalar escritorio remoto XRDP en Ubuntu 20.0 minimal

Si deja de funcionar el Ctrl+C Ctrl+V

Si deseas eliminar un usuario remoto

Restaurar o corregir sesión xfce

Si luego del login se desconecta del escritorio remoto

Configurar Let's Encrypt SSL en Apache 2.4 y Centos 8

Either get and install your certificates...

Or, just get a certificate

Cómo configurar depurador de código PHP en Visual Code

XAMPP 7.4.25 Configuración de VHOST en ambiente de desarrollo

Oracle Cloud: Acceso remoto MariaDB en CentOS 7 Linux Bitnami

Oracle Cloud: Instalar WordPress 4.5 en CentOS 7 Linux con Docker

Oracle Cloud: Instalar WordPress 5.7 en CentOS 7 Linux

Oracle Cloud: Instalar WordPress 5.6 en RHEL 8 / CentOS 8 Linux

Balanceo de carga con GlassFish

Instalar certificado en Glassfish

SQL: Tamaño de tablas

SQL Server: While cambio de cursores

FUNCIONES DE FECHA ÚTILES EN SQL SERVER.

Encuestas en MOODLE

Preguntas de examen de certificación TOGAF

Establecer un JVM para un dominio especifico de GlassFish

Ablebits Add-ins for Microsoft Excel 2016, 2013-2007

Como realizar mantenimiento a base de datos MySQL

1. Check a Specific Table in a Database

2. Check All Tables in a Database

3. Check All Tables and All Databases

4. Analyze Tables using Mysqlcheck

5. Optimize Tables using Mysqlcheck

6. Repair Tables using Mysqlcheck

7. Combine Check, Optimize, and Repair Tables

8. Additional Useful Mysqlcheck Options