WorksheetsAzure Quiz 1
Total questions: 49
Worksheet time: 32mins
Which feature of Azure Synapse Analytics enables you to transfer data from one store to another and apply transformations to the data at scheduled intervals?
Serverless SQL pool
Pipelines
Apache Spark pool
You want to create a data warehouse in Azure Synapse Analytics in which the data is stored and queried in a relational data store. What kind of pool should you create?
Serverless SQL pool
Apache Spark pool
Dedicated SQL pool
A data analyst wants to analyze data by using Python code combined with text descriptions of the insights gained from the analysis. What should they use to perform the analysis?
A notebook connected to an Apache Spark pool
A KQL script connected to a Data Explorer pool
A SQL script connected to a serverless SQL pool
Which Azure Service is Azure Synapse Pipelines based on?
Azure Data Explorer
Azure Data Factory
Azure Stream Analytics
Which Azure Synapse Studio hub would you go to create Notebooks?
Data
Integrate
Develop
Which technology is typically used as a staging area in a modern data warehousing architecture?
Azure Data Lake
Azure Synapse Spark Pools
Azure Synapse SQL Pools
Which component enables you to perform code free transformations in Azure Synapse Analytics?
Studio
Mapping Data Flow
Copy activity
In which order should you load tables in the data warehouse?
Staging tables, then dimension tables, then fact tables
Dimension tables, then staging tables, then fact tables
Staging tables, then fact tables, then dimension tables
Which command should you use to load a staging table with data from files in the data lake?
COPY
INSERT
LOAD
When a customer changes their phone number, the change should be made in the existing row for that customer in the dimension table. What type of slowly changing dimension does this scenario require?
Type 0
Type 1
Type 2
... provides you with personalized messages that provide information on best practices to optimize the setup of your Azure services.
Azure Services
Azure Advisor
Azure Synapse Link
The logic for 'Leo' only to access the columns specified for the department he works in, is a logic that is located in the database tier, rather than on the application level data tier.
Column level security
Row level security
Which definition best describes Apache Spark?
A highly scalable relational database management system
A distributed platform for parallel data processing using multiple languages
A virtual server with a Python runtime
Which method of the Dataframe object is used to save a dataframe as a file?
toFile()
save()
write()
Which method is used to split the data across folders when saving a dataframe?
splitBy()
partitionBy()
distributeBy()
You've created an Azure Databricks workspace in which you plan to use code in notebooks to process data. What must you create in the workspace?
A SQL Warehouse
A Windows Server virtual machine
A Spark cluster
What feature of Delta Lake enables you to retrieve data from previous versions of a table?
Spark Structured Streaming
Catalog Tables
Time Travel
You need to share data visualizations, including charts and tables of data, with users in your organization. What should you create?
A table
A dashboard
A query
You want to create a visualization that updates dynamically based on a table in a streaming dataset in Power BI. What should you do?
Create a report from the dataset
Create a dashboard with a tile based on the streaming dataset
Export the streaming dataset to Excel and create a report from the Excel workbook
Which type of output should you use to ingest the results of an Azure Stream Analytics job into a dedicated SQL pool table in Azure Synapse Analytics?
Azure Synapse Analytics
Blob storage/ADLS Gen2
Azure Event Hubs
Which of the following are capabilities of Azure Cognitive Services? (Choose all that apply.)
Processes natural language to determine what a user is asking.
Performs translation from one language to another.
Acts as a virtual agent to interact with users in a humanlike way.
Analyzes photos to identify content within them.
Is the underlined portion of the following statement true, or does it need to be replaced with one of the other fragments that appear below? Azure Bot Services provides the capability to analyze photos and other data types to identify specific content.
is a stand-alone Azure service that cannot interact with other Azure services.
provides natural language translation services.
enables you to build virtual agents that interact with users in a humanlike way.
No change is needed.
Which of the following Azure services provides the ability to create workflow-based processes?
Functions
Bot Service
Logic Apps
None of the above
Which of the following correctly describe Azure Functions? (Choose all that apply.)
Functions are typically stateless but can be made stateful with the addition of a storage account.
Functions operate independently and cannot be integrated with Logic Apps.
You can use drag-and-drop features to create functions that automate processes.
Functions can be developed with any of several programming languages.
Is the underlined portion of the following statement true, or does it need to be replaced with one of the other fragments that appear below? Azure Artifacts is a component service of Azure DevOps that provides a repository for storing development artifacts such as compiled source code.
provides a means for managing development projects and individual items such as features and bugs.
is intended for open source code development projects.
works in conjunction with Azure Blueprints to provide a means of storing information about Azure resources.
No change is needed.
Which of the following is intended primarily for collaborating on open source development efforts?
Azure Repos
Azure Boards
GitHub
Azure DevTest Labs
Is the underlined portion of the following statement true, or does it need to be replaced with one of the other fragments that appear below? Azure DevTest Labs provides a customizable development environment in which your developers can collaborate on code projects.
provides alerting and monitoring tools to analyze telemetry from servers in an application test.
enables your development team to quickly and easily deploy virtual machines and other Azure resources to test an application, then decommission those resources.
can provision Windows servers but not Linux servers.
No change is needed.
Which of the following is the first step in deploying services to Azure?
Choosing a storage tier
Purchasing the appropriate Azure resources
Creating an Azure subscription
None of the above
You are deploying a new solution that requires four instances of Azure SQL Server in an existing subscription, and you receive a message that you need to increase the subscription limit to create these resources. Which option correctly describes how to increase the limit?
Modify the policy that is restricting you from creating the resource.
Use Azure Resource Manager to increase the limits.
You must create a new subscription and deploy the resources to it.
Open an online support case to have Microsoft increase the limit for you.
Which of the following is not an option for purchasing Azure services?
Enterprise agreement
Cloud solution provider
Web Direct
Unified Support
Which two of the following would potentially increase operational costs for an Azure solution that you have deployed?
The region in which the resources are deployed
The subscription in which the resources are deployed
The billing account used for the target subscription
Deploying resources across multiple regions
You are the Director of Infrastructure for your organization, which currently has no Azure subscriptions. Your CIO has requested an estimate of how much your organization can save by moving its entire data center to Azure. Which of the following should you use for an initial overall estimate?
Azure Advisor
Pricing Calculator
TCO Calculator
Create an Azure subscription and use the Azure Estimator tool to model costs.
Is the underlined portion of the following statement true, or does it need to be replaced with one of the other fragments that appear below? The Azure Pricing Calculator enables you to estimate the cost of a specific Azure solution based on the resources and services in that solution.
can calculate the estimated cost of moving a data center to Azure.
factors facilities costs such as power and cooling into an estimate.
is a downloadable tool that can help you calculate the costs of deploying an Azure solution.
No change is needed.
Which of the following use scenarios are appropriate for Azure Advisor? (Choose all that apply.)
Determining ways to reduce costs
Deploying security policies and initiatives based on recommendations from Microsoft
Getting recommendations for improving security
Viewing service health
Your organization completed a sizable Azure deployment over the past year encompassing compute, storage, big data, and serverless computing, with a relatively small DevOps component. As the IT Director, you have been tasked by the CIO with reducing Azure expenditures. You cannot reduce the resources you have deployed in Azure. Which option could provide the most significant cost savings?
Reviewing and resizing VMs
Moving resources to less expensive regions
Using Azure reservations to prepay for services
Moving from Azure SQL Database to Azure SQL Managed Instance
Which of the following is most likely to increase Azure operational costs?
Adding another subscription
Moving storage from the hot access tier to the archive tier
Deploying connected resources across multiple regions
None of the above
Is the underlined portion of the following statement true, or does it need to be replaced with one of the other fragments that appear below? Azure Hybrid Benefit is a cost-saving option offered by Microsoft for all Azure hybrid deployments.
enables you to leverage your existing Windows Server and SQL Server licenses that are covered by Software Assurance for deployments in Azure.
reduces pricing for network ingress traffic from your on-premises data center to Azure in a hybrid deployment.
enables you to leverage all your Microsoft perpetual licenses in Azure if those licenses are decommissioned in your on-premises data center.
No change is needed.
Which of the following enables you to define budgets for your subscriptions and receive notifications when spending crosses alert thresholds that you have set?
Azure Quota Management
Azure Budget Management
Azure Cost Management
Azure Monitor
You are planning to deploy a solution in Azure that comprises two VMs, each of which has a 99.5 percent SLA, and one Azure SQL Database with a 99.99 percent SLA. Which of the following is the resulting composite SLA for this scenario?
The lowest SLA value, 99.5 percent
The highest SLA value, 99.99 percent
The average of the three SLAs, or 99.97 percent
The product of the three SLAs, or 98.99 percent
You have deployed several VMs into Azure and need to increase the SLA for the VMs to meet mandated business requirements. Which of the following would achieve that requirement?
Adding more storage for the VMs
Deploying additional instances of the VMs to two or more availability zones
Increasing the number of VMs
None of the above
Is the underlined portion of the following statement true, or does it need to be replaced with one of the other fragments that appear below? An Azure service that is in public preview is available to public customers by invitation from Microsoft.
available to all Azure customers.
available only with an enterprise agreement.
subject to SLAs.
No change is needed.
Which of the following accurately describe Azure Services that are in private preview? (Choose all that apply.)
They are available for all customers in the United States only.
They are available for customers by invitation from Microsoft.
They are generally not subject to SLAs.
They are not guaranteed to move to general availability.
How much notice does Microsoft provide before it retires an Azure service?
30 days
6 months
12 months
5 years
You are a developer and need to deploy a single VM to test some code overnight. Which of the following management options is the best choice?
Azure PowerShell
Azure CLI
Azure portal
ARM templates
You are an infrastructure management engineer for your organization. You work most with Linux servers and are therefore very familiar with Bash and know what command you would use to retrieve specific properties of a VM. Which of the following management solutions should you use to retrieve a property of one of the VMs that you manage?
Azure PowerShell
Azure CLI
Azure portal
Azure Monitor
You are the Director of IT for your organization. Your CIO has asked you what methods or processes your organization should consider using to build out the capability to deploy large numbers of Azure resources with connected services and policies in a controlled way. Which of the following solutions should you recommend?
Azure PowerShell
Azure CLI
Azure portal
ARM templates
You want to use the Azure CLI to perform management functions in Azure. Which of the following configurations does not suit this requirement?
You install the Azure CLI on a Windows 10 PC.
You install the Azure CLI on a Mac.
You open the Azure portal in a browser and then run the Azure CLI in the Azure Cloud Shell.
You run the Azure CLI from PowerShell on a Windows 10 device.
You are out of the office at an appointment and one of your team members sends you an urgent request to reset a web app because the only other people with the appropriate access are not available. All you have is your mobile device. Which two options can you use to reset the web app?
Azure portal
Azure CLI
Azure Cloud Shell
Azure PowerShell
Which blade in the Azure portal should you use to view security alerts and recommendations?
All Services
App Security
Security Center
Monitor
