¡GoConqr estrena diseño! Cuéntanos qué te parece.

Regístrate gratis

Test

Azure Datos

Diego Vasquez 9 preguntas

Hacer el test

Preguntas del test (9)

  1. 1Identify the missing word(s) in the following sentence within the context of Microsoft Azure.
    Setting Global parameters in an Azure Data Factory pipeline … [?]
    1. Acannot be overridden if you wish to use continuous integration and deployment process.
    2. Breferences to an attribute like a dataset or data flow, this reroutes default parameter values through the resource parameter.
    3. Callows you to use constants for consumption in pipeline expressions.
    4. DNone of the listed options.
  2. 2Scenario: The company you work at is in the Healthcare industry, which in turn is working with a specific health care provider. This healthcare provider only wants doctors and nurses to be able to access medical records. The billing department should not have access to view this data.
    Which type of security would typically be best used in for this scenario?
    1. AColumn-level security
    2. BDynamic Data Masking
    3. CRow-level security
    4. DTable-level security
  3. 3Identify the missing word(s) in the following sentence within the context of Microsoft Azure.

    [?] logs every operation Azure Storage account activity in real time, and you can search the logs for specific requests. Filter based on the authentication mechanism, the success of the operation, or the resource that was accessed.
    1. AApplication Security Groups
    2. BStorage Analytics
    3. CAdvanced Data Security
    4. DNetwork Security Groups
    5. EAzure Advanced Threat Protection
  4. 4How do you cache data into the memory of the local executor for instant access?
    1. A.inMemory().save()
    2. B.cacheLocalExe()
    3. C.cache()
    4. D.save().inMemory()
  5. 5Azure Synapse Analytics supports querying both relational (dedicated and serverless SQL endpoints) and non-relational data (Azure Data Lake Storage Gen 2, Cosmos DB and Azure Blob Storage) at petabyte-scale using Transact SQL, supporting ANSI-compliant SQL language.

    The Azure Synapse SQL query language supports different features based on the resource model being used.

    Which of the below have support in both relational and non-relational data types? (Select all that apply)?
    1. ADDL statements (CREATE, ALTER, DROP)
    2. BUPDATE statement
    3. CData export
    4. DBuilt-in functions (analysis)
    5. EControl of flow
    6. FSELECT statement
    7. GMERGE statement
    8. HDELETE statement
    9. IBuilt-in functions (text)
    10. JINSERT statement
  6. 6Azure Advisor provides you with personalized messages that provide information on best practices to optimize the setup of your Azure services. It analyzes your resource configuration and usage telemetry and then recommends solutions for which of the following Azure metrics? (Select all that apply)
    1. AEncryption deficiencies
    2. BPerformance
    3. CCost effectiveness
    4. DReliability (formerly called High availability)
    5. ESecurity
  7. 7Scenario: O'Shaughnessy's is a fast food restaurant. The chain has stores nationwide and is rivalled by Big Belly Burgers. You have been hired by the company to advise on working with Microsoft Azure Data Lake Storage.
    At the moment, the team is planning the deployment of Azure Data Lake Storage Gen2.
    There are two reports which will access the data lake:
    • Report1: Reads three columns from a file that contains 50 columns.
    • Report2: Queries a single record based on a timestamp.
    As the Azure expert, the team is looking for you to recommend in which format to store the data in the data lake to support the reports. The solution must minimize read times.
    The options available are:
    a. AVRO
    b. CSV
    c. Parquet
    d. TSV
    Which should you recommend to O'Shaughnessy's for each report?
    1. AReport1: Parquet
      Report2: AVRO
    2. BReport1: CSV
      Report2: Parquet
    3. CReport1: Parquet
      Report2: TSV
    4. DReport1: CSV
      Report2: TSV
  8. 8Identify the missing word(s) in the following sentence within the context of Microsoft Azure.

    Within an Apache Spark Pool it is possible to configure a fixed size when you disable autoscaling. When you enable autoscale, you can set a minimum and maximum number of nodes in order to control the scale that you'd like. Once you have enabled autoscale, Synapse Analytics will monitor the resource load.

    It will continuously monitoring CPU usage, pending memory, free CPU, free memory, and the used memory per node for scaling decisions. It checks these metrics every [?] seconds and makes scaling decisions based on the values.
    1. A30
    2. B90
    3. C60
    4. D120
    5. E45
  9. 9Identify the missing word(s) in the following sentence within the context of Microsoft Azure.
    Azure Synapse Analytics can work by acting as the one stop shop to meet all of your analytical needs in an integrated environment.

    [?] offers both serverless and dedicated resource models to work with both descriptive and diagnostic analytical scenarios. This is a distributed query system that enables you to implement data warehousing and data virtualization scenarios using standard T-SQL.
    1. AAzure Cosmos DB
    2. BAzure Synapse Link
    3. CAzure Synapse SQL
    4. DAzure Synapse Pipelines
    5. EApache Spark for Azure Synapse

Información

Descripción
Curso Interno de Empresa Tecnología Test sobre Azure Datos, creado por Diego Vasquez el 09/11/2022.
Idioma
Español
Visitas
4
Valoración
Aún sin valoraciones
Valora este test
Valora este test

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué te parece el nuevo diseño?

¿Te gusta?